News:

Looking for documentation? Take a look on our wiki

Main Menu

1064 error on product page after updating VM to 3.2.2

Started by scooterpower, May 22, 2017, 18:21:46 PM

Previous topic - Next topic

scooterpower

Hi there,

After updating VirtueMart to version 3.2.2. my product pages are showing a 1064 error. This is the full error:

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 'DESC FROM `#__VIRTUEMART_PRODUCTS` AS P LEFT JOIN `#__VIRTUEMART_PRODUCTS_' AT LINE 1

I've did the following thing:

- Updated VM again
- Deleted cache
- Disabled VM modules
- Checked VMsettings
- Installed database tables again (with tools)

Still, I can't find the cause.

Any tips?

Cheers, Frank



jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

scooterpower

Thanks for your reaction.

The fix doesn't help me. Any other ideas?

I came from version 3.0.18 by the way.

Cheers, Frank

jjk

Quote from: scooterpower on May 23, 2017, 10:06:32 AM
The fix doesn't help me. Any other ideas?

If you unsuccessfully tried the 'Install or if necessary update tables" button in VM 'Tools & Migration' already, you may try to enable 'Debug System' in Joomla Configuration. Perhaps it gives you a hint about what might cause the error. (Could be a third party extension for example)
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

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/


jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum