VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: mabeall32 on March 21, 2012, 02:52:06 AM

Title: vmERror - exeSortSearchListQuery Unknown column????????
Post by: mabeall32 on March 21, 2012, 02:52:06 AM
I getting the following error. When I try to select a category there is no selection.  What should I do to correct this?

vmError: exeSortSearchListQuery Unknown column 'p.virtuemart_product_id' in 'order clause' SQL=SELECT SQL_CALC_FOUND_ROWS  c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`  FROM `zn0ut_virtuemart_categories_en_gb` l              JOIN `zn0ut_virtuemart_categories` AS c using (`virtuemart_category_id`)              LEFT JOIN `zn0ut_virtuemart_category_categories` AS cx              ON l.`virtuemart_category_id` = cx.`category_child_id`  WHERE  c.`published` = 1  AND  cx.`category_parent_id` = 0 ORDER BY p.virtuemart_product_id ASC LIMIT 0, 9
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: PRO on March 21, 2012, 02:57:36 AM
tools
"install or update tables"

Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: mabeall32 on March 21, 2012, 03:02:49 AM
Reinstall 2.03e and 2.03e aoi?
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: PRO on March 21, 2012, 10:51:43 AM
NO

WHEN; You upgrade from a previous version of 2.0, and there have been changes in the database.
The "update tables or install if necessary" tool fixes the tables.

GO to tools and migration, and click that button
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: Logickske on March 02, 2013, 19:19:50 PM
I have the same problem.. Can you please show me a printscreen of the PhpMyAdmin where i can find "GO to tools and migration, and click that button" that.. I have a dutch version of PhpMyAdmin and don't know where to look..

Thank you in advance

Kind regards

Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: PRO on March 02, 2013, 19:37:06 PM
Quote from: Logickske on March 02, 2013, 19:19:50 PM
I have the same problem.. Can you please show me a printscreen of the PhpMyAdmin where i can find "GO to tools and migration, and click that button" that.. I have a dutch version of PhpMyAdmin and don't know where to look..

Thank you in advance

Kind regards



its in your virtuemart administrator, not phpmyadmin
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: Logickske on March 03, 2013, 13:33:09 PM
Ok,

If I go to that menu in my administrator section I have these buttons: (see attachment).

I have to click on witch one to fix the error?

Thank you in advance!



[attachment cleanup by admin]
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: PRO on March 03, 2013, 18:50:00 PM
Quote from: PRO on March 21, 2012, 10:51:43 AM
NO

WHEN; You upgrade from a previous version of 2.0, and there have been changes in the database.
The "update tables or install if necessary" tool fixes the tables.

GO to tools and migration, and click that button


^^^

but first you need to enable the tools
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: Logickske on March 03, 2013, 20:07:01 PM
Ok i have enabled the option but now in "tools & migration" i dont see the button "update tables or install if necessary"

See printscreen in previous post..

And now?
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: Milbo on March 03, 2013, 21:19:19 PM
lol   search for a & b instead of b & a
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: Logickske on March 03, 2013, 21:24:06 PM
Quote from: Milbo on March 03, 2013, 21:19:19 PM
lol   search for a & b instead of b & a

????  Don't understand what you mean with that :-S
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: PRO on March 03, 2013, 22:14:12 PM
"install or if necessary update tables"

Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: goeher on September 06, 2013, 10:22:55 AM
Hi,
this is my first mail on  this Forum, then Hello!!!

When I am trying to sort by name, I am getting something like this:

vmError: exeSortSearchListQuery Unknown column 'p.product_name' in 'order clause' SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `c0wsv_virtuemart_products_pl_pl` as l JOIN `c0wsv_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `c0wsv_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `c0wsv_virtuemart_categories_pl_pl` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `c0wsv_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `c0wsv_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `c0wsv_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `c0wsv_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `pc`.`virtuemart_category_id` = 1 AND `pc`.`virtuemart_category_id` > 0 AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id`= "2" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY p.product_name ASC LIMIT 0, 18

"install or if necessary update tables" is not giving any result. Important, I think, is information, that I am working with 1-language Virtuemart Shop in PL (Polish).

I hope, I will get some help. Please look "carefully" - I am totally NEWBIE...

Regards
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: Milbo on September 06, 2013, 14:11:40 PM
Version? updated?
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: goeher on September 06, 2013, 14:32:55 PM
Virtuemart 2.022c
Joomla 2.5.14

Both are latest versions
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: dbcig2013 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
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: dbcig2013 on October 21, 2013, 23:04:00 PM
NO Idea at all ??

any workaround would be greatly appreciated....

thanks
David
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: Milbo 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.
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: dbcig2013 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.
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: 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.
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: dbcig2013 on October 23, 2013, 21:24:43 PM
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
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: Milbo on October 23, 2013, 22:15:13 PM
yeh the one in vm config
Title: Re: vmERror - exeSortSearchListQuery Unknown column????????
Post by: dbcig2013 on October 24, 2013, 00:33:53 AM
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