Left side menu problem

Hi

I have updated joomla and VM to the newest wersion and I have problem with the left menu, when I click any position I'm getting that:

vmError: exeSortSearchListQuery Unknown column 'p.product_name' in 'order clause' SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `tvmip_virtuemart_products_en_gb` as l JOIN `tvmip_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `tvmip_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `tvmip_virtuemart_categories_en_gb` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `tvmip_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `tvmip_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `tvmip_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `tvmip_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `pc`.`virtuemart_category_id` = 37 AND ( s.`virtuemart_shoppergroup_id`= "4" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY p.product_name ASC LIMIT 0, 4

Any Idea how I can fix it?

Go to extension manager , database tab. If you see some button saying click here to repair database click on it

I just did and that doesn't help at all same error
vmError: exeSortSearchListQuery Unknown column 'p.product_name' in 'order clause' SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `tvmip_virtuemart_products_en_gb` as l JOIN `tvmip_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `tvmip_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `tvmip_virtuemart_categories_en_gb` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `tvmip_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `tvmip_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `tvmip_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `tvmip_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `pc`.`virtuemart_category_id` = 35 AND ( s.`virtuemart_shoppergroup_id`= "4" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY p.product_name ASC LIMIT 0, 4

Try this to go vm admin in backed, then configuration->configuration> "Product Order Settings" tab then check some "Available Sort-by fields" (ones you need) and save.

Thanks Ivan that was it! thanks again.