[solved] Testing VM 3.0.7: SQL error cart

[suvel]

Hallo all,

Joomla: 3.4.1
MySQL: 5.1.73-1
PHP: 5.3.28-1

When trying to access cart at frontend get following error:

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!= "861" ORDER BY `name` LIMIT 0,10000' at line 1 SQL=SELECT ju.`id`,`name`,`username` FROM `xxx_users` as ju AND ju.id!= "861" ORDER BY `name` LIMIT 0,10000

--- edit ---
When dis-Allow Administrators to change the current Shopper problem not present. Seems typo at users model?

Please advice
Ronald

[Daniel Sjöstrand]

Have the same

[Milbo]

Please try this user model /administrator/components/com_virtuemart/models

edit: use directly the updated version http://dev.virtuemart.net/attachments/download/939/com_virtuemart.3.0.7.2_extract_first.zip

[suvel]

Provided fix model user.php seems to solve the problem.

Regards,
Ronald

[suvel]

Problem not solved completely.

After selecting other customer and save warning: Key folder in safepath unaccessible
Now is choosing another customer not possible anymore.

[Milbo]

That is another problem
http://forum.virtuemart.net/index.php?topic=129246.msg444769#msg444769

[PaulButler]

All now fixed! Thanks everyone

[revaboogy]

Hi Guys, Cart fixed but now Error: 1146 when try to confirm order??? The same happens when trying to view and order. Any ideas? Please help

In admin get this when trying to veiw an order:

1146 Table 'keyspins_vm.lr59t_virtuemart_payment_plg_standard' doesn't exist SQL=SELECT * FROM `lr59t_virtuemart_payment_plg_standard` WHERE `virtuemart_order_id` = 209

Fixed it guys.... was missing the images/stories/virtumart/payment folder for some reason

[PabloArias]

Hi all:

I'm using Joomla 3.4.1 and Virtuemart 3.0.8. Upgraded from Joomla 2.5.

I'm still having the 1064 MySQL error.

Any solution?

Thank you and best regards