1064 - You have an error in your SQL syntax

[Nimeshin]

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

[Jörgen]

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

[Nimeshin]

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

[Studio 42]

Try to change your server setting PHP 7.2 > PHP 7.1

[Nimeshin]

7.1 also didnt work

thanks

[Studio 42]

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