INFO Running migrations. 2026_04_20_000006_update_business_promotions_table_v2 30ms FAIL Illuminate\Database\QueryException SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'state_id' (SQL: alter table `business_promotions` add `business_owner_id` bigint unsigned null after `id`, add `promotion_type_id` bigint unsigned null after `business_owner_id`, add `total_days` int null after `end_date`, add `city_id` bigint unsigned null after `total_days`, add `state_id` bigint unsigned null after `city_id`, add `status` varchar(255) not null default 'pending' after `state_id`, add `amount` decimal(10, 2) not null default '0' after `status`, add `is_active` tinyint(1) not null default '0' after `amount`, add `payment_mode` enum('online', 'offline') not null default 'offline' after `is_active`, add `payment_status` enum('pending', 'paid', 'failed') not null default 'pending' after `payment_mode`, add `notes` text null after `payment_status`, add `rejection_reason` text null after `notes`, add `reviewed_by` bigint unsigned null after `rejection_reason`, add `reviewed_at` timestamp null after `reviewed_by`) at vendor/laravel/framework/src/Illuminate/Database/Connection.php:760 756▕ // If an exception occurs when attempting to run a query, we'll format the error 757▕ // message to include the bindings with SQL, which will make this exception a 758▕ // lot more helpful to the developer instead of just the database's errors. 759▕ catch (Exception $e) { ➜ 760▕ throw new QueryException( 761▕ $query, $this->prepareBindings($bindings), $e 762▕ ); 763▕ } 764▕ } 1 vendor/laravel/framework/src/Illuminate/Database/Connection.php:545 PDOException::("SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'state_id'") 2 vendor/laravel/framework/src/Illuminate/Database/Connection.php:545 PDOStatement::execute() 3 vendor/laravel/framework/src/Illuminate/Database/Connection.php:753 Illuminate\Database\Connection::Illuminate\Database\{closure}() 4 vendor/laravel/framework/src/Illuminate/Database/Connection.php:720 Illuminate\Database\Connection::runQueryCallback() 5 vendor/laravel/framework/src/Illuminate/Database/Connection.php:534 Illuminate\Database\Connection::run() 6 vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:109 Illuminate\Database\Connection::statement() 7 vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:439 Illuminate\Database\Schema\Blueprint::build() 8 vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:269 Illuminate\Database\Schema\Builder::build() 9 vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:338 Illuminate\Database\Schema\Builder::table() 10 database/migrations/2026_04_20_000006_update_business_promotions_table_v2.php:16 Illuminate\Support\Facades\Facade::__callStatic() 11 vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:496 Illuminate\Database\Migrations\Migration@anonymous\/var/www/html/Git/Loyalty & Rewards(16042026)/loyalty-laravel/database/migrations/2026_04_20_000006_update_business_promotions_table_v2.php:7$102::up() 12 vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:414 Illuminate\Database\Migrations\Migrator::runMethod() 13 vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:423 Illuminate\Database\Migrations\Migrator::Illuminate\Database\Migrations\{closure}() 14 vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:224 Illuminate\Database\Migrations\Migrator::runMigration() 15 vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php:37 Illuminate\Database\Migrations\Migrator::Illuminate\Database\Migrations\{closure}() 16 vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:778 Illuminate\Console\View\Components\Task::render() 17 vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:224 Illuminate\Database\Migrations\Migrator::write() 18 vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:189 Illuminate\Database\Migrations\Migrator::runUp() 19 vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:132 Illuminate\Database\Migrations\Migrator::runPending() 20 vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:88 Illuminate\Database\Migrations\Migrator::run() 21 vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:636 Illuminate\Database\Console\Migrations\MigrateCommand::Illuminate\Database\Console\Migrations\{closure}() 22 vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:81 Illuminate\Database\Migrations\Migrator::usingConnection() 23 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 Illuminate\Database\Console\Migrations\MigrateCommand::handle() 24 vendor/laravel/framework/src/Illuminate/Container/Util.php:41 Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() 25 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93 Illuminate\Container\Util::unwrapIfClosure() 26 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35 Illuminate\Container\BoundMethod::callBoundMethod() 27 vendor/laravel/framework/src/Illuminate/Container/Container.php:661 Illuminate\Container\BoundMethod::call() 28 vendor/laravel/framework/src/Illuminate/Console/Command.php:183 Illuminate\Container\Container::call() 29 vendor/symfony/console/Command/Command.php:326 Illuminate\Console\Command::execute() 30 vendor/laravel/framework/src/Illuminate/Console/Command.php:152 Symfony\Component\Console\Command\Command::run() 31 vendor/symfony/console/Application.php:1078 Illuminate\Console\Command::run() 32 vendor/symfony/console/Application.php:324 Symfony\Component\Console\Application::doRunCommand() 33 vendor/symfony/console/Application.php:175 Symfony\Component\Console\Application::doRun() 34 vendor/laravel/framework/src/Illuminate/Console/Application.php:102 Symfony\Component\Console\Application::run() 35 vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:155 Illuminate\Console\Application::run() 36 artisan:35 Illuminate\Foundation\Console\Kernel::handle()