Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-20-2006, 04:49 PM
daemonreaver
Fire Beetle
 
Join Date: Apr 2006
Posts: 21
Unhappy 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..?

Last edited by daemonreaver; 04-21-2006 at 01:35 AM..
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 02:04 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3