VM problem

Change your online store into modern look with myStore eCommerce VirtueMart Joomla template - discussion forum.
GK User
Tue May 01, 2012 11:02 am
hi, i installed this template with virtuemart incluse. I have the latest version of vm and joomla, everithing seems working good but from the frontend when i add a product with "add to chart" button i recieve this message.

vmError: Error reading getPluginMethods 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 'ORs.`virtuemart_shoppergroup_id`= "2" OR (s.`virtuemart_shoppergroup_id`) IS NUL' at line 4 SQL=SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id FROM `gml89_virtuemart_paymentmethods_it_it` as l JOIN `gml89_virtuemart_paymentmethods` AS v USING (`virtuemart_paymentmethod_id`) LEFT JOIN `gml89_extensions` as j ON j.`extension_id` = v.`payment_jplugin_id` LEFT OUTER JOIN `gml89_virtuemart_paymentmethod_shoppergroups` AS s ON v.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id` WHERE v.`published` = "1" AND j.`element` = "standard" AND (v.`virtuemart_vendor_id` = "1" OR v.`virtuemart_vendor_id` = "0") AND (s.`virtuemart_shoppergroup_id`= "1" ORs.`virtuemart_shoppergroup_id`= "2" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) ORDER BY v.`ordering`

Can u help me to resolve it?.. tnx
User avatar
Gold Boarder

GK User
Tue May 01, 2012 1:10 pm
Hi

The message seams clear. It's on your PHP version that you have on your host.
Please check if you have all requirements on this page and compare it with your host.

Cheers
User avatar
Platinum Boarder


cron