View Single Post
  #1  
Old 07-08-2009, 09:29 AM
nosfentora
Discordant
 
Join Date: Oct 2004
Location: In a house
Posts: 387
Default group_leaders not sourcing

Just pulled db rev 27 and did a complete re-install.
on sourcing load_player.sql i get the following error:

ERROR 1101 (42000) at line 5 in file: 'player_tables\group_leaders.sql': BLOB/TEXT column 'leadershipaa' can't have a default value

The code for group_leaders.sql should be

Code:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for group_leaders
-- ----------------------------
CREATE TABLE `group_leaders` (
  `gid` int(4) NOT NULL,
  `leadername` varchar(64) NOT NULL,
  `marknpc` VARCHAR( 64 ) NOT NULL DEFAULT '',
  `leadershipaa` TINYBLOB NOT NULL,
  PRIMARY KEY  (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
unless it's not supposed to be a TINYBLOB.
Reply With Quote