vmError: exeSortSearchListQuery Column 'virtuemart

[René Mendel]

vmError: exeSortSearchListQuery Column 'virtuemart_manufacturercategories_id' in order clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `jos_virtuemart_manufacturercategories_nl_nl` as l JOIN `jos_virtuemart_manufacturercategories` as mc using (`virtuemart_manufacturercategories_id`) ORDER BY virtuemart_manufacturercategories_id DESC LIMIT 0, 20

Joomla 1.5.26 VM 2.06

How to solve this problem ?

[irina]

I have the same problem,
do you could resolved it ?

[bytelord]

Hi,

Did you try from the backend to go to Tools->Tools & Migration and click the option Install tables or if necessary update them

Regards

[lliseil]

Sorry for hijacking the post. Got the same issue with "vmerror: exeSortSearchListQuery Column <SNIP>" after we updated a VM2 shopping-cart from 2.0.14 to 2.0.18a. Actually it also caused the products list to not display ,,-|

« Install tables or if necessary update them » solved the issue so far.
Thank you bytelord and René