When I go to the installer, I get all the way to step 3 then it creates the tables:
Code:
Created Table: zg_rpg_alignments
Created Table: zg_rpg_battle
Created Table: zg_rpg_battle_posts
Created Table: zg_rpg_battlemusic
Created Table: zg_rpg_categories
Created Table: zg_rpg_clans
Then I get this error:
Code:
Database error in vBulletin 3.5.4:
Invalid SQL:
CREATE TABLE `zg_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/TEXT column 'invite' can't have a default value
Error Number : 1101
Date : Tuesday, April 18th 2006 @ 01:09:43 AM
Script : http://forums.zeldagenesis.com/installer/index.php
Referrer : http://forums.zeldagenesis.com/installer/index.php
IP Address :
Username : Karashimu
Classname : vb_database