Aw: Bug of sorting by category
thanks for answers.
The problem was there befor update (there was ver 3.7.2.), i have updated 3.10.0 (step by step), but the problems stil there.(
Joomla version 2.5.6
Joomshopping version 3.10.0
PHP 5.2.17
MySQL 5.0.95-community-log
I turn on debug mode, and there is error
JDatabaseMySQLi::query: 1054 - Unknown column 'namescats' in 'order clause' SQL=SELECT pr.product_id, pr.product_publish, pr_cat.product_ordering, pr.`name_ru-RU` as name, pr.`short_description_ru-RU` as short_description, man.`name_ru-RU` 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 , pr.vendor_id, V.f_name as v_f_name, V.l_name as v_l_name FROM `r8796_jshopping_products` AS pr LEFT JOIN `r8796_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `r8796_jshopping_manufacturers` AS man ON pr.product_manufacturer_id=man.manufacturer_id left join `r8796_jshopping_vendors` as V on pr.vendor_id=V.id WHERE pr.parent_id=0 AND pr_cat.category_id = '9' order by namescats asc LIMIT 0 , 7
Вернуться в Панель управления
Call stack
# Function Location
1 JAdministrator->dispatch() /home/boutique/public_html/administrator/index.php:46
2 JComponentHelper::renderComponent() /home/boutique/public_html/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /home/boutique/public_html/libraries/joomla/application/component/helper.php:351
4 require_once() /home/boutique/public_html/libraries/joomla/application/component/helper.php:383
5 JController->execute() /home/boutique/public_html/administrator/components/com_jshopping/admin.jshopping.php:66
6 JshoppingControllerProducts->display() /home/boutique/public_html/libraries/joomla/application/component/controller.php:760
7 JshoppingModelProducts->getAllProducts() /home/boutique/public_html/administrator/components/com_jshopping/controllers/products.php:63
8 JDatabase->loadObjectList() /home/boutique/public_html/administrator/components/com_jshopping/models/products.php:99
9 JDatabaseMySQLi->execute() /home/boutique/public_html/libraries/joomla/database/database.php:1100
10 JError::raiseError() /home/boutique/public_html/libraries/joomla/database/database/mysqli.php:396
11 JError::raise() /home/boutique/public_html/libraries/joomla/error/error.php:251