Author Topic: Help! VirtueMart 2.0.16 Product Search cant worked. Joomla! 2.5.8  (Read 2522 times)

aronxie

  • Beginner
  • *
  • Posts: 8
When I try to search sth, it display below message:

vmError: exeSortSearchListQuery Column 'ordering' in where clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `jml_virtuemart_products_zh_cn` as l JOIN `jml_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `jml_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `jml_virtuemart_categories_zh_cn` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `jml_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `jml_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `jml_virtuemart_manufacturers_zh_cn` as m ON m.`virtuemart_manufacturer_id` = `jml_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `jml_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` LEFT JOIN `jml_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `jml_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `jml_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `jml_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ((`product_name` LIKE "%karicare%" OR `product_s_desc` LIKE "%karicare%" OR `category_name` LIKE "%karicare%" OR `category_description` LIKE "%karicare%" OR `mf_name` LIKE "%karicare%" OR `product_price` LIKE "%karicare%" OR `product_availability` LIKE "%karicare%" OR `ordering` LIKE "%karicare%") AND p.`published`="1" AND `pc`.`virtuemart_category_id` > 0 AND ( s.`virtuemart_shoppergroup_id`= "2" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY product_name ASC LIMIT 0, 9

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10404
  • VirtueMart Version: 3+
Re: Help! VirtueMart 2.0.16 Product Search cant worked. Joomla! 2.5.8
« Reply #1 on: December 26, 2012, 21:30:12 pm »
did you update the "all in one" component?

J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)

aronxie

  • Beginner
  • *
  • Posts: 8
Re: Help! VirtueMart 2.0.16 Product Search cant worked. Joomla! 2.5.8
« Reply #2 on: December 26, 2012, 22:19:23 pm »
did you update the "all in one" component?

Yes, I did.

[attachment cleanup by admin]

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10404
  • VirtueMart Version: 3+
Re: Help! VirtueMart 2.0.16 Product Search cant worked. Joomla! 2.5.8
« Reply #3 on: December 26, 2012, 22:34:36 pm »
is this backend or frontend?

have you tried

"tools & migration"  "install or update tables"   ?
J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)

aronxie

  • Beginner
  • *
  • Posts: 8
Re: Help! VirtueMart 2.0.16 Product Search cant worked. Joomla! 2.5.8
« Reply #4 on: December 26, 2012, 22:57:40 pm »
is this backend or frontend?

have you tried

"tools & migration"  "install or update tables"   ?

This is the frontend. Yes, I have tried the "install or update tables".

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3643
  • using Matomo instead of Google Analytics
Re: Help! VirtueMart 2.0.16 Product Search cant worked. Joomla! 2.5.8
« Reply #5 on: December 27, 2012, 14:37:24 pm »
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

aronxie

  • Beginner
  • *
  • Posts: 8
Re: Help! VirtueMart 2.0.16 Product Search cant worked. Joomla! 2.5.8
« Reply #6 on: December 28, 2012, 06:17:56 am »
Perhaps the same problem/solution as this one:
http://forum.virtuemart.net/index.php?topic=111341.msg373996#msg373996

I have changed the the "case 'ordering':" to "case '`pc`.ordering':". But still doesn't work. Could you help to find the problem? thank you

vmError: exeSortSearchListQuery Column 'ordering' in where clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `jml_virtuemart_products_zh_cn` as l JOIN `jml_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `jml_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `jml_virtuemart_categories_zh_cn` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `jml_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `jml_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `jml_virtuemart_manufacturers_zh_cn` as m ON m.`virtuemart_manufacturer_id` = `jml_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `jml_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` LEFT JOIN `jml_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `jml_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `jml_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `jml_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ((`product_name` LIKE "%karicare%" OR `product_s_desc` LIKE "%karicare%" OR `category_name` LIKE "%karicare%" OR `category_description` LIKE "%karicare%" OR `mf_name` LIKE "%karicare%" OR `product_price` LIKE "%karicare%" OR `product_availability` LIKE "%karicare%" OR `ordering` LIKE "%karicare%") AND p.`published`="1" AND `pc`.`virtuemart_category_id` > 0 AND ( s.`virtuemart_shoppergroup_id`= "2" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY product_name ASC LIMIT 0, 9

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10404
  • VirtueMart Version: 3+
J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)