Column 'ordering' in where clause is ambiguous

[htexperts]

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_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 product_name ASC LIMIT 0, 10

Call stack
# Function Location
1 JSite->dispatch() /homepages/14/d27010350/htdocs/joomla_shop/joomla_shop/index.php:42
2 JComponentHelper::renderComponent() /homepages/14/d27010350/htdocs/joomla_shop/joomla_shop/includes/application.php:198
3 JComponentHelper::executeComponent() /homepages/14/d27010350/htdocs/joomla_shop/joomla_shop/libraries/joomla/application/component/helper.php:357
4 require_once() /homepages/14/d27010350/htdocs/joomla_shop/joomla_shop/libraries/joomla/application/component/helper.php:388
5 JController->execute() /homepages/14/d27010350/htdocs/joomla_shop/joomla_shop/components/com_virtuemart/virtuemart.php:98
6 VirtueMartControllerCategory->display() /homepages/14/d27010350/htdocs/joomla_shop/joomla_shop/libraries/joomla/application/component/controller.php:754
7 VirtuemartViewCategory->display() /homepages/14/d27010350/htdocs/joomla_shop/joomla_shop/components/com_virtuemart/controllers/category.php:56
8 VirtueMartModelProduct->getProductsInCategory() /homepages/14/d27010350/htdocs/joomla_shop/joomla_shop/components/com_virtuemart/views/category/view.html.php:173
9 VirtueMartModelProduct->sortSearchListQuery() /homepages/14/d27010350/htdocs/joomla_shop/joomla_shop/administrator/components/com_virtuemart/models/product.php:1081
10 VmModel->exeSortSearchListQuery() /homepages/14/d27010350/htdocs/joomla_shop/joomla_shop/administrator/components/com_virtuemart/models/product.php:484
11 JDatabase->loadResultArray() /homepages/14/d27010350/htdocs/joomla_shop/joomla_shop/administrator/components/com_virtuemart/helpers/vmmodel.php:365
12 JDatabase->loadColumn() /homepages/14/d27010350/htdocs/joomla_shop/joomla_shop/libraries/joomla/database/database.php:1800
13 JDatabaseMySQL->query() /homepages/14/d27010350/htdocs/joomla_shop/joomla_shop/libraries/joomla/database/database.php:936
14 JError::raiseError() /homepages/14/d27010350/htdocs/joomla_shop/joomla_shop/libraries/joomla/database/database/mysql.php:542
15 JError::raise() /homepages/14/d27010350/htdocs/joomla_shop/joomla_shop/libraries/joomla/error/error.php:251


Virtuemart and AIO is up to date. (latest Version)
thanks for your advice!

[Milbo]

How do you create it? which condition? Be product listing sorting for ordering? oder wie?

Sorry I was not able to recreate.