VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: gmcfuerte on February 18, 2015, 23:38:42 PM

Title: Upgrade 3.0.2 to 3.0.4
Post by: gmcfuerte on February 18, 2015, 23:38:42 PM
On update my frontend is :
1064 - 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 'OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AN' at line 1 SQL=SELECT * FROM `u27qw_virtuemart_product_prices` WHERE `virtuemart_product_id` = "44" AND ( OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2015-02-17 14:54:48" ) AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2015-02-17 14:54:48" ) ) ORDER BY `product_price` DESC


Please help

GMC
Title: Re: Upgrade 3.0.2 to 3.0.4
Post by: Milbo on February 19, 2015, 12:34:16 PM
Thank you. Fixed
Title: Re: Upgrade 3.0.2 to 3.0.4
Post by: gmcfuerte on February 20, 2015, 22:53:05 PM
Quote from: Milbo on February 19, 2015, 12:34:16 PM
Thank you. Fixed
but now all the list of my website are dotted and lined losing all template classes...