Infobox Admin - Sql wont install

[bradholland]

Hi people,

 

I have been trying to install the contribution "Infobox Addon"

 

Not having much luck installing it, to make sure its not something I have done to my db i even set up a fresh clean osc install and db and tried importing the supplied sql file, and even tried a couple of diff. versions of the contribution, all with the same sql error when trying to install.

 

 

#1067 - Invalid default value for 'location'

 

Any ideas? would it help if I post the sql too?

 

Error

SQL query:

 

CREATE TABLE theme_configuration(

 

configuration_id int( 11 ) NOT NULL AUTO_INCREMENT ,

configuration_title varchar( 64 ) NOT NULL default '',

configuration_key varchar( 64 ) NOT NULL default 'BOX_HEADING_',

configuration_value varchar( 255 ) NOT NULL default '',

configuration_description varchar( 255 ) NOT NULL default '',

configuration_group_id int( 11 ) NOT NULL default '1',

configuration_column varchar( 64 ) NOT NULL default 'left',

location int( 5 ) NOT NULL default '',

sort_order int( 5 ) default NULL ,

last_modified datetime default NULL ,

date_added datetime NOT NULL default '0000-00-00 00:00:00',

box_heading varchar( 64 ) NOT NULL default '',

PRIMARY KEY ( configuration_id )

) TYPE = MYISAM ;

[krobinson]

I am having the same issue - It looks like a really nice contribution, however I can't get started due to this same problem.

 

Anyone have any luck on this?

[krobinson]

I am having the same issue - It looks like a really nice contribution, however I can't get started due to this same problem.

 

Anyone have any luck on this?

 

I went back to an older verson and found this:

 

DROP TABLE IF EXISTS theme_configuration;

CREATE TABLE theme_configuration (

configuration_id int(11) NOT NULL auto_increment,

configuration_title varchar(64) NOT NULL default '',

configuration_key varchar(64) NOT NULL default 'BOX_HEADING_',

configuration_value varchar(255) NOT NULL default '',

configuration_description varchar(255) NOT NULL default '',

configuration_group_id int(11) NOT NULL default '1',

configuration_column varchar(64) NOT NULL default 'left',

location varchar(64) NOT NULL default '',

sort_order int(5) default NULL,

last_modified datetime default NULL,

date_added datetime NOT NULL default '0000-00-00 00:00:00',

box_heading varchar(64) NOT NULL default '',

PRIMARY KEY (configuration_id)

) TYPE=MyISAM;

 

..............................................

 

It appears that location varchar(64) NOT NULL default '', is the correct expression to use. I tried it and it worked fine.

 

Thanks,

Kristine

Edited September 15, 2006 by krobinson