Author Topic: vmERror - exeSortSearchListQuery Unknown column????????  (Read 17381 times)

dbcig2013

  • Beginner
  • *
  • Posts: 36
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #15 on: September 15, 2013, 10:53:11 am »
similar pb  only with the search field
Any kind of search field do not work, (except the "its google search " module )

vmError: exeSortSearchListQuery Unknown column 'pc.ordering' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `xxxxx_virtuemart_products_fr_fr` as l JOIN `xxxxx_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `xxxxx_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `xxxxx_virtuemart_categories_fr_fr` as c ON c.`virtuemart_category_id` =

No pb with the order fonction.



last version of joomla, virtuemart and virtuemart aio, 
table updated correctly.(via installation module and virtuemart  tool )

Joomla 2.5.14  virtuemart ( and aio) 2.022c

dbcig2013

  • Beginner
  • *
  • Posts: 36
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #16 on: October 21, 2013, 23:04:00 pm »
NO Idea at all ??

any workaround would be greatly appreciated....

thanks
David

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10530
  • VM4.0.7 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #17 on: October 22, 2013, 10:51:46 am »
Not reproduceable with the latest version, please update

It seems to be also very rare. We need more information about your ordering and sorting options.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

dbcig2013

  • Beginner
  • *
  • Posts: 36
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #18 on: October 22, 2013, 20:24:41 pm »
Pb appeared the first time after update to 2.0.22
I tried to disable the other component installed at the same time ( artio joomsef) without any success.

the pb appear for every kind of research ( virtuemart product or othe content )

all of the other plugin or  search module ( vm search, joomla search,..) do not work as well ( same error) except the "itps google search module".


of courses, table updated and virtuemart aio updated as well
Dernière version 2.0.24  //  Joomla!, 2.5.14.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10530
  • VM4.0.7 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #19 on: October 23, 2013, 11:21:35 am »
Just disable the ordering of "ordering". I found the problem btw. There will be a new version today with a fix for this.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

dbcig2013

  • Beginner
  • *
  • Posts: 36
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #20 on: October 23, 2013, 21:24:43 pm »
Just disable the ordering of "ordering". I found the problem btw. There will be a new version today with a fix for this.




where ? in  php myadmin on the server ?
as, i m not able to find any kind of 'ordering disable option' in virtuemart configuration;  except the default ordering option in "product ordering"  for the customer.

thanks
david

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10530
  • VM4.0.7 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #21 on: October 23, 2013, 22:15:13 pm »
yeh the one in vm config
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

dbcig2013

  • Beginner
  • *
  • Posts: 36
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #22 on: October 24, 2013, 00:33:53 am »
yeh the one in vm config

hi
you are right !!!

It seems so obvious when you know the answer ...

Thanks  a lot
David