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

mabeall32

  • Jr. Member
  • **
  • Posts: 116
vmERror - exeSortSearchListQuery Unknown column????????
« 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

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10437
  • VirtueMart Version: 3+
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #1 on: March 21, 2012, 02:57:36 am »
tools
"install or update tables"


mabeall32

  • Jr. Member
  • **
  • Posts: 116
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #2 on: March 21, 2012, 03:02:49 am »
Reinstall 2.03e and 2.03e aoi?

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10437
  • VirtueMart Version: 3+
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #3 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

Logickske

  • Beginner
  • *
  • Posts: 5
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #4 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


PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10437
  • VirtueMart Version: 3+
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #5 on: March 02, 2013, 19:37:06 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

Logickske

  • Beginner
  • *
  • Posts: 5
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #6 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]

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10437
  • VirtueMart Version: 3+
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #7 on: March 03, 2013, 18:50:00 pm »
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

Logickske

  • Beginner
  • *
  • Posts: 5
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #8 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?

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10495
  • VM4.0.7 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #9 on: March 03, 2013, 21:19:19 pm »
lol   search for a & b instead of b & a
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Logickske

  • Beginner
  • *
  • Posts: 5
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #10 on: March 03, 2013, 21:24:06 pm »
lol   search for a & b instead of b & a

????  Don't understand what you mean with that :-S

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10437
  • VirtueMart Version: 3+
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #11 on: March 03, 2013, 22:14:12 pm »
"install or if necessary update tables"


goeher

  • Beginner
  • *
  • Posts: 3
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #12 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

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10495
  • VM4.0.7 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #13 on: September 06, 2013, 14:11:40 pm »
Version? updated?
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

goeher

  • Beginner
  • *
  • Posts: 3
Re: vmERror - exeSortSearchListQuery Unknown column????????
« Reply #14 on: September 06, 2013, 14:32:55 pm »
Virtuemart 2.022c
Joomla 2.5.14

Both are latest versions