News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

1064 You have an error in your SQL syntax HELP?

Started by dgrepo, November 11, 2016, 17:54:51 PM

Previous topic - Next topic

dgrepo

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

GJC Web Design

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?

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