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!

Categories: ContentGeneral