▼テンプレート
[EC-CUBE]4.0.6-p1
[レンタルサーバ]さくらサーバー
[OS]FreeBSD www971.sakura.ne.jp 13.0-RELEASE-p13 FreeBSD 13.0-RELEASE-p13 #0: Mon Aug 29 19:52:47 UTC 2022 [email protected]:/usr/obj/usr/src/amd64.amd64/sys/GENERIC amd64
[PHP]PHP Version 7.4.33
[データベース]MySQL 5.7.40-log
[WEBサーバ]Apache
[現象]

商品注文後の画面で
システムエラーが発生しました
という画面が表示されて注文ができないとの問い合わせがありました。
こちらで再現はできていない状態です。

エラーログを添付するので、原因特定のご協力をお願いしたいです。

[エラーログ]
[2023-07-31 23:39:37] front.ERROR [195d0cde] [e38389d] [15] [Eccube\Log\Logger:log:66] - システムエラーが発生しました。 ["An exception occurred while executing 'INSERT INTO dtb_order (pre_order_id, order_no, message, name01, name02, kana01, kana02, company_name, email, phone_number, postal_code, addr01, addr02, birth, subtotal, discount, delivery_fee_total, charge, tax, total, payment_total, payment_method, note, create_date, update_date, order_date, payment_date, currency_code, complete_message, complete_mail_message, add_point, use_point, customer_id, country_id, pref_id, sex_id, job_id, payment_id, device_type_id, order_status_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\"41421f56fd79b19698108fae9eb2b994bd77639b\", null, null, \"\\u9ad9\\u6a4b\", \"\\u548c\\u4ee3\", \"\\u30bf\\u30ab\\u30cf\\u30b7\", \"\\u30ab\\u30ba\\u30e8\", \"\\u307f\\u3084\\u3058\\u307e\\u6b6f\\u79d1\", \"[email protected]\", \"0473074618\", \"2720133\", \"\\u5e02\\u5ddd\\u5e02\\u884c\\u5fb3\\u99c5\\u524d\", \"2-20-2\", \"1968-02-13 15:00:00\", 43000, 0, 0, 0, 3000, 43000, 43000, \"\\u4ee3\\u91d1\\u5f15\\u63db\\uff08\\u624b\\u6570\\u6599\\u7121\\u6599\\uff09\", null, \"2023-07-31 14:39:37\", \"2023-07-31 14:39:37\", null, null, \"JPY\", null, null, \"0\", \"0\", 15, null, 12, 2, 6, 4, 10, 8, \"order\"]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`crane-hill_ec-cube`.`dtb_order`, CONSTRAINT `FK_1D66D807BE04EA9` FOREIGN KEY (`job_id`) REFERENCES `mtb_job` (`id`))","/home/crane-hill/www/sample.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",49,"#0 /home/crane-hill/www/sample.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(169): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException()\n#1 /home/crane-hill/www/sample.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(145): Doctrine\\DBAL\\DBALException::wrapException()\n#2 /home/crane-hill/www/sample.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(162): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery()\n#3 /home/crane-hill/www/sample.com/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(287): Doctrine\\DBAL\\Statement->execute()\n#4 /home/crane-hill/www/sample.com/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1087): Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister->executeInserts()\n#5 /home/crane-hill/www/sample.com/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(400): Doctrine\\ORM\\UnitOfWork->executeInserts()\n#6 /home/crane-hill/www/sample.com/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(368): Doctrine\\ORM\\UnitOfWork->commit()\n#7 /home/crane-hill/www/sample.com/var/cache/prod/ContainerSbsgt5z/EntityManager_9a5be93.php(83): Doctrine\\ORM\\EntityManager->flush()\n#8 /home/crane-hill/www/sample.com/src/Eccube/Controller/ShoppingController.php(115): EntityManager_9a5be93->flush()\n#9 /home/crane-hill/www/sample.com/vendor/symfony/http-kernel/HttpKernel.php(151): Eccube\\Controller\\ShoppingController->index()\n#10 /home/crane-hill/www/sample.com/vendor/symfony/http-kernel/HttpKernel.php(68): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()\n#11 /home/crane-hill/www/sample.com/vendor/symfony/http-kernel/Kernel.php(200): Symfony\\Component\\HttpKernel\\HttpKernel->handle()\n#12 /home/crane-hill/www/sample.com/index.php(76): Symfony\\Component\\HttpKernel\\Kernel->handle()\n#13 {main}"] [GET, /shopping, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] front.INFO [195d0cde] [e38389d] [15] [Eccube\Log\Logger:log:66] - [注文手続] 集計処理を開始します. [null] [GET, /shopping, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] front.INFO [195d0cde] [e38389d] [15] [Eccube\Log\Logger:log:66] - [注文手続] 受注の初期化処理を開始します. [] [GET, /shopping, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] front.INFO [195d0cde] [e38389d] [15] [Eccube\Log\Logger:log:66] - LOGIC START ["shopping"] [GET, /shopping, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] front.DEBUG [195d0cde] [e38389d] [15] [Eccube\Log\Logger:log:66] - Begin Transaction. [] [GET, /shopping, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] front.INFO [195d0cde] [e38389d] [15] [Eccube\Log\Logger:log:66] - PROCESS START ["shopping"] [GET, /shopping, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] security.DEBUG [195d0cde] [e38389d] [N/A] [Symfony\Component\Security\Http\Firewall\ContextListener:refreshUser:214] - User was reloaded from a user provider. {"provider":"Eccube\\Security\\Core\\User\\CustomerProvider","username":"[email protected]";} [GET, /shopping, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] security.DEBUG [195d0cde] [e38389d] [N/A] [Symfony\Component\Security\Http\Firewall\ContextListener:handle:101] - Read existing security token from the session. {"key":"_security_customer","token_class":"Symfony\\Component\\Security\\Core\\Authentication\\Token\\UsernamePasswordToken"} [GET, /shopping, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] request.INFO [N/A] [e38389d] [N/A] [Symfony\Component\HttpKernel\EventListener\RouterListener:onKernelRequest:123] - Matched route "shopping". {"route":"shopping","route_parameters":{"_controller":"Eccube\\Controller\\ShoppingController::index","_route":"shopping"},"request_uri":"https://sample.com/shopping","method":"GET"} [GET, /shopping, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] front.INFO [N/A] [e38389d] [N/A] [Eccube\Log\Logger:log:66] - INIT [] [GET, /shopping, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] app.INFO [N/A] [54a86fe] [15] [Eccube\Log\Logger:log:68] - PROCESS END ["cart_buystep"] [GET, /cart/buystep/15_1, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] front.INFO [195d0cde] [54a86fe] [15] [Eccube\Log\Logger:log:66] - LOGIC END ["cart_buystep"] [GET, /cart/buystep/15_1, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] php.INFO [195d0cde] [54a86fe] [15] [Symfony\Component\Debug\ErrorHandler:handleError:532] - User Deprecated: Calling Doctrine\ORM\EntityManager::flush() with any arguments to flush specific entities is deprecated and will not be supported in Doctrine ORM 3.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Calling Doctrine\\ORM\\EntityManager::flush() with any arguments to flush specific entities is deprecated and will not be supported in Doctrine ORM 3.0. at /home/crane-hill/www/sample.com/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:362)"} [GET, /cart/buystep/15_1, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] php.INFO [195d0cde] [54a86fe] [15] [Symfony\Component\Debug\ErrorHandler:handleError:532] - User Deprecated: Calling Doctrine\ORM\EntityManager::flush() with any arguments to flush specific entities is deprecated and will not be supported in Doctrine ORM 3.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Calling Doctrine\\ORM\\EntityManager::flush() with any arguments to flush specific entities is deprecated and will not be supported in Doctrine ORM 3.0. at /home/crane-hill/www/sample.com/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:362)"} [GET, /cart/buystep/15_1, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] php.INFO [195d0cde] [54a86fe] [15] [Symfony\Component\Debug\ErrorHandler:handleError:532] - User Deprecated: Calling Doctrine\ORM\EntityManager::flush() with any arguments to flush specific entities is deprecated and will not be supported in Doctrine ORM 3.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Calling Doctrine\\ORM\\EntityManager::flush() with any arguments to flush specific entities is deprecated and will not be supported in Doctrine ORM 3.0. at /home/crane-hill/www/sample.com/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:362)"} [GET, /cart/buystep/15_1, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] php.INFO [195d0cde] [54a86fe] [15] [Symfony\Component\Debug\ErrorHandler:handleError:532] - User Deprecated: Calling Doctrine\ORM\EntityManager::flush() with any arguments to flush specific entities is deprecated and will not be supported in Doctrine ORM 3.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Calling Doctrine\\ORM\\EntityManager::flush() with any arguments to flush specific entities is deprecated and will not be supported in Doctrine ORM 3.0. at /home/crane-hill/www/sample.com/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:362)"} [GET, /cart/buystep/15_1, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]
[2023-07-31 23:39:37] php.INFO [195d0cde] [54a86fe] [15] [Symfony\Component\Debug\ErrorHandler:handleError:532] - User Deprecated: Calling Doctrine\ORM\EntityManager::flush() with any arguments to flush specific entities is deprecated and will not be supported in Doctrine ORM 3.0. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Calling Doctrine\\ORM\\EntityManager::flush() with any arguments to flush specific entities is deprecated and will not be supported in Doctrine ORM 3.0. at /home/crane-hill/www/sample.com/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:362)"} [GET, /cart/buystep/15_1, 147.192.111.53, https://sample.com/cart, Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15]

dtb_orderテーブルのjob_id列に値を挿入または更新しようとしていますが、その値が参照先のmtb_jobテーブルのid列に存在しないため、エラーが発生しています。

----------------


http://ec-lab.net/

ご回答いただきありがとうございます。
助かりました。