Joomla 1.0.9 and Virtuemart 1.0.0 problems with MySQL 5

One of my clients just complained his Joomla/Virtuemart website stopped to work.
Joomla was pretty old, version 1.0.9, the same ancient version was Virtuemart.

The description was more meaningful: it looks working but the list of products is empty.
Admin panel however shows a lot of products and everything looks ok from that side.

The client was completely disappointed because nothing has been changed on the site since month ago when everything worked just fine.

The only major update on our server for that month was MySQL database upgrade from version 4.xx to MySQL 5.

And that was the answer:
Virtuemart's SQL statements just crashed on the new database.
I'm totally disappointed with both Virtuemart and MySQL and how they work with each other. :)

Here is the solution.

1. Find administrator/components/com_virtuemart/html/shop_browse_queries.php file and backup it.

2. Find the following line in the file

#__{vm}_product, #__{vm}_category, #__{vm}_product_category_xref,#__{vm}_shopper_group

and replace it with this one:
(#__{vm}_product, #__{vm}_category, #__{vm}_product_category_xref,#__{vm}_shopper_group)

There are 4 replacements required for the file.

3. Enjoy! or let me know if you have any problem...


So as I understand MySQL brought more restrictions on version 5 so your website might experience some problems with such upgrade.