coelroy Posted March 25, 2008 Posted March 25, 2008 Hi I installed osc 2.2rc. In addition I installed Star Product v 1.6. Now I noticed that when I activate the "Star Product" in Admin I get the following error: select substring(pd.products_description, 1, 598) as products_description, p.products_id, p.products_image, p.manufacturers_id, p.products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_tax_class_id, sp.product_id from products p, products_description pd, star_product sp left join specials s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_status = '1' and pd.products_description != '' and p.products_id=sp.product_id and pd.language_id = '1' Any help will do. MySql version 5.4.4.5 Regards Elroy
bkellum Posted March 25, 2008 Posted March 25, 2008 Hi I installed osc 2.2rc. In addition I installed Star Product v 1.6. Now I noticed that when I activate the "Star Product" in Admin I get the following error: select substring(pd.products_description, 1, 598) as products_description, p.products_id, p.products_image, p.manufacturers_id, p.products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_tax_class_id, sp.product_id from products p, products_description pd, star_product sp left join specials s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_status = '1' and pd.products_description != '' and p.products_id=sp.product_id and pd.language_id = '1' Any help will do. MySql version 5.4.4.5 Regards Elroy Elroy, The problem is that the query above is not compatible with MySQL 5. My suggestion would be to restore your backup of your database as well as your store prior to installing Star Product. Then, merge in the Star Product changes manually (not uploading or existing files). You will then need to manually merge in any queries to existing queries so as not to break the MySQL compatibility. If the query that is having issues is in a new file from the contribution, you will either need to correct it yourself or look in the Star Products download site or support thread for a fix. Hope this helped you out, Bill Kellum Sounds Good Productions STS Tutorials & more: STSv4.6, STS Add-ons (STS Power Pack), STS V4 Forum STS Forum FREE TEMPLATE
Recommended Posts
Archived
This topic is now archived and is closed to further replies.