[Revan]

Originally Posted by Replicators

I got this when trying to install the MYSQL tables....

Database error in vBulletin 3.5.4:

Invalid SQL:

CREATE TABLE `sf_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         : Monday, April 10th 2006 @ 03:11:23 AM
Script       : http://www.******.com/installer/index.php
Referrer     : http://www.******.com/installer/index.php
IP Address   : **.**.***.***
Username     : Replicators
Classname    : vb_database

Im uploading a fixed file, youll have to continue from that step but you shouldn't have any errors.
Check abck in 5 mins and it should be up.