Attribute Sets ERRORS, please help....
Hello, I need some help with Attribute Sets contribution, please. When I run the SQL file to create 3 tables, it gives me an error:
ERROR 1067 (42000): Invalid default value for 'products_options_id'
I had to edit the sql file and insert "0"
# drop table products_attributes_sets;
CREATE TABLE products_attributes_sets (
products_attributes_sets_id int(11) NOT NULL auto_increment,
products_attributes_sets_name varchar(50) NOT NULL default '', <-- NOT NULL default '0',
products_options_id int (11) NOT NULL default '',
PRIMARY KEY (products_attributes_sets_id)
) TYPE=MyISAM;
Then it worked!
But, when I try to create a set, give it a name and hit save, I get an error message:
1264 - Out of range value adjusted for column 'products_attributes_sets_id' at row 1
insert into products_attributes_sets (products_attributes_sets_id, products_attributes_sets_name, products_options_id) values ('','test',1)
At this point my knowledge stops, I don't know where to go to check things. I'm running PHP 5.1.1, MySQL 5.0 and OSC 2.2ms2
I know how to edit things, manage MySQL tables, but I'm no programmer. Any help would be greatly appreciated.
Thank you,
Robert