VirtueMart 2.0.14 product search mysql error

[htexperts]

Hello together,

unfortunatly our product search isnt working.
in debug mode, i see the following mysql error

Code Select Expand


JDatabaseMySQL::query: 1052 - Column 'ordering' in where clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `oscik_virtuemart_products_de_de` as l JOIN `oscik_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `oscik_virtuemart_product_categories` ON p.`virtuemart_product_id` = `oscik_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `oscik_virtuemart_categories_de_de` as c ON c.`virtuemart_category_id` = `oscik_virtuemart_product_categories`.`virtuemart_category_id` LEFT JOIN `oscik_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `oscik_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `oscik_virtuemart_manufacturers_de_de` as m ON m.`virtuemart_manufacturer_id` = `oscik_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `oscik_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `oscik_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `oscik_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `oscik_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ((`product_name` LIKE "%uhr%" OR `product_sku` LIKE "%uhr%" OR `product_s_desc` LIKE "%uhr%" OR `category_name` LIKE "%uhr%" OR `category_description` LIKE "%uhr%" OR `mf_name` LIKE "%uhr%" OR `ordering` LIKE "%uhr%") AND p.`published`="1" AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY p.modified_on ASC LIMIT 0, 10


virtuemart version is: 2.0.14

also, the "select product type" dropdown menu is empty
i tried a lot of product version of the product name, everytime the same error.

thanks for your advice and time

[jenkinhill]

It is working OK for me, J2.5.8 MySQL 5.1.65-cll  PHP 5.3.17

Did you apply the aio component update, too.

[htexperts]

hello,

yes i did:

Sie haben die aktuelle Version (you have the latest version)
Installierte Version 2.0.14 (installed version)
Neueste Version 2.0.14 (latest version)
Neuestes Veröffentlichungsdatum 2012-11-13 (latest release date)

((