EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   group_leaders not sourcing (https://www.eqemulator.org/forums/showthread.php?t=28814)

nosfentora 07-08-2009 09:29 AM

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.

eqemuross 09-03-2009 03:38 AM

getting this error too...

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


All times are GMT -4. The time now is 09:00 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.