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

Started by mabeall32, March 21, 2012, 02:52:06 AM

Previous topic - Next topic

dbcig2013

#15
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.
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

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.
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

Quote from: Milbo 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.




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

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

Quote from: Milbo on October 23, 2013, 22:15:13 PM
yeh the one in vm config

hi
you are right !!!

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

Thanks  a lot
David