Crash: Create Char, Entering World.

[daemonreaver]

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):

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:

[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:

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:

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..?

[cavedude]

Class should be tinyint(4) and Level should be mediumint( But you had a problem with my database as well or PEQ that came with the DRP installer? Both fields are in mine, that's where I got the info from.

[fathernitwit]

the current scheme actively running on PEQ is always avaliable here:
http://www.projecteq.net/sql/

[daemonreaver]

Originally Posted by cavedude

Class should be tinyint(4) and Level should be mediumint( But you had a problem with my database as well or PEQ that came with the DRP installer? Both fields are in mine, that's where I got the info from.

Ok, I found (in the 0.6.4 changelog and the 0.7.0 changelog) the SQl adjustments, plus changes in the /util/ folder... Made up an SQL file to apply all the changes...

However...

I grabbed the PEQ DB and Caveman's DB...

Issues with them:

PEQ:
+ Merchants work fine
+ Most quests work fine
+ Mob agro seems fine
- Missing PoP and GoD polulation
- Missing PoP and GoD items

Caveman's:
+ PoP and GoD fully populated (even Kodtaz, but zone-in point is beow world)
+ PoP and GoD items present
- Agro messed, especially in Neriak (all the undead attack new chars)
- Has issues with Loregroup (old columns?), so an Epic group shield and Sword are not possible to have

I've been importing the zones, population and items from Cave's DB to PEQ.. so far so good... Hard part is praying the NPC id's will match up and vendors work in PoP and GoD.

Sorry it takes so long to respond. Usually dont have an internet connection available, do most my work on the laptop mobile