PDA

View Full Version : group_leaders not sourcing


nosfentora
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


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
09-03-2009, 03:38 AM
getting this error too...

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