I have a database issue in my VM Shop (2.04) which cannot be fixed by the database repair tools. In the backend a get this error:
vmError: exeSortSearchListQuery Unknown column 'product_name' in 'order clause' 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 `z6pos_virtuemart_categories_de_de` l JOIN `z6pos_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `z6pos_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY product_name ASC
The product categories are correctly displayed in the products listing, but I cannot use the categories filter (no categories in dropdown menu). When I try to edit a product, the categories have vanished and I cannot add any new category.
Is there really nobody who can help me with this issue?
http://forum.virtuemart.net/index.php?topic=99927.0
might help