vmError: exeSortSearchListQuery Column 'virtuemart

Started by René Mendel, June 11, 2012, 14:27:00 PM

Previous topic - Next topic

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
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!

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é  :D
- A thread solved is a thread [SOLVED]! (a memo for myself)