Sorting bug at products

02.07.2013 10:39
#1
borre
Joomshopping forum user no avatar
Name: bjorn
10.06.2013
Posts: 1
Quote
Sorting bug at products

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



Joomla: 2.5.11
JoomShopping: 3.14.3
PHP: 5.2.14
MySQL: 5.1.53
 
02.07.2013 19:46
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16517
Quote
Aw: Sorting bug at products

Thank you

 
Copyrights MAXXmarketing GmbH. All Rights Reserved