1064 error on product page after updating VM to 3.2.2

[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]

Similar to http://forum.virtuemart.net/index.php?topic=137537  - try the same fix.

[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]

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)

[Milbo]

He should directly try http://dev.virtuemart.net/attachments/download/1086/com_virtuemart.3.2.3.9614_extract_first.zip

[scooterpower]

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!

[jenkinhill]

i have problem 

Is this a guessing game?  See http://forum.virtuemart.net/index.php?topic=104795.0