Author Topic: vmError: exeSortSearchListQuery Column 'virtuemart  (Read 1872 times)

René Mendel

  • Beginner
  • *
  • Posts: 4
vmError: exeSortSearchListQuery Column 'virtuemart
« 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 ?

irina

  • Beginner
  • *
  • Posts: 2
Re: vmError: exeSortSearchListQuery Column 'virtuemart
« Reply #1 on: October 03, 2012, 15:24:25 pm »
I have the same problem,
do you could resolved it ?

bytelord

  • Nikos
  • Global Moderator
  • Full Member
  • *
  • Posts: 2369
Re: vmError: exeSortSearchListQuery Column 'virtuemart
« Reply #2 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
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

  • Beginner
  • *
  • Posts: 34
  • Man is Web's future.
    • LLiseil Web services e-Commerce Virtuemart
  • VirtueMart Version: 2.0.26
Re: vmError: exeSortSearchListQuery Column 'virtuemart
« Reply #3 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
- A thread solved is a thread [SOLVED]! (a memo for myself)