VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: Sheepiss on April 07, 2015, 11:12:35 AM

Title: Error 1064 after clicking on "show cart" button
Post by: Sheepiss on April 07, 2015, 11:12:35 AM
Hello,

when I click on "show cart" (in the right top corner), I get an error 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 'AND ju.id!= "880" ORDER BY `name` LIMIT 0,10000' at line 1 SQL=SELECT ju.`id`,`name`,`username` FROM `fxt61_users` as ju AND ju.id!= "880" ORDER BY `name` LIMIT 0,10000"

(screenshot enclosed)

website: http://pujcovnatylovek.cz

Can anybody help me how to solve it?
Title: Re: Error 1064 after clicking on "show cart" button
Post by: jenkinhill on April 07, 2015, 11:22:45 AM
http://forum.virtuemart.net/index.php?topic=79799.0  - it saves time!

But I'll guess you are using VM3.0.7RC? If so then see http://forum.virtuemart.net/index.php?topic=129249.msg444770#msg444770
Title: Re: Error 1064 after clicking on "show cart" button
Post by: PabloArias on April 27, 2015, 04:55:01 AM
I have the same problem with Joomla 3.4.1 and Virtuemart 3.0.8.

Any solution?

In the post you mention, Jenkinhill, the solution is to update to Virtuemart 3.0.7.2 but I have a newer version.

Thank you and best regards