Answer the question
In order to leave comments, you need to log in
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
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question