A
A
Alexey Evlait2018-05-29 22:23:24
MySQL
Alexey Evlait, 2018-05-29 22:23:24

Error 1064 Opencart. What is wrong here?

Thanks for dropping by!
Need help. I don't know SQL... I don't work much with OpenCart either...
It was useful to edit one entry (displayed as feedback) in the SeoCMS PRO module - it was necessary to replace tags and fix a couple of styles in the settings of the module itself.
When I try to access the product card, I get the following error:

Fatal error: Uncaught exception 'ErrorException' with message '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 ') ) LEFT JOIN `oc_review_fields` r_f ON (r.comment_id = r_f.review_' at line 15
Error No: 1064
SELECT cu.avatar as avatar, o.order_id as buy, r_f.*, r.*, r.comment_id as review_id, r.comment_id as comment_id, p.record_id, pd.name, p.image, r.date_added as date_added, r.date_added as date_added, r.date_added as date_available, (r.sorthex) as hsort FROM oc_comment r LEFT JOIN oc_record p ON (r.record_id = p.record_id) LEFT JOIN oc_record_description pd ON (p.record_id = pd.record_id) LEFT JOIN `oc_customer` cu ON (r.customer_id = cu.customer_id) LEFT JOIN `oc_order` o ON ( r.customer_id = o.customer_id AND o.customer_id <> 0 AND o.order_status_id IN () ) LEFT JOIN `oc_review_fields` r_f ON (r.comment_id = r_f.review_id AND r_f.mark = 'record_id' ) in 
/public_html/system/database/ipsmysqli.php on line 43

Before these edits, everything worked fine ...
I found that the error was in the treecomments.php file, because minor edits in the file (such as quotes) change the text of the error.
Is it possible to understand something from this error code?
Or other information is needed.
OpenCart Version 1.5.6.4_rc This
won't happen because I changed one html tag and a couple of styles

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question