group_leaders not sourcing

nosfentora · #1 07-08-2009, 09:29 AM

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.

eqemuross · #2 09-03-2009, 03:38 AM

getting this error too...

is it because i've only enabled up to kunark?