News:

Support the VirtueMart project and become a member

Main Menu

VirtueMart 2.0.14 product search mysql error

Started by htexperts, November 13, 2012, 20:09:12 PM

Previous topic - Next topic

htexperts

Hello together,

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


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.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

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)

:(((