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
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
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 Gottwals
30.11.2011
Posts: 664
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. All Rights Reserved