Errors with Attrib Sets

[mikan]

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