Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mikan

Archived
  • Posts

    2
  • Joined

  • Last visited

Profile Information

  • Real Name
    Robert

mikan's Achievements

  1. 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
  2. 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
×
×
  • Create New...