/
var
/
www
/
vhosts
/
nabawater
/
console
/
runtime
/
logs
/
/var/www/vhosts/nabawater/console/runtime/logs
mkdir
upload
Name
Size
Mode
Actions
app.log
5423
0664
edit
dl
rm
Edit:
/var/www/vhosts/nabawater/console/runtime/logs/app.log
(5423B)
2026-04-05 09:56:34 [-][-][-][error][yii\db\Exception] PDOException: SQLSTATE[HY000]: General error: 3780 Referencing column 'product_id' and referenced column 'item_id' in foreign key constraint 'fk_ads_product_id' are incompatible. in /var/www/vhosts/nabawater/vendor/yiisoft/yii2/db/Command.php:1290 Stack trace: #0 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/db/Command.php(1290): PDOStatement->execute() #1 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/db/Command.php(1091): yii\db\Command->internalExecute() #2 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/db/Migration.php(467): yii\db\Command->execute() #3 /var/www/vhosts/nabawater/console/migrations/m251116_000000_create_ads_table.php(38): yii\db\Migration->addForeignKey() #4 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(725): m251116_000000_create_ads_table->up() #5 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(199): yii\console\controllers\BaseMigrateController->migrateUp() #6 [internal function]: yii\console\controllers\BaseMigrateController->actionUp() #7 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array() #8 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams() #9 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/console/Controller.php(148): yii\base\Controller->runAction() #10 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/base/Module.php(528): yii\console\Controller->runAction() #11 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction() #12 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction() #13 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/base/Application.php(386): yii\console\Application->handleRequest() #14 /var/www/vhosts/nabawater/yii(27): yii\base\Application->run() #15 {main} Next yii\db\Exception: SQLSTATE[HY000]: General error: 3780 Referencing column 'product_id' and referenced column 'item_id' in foreign key constraint 'fk_ads_product_id' are incompatible. The SQL being executed was: ALTER TABLE `ads` ADD CONSTRAINT `fk_ads_product_id` FOREIGN KEY (`product_id`) REFERENCES `item` (`item_id`) ON DELETE CASCADE ON UPDATE CASCADE in /var/www/vhosts/nabawater/vendor/yiisoft/yii2/db/Schema.php:664 Stack trace: #0 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/db/Command.php(1295): yii\db\Schema->convertException() #1 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/db/Command.php(1091): yii\db\Command->internalExecute() #2 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/db/Migration.php(467): yii\db\Command->execute() #3 /var/www/vhosts/nabawater/console/migrations/m251116_000000_create_ads_table.php(38): yii\db\Migration->addForeignKey() #4 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(725): m251116_000000_create_ads_table->up() #5 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(199): yii\console\controllers\BaseMigrateController->migrateUp() #6 [internal function]: yii\console\controllers\BaseMigrateController->actionUp() #7 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array() #8 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams() #9 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/console/Controller.php(148): yii\base\Controller->runAction() #10 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/base/Module.php(528): yii\console\Controller->runAction() #11 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction() #12 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction() #13 /var/www/vhosts/nabawater/vendor/yiisoft/yii2/base/Application.php(386): yii\console\Application->handleRequest() #14 /var/www/vhosts/nabawater/yii(27): yii\base\Application->run() #15 {main} Additional Information: Array ( [0] => HY000 [1] => 3780 [2] => Referencing column 'product_id' and referenced column 'item_id' in foreign key constraint 'fk_ads_product_id' are incompatible. ) 2026-04-05 09:56:34 [-][-][-][info][application] $_GET = [] $_POST = [] $_FILES = [] $_COOKIE = [] $_SERVER = [ 'SHELL' => '/bin/bash' 'PWD' => '/var/www/vhosts/nabawater' 'LOGNAME' => 'ubuntu' 'XDG_SESSION_TYPE' => 'tty' 'HOME' => '/home/ubuntu' 'LANG' => 'C.UTF-8' 'SSH_CONNECTION' => '2.50.143.77 63025 172.31.12.41 22' 'XDG_SESSION_CLASS' => 'user' 'USER' => 'ubuntu' 'SHLVL' => '1' 'XDG_SESSION_ID' => '122' 'XDG_RUNTIME_DIR' => '/run/user/1000' 'SSH_CLIENT' => '2.50.143.77 63025 22' 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin' 'DBUS_SESSION_BUS_ADDRESS' => 'unix:path=/run/user/1000/bus' 'OLDPWD' => '/home/ubuntu' '_' => '/usr/bin/php7.4' 'PHP_SELF' => 'yii' 'SCRIPT_NAME' => 'yii' 'SCRIPT_FILENAME' => 'yii' 'PATH_TRANSLATED' => 'yii' 'DOCUMENT_ROOT' => '' 'REQUEST_TIME_FLOAT' => 1775382994.5298 'REQUEST_TIME' => 1775382994 'argv' => [ 0 => 'yii' 1 => 'migrate/up' 2 => '4' 3 => '--interactive=0' ] 'argc' => 4 ]
Save
cmd:
run