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
Have the same
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
Provided fix model user.php seems to solve the problem.
Regards,
Ronald
Problem not solved completely.
After selecting other customer and save warning: Key folder in safepath unaccessible
Now is choosing another customer not possible anymore.
That is another problem
http://forum.virtuemart.net/index.php?topic=129246.msg444769#msg444769
All now fixed! Thanks everyone
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
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