vmERror - exeSortSearchListQuery Unknown column????????

[dbcig2013]

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]

NO Idea at all ??

any workaround would be greatly appreciated....

thanks
David

[Milbo]

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.

[dbcig2013]

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]

Just disable the ordering of "ordering". I found the problem btw. There will be a new version today with a fix for this.

[dbcig2013]

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]

yeh the one in vm config

[dbcig2013]

yeh the one in vm config

hi
you are right !!!

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

Thanks  a lot
David