Attribute Sets Plus

[Guest]

Hi there,

After attempting to start install of this contr. I have encountered the following error.

 

 

<Error

SQL query:

 

# The 'drop table' commands should only be uncommented if your are re-installing

# attributes sets plus for any reason. For a first time install they are not required.

# 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 '',

products_options_id int( 11 ) NOT NULL default '',

PRIMARY KEY ( products_attributes_sets_id )

) TYPE = MYISAM >

 

This is the return in PHPMyAdmin after hitting go... (after copying and pasting whole of att~lct.sql to text box)

 

I am indeed a newbie at all of this, and have read almost all of the posts in this forum BEFORE starting... (I didnt want to have problems!)

 

What have I done, or not done to get this error to occur? There is no error number returned so I am at a loss with the documentation of PHPMyAdmin as well...

 

Yours,

 

Kaz

[Guest]

Hi there,

After attempting to start install of this contr. I have encountered the following error.

<Error

SQL query:

 

# The 'drop table' commands should only be uncommented if your are re-installing

# attributes sets plus for any reason. For a first time install they are not required.

# 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 '',

products_options_id int( 11 ) NOT NULL default '',

PRIMARY KEY ( products_attributes_sets_id )

) TYPE = MYISAM >

 

This is the return in PHPMyAdmin after hitting go... (after copying and pasting whole of att~lct.sql to text box)

 

I am indeed a newbie at all of this, and have read almost all of the posts in this forum BEFORE starting... (I didnt want to have problems!)

 

What have I done, or not done to get this error to occur? There is no error number returned so I am at a loss with the documentation of PHPMyAdmin as well...

 

Yours,

 

Kaz

 

Ummm..... I have tried this through the RHS pane of PHPMyAdmin, and now I DO get an error message...

 

<#1067 - Invalid default value for 'products_options_id'>

 

This is the line ...

<products_options_id int( 11 ) NOT NULL default '',>

 

Any assistance I am thankful for.

 

Kaz