Attribute

20.01.2012 17:39
#1
simplesite
Joomshopping forum user no avatar
Name: Mireille Liong
04.12.2011
Posts: 39
Quote
Attribute

Hello People,

I really love this shop. Way better than VM. I do have one issue: I can't add attributes. Somehow they are not saved.

Anybody else have had this problem? I'd appreciate your help.


Joomla: 1.7.3
JoomShopping: 3.2.7
PHP: 5.2.17
MySQL: 5.0.92
Website Url: going-natural.com
 
20.01.2012 19:18
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25919
Quote
Aw: Attribute

Error?

Screenshot?

 
20.01.2012 20:27
#3
simplesite
Joomshopping forum user no avatar
Name: Mireille Liong
04.12.2011
Posts: 39
Quote
Aw: Attribute

There is no error. It just disappears.

You can see in the screen that I added the attributes: size: 4 oz and 8 oz for this product: http://going-natural.com/Going-Natural/Going-Natural-Herbal-Styling-Gel.html

When I click save it disappears. As you can see on the site, there is no option to choose size.
Aw: Attribute

 
20.01.2012 20:52
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25919
Quote
Aw: Attribute

Try.
Enable debug mode joomla and test again

 
20.01.2012 22:45
#5
simplesite
Joomshopping forum user no avatar
Name: Mireille Liong
04.12.2011
Posts: 39
Quote
Aw: Attribute

It looks like the field weight causes the error but it's an inbuilt field so I am not sure what to do:

00 - An error has occurred.

JDatabaseMySQL::query: 1054 - Unknown column 'weight' in 'field list' SQL=INSERT INTO `test_jshopping_products_attr` (`product_attr_id`,`product_id`,`buy_price`,`price`,`count`,`ean`,`weight`,`attr_1`,`attr_2`,`attr_3`,`attr_4`,`attr_5`) VALUES ('0','61','0','6.99','1','Going Natural Herbal Styling Gel','0.3000','8','0','0','0','0')

 
20.01.2012 22:50
#6
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25919
Quote
Aw: Attribute

Problem update.

need add field in table

query:

alter table jos_jshopping_products_attr add `weight` DECIMAL(12,4) NOT NULL;

jos - prefix table joomla


Letzte Änderung: 20.01.2012 22:53
 
11.05.2012 16:40
#7
pasanen
Joomshopping forum user no avatar
Name: pasanen
21.04.2012
Posts: 3
Quote
Aw: Attribute

Im starting to get really sick with this attributes..
First im unable to list attributes with dependent mode because i havee too many attributes and list would become too long and my browser crashes (i have tried different browsers with same result).

So i found way to solve my problem to let only few options with less choices to be dependent and these selecitons change price and weight and all other choices (undependent) i list 1 by 1 to be on the list..

So now ive got the point that im unable to save if i put even 1 more option to the list.
When i press save button it just comes back to the products page and it doesnt save anything.

I see your reply to change some code but im unable to do this since i cannot find the line anywhere.

So i changed joomla for debug mode and was looking for some error but i dont get any.

So is there way to do this ?


Joomla: 2.5
JoomShopping: 3.6.1
Website Url: http://stableservers.eu/~pasanen/index.php/shop/product/view/1/12
 
11.05.2012 20:45
#8
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25919
Quote
Aw: Attribute

Brouser?
Screenshot?

 
11.05.2012 23:01
#9
pasanen
Joomshopping forum user no avatar
Name: pasanen
21.04.2012
Posts: 3
Quote
Aw: Attribute

I have tryied with internet explorel and with google chrome but i get exactly same result.
(Please see pictures attached.)

Aw: Attribute

Aw: Attribute

Aw: Attribute

Here is link to see what i try to accomplish. http://stableservers.eu/~pasanen/index.php/shop/product/view/1/12

So i have few dependent attributes and big list of undependent and it feels like i have reached a limit of attributes and if i try to add even 1 more attribute and click save (not save&close) it doesnt save and it returns to products screen.

To set all as dependent would solve my problem but list would become too long and everytime i have tryied it my browser crash and it gives me error and asks me stop the script.

Please tell me if anymore info is needed and i will provide you what is needed.

Thank you for your quick response.

ps. Love the product and has been really satisfyied with all the functions and it exeeds all my expectations. exept attributes has taken alot of time from me to try solve this.


Joomla: 2.5.4
JoomShopping: 3.6.1
Website Url: http://stableservers.eu/~pasanen/

Letzte Änderung: 11.05.2012 23:03
 
12.05.2012 08:57
#10
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25919
Quote
Aw: Attribute

Send me admin login?

 
12.05.2012 14:25
#11
pasanen
Joomshopping forum user no avatar
Name: pasanen
21.04.2012
Posts: 3
Quote
Aw: Attribute

Hi again,

max_input_vars was 1000 and we changed this to be 5000 but im still facing same problem.

Would you have any other idea to solve this problem ?

Thank you.

 
12.10.2012 21:19
#12
theatretech
Joomshopping forum user no avatar
Name: Simon Thorpe
24.06.2011
Posts: 1
Quote
Aw: Attribute

I am also finding that Attributes are now no longer working for my prodyucts and I get the following error on the Debug.

JDatabaseMySQL::query: 1054 - Unknown column 'attr_3' in 'field list' SQL=INSERT INTO `c0bwg_jshopping_products_attr` (`product_attr_id`,`product_id`,`buy_price`,`price`,`old_price`,`count`,`ean`,`weight`,`ext_attribute_product_id`,`attr_30`,`attr_3`,`attr_5`,`attr_14`,`attr_16`,`attr_17`,`attr_18`,`attr_19`,`attr_20`,`attr_21`,`attr_22`,`attr_23`,`attr_24`,`attr_25`,`attr_26`,`attr_27`,`attr_28`,`attr_29`) VALUES ('0','33','0','1322.5','0','1','TH-00285','10.0000','0','78','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')


Joomla: 2.5.7
JoomShopping: 3.11.3
PHP: 5.2.17
 
12.10.2012 23:02
#13
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25919
Quote
Aw: Attribute

Add field attr_3 in table.
Use phpmyadmin.

 
09.08.2013 20:29
#14
pavali007
Joomshopping forum user no avatar
Name: Pimpin
09.08.2013
Posts: 1
Quote
Aw: Attribute

First I want to say this: I changed the hosting PHP 5.2 and PHP 5.23 have now, then I update to Joomla 5.2.11. Until I changed my hosting and attributes to function normally, but now as it was limit how much I can add to one max attribute of the product. I have a problem with saving attribute. Once you exceed the limit of 222 attribute and I will save, so either make a copy of a product or save and jump to product category. I tried all options I can think of, and I even deleted all the attributes and created again. Please help.


Joomla: 2.5.11
JoomShopping: 3.11.2
PHP: 5.3.23-1~dotdeb.0
MySQL: 5.5.30-1~dotdeb.0
Website Url: http://pizzerieuareny.cz
 
09.08.2013 22:45
#15
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25919
Quote
Aw: Attribute

http://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/forum/posts/7/5027.html?lang=en

 


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.