News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

[solved] Testing VM 3.0.7: SQL error cart

Started by suvel, April 07, 2015, 10:30:58 AM

Previous topic - Next topic

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


Milbo

#2
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
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

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

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

PaulButler


revaboogy

#7
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
Pablo Arias
www.pabloarias.eu