Bug of sorting by category

11.09.2012 20:29
#1
andreynk79
Joomshopping forum user no avatar
Name: Andrey
13.07.2012
Posts: 4
Quote
Bug of sorting by category

Hello. Have problem: In backend, when administrator atempt sorting products by category theare is appear next bug:

Warning: Invalid argument supplied for foreach() in /home/boutique/public_html/administrator/components/com_jshopping/controllers/products.php on line 68


Warning: Invalid argument supplied for foreach() in /home/boutique/public_html/administrator/components/com_jshopping/controllers/products.php on line 108


Warning: Invalid argument supplied for foreach() in /home/boutique/public_html/administrator/components/com_jshopping/views/product_list/tmpl/default.php on line 102

Please, help.
Bug of sorting by category

 
11.09.2012 20:33
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
Quote
Aw: Bug of sorting by category

After update?

Enable debug mode, see errors.

 
11.09.2012 20:34
#3
FrankG.
User FrankG.
Name: Frank
30.11.2011
Posts: 1600
Quote
Aw: Bug of sorting by category

Joomla version? Joomshopping version? PHP version? MySQL version?

 
11.09.2012 20:56
#4
andreynk79
Joomshopping forum user no avatar
Name: Andrey
13.07.2012
Posts: 4
Quote
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

 
11.09.2012 21:24
#5
andreynk79
Joomshopping forum user no avatar
Name: Andrey
13.07.2012
Posts: 4
Quote
Aw: Bug of sorting by category

The problem solved. Actualy i did nothing, and think, i have needed to clean cach after updating jooshopping or something. But now it's OK. Thanks.

 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.