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
Similar to http://forum.virtuemart.net/index.php?topic=137537 - try the same fix.
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
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)
He should directly try http://dev.virtuemart.net/attachments/download/1086/com_virtuemart.3.2.3.9614_extract_first.zip
Quote from: Milbo on August 07, 2017, 11:41:29 AM
He should directly try http://dev.virtuemart.net/attachments/download/1086/com_virtuemart.3.2.3.9614_extract_first.zip
Thank you, that did fix the issue I was having!
Quote from: shopintex on August 08, 2017, 01:37:13 AM
i have problem :-\
Is this a guessing game? See http://forum.virtuemart.net/index.php?topic=104795.0