Hello,
Hope that someone can help me to fix this since it concerns a live website. I do have a backup but restoring it would still mean a lot of work needs to be redone.
It concerns this website: http://www.ladytoys.nl/.
The error I get both at front and backend:
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 '' at line 1 SQL=SELECT country_name FROM xxx_virtuemart_countries WHERE virtuemart_country_id=
Yesterday I worked on the site and there was no problem at all. I checked the xxx_virtuemart_countries table but do not see anything strange.
The site runs on Joomla 3.4.4 and Virtuemart 3.0.9 or 3.0.10. I cannot check the exact version now because of the error. Please let me know if additional info is needed.
Regards Marloes
had a quick look thru VM and i don't see any query starting with SELECT country_name
what is this page? VM frontpage?
try unpub. 3rd party modules and plugins as maybe comes from one of those
Thank you for looking into this.
The error is present everywhere, I cannot access Joomla nor any other page of the website so disabling extensions is not possible.
The homepage shows a Virtuemart featured products module, a slider and a custom filter search. All worked fine until today.
you can disable any extension directly in the DB extensions table
Yes, I found it, thank you. I disabled xtensions one by one and this extension: http://www.virtuemartrackingextension.com/extensions/virtuemart-tracking-google-analytics-joomla3-vm3.htm
seems to be the problem. I left it disabled now and will contact the developer.
Thank you very much for your help!