Skip to content

..near 'option o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.o' at line 1

So you’ve just installed Opencart 1.5.0 and when attempting to edit a product or category or etc you get the following error:

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 ‘option o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.o’ at line 1
Error No: 1064
SELECT * FROM product_option po LEFT JOIN option o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = ’42’ AND od.language_id = ‘1’

This is because you probably didn’t set a table prefix in the database install initially.

There is a very simple fix for this, you need RC1 which you can download here:
http://forum.opencart.com/download/file.php?id=5056

Once this has been downloaded, just upload and replace over the root of your opencart 1.5.0 site and you’re good to go!

See also  How to Check for Factor in Python
Tags:
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x