[Rated]

Originally Posted by Rated

Database error in vBulletin 3.5.4:

Invalid SQL:

CREATE TABLE `rpg_clans`
(
`clanid` int(10) UNSIGNED NOT NULL auto_increment,
`title` varchar(50) NOT NULL DEFAULT '',
`leader` int(10) UNSIGNED NOT NULL DEFAULT '0',
`clanpoints` mediumint(5) UNSIGNED NOT NULL DEFAULT '0',
`logo` varchar(100) NOT NULL DEFAULT '',
`signature` VARCHAR( 255 ) NOT NULL DEFAULT '',
`ally` MEDIUMTEXT NOT NULL,
`enemy` MEDIUMTEXT NOT NULL,
`members` INT( 10 ) UNSIGNED NOT NULL DEFAULT '1',
`maxmem` tinyint(3) UNSIGNED NOT NULL DEFAULT '5',
`invite` MEDIUMTEXT NOT NULL DEFAULT 'a:0:{}',
`col1` int(10) UNSIGNED NOT NULL DEFAULT '0',
`col2` int(10) UNSIGNED NOT NULL DEFAULT '0',
`col3` int(10) UNSIGNED NOT NULL DEFAULT '0',
`col4` int(10) UNSIGNED NOT NULL DEFAULT '0',
`cm_col_access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`ci_col_access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`rm_col_access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`midiurl` varchar(100) NOT NULL DEFAULT '',
`rank` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`clanid`)
) TYPE=InnoDB;

MySQL Error : BLOB column 'invite' can't have a default value
Error Number : 1101

Can anyone help me out please?