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: 19146
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: 19146
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: 19146
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: 19146
Quote
Aw: Attribute error

Error?

JDatabaseMySQL::query.....?

 


Copyrights MAXXmarketing GmbH. All Rights Reserved
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.