News:

Support the VirtueMart project and become a member

Main Menu

More errors with 2.0.6a !!! All tables not working :|

Started by lipes, April 22, 2012, 01:01:16 AM

Previous topic - Next topic

lipes

I've instaled the 2.0.6a aio update few minutes ago to see if my registration problem could be solved.... then i've go to VM BE to see the update and i've clicked in Manufacturer menu and others options and i got error message :

categories:
vmError: exeSortSearchListQuery Table 'joom751.jos_virtuemart_categories_pt_pt' 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 `jos_virtuemart_categories_pt_pt` l JOIN `jos_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `jos_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY category_name DESC

Manufacturers:
vmError: exeSortSearchListQuery Table 'joom751.jos_virtuemart_manufacturers_pt_pt' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS `m`.*,`jos_virtuemart_manufacturers_pt_pt`.*, mc.`mf_category_name` FROM `jos_virtuemart_manufacturers_pt_pt` JOIN `jos_virtuemart_manufacturers` as m USING (`virtuemart_manufacturer_id`) LEFT JOIN `jos_virtuemart_manufacturercategories_pt_pt` AS mc on mc.`virtuemart_manufacturercategories_id`= `m`.`virtuemart_manufacturercategories_id` ORDER BY mf_name DESC LIMIT 0, 10


Products:
vmError: exeSortSearchListQuery Table 'joom751.jos_virtuemart_products_pt_pt' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `jos_virtuemart_products_pt_pt` as l JOIN `jos_virtuemart_products` AS p using (`virtuemart_product_id`)group by p.`virtuemart_product_id` ORDER BY p.virtuemart_product_id DESC LIMIT 0, 10
Warning: array_unshift() expects parameter 1 to be array, null given in D:\Ampps\www\mp10\administrator\components\com_virtuemart\models\manufacturer.php on line 123

Payments
vmError: exeSortSearchListQuery Table 'joom751.jos_virtuemart_paymentmethods_pt_pt' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS o.*, CONCAT_WS(' ',u.first_name,u.middle_name,u.last_name) AS order_name ,pm.payment_name AS payment_method FROM jos_virtuemart_orders as o LEFT JOIN jos_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN jos_virtuemart_paymentmethods_pt_pt as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE o.virtuemart_vendor_id = "1" ORDER BY created_on DESC LIMIT 0, 10

Etc... Nothing works!! :(   Now i dont have any products and products categories tables, etc..
VM V. online: J2.5.14 | VM 2.0.20a | SQL 5.1.70 | PHP 5.3.25

lipes

solved... i've instaled again joomla + vm2.0.6 .. and using from beggin pt-pt until this moment its working
VM V. online: J2.5.14 | VM 2.0.20a | SQL 5.1.70 | PHP 5.3.25