Print Page - 1064 - You have an error in your SQL syntax

Title: 1064 - You have an error in your SQL syntax
Post by: Nimeshin on June 30, 2018, 17:01:27 PM

Hi, Im getting this error when I cancel my payment from my merchant site. I can complete payment successfully and it redirects back to my site with no errors, only appears when i cancel payment.

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 'GY4I030''' at line 1

thanks

Title: Re: 1064 - You have an error in your SQL syntax
Post by: Jörgen on June 30, 2018, 22:09:56 PM

Could be that you have to update the tables in VM config tools or maybe not.
No VM version, No joomla version, etc and not details of the error...

regards

Jörgen @ Kreativ Fotografi

Title: Re: 1064 - You have an error in your SQL syntax
Post by: Nimeshin on July 01, 2018, 16:04:35 PM

i have tried update tables tool, same error. Also created an orders menu link as well. Full error attached

VirtueMart 3.2.14, Joomla! 3.8.10, PHP 7.2

thanks

Title: Re: 1064 - You have an error in your SQL syntax
Post by: Studio 42 on July 01, 2018, 18:46:36 PM

Try to change your server setting PHP 7.2 > PHP 7.1

Title: Re: 1064 - You have an error in your SQL syntax
Post by: Nimeshin on July 03, 2018, 20:16:52 PM

7.1 also didnt work

thanks

Title: Re: 1064 - You have an error in your SQL syntax
Post by: Studio 42 on July 03, 2018, 20:19:30 PM

Have you test another payment?
It's perhpas only the payment plugin.

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: Nimeshin on June 30, 2018, 17:01:27 PM