Bug on shared ordering (Product Categories)

[sweetkurapika]

Once I wanted to deactivate all shared product categories, I got the following error message:

vmError: exeSortSearchListQuery Unknown column 'cx.category_shared' 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 `jab_virtuemart_categories_en_gb` l JOIN `jab_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `jab_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY cx.category_shared ASC


Could you please tell me what to do?

[jenkinhill]

Sounds like tables need updating. How did you " try from the backend to go to Tools->Tools & Migration and click the option Install tables or if necessary update them"

Try in the backend to go to Tools->Tools & Migration and click the option Install tables or if necessary update them (on a backup, of course).