VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: micropalla on August 05, 2012, 20:50:00 PM

Title: Errors after upgrading
Post by: micropalla on August 05, 2012, 20:50:00 PM
Hi guys!

I've got some problems after upgrading my VM.
This is it.

I had Joomla 1.5.26 and VM 1.0.9 on my website.
First of all I've upgraded VM from 1.0.9 to 2.0.8e and all was ok.
Then I've upgraded Joomla to 1.5.26. After JUpgrade did its job I receive a lots of errors.

As I open VM no menu on the left.
Moreover there are these warnings:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mhd/www.cfbonline.it/htdocs/libraries/joomla/database/database/mysql.php on line 293
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mhd/www.cfbonline.it/htdocs/libraries/joomla/database/database/mysql.php on line 293
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mhd/www.cfbonline.it/htdocs/libraries/joomla/database/database/mysql.php on line 293
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mhd/www.cfbonline.it/htdocs/libraries/joomla/database/database/mysql.php on line 293
Warning: Invalid argument supplied for foreach() in /home/mhd/www.cfbonline.it/htdocs/administrator/components/com_virtuemart/views/virtuemart/view.html.php on line 60


If I go in Products it shows me these errors:

vmError: exeSortSearchListQuery Table 'cfbonlineit.j25_virtuemart_products' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `j25_virtuemart_products_it_it` as l JOIN `j25_virtuemart_products` AS p using (`virtuemart_product_id`)group by p.`virtuemart_product_id` ORDER BY p.virtuemart_product_id DESC LIMIT 0, 10
vmError: exeSortSearchListQuery Table 'cfbonlineit.j25_virtuemart_categories' doesn't exist SQL=SELECT c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `j25_virtuemart_categories_it_it` l JOIN `j25_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `j25_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY category_name ASC


What can I do??
Thanks