Доброго времени суток. Подскажите плиз куда копать.
Опенкарт 3
Шаблон Журнал
Система корзины симпла
Ошибка при создании заказа. Сам заказ создается, но выдает ошибку сервера.
По логам следующее... где то несовпадение синтаксиса, но странно так как функционально все создается и ордер появляется, на почту все уходит, но не выводится страница результата. Буду благодарен за подсказку.
[Tue Apr 12 12:18:04.872669 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: PHP Fatal error: Uncaught Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.872779 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: \t\t\tWHERE p.product_id IN (: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.872804 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: \t\t\t\tSELECT: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.872849 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: \t\t\t\t\tdistinct product_id: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.872869 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: \t\t\t\tFROM: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.872954 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: \t\t\t\t\t`' at line 1<br />Error No: 1064<br />: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.873028 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: \t\t\tDELETE FROM `oc_journal3_product_sales` p: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.873086 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: \t\t\tWHERE p.product_id IN (: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.873109 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: \t\t\t\tSELECT: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.873154 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: \t\t\t\t\tdistinct product_id: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.873174 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: \t\t\t\tFROM: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.873217 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: \t\t\t\t\t`oc_order_product`: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.873238 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: \t\t\t\tWHERE: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.873277 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: \t\t\t\t\torder_id = '17': /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.873290 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: \t\t\t): /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.873433 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: \t\t in /var/www//data/www//system/library/db/mysqli.php:48: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.873481 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: Stack trace:: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.873683 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: #0 /var/www//data/www/storage/modification/system/library/db.php(55): DB\\MySQLi->query('\\n\\t\\t\\tDELETE FROM...'): /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.873982 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: #1 /var/www//data/www//system/library/journal3/opencart/bestseller.php(107): DB->query('\\n\\t\\t\\tDELETE FROM...'): /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.874275 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: #2 /var/www//data/www//catalog/controller/journal3/event/cache.php(12): Journal3\\Opencart\\Bestseller->update(17): /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
[Tue Apr 12 12:18:04.874626 2022] [cgi:error] [pid 9913] [client 92.38.133.82:48476] AH01215: #3 /var/www//data/www/storage/modification/system/engine/acti in /var/www//data/www//system/library/db/mysqli.php on line 48: /var/www//data/php-bin//php, referer: https:///index.php?route=checkout/simplecheckout
