FM / logs

/var/www/vhosts/nabawater/console/runtime/logs/

/var/www/vhosts/nabawater/console/runtime/logs

Name	Size	Mode	Actions
app.log	5423	0664	edit dl rm

Edit: /var/www/vhosts/nabawater/console/runtime/logs/app.log (5423B)

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
]

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 ]