News:

Support the VirtueMart project and become a member

Main Menu

Errors after upgrading

Started by micropalla, August 05, 2012, 20:50:00 PM

Previous topic - Next topic

micropalla

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