VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: dgrepo on November 11, 2016, 17:54:51 PM

Title: 1064 You have an error in your SQL syntax HELP?
Post by: dgrepo on November 11, 2016, 17:54:51 PM
I have a problem with this message after Confirm Purchase instead of showing the order confirmation page.

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 '' at line 3 SQL=SELECT params FROM y30cq_jarvis_template_styles WHERE style_id =

Customer even when the error is shown get mail about order.

Please can you help me to solve this problem.

Im using Joomla! version, 3.3.6. and VirtueMart 3.0.4
Title: Re: 1064 You have an error in your SQL syntax HELP?
Post by: GJC Web Design on November 12, 2016, 00:10:24 AM
QuoteIm using Joomla! version, 3.3.6. and VirtueMart 3.0.4

come on... have u not noticed->

https://www.joomla.org/announcements/release-news/5678-joomla-3-6-4-released.html

http://www.theregister.co.uk/2016/11/02/hurried_crims_target_30000_sites_to_pop_unpatched_joomla/
plus VM wildly out of date

won't be the cause of the sql failure I guess but if u leave the site wide open like this u will have far more toworry about

I think why VM would be quering template styles so look at 3rd party ext. maybe..

SELECT params FROM y30cq_jarvis_template_styles WHERE style_id =

is y30cq_jarvis really your db tables  prefix?