error adding attribute set to product

[tonster]

Hi. I'm pretty new to ths & have inherited a store so I'm not sure how my site has evolved in terms of contribution. I get the following error when I try to add an attribute set to a product.

 

1064 - You have an error in your SQL syntax near '15.0000,'+')' at line 1

 

insert into products_attributes (products_id, options_id, options_values_id, options_values_price, price_prefix) values (75,18,,15.0000,'+')

 

Here's the table def.

 

CREATE TABLE `products_attributes` (

`products_attributes_id` int(11) NOT NULL auto_increment,

`products_id` int(11) NOT NULL default '0',

`options_id` int(11) NOT NULL default '0',

`options_values_id` int(11) NOT NULL default '0',

`options_values_price` decimal(15,4) NOT NULL default '0.0000',

`price_prefix` char(1) NOT NULL default '',

PRIMARY KEY (`products_attributes_id`)

 

Has anyone seen this before?

 

thanks

[desidil4ever]

I aint a 100% sure...but would try recommending it to you....you are tryin to add the "+"

as a price_prefix....change it to a "&43;" which is the coded graphic character set for the "+"

 

I m hoping that should solve ur issue:)

 

Hi. I'm pretty new to ths & have inherited a store so I'm not sure how my site has evolved in terms of contribution. I get the following error when I try to add an attribute set to a product.

 

1064 - You have an error in your SQL syntax near '15.0000,'+')' at line 1

 

insert into products_attributes (products_id, options_id, options_values_id, options_values_price, price_prefix) values (75,18,,15.0000,'+')

 

Here's the table def.

 

CREATE TABLE `products_attributes` (

`products_attributes_id` int(11) NOT NULL auto_increment,

`products_id` int(11) NOT NULL default '0',

`options_id` int(11) NOT NULL default '0',

`options_values_id` int(11) NOT NULL default '0',

`options_values_price` decimal(15,4) NOT NULL default '0.0000',

`price_prefix` char(1) NOT NULL default '',

PRIMARY KEY (`products_attributes_id`)

 

Has anyone seen this before?

 

thanks

[tonster]

I aint a 100% sure...but would try recommending it to you....you are tryin to add the "+"

as a price_prefix....change it to a "&43;" which is the coded graphic character set for the "+"

 

I m hoping that should solve ur issue:)

 

 

Thanks. I did a bit more lookin' and the products_attributes.php script isn't finding a value for options_values_id so the SQL chokes. The products_attributes table needs that value to have unique records.