exeSortSearchListQuery error

[liquid.ideas]

Hi Guys,


I have gone through all the posts on this and most peoples seems to be fixed by install/update tables in VM backend, mine however is not!! At my wits end here!

I have Joomla 2.5 and VM 2.0.20b

If i click on a category in my frontend the products do not show up I can however search for the products and they come up, in VM debugging I am getting this

Code Select Expand

vmdebug exeSortSearchListQuery error in class VirtueMartModelProduct sql: Var1:

Unknown column 'v4p3i_virtuemart_product_categories.virtuemart_category_id' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS  l.`virtuemart_product_id` FROM `v4p3i_virtuemart_products_en_gb` as l JOIN `v4p3i_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `v4p3i_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`"

I have tried everything I have seen in the forums to no avail! I have even translated some foreighn forums! Any help would be much appreciated!

[Milbo]

You may try in tools the table corrector.