VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: René Mendel on June 11, 2012, 14:27:00 PM

Title: vmError: exeSortSearchListQuery Column 'virtuemart
Post by: René Mendel on June 11, 2012, 14:27:00 PM
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 ?
Title: Re: vmError: exeSortSearchListQuery Column 'virtuemart
Post by: irina on October 03, 2012, 15:24:25 PM
I have the same problem,
do you could resolved it ?
Title: Re: vmError: exeSortSearchListQuery Column 'virtuemart
Post by: bytelord on October 03, 2012, 17:48:53 PM
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
Title: Re: vmError: exeSortSearchListQuery Column 'virtuemart
Post by: lliseil on January 31, 2013, 21:27:03 PM
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é  :D