EQEmulator Forums - Crash: Create Char, Entering World.

NOTE: At first fire-up, there were alot of SQL errors returned. This is the full DB from PEQ.

Table "character_" was missing "level" and "class" fields, adding them automatically, quessing they are types "INT" and "VARCHAR", respectively.

Now the server fires up, and I have 5 dynamic zones set up. everything sems fine...

1) Server shows up in server list..
2) Can log in to server from eqemulator.net's login server..
-> NOTE: Any character created gets error in world.exe when logging in (if the characters were made previously) as (note, this is *not* in a log file, just the consle):

Code:

Got a bogus character (Cuuguxep) Ignoring!!!

PP length =0 but PP should be 19568

Got a bogus character (Raph) Ignoring!!!

PP length =0 but PP should be 19568

3) Character creation comes up, and all seems well:

Code:

[04.21. - 04:32:19] [WORLD__CLIENT] <username:removed>: Name approval request.  Name=Raph, race=Dark Elf, class=Cleric

[04.21. - 04:32:19] [WORLD__CLIENT_TRACE] <username:removed>: Sending EQApplicationPacket OpCode 0x0103

[04.21. - 04:32:19] [WORLD__CLIENT_TRACE] <username:removed>: Recevied EQApplicationPacket

[04.21. - 04:32:19] [WORLD__CLIENT] <username:removed>: Character creation request from daemonreaver LS#77215 (192.168.1.118:4315) : 

[04.21. - 04:32:19] [WORLD__CLIENT] <username:removed>: Name: Raph

[04.21. - 04:32:19] [WORLD__CLIENT] <username:removed>: Race: 6  Class: 2  Gender: 1  Deity: 206  Start zone: 5

[04.21. - 04:32:19] [WORLD__CLIENT] <username:removed>: STR  STA  AGI  DEX  WIS  INT  CHA    Total

[04.21. - 04:32:19] [WORLD__CLIENT] <username:removed>:  65   75   90   75  118   99   60     582

[04.21. - 04:32:19] [WORLD__CLIENT] <username:removed>: Face: 2  Eye colors: 4 4

[04.21. - 04:32:19] [WORLD__CLIENT] <username:removed>: Hairstyle: 1  Haircolor: 18

[04.21. - 04:32:19] [WORLD__CLIENT] <username:removed>: Beard: 255  Beardcolor: 255

[04.21. - 04:32:19] [WORLD__CLIENT] Validating char creation info...

[04.21. - 04:32:19] [WORLD__CLIENT] Found 0 errors in character creation request

[04.21. - 04:32:19] [WORLD__CLIENT] <username:removed>: Current location: neriakc  -774.00, 405.00, -52.84

[04.21. - 04:32:19] [WORLD__CLIENT] <username:removed>: Bind location: neriakc  -774.00, 405.00, -52.84

4) world.exe actually *fails* to save the character's info, leaving the following DB entry:

Code:

4        3                        Raph                0        5        0        0        0        0                        0        0                        0

--> NOTE: Only name, ID, accountID, and Guild Rank are actually saved to DB.

5) Character never shows up in character list after creating -OR- if tutorial is checked, world.exe closes itself, with no entry in log file as to why.

Am I missing something that will allow world.exe to save characters correctly?

Files present in EMU folder:
eqtime.cfg
spells_en.txt
spells_us.txt
patch_live.conf
patch_6.2.conf
patch_titanium.conf

Server Details:
EMU 7.0.0
MySQL 4.1
Windows 2000 Adv Server
AMD 1700+
2.5Gb DDR400

- Edit: Added Info
I can create characters on other EMU servers (0.7.0 and older) and enter world and everything runs fine... So it's not my EQ.

Going to try caveman's install, maybe there's something missing or a serious DB error.

- Edit: Results of caveman's: same problem.

Further notes: PEQ SQL contents for creating "character_" table is:

Code:

CREATE TABLE character_ (

  id int(11) NOT NULL auto_increment,

  account_id int(11) NOT NULL default '0',

  name varchar(64) NOT NULL default '',

  profile blob,

  guild int(11) default '0',

  guildrank tinyint(2) unsigned default '5',

  timelaston int(11) unsigned default '0',

  x float NOT NULL default '0',

  y float NOT NULL default '0',

  z float NOT NULL default '0',

  zonename varchar(30) NOT NULL default '',

  alt_adv blob,

  zoneid smallint(6) NOT NULL default '0',

  pktime int(8) NOT NULL default '0',

  inventory blob,

  publicnote varchar(100) NOT NULL default '',

  groupid int(10) unsigned NOT NULL default '0',

  extprofile blob NOT NULL,

  PRIMARY KEY  (id),

  UNIQUE KEY name (name),

  KEY account_id (account_id)

) TYPE=MyISAM;

Note the lack of level" and "class" fields.. What is the proper definition of these? INT or Varchar or..?