When I enable the split_test module, I get this error:

user warning: Invalid default value for 'stid' query: CREATE TABLE split_test ( stid int unsigned NOT NULL AUTO_INCREMENT default '0', theme1 varchar(200), theme1_hits int(10) default 0, theme1_conv int(10) default 0, theme2 varchar(200), theme2_hits int(10) default 0, theme2_conv int(10) default 0, action varchar(200), hit_limit int(10), active boolean default 1, PRIMARY KEY (stid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /usr/local/www/drupal-5.3/includes/database.mysql.inc on line 172.

Any idea what's going wrong?

Comments

samhassell’s picture

samhassell commented

Hi Tyler,

The problem is in the definition of the stid column.

A working version would be:

CREATE TABLE split_test(
stid int unsigned AUTO_INCREMENT ,
theme1 varchar( 200 ) ,
theme1_hits int( 10 ) default 0,
theme1_conv int( 10 ) default 0,
theme2 varchar( 200 ) ,
theme2_hits int( 10 ) default 0,
theme2_conv int( 10 ) default 0,
ACTION varchar( 200 ) ,
hit_limit int( 10 ) ,
active boolean default 1,
PRIMARY KEY ( stid )
)/*!40100 DEFAULT CHARACTER SET UTF8 */

If you run this manually on your database you should be good to go.

I will release a fixed version over the next week.

samhassell’s picture

samhassell commented
Assigned: Unassigned » samhassell
Priority: Normal » Critical
samhassell’s picture

samhassell commented
Status: Active » Fixed

fixed in 5.x-3.0

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.