Attribute error

03.11.2012 15:38
#1
rutgerkamp
Joomshopping forum user no avatar
Name: Rutger
19.06.2012
Posts: 4
Quote
Attribute error

I get the following errors when I open a product detail page (see: http://www.prosnow.nl/shop/abs-lawine-rugzak/abs-rugzakken/abs-powder-backpack-black-15l.html). It has something to do with the attributes which are not fuctioning anymore. How can I fix this problem? Thank you in advance!


Warning: Invalid argument supplied for foreach() in /public/sites/www.prosnow.nl/components/com_jshopping/tables/attribut.php on line 33

Warning: Invalid argument supplied for foreach() in /public/sites/www.prosnow.nl/components/com_jshopping/lib/factory.php on line 340

Warning: Invalid argument supplied for foreach() in /public/sites/www.prosnow.nl/components/com_jshopping/tables/attribut.php on line 33

Warning: Invalid argument supplied for foreach() in /public/sites/www.prosnow.nl/components/com_jshopping/tables/product.php on line 890


Joomla: 2.5.7
JoomShopping: 3.11.4
PHP: 5.3.3-7+squeeze3
Website Url: http//www.prosnow.nl
 
03.11.2012 17:45
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16518
Quote
Aw: Attribute error

Update?

update again step to step.

 
04.11.2012 13:50
#3
rutgerkamp
Joomshopping forum user no avatar
Name: Rutger
19.06.2012
Posts: 4
Quote
Aw: Attribute error

Thanks for you suggestion! I did the following updates again and got 3 errors with installing the first 3 updates.After the updates I still have the problem with my atributes. Is it possible to reinstall Joomshopping and keep the product information?

Component Update 3.11.3 -> 3.11.4
Component Update 3.11.2 -> 3.11.3
Component Update 3.11.1 -> 3.11.2
Component Update 3.11.0 -> 3.11.1

Component Update 3.10.0 -> 3.11.0 "Duplicate column name 'multilist' SQL=alter table `kamp_jshopping_products_extra_fields` ADD COLUMN `multilist` tinyint(1) NOT NULL;"

Component Update 3.9.0 -> 3.10.0 "Duplicate column name 'manufacturer' SQL=alter table `kamp_jshopping_order_item` ADD COLUMN `manufacturer` varchar(255) NOT NULL, ADD COLUMN `params` text NOT NULL;"

Component Update 3.8.1 -> 3.9.0 "Duplicate column name 'video_code' SQL=alter table `kamp_jshopping_products_videos` add column `video_code` text NOT NULL;"

 
04.11.2012 16:18
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16518
Quote
Aw: Attribute error

No.

enable debug mode joomla

Errors?

 
04.11.2012 18:44
#5
rutgerkamp
Joomshopping forum user no avatar
Name: Rutger
19.06.2012
Posts: 4
Quote
Aw: Attribute error

This is the error message it gives:

JDatabaseMySQL::query: 1054 - Unknown column 'allcats' in 'field list' SQL=SELECT attr_id, `name_nl-NL` as name, `description_nl-NL` as description, attr_type, independent, allcats, cats, attr_ordering FROM `kamp_jshopping_attr` ORDER BY attr_ordering

Call stack
# Function Location
1 JSite->dispatch() /public/sites/www.prosnow.nl/index.php:42
2 JComponentHelper::renderComponent() /public/sites/www.prosnow.nl/includes/application.php:197
3 JComponentHelper::executeComponent() /public/sites/www.prosnow.nl/libraries/joomla/application/component/helper.php:351
4 require_once() /public/sites/www.prosnow.nl/libraries/joomla/application/component/helper.php:383
5 JController->execute() /public/sites/www.prosnow.nl/components/com_jshopping/jshopping.php:28
6 JshoppingControllerProduct->display() /public/sites/www.prosnow.nl/libraries/joomla/application/component/controller.php:761
7 jshopProduct->getAttributesDatas() /public/sites/www.prosnow.nl/components/com_jshopping/controllers/product.php:45
8 jshopProduct->getRequireAttribute() /public/sites/www.prosnow.nl/components/com_jshopping/tables/product.php:160
9 JSFactory::getAllAttributes() /public/sites/www.prosnow.nl/components/com_jshopping/tables/product.php:90
10 jshopAttribut->getAllAttributes() /public/sites/www.prosnow.nl/components/com_jshopping/lib/factory.php:324
11 JDatabase->loadObjectList() /public/sites/www.prosnow.nl/components/com_jshopping/tables/attribut.php:32
12 JDatabaseMySQL->execute() /public/sites/www.prosnow.nl/libraries/joomla/database/database.php:1100
13 JError::raiseError() /public/sites/www.prosnow.nl/libraries/joomla/database/database/mysql.php:548
14 JError::raise() /public/sites/www.prosnow.nl/libraries/joomla/error/error.php:251

 
05.11.2012 08:06
#6
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16518
Quote
Aw: Attribute error

alter table `jos_jshopping_attr`
ADD COLUMN `allcats` tinyint(1) NOT NULL default '1',
ADD COLUMN `cats` text NOT NULL;


jos_ - prefix

 
06.11.2012 22:16
#7
rutgerkamp
Joomshopping forum user no avatar
Name: Rutger
19.06.2012
Posts: 4
Quote
Aw: Attribute error

The attributes are working again but I can not change and safe the category / article component of the configuration part. This gives the error below. Do you have a solution for this error?

Call stack
# Function Location
1 JAdministrator->dispatch() /public/sites/www.prosnow.nl/administrator/index.php:46
2 JComponentHelper::renderComponent() /public/sites/www.prosnow.nl/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /public/sites/www.prosnow.nl/libraries/joomla/application/component/helper.php:351
4 require_once() /public/sites/www.prosnow.nl/libraries/joomla/application/component/helper.php:383
5 JController->execute() /public/sites/www.prosnow.nl/administrator/components/com_jshopping/admin.jshopping.php:66
6 JshoppingControllerConfig->save() /public/sites/www.prosnow.nl/libraries/joomla/application/component/controller.php:761
7 JTable->store() /public/sites/www.prosnow.nl/administrator/components/com_jshopping/controllers/config.php:368
8 JDatabase->updateObject() /public/sites/www.prosnow.nl/libraries/joomla/database/table.php:604
9 JDatabaseMySQL->execute() /public/sites/www.prosnow.nl/libraries/joomla/database/database.php:1650
10 JError::raiseError() /public/sites/www.prosnow.nl/libraries/joomla/database/database/mysql.php:548
11 JError::raise() /public/sites/www.prosnow.nl/libraries/joomla/error/error.php:251

 
07.11.2012 08:14
#8
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16518
Quote
Aw: Attribute error

Error?

JDatabaseMySQL::query.....?

 
Copyrights MAXXmarketing GmbH. All Rights Reserved