L
L
Lisssa092019-01-14 20:34:04
opencart
Lisssa09, 2019-01-14 20:34:04

Orders are not uploaded from the opencart site with 1C v8.x?

Unloading orders on the site stopped working
. The following errors are written in the log:
2019-01-14 0:16:12 - PHP Warning: simplexml_load_file(): I/O warning : failed to load external entity "/var/www/u0230465/data/ www/xn--80agtnfmm5a.com/system/storage/cache/exchange1c/import.xml" in /var/www/u0230465/data/www/xn--80agtnfmm5a.com/admin/model/tool/exchange1c.php on line 4121
2019-01-14 0:31:25 - PHP Notice: 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 '' AND ptd.language_id = '1' AND pt.status = 1 ORDER BY sort_order ASC' at line 1
Error No: 1064
SELECT * FROM oc_product_tab pt LEFT JOIN oc_product_tab_desc ptd ON(pt.product_tab_id = ptd.product_tab_id) WHERE pt.product_id = '15566'"' AND ptd.language_id = '1' AND pt.status = 1 ORDER BY sort_order ASC in /var /www/u0230465/data/www/xn--80agtnfmm5a.com/system/library/db/mysqli.php on line 46
2019-01-14 0:31:25 - PHP Notice: Trying to get property of non-object in /var/www/u0230465/data/www/xn--80agtnfmm5a.com/system/storage/modification/catalog/model/catalog/product.php on line 89
2019-01-14 9:51:26 - PHP Notice : Undefined variable: fix2 in /var/www/u0230465/data/www/xn--80agtnfmm5a.com/system/storage/modification/catalog/view/theme/magazin/template/product/product.tpl on line 92
2019-01-14 12:32:11 - PHP Notice: Undefined index: product_id in /var/www/u0230465/data/www/xn--80agtnfmm5a.com/system/storage/modification/catalog/view/theme/magazin /template/account/order_info.tpl on line 92
Code in file /var/www/u0230465/data/www/xn--80agtnfmm5a.com/system/storage/modification/catalog/view/theme/magazin/template/product/ product.tpl
<?php if ($images && $config->get('control_additional')== 1) { ?> <?php foreach ($images as $image) { ?> <?php } ?> <? php} ?>


Answer the question

In order to leave comments, you need to log in

1 answer(s)
Z
zoozag, 2019-01-15
@zoozag

pt.product_id = '15566'"'

Some kind of mess with quotes in your SQL

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question