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
tools
"install or update tables"
Reinstall 2.03e and 2.03e aoi?
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
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
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
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]
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
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?
lol search for a & b instead of b & a
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
"install or if necessary update tables"
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
Version? updated?
Virtuemart 2.022c
Joomla 2.5.14
Both are latest versions
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
NO Idea at all ??
any workaround would be greatly appreciated....
thanks
David
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.
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.
Just disable the ordering of "ordering". I found the problem btw. There will be a new version today with a fix for this.
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
yeh the one in vm config
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