[2021-09-21 06:00:30] > Синхронизация штрихкодов - добавление новых
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`yii_doc`.`prices_all_barcodes`, CONSTRAINT `prices_all_barcodes_ibfk_1` FOREIGN KEY (`pa_id`) REFERENCES `prices_all` (`id`)) in /var/www/dok2.dok.ua/vendor/yiisoft/yii2/db/Command.php:1291
Stack trace:
#0 /var/www/dok2.dok.ua/vendor/yiisoft/yii2/db/Command.php(1291): PDOStatement->execute()
#1 /var/www/dok2.dok.ua/vendor/yiisoft/yii2/db/Command.php(1092): yii\db\Command->internalExecute()
#2 /var/www/dok2.dok.ua/protected/commands/BarcodesSyncCommand.php(82): yii\db\Command->execute()
#3 /var/www/dok2.dok.ua/protected/commands/BarcodesSyncCommand.php(28): BarcodesSyncCommand->addNewBarcodes()
#4 [internal function]: BarcodesSyncCommand->actionIndex()
#5 /var/www/framework/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs()
#6 /var/www/framework/console/CConsoleCommandRunner.php(67): CConsoleCommand->run()
#7 /var/www/framework/console/CConsoleApplication.php(91): CConsoleCommandRunner->run()
#8 /var/www/framework/base/CApplication.php(169): CConsoleApplication->processRequest()
#9 /var/www/dok2.dok.ua/protected/components/DokConsoleFrameworkApplication.php(29): CApplication->run()
#10 /var/www/dok2.dok.ua/protected/cron.php(35): DokConsoleFrameworkApplication->run()
#11 {main}

Next yii\db\IntegrityException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`yii_doc`.`prices_all_barcodes`, CONSTRAINT `prices_all_barcodes_ibfk_1` FOREIGN KEY (`pa_id`) REFERENCES `prices_all` (`id`))
The SQL being executed was:
            INSERT INTO yii_doc.prices_all_barcodes (
                pa_id
                , barcode
                , wms_id
                , is_send
                , from_wms
            )
            SELECT wpb.product_barcode_product_id
                , wpb.product_barcode_title
                , wpb.product_barcode_id
                , 1
                , 1
            FROM wms.web7_product_barcode wpb
            LEFT JOIN yii_doc.prices_all_barcodes pab ON pab.pa_id = wpb.product_barcode_product_id
                AND pab.barcode = wpb.product_barcode_title
            WHERE pab.id IS NULL
                OR pab.active = 0
            ON DUPLICATE KEY UPDATE
                active = 1
                , created = NOW()
                , wms_id = VALUES(wms_id)
         in /var/www/dok2.dok.ua/vendor/yiisoft/yii2/db/Schema.php:674
Stack trace:
#0 /var/www/dok2.dok.ua/vendor/yiisoft/yii2/db/Command.php(1296): yii\db\Schema->convertException()
#1 /var/www/dok2.dok.ua/vendor/yiisoft/yii2/db/Command.php(1092): yii\db\Command->internalExecute()
#2 /var/www/dok2.dok.ua/protected/commands/BarcodesSyncCommand.php(82): yii\db\Command->execute()
#3 /var/www/dok2.dok.ua/protected/commands/BarcodesSyncCommand.php(28): BarcodesSyncCommand->addNewBarcodes()
#4 [internal function]: BarcodesSyncCommand->actionIndex()
#5 /var/www/framework/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs()
#6 /var/www/framework/console/CConsoleCommandRunner.php(67): CConsoleCommand->run()
#7 /var/www/framework/console/CConsoleApplication.php(91): CConsoleCommandRunner->run()
#8 /var/www/framework/base/CApplication.php(169): CConsoleApplication->processRequest()
#9 /var/www/dok2.dok.ua/protected/components/DokConsoleFrameworkApplication.php(29): CApplication->run()
#10 /var/www/dok2.dok.ua/protected/cron.php(35): DokConsoleFrameworkApplication->run()
#11 {main}
Additional Information:
Array
(
    [0] => 23000
    [1] => 1452
    [2] => Cannot add or update a child row: a foreign key constraint fails (`yii_doc`.`prices_all_barcodes`, CONSTRAINT `prices_all_barcodes_ibfk_1` FOREIGN KEY (`pa_id`) REFERENCES `prices_all` (`id`))
)