Repair SQL Error after 5.0.0d patch

[piccirm2]

After patching to 500d if I try to use quick repair admin featurs I get the following error...
Error creating table: repair_table: Query Failed:CREATE TABLE repair_table (id varchar(255) NOT NULL ,name varchar(255) NULL ,vname varchar(255) NULL ,comments varchar(255) NULL ,help varchar(255) NULL ,custom_module varchar(255) NULL ,type varchar(255) NULL ,len int(11) NULL ,required bool DEFAULT '0' NULL ,default_value varchar(255) NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,audited bool DEFAULT '0' NULL ,massupdate bool DEFAULT '0' NULL ,duplicate_merge smallint DEFAULT '0' NULL ,reportable bool DEFAULT '1' NULL ,ext1 varchar(255) DEFAULT '' NULL ,ext2 varchar(255) DEFAULT '' NULL ,ext3 varchar(255) DEFAULT '' NULL ,ext4 NULL , PRIMARY KEY (id), KEY idx_meta_id_del (id, deleted), KEY idx_meta_cm_del (custom_module, deleted)) CHARACTER SET utf8 COLLATE utf8_general_ci::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL , PRIMARY KEY (id), KEY idx_meta_id_del (id, deleted), KEY idx_meta_cm' at line 1

any explanation of this ???

[nite_man]

Have the same issue on the fresh 5.1 Beta installation. Didn't find solution yet.

[mikesolomon]

After patching to 500d if I try to use quick repair admin featurs I get the following error...
Error creating table: repair_table: Query Failed:CREATE TABLE repair_table (id varchar(255) NOT NULL ,name varchar(255) NULL ,vname varchar(255) NULL ,comments varchar(255) NULL ,help varchar(255) NULL ,custom_module varchar(255) NULL ,type varchar(255) NULL ,len int(11) NULL ,required bool DEFAULT '0' NULL ,default_value varchar(255) NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,audited bool DEFAULT '0' NULL ,massupdate bool DEFAULT '0' NULL ,duplicate_merge smallint DEFAULT '0' NULL ,reportable bool DEFAULT '1' NULL ,ext1 varchar(255) DEFAULT '' NULL ,ext2 varchar(255) DEFAULT '' NULL ,ext3 varchar(255) DEFAULT '' NULL ,ext4 NULL , PRIMARY KEY (id), KEY idx_meta_id_del (id, deleted), KEY idx_meta_cm_del (custom_module, deleted)) CHARACTER SET utf8 COLLATE utf8_general_ci::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL , PRIMARY KEY (id), KEY idx_meta_id_del (id, deleted), KEY idx_meta_cm' at line 1

any explanation of this ???

dont know if it helps but the problem is ext4 which has no type

ext2 varchar(255) DEFAULT '' NULL ,
ext3 varchar(255) DEFAULT '' NULL ,
ext4 NULL ,

PRIMARY KEY (id),