Files
AYS-Backend/migration_error.log
2026-02-18 17:16:53 +08:00

116 lines
20 KiB
Plaintext

Migrating: 2024_05_25_044210_create_mail_templates_table
Illuminate\Database\QueryException
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mail_templates' already exists (SQL: create table `mail_templates` (`id` bigint unsigned not null auto_increment primary key, `name` varchar(255) null, `label` varchar(255) null, `description` longtext null, `type` varchar(255) null, `to` longtext null, `bcc` longtext null, `cc` longtext null, `status` tinyint not null default '0', `channels` varchar(255) null, `created_by` int unsigned null, `updated_by` int unsigned null, `deleted_by` int unsigned null, `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')
at C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Connection.php:712
708Γûò // If an exception occurs when attempting to run a query, we'll format the error
709Γûò // message to include the bindings with SQL, which will make this exception a
710Γûò // lot more helpful to the developer instead of just the database's errors.
711Γûò catch (Exception $e) {
Γ₧£ 712Γûò throw new QueryException(
713Γûò $query, $this->prepareBindings($bindings), $e
714Γûò );
715Γûò }
716Γûò }
1 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Connection.php:501
PDOException::("SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mail_templates' already exists")
2 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Connection.php:501
PDOStatement::execute()
3 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Connection.php:705
Illuminate\Database\Connection::Illuminate\Database\{closure}("create table `mail_templates` (`id` bigint unsigned not null auto_increment primary key, `name` varchar(255) null, `label` varchar(255) null, `description` longtext null, `type` varchar(255) null, `to` longtext null, `bcc` longtext null, `cc` longtext null, `status` tinyint not null default '0', `channels` varchar(255) null, `created_by` int unsigned null, `updated_by` int unsigned null, `deleted_by` int unsigned null, `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'", [])
4 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Connection.php:672
Illuminate\Database\Connection::runQueryCallback("create table `mail_templates` (`id` bigint unsigned not null auto_increment primary key, `name` varchar(255) null, `label` varchar(255) null, `description` longtext null, `type` varchar(255) null, `to` longtext null, `bcc` longtext null, `cc` longtext null, `status` tinyint not null default '0', `channels` varchar(255) null, `created_by` int unsigned null, `updated_by` int unsigned null, `deleted_by` int unsigned null, `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'", [], Object(Closure))
5 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Connection.php:490
Illuminate\Database\Connection::run("create table `mail_templates` (`id` bigint unsigned not null auto_increment primary key, `name` varchar(255) null, `label` varchar(255) null, `description` longtext null, `type` varchar(255) null, `to` longtext null, `bcc` longtext null, `cc` longtext null, `status` tinyint not null default '0', `channels` varchar(255) null, `created_by` int unsigned null, `updated_by` int unsigned null, `deleted_by` int unsigned null, `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'", [], Object(Closure))
6 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Schema\Blueprint.php:109
Illuminate\Database\Connection::statement("create table `mail_templates` (`id` bigint unsigned not null auto_increment primary key, `name` varchar(255) null, `label` varchar(255) null, `description` longtext null, `type` varchar(255) null, `to` longtext null, `bcc` longtext null, `cc` longtext null, `status` tinyint not null default '0', `channels` varchar(255) null, `created_by` int unsigned null, `updated_by` int unsigned null, `deleted_by` int unsigned null, `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'")
7 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Schema\Builder.php:364
Illuminate\Database\Schema\Blueprint::build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
8 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Schema\Builder.php:223
Illuminate\Database\Schema\Builder::build(Object(Illuminate\Database\Schema\Blueprint))
9 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php:261
Illuminate\Database\Schema\Builder::create("mail_templates", Object(Closure))
10 C:\laragon\www\ays-backend\database\migrations\2024_05_25_044210_create_mail_templates_table.php:16
Illuminate\Support\Facades\Facade::__callStatic("create")
11 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php:472
CreateMailTemplatesTable::up()
12 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php:394
Illuminate\Database\Migrations\Migrator::runMethod(Object(Illuminate\Database\MySqlConnection), Object(CreateMailTemplatesTable), "up")
13 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php:403
Illuminate\Database\Migrations\Migrator::Illuminate\Database\Migrations\{closure}()
14 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php:202
Illuminate\Database\Migrations\Migrator::runMigration(Object(CreateMailTemplatesTable), "up")
15 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php:167
Illuminate\Database\Migrations\Migrator::runUp("C:\laragon\www\ays-backend\database\migrations/2024_05_25_044210_create_mail_templates_table.php")
16 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php:112
Illuminate\Database\Migrations\Migrator::runPending([])
17 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Console\Migrations\MigrateCommand.php:84
Illuminate\Database\Migrations\Migrator::run([])
18 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php:606
Illuminate\Database\Console\Migrations\MigrateCommand::Illuminate\Database\Console\Migrations\{closure}()
19 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Database\Console\Migrations\MigrateCommand.php:77
Illuminate\Database\Migrations\Migrator::usingConnection(Object(Closure))
20 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php:36
Illuminate\Database\Console\Migrations\MigrateCommand::handle()
21 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Container\Util.php:40
Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
22 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php:93
Illuminate\Container\Util::unwrapIfClosure(Object(Closure))
23 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php:35
Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Object(Closure))
24 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Container\Container.php:653
Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), [])
25 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Console\Command.php:136
Illuminate\Container\Container::call()
26 C:\laragon\www\ays-backend\vendor\symfony\console\Command\Command.php:298
Illuminate\Console\Command::execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
27 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Console\Command.php:120
Symfony\Component\Console\Command\Command::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
28 C:\laragon\www\ays-backend\vendor\symfony\console\Application.php:1040
Illuminate\Console\Command::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
29 C:\laragon\www\ays-backend\vendor\symfony\console\Application.php:301
Symfony\Component\Console\Application::doRunCommand(Object(Illuminate\Database\Console\Migrations\MigrateCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
30 C:\laragon\www\ays-backend\vendor\symfony\console\Application.php:171
Symfony\Component\Console\Application::doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
31 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Console\Application.php:94
Symfony\Component\Console\Application::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
32 C:\laragon\www\ays-backend\vendor\laravel\framework\src\Illuminate\Foundation\Console\Kernel.php:129
Illuminate\Console\Application::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
33 C:\laragon\www\ays-backend\artisan:35
Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))