News:

Support the VirtueMart project and become a member

Main Menu

All of a sudden 1064 error? How to solve

Started by chaldama, September 28, 2015, 17:56:06 PM

Previous topic - Next topic

chaldama

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

GJC Web Design

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

chaldama

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.

GJC Web Design

you can disable any extension directly in the DB extensions table
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

chaldama

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!