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:
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!