Hi,
I just discovered a little display bug while sorting in our product list.
Reproduce steps:
1. Go to product list
2. Sort on category collumn ASC or DESC
3. Jump into a category using the form above the product lists
4. **BOOM** bug shows up:
JDatabaseMySQLi::query: 1054 - Unknown column 'namescats' in 'order clause' SQL=SELECT pr.product_id, pr.product_publish, pr_cat.product_ordering, pr.`name_nl-NL` as name, pr.`short_description_nl-NL` as short_description, man.`name_nl-NL` as man_name, pr.product_ean as ean, pr.product_quantity as qty, pr.product_thumb_image as image, pr.product_price, pr.currency_id, pr.hits, pr.unlimited, pr.product_date_added, pr.label_id FROM `joomla_jshopping_products` AS pr LEFT JOIN `joomla_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `joomla_jshopping_manufacturers` AS man ON pr.product_manufacturer_id=man.manufacturer_id WHERE pr.parent_id=0 AND pr_cat.category_id = '10' order by namescats asc LIMIT 0 , 20
Terug naar controlepaneel
Call stack
# Function Location
1 JAdministrator->dispatch() /public_html/projecten/hb/joomla/administrator/index.php:46
2 JComponentHelper::renderComponent() /public_html/projecten/hb/joomla/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /public_html/projecten/hb/joomla/libraries/joomla/application/component/helper.php:351
4 require_once() /public_html/projecten/hb/joomla/libraries/joomla/application/component/helper.php:383
5 JController->execute() /public_html/projecten/hb/joomla/administrator/components/com_jshopping/jshopping.php:64
6 JshoppingControllerProducts->display() //public_html/projecten/hb/joomla/libraries/joomla/application/component/controller.php:761
7 JshoppingModelProducts->getAllProducts() /public_html/projecten/hb/joomla/administrator/components/com_jshopping/controllers/products.php:63
8 JDatabase->loadObjectList() /public_html/projecten/hb/joomla/administrator/components/com_jshopping/models/products.php:100
9 JDatabaseMySQLi->execute() /public_html/projecten/hb/joomla/libraries/joomla/database/database.php:1100
10 JError::raiseError() /public_html/projecten/hb/joomla/libraries/joomla/database/database/mysqli.php:396
11 JError::raise() /public_html/projecten/hb/joomla/libraries/joomla/error/error.php:251
Terug naar controlepaneel
Call stack
# Function Location
1 JAdministrator->dispatch() /public_html/projecten/hb/joomla/administrator/index.php:46
2 JComponentHelper::renderComponent() /public_html/projecten/hb/joomla/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /public_html/projecten/hb/joomla/libraries/joomla/application/component/helper.php:351
4 require_once() /public_html/projecten/hb/joomla/libraries/joomla/application/component/helper.php:383
5 JController->execute() /public_html/projecten/hb/joomla/administrator/components/com_jshopping/jshopping.php:64
6 JshoppingControllerProducts->display() //public_html/projecten/hb/joomla/libraries/joomla/application/component/controller.php:761
7 JshoppingModelProducts->getAllProducts() /public_html/projecten/hb/joomla/administrator/components/com_jshopping/controllers/products.php:63
8 JDatabase->loadObjectList() /public_html/projecten/hb/joomla/administrator/components/com_jshopping/models/products.php:100
9 JDatabaseMySQLi->execute() /public_html/projecten/hb/joomla/libraries/joomla/database/database.php:1100
10 JError::raiseError() /public_html/projecten/hb/joomla/libraries/joomla/database/database/mysqli.php:396
11 JError::raise() /public_html/projecten/hb/joomla/libraries/joomla/error/error.php:251
Joomla: 2.5.11
JoomShopping: 3.14.3
PHP: 5.2.14
MySQL: 5.1.53
JoomShopping: 3.14.3
PHP: 5.2.14
MySQL: 5.1.53