(Blank screen) after server list. full info help.

calranthe · #1 12-01-2004, 10:36 AM

Now this has been a bumpy ride.
Problem and clarified situation.

Error : Trying to access my server on the server list (EQemulator) screen goes black nothing happens. this has happened from 2 different home pc's and a friend in the USA.

Windows XP professional clean install.
Perl installed and working.
Mysql installed and working.

No visible errors when World exe is run.

Log

Code:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=36965
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Warning: You need to get laid...
TCP listening on: edgeofmidnight.kicks-ass.net:9000
World server listening on: edgeofmidnight.kicks-ass.net:9000
Connected to LoginServer: newlogin1.eqemulator.net:5994
38297 New TCP connection: 10.0.0.3:1129
New zoneserver: #1 10.0.0.3:1129
Zoneserver SetConnectInfo: 10.0.0.3:1129: edgeofmidnight.kicks-ass.net:7999
38781 New TCP connection: 10.0.0.3:1130
38781 New TCP connection: 10.0.0.3:1131
38781 New TCP connection: 10.0.0.3:1132
New zoneserver: #2 10.0.0.3:1131
New zoneserver: #3 10.0.0.3:1130
38812 New TCP connection: 10.0.0.3:1133
New zoneserver: #4 10.0.0.3:1133
New zoneserver: #5 10.0.0.3:1132
Zoneserver SetConnectInfo: 10.0.0.3:1130: edgeofmidnight.kicks-ass.net:7996
Zoneserver SetConnectInfo: 10.0.0.3:1131: edgeofmidnight.kicks-ass.net:7995
Zoneserver SetConnectInfo: 10.0.0.3:1132: edgeofmidnight.kicks-ass.net:7998
Zoneserver SetConnectInfo: 10.0.0.3:1133: edgeofmidnight.kicks-ass.net:7997

Zone boot up looks fine too

Code:

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 6299
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading tributes
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 176 commands loaded
[Status] Loading embedded perl XS
[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Error] Starting command queue Mapping...

[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Status] Entering sleep mode
Connected to worldserver: 10.0.0.3:9000

Loginserver.ini (incase you can see an error.

Code:

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We reccomend using the EQEmu.net Loginserver ALWAYS.

### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=newlogin1.eqemulator.net
loginport=5994
worldname=Edge of insanity
worldaddress=edgeofmidnight.kicks-ass.net
locked=false
account=
password=


[WorldServer]
Defaultstatus=0
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

Boot5zones.bat

Code:

REM: ****Read this first!!!**** 

REM: If you still get errors try using localhost instead of 127.0.0.1 

REM:--------------Start----------------------- 
@echo off 

if NOT exist spells_us.txt goto NOSPELL 

start zone . edgeofmidnight.kicks-ass.net 7995 10.0.0.3
start zone . edgeofmidnight.kicks-ass.net 7996 10.0.0.3
start zone . edgeofmidnight.kicks-ass.net 7997 10.0.0.3
start zone . edgeofmidnight.kicks-ass.net 7998 10.0.0.3
start zone . edgeofmidnight.kicks-ass.net 7999 10.0.0.3
exit
cls

:NOSPELL 
echo You did not copy the spells_us.txt from your everquest directory to this one. Please do so or zones will crash on startup. 
PAUSE 

REM:---------------END------------------------

My router config

Code:

11 7995 7995 TCP  10.0.0.3  
12 7996 7996 TCP  10.0.0.3  
13 7997 7997 TCP  10.0.0.3  
14 7998 7998 TCP  10.0.0.3  
15 7999 7999 TCP  10.0.0.3  
16 9000 9000 TCP  10.0.0.3

Now for 4 mins I thought I had it working, I was just trying to log in again and it loaded I created a char logged into neriak, no npc's and when I zoned it went black screen and stayed that way.

but its not letting me now, the above is the furthest i've gotten.

calranthe · #2 12-01-2004, 10:42 AM

I've been working on this from about 6am till 11pm only stopping for sleep and eat/cook/walk dog for 3 days

I've fixed my perl errors my scalar error, the mysql error

but now i'm stuck i've read everything I can.

I am desperate.

If someone can walk me through this or help me fix it i will be more than greatful.

its now 22:41pm gotta sleep.

**Derision** · #3 12-01-2004, 11:31 AM

Quote:

Originally Posted by calranthe

My router config

Code:

11 7995 7995 TCP  10.0.0.3  
12 7996 7996 TCP  10.0.0.3  
13 7997 7997 TCP  10.0.0.3  
14 7998 7998 TCP  10.0.0.3  
15 7999 7999 TCP  10.0.0.3  
16 9000 9000 TCP  10.0.0.3

I am assuming the 'TCP' parameter you have there is forwarding TCP ports. EQClient uses UDP, so if your router supports it, try forwarding both (though you say you got in once, so this has likely has nothing to do with your problem.

calranthe · #4 12-01-2004, 11:58 AM

Quote:

Originally Posted by Derision

Quote:

Originally Posted by calranthe

My router config

Code:

11 7995 7995 TCP  10.0.0.3  
12 7996 7996 TCP  10.0.0.3  
13 7997 7997 TCP  10.0.0.3  
14 7998 7998 TCP  10.0.0.3  
15 7999 7999 TCP  10.0.0.3  
16 9000 9000 TCP  10.0.0.3

I am assuming the 'TCP' parameter you have there is forwarding TCP ports. EQClient uses UDP, so if your router supports it, try forwarding both (though you say you got in once, so this has likely has nothing to do with your problem.

Can anyone confirm which ports are TCP and which UDP

because as above "38297 New TCP connection: 10.0.0.3:1129 "
it looks for tcp.

okay okay definetly to bed with me or i will be facing a divorce lol.

i messed with some settings changed afew to UDP in my router

this is what i got

Code:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=36965
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Formatting drive C:
TCP listening on: edgeofmidnight.kicks-ass.net:9000
World server listening on: edgeofmidnight.kicks-ass.net:9000
Error: LoginServer::Connect: Resolving IP address: 'Unable to get the host name.
 Error: 11004'
54344 New TCP connection: 10.0.0.3:1038
54344 New TCP connection: 10.0.0.3:1039
54344 New TCP connection: 10.0.0.3:1040
New zoneserver: #1 10.0.0.3:1039
New zoneserver: #2 10.0.0.3:1038
Zoneserver SetConnectInfo: 10.0.0.3:1038: edgeofmidnight.kicks-ass.net:7995
54453 New TCP connection: 10.0.0.3:1041
54453 New TCP connection: 10.0.0.3:1042
New zoneserver: #3 10.0.0.3:1042
New zoneserver: #4 10.0.0.3:1041
New zoneserver: #5 10.0.0.3:1040
Zoneserver SetConnectInfo: 10.0.0.3:1039: edgeofmidnight.kicks-ass.net:7998
Zoneserver SetConnectInfo: 10.0.0.3:1040: edgeofmidnight.kicks-ass.net:7996
Zoneserver SetConnectInfo: 10.0.0.3:1041: edgeofmidnight.kicks-ass.net:7999
Zoneserver SetConnectInfo: 10.0.0.3:1042: edgeofmidnight.kicks-ass.net:7997
Connected to LoginServer: newlogin1.eqemulator.net:5994
196515 New client from ip: 68.239.160.254 port: 3014
Account Attempting to be created:Anthony 0
Logged in: FirstLogin LS#35479: Anthony
207.36.180.194:5994: TCPConnection::RecvData(): Error: 10054
Client disconnected
Removing client from ip:68.239.160.254 port:3014
Error: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error:
 10065'
Connected to LoginServer: newlogin1.eqemulator.net:5994
448094 New client from ip: 68.239.160.254 port: 3395
Logged in: FirstLogin LS#35479: Anthony
Received unknown opcode: 0x02eb size:0 bytes
552375 New client from ip: 68.44.222.95 port: 64565
Account Attempting to be created:karaluven 0
Logged in: FirstLogin LS#44698: karaluven
Received unknown opcode: 0x02eb size:0 bytes
Name approval request for:Caveroamer race:130 class:15
Character creation request from Anthony LS#35479 (68.239.160.254:3395) :
Name: Caveroamer
Race: 130  Class: 15  Gender: 0  Deity: 396  Start zone: 13
STR  STA  AGI  DEX  WIS  INT  CHA    Total
100   95   95   70   80   65   70     575
Face: 0  Eye colors: 9 9
Hairstyle: 0  Haircolor: 255
Beard: 255  Beardcolor: 255
Validating char creation info...
Found 0 errors in character creation request
[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE p
layer_choice=13 AND player_class=15 AND player_deity=396 AND player_race=130

[Status] Found starting location in start_zones
Current location: (null)  0.75, -112.38, -181.62
Bind location: (null)  0.75, -112.38, -181.62
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (rac
e = 130 or race = 0) AND (class = 15 or class = 0) AND (deityid = 396 or deityid
=0) AND (zoneid = 155 or zoneid = 0) AND gm &lt;= 0 ORDER BY id
Character creation successful: Caveroamer
Read group ID for 'Caveroamer': 0
   0: 2C 30 2C 2E 43 61 76 65 - 72 6F 61 6D 65 72 2C 30  | ,0,.Caveroamer,0
  16: 36 37 61 37 39 64 34 00                            | 67a79d4.
Attempting autobootup of Qeynos (1) for Caveroamer
Zoneserver SetZone: edgeofmidnight.kicks-ass.net:7996 Qeynos (1)
Enter world: Caveroamer: Qeynos (1)
Zoneserver SetZone: edgeofmidnight.kicks-ass.net:7996 Qeynos (1)
Received unknown opcode: 0x0376 size:0 bytes
Name approval request for:Sweetie race:74 class:1
Character creation request from karaluven LS#44698 (68.44.222.95:64565) :
Name: Sweetie
Race: 330  Class: 1  Gender: 1  Deity: 208  Start zone: 6
STR  STA  AGI  DEX  WIS  INT  CHA    Total
 90  100  110  100   75   75   50     600
Face: 5  Eye colors: 8 8
Hairstyle: 255  Haircolor: 255
Beard: 255  Beardcolor: 255
Validating char creation info...
Found 0 errors in character creation request
[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE p
layer_choice=6 AND player_class=1 AND player_deity=208 AND player_race=330

No start_zones entry in database, using defaults
Current location: gukta  0.00, 0.00, 0.00
Bind location: innothule  0.00, 0.00, 0.00
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (rac
e = 330 or race = 0) AND (class = 1 or class = 0) AND (deityid = 208 or deityid=
0) AND (zoneid = 52 or zoneid = 0) AND gm &lt;= 0 ORDER BY id
Character creation successful: Sweetie
Read group ID for 'Sweetie': 0
   0: 2C 30 2C 2E 53 77 65 65 - 74 69 65 2C 30 36 37 61  | ,0,.Sweetie,067a
  16: 37 39 64 34 00                                     | 79d4.
Attempting autobootup of gukta (52) for Sweetie
Zoneserver SetZone: edgeofmidnight.kicks-ass.net:7999 gukta (52)
Enter world: Sweetie: gukta (52)
Zoneserver SetZone: edgeofmidnight.kicks-ass.net:7999 gukta (52)
Client disconnected
Removing client from ip:68.239.160.254 port:3395
Client disconnected
Removing client from ip:68.44.222.95 port:64565

calranthe · #5 12-01-2004, 11:59 AM

oh btw the 207.36.180.194:5994: TCPConnection::RecvData(): Error: 10054 error is just when i reboot my router

calranthe · #6 12-01-2004, 06:43 PM

Error I didn't notice last night.

At the same time as the above connection was happening and this leads me to believe it may not be a router problem
I've edited it down slightly to stip it been too big

Quote:

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading doors
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading tributes
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 176 commands loaded
[Status] Loading embedded perl XS
[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Error] Starting command queue Mapping...

[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Status] Entering sleep mode
Connected to worldserver: 10.0.0.3:9000
Map header: 26688 faces, 1176 nodes, 56225 facelists
Loaded map: 80064 vertices, 26688 faces
Map BB: (-877.19 -> 2041.69, -2974.91 -> 2763.34, -97.44 -> 805.50)
Map ./Maps/innothule.map loaded.
[Status] Weather should change in 11004 seconds
Error loading NPCs from database. Bad query.
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 46; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for innothule ...
[Status] Done loading doors for innothule ...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
Error in LoadTempMerchantData query 'select ml.npcid,ml.slot,ml.itemid,ml.charge
s from merchantlist_temp ml, npc_types nt, spawnentry se, spawn2 s2 where nt.id=
ml.npcid and nt.id=se.npcid and se.spawngroupid=s2.spawngroupid and s2.zone='inn
othule' group by ml.npcid,slot order by npcid,slot asc' #1146: Table 'eq.merchan
tlist_temp' doesn't exist
[Status] Zone Bootup: innothule (46)
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
(many many of this line)
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
[Status] 679219 New client from ip:68.44.222.95 port:64689
Read group ID for 'Sweetie': 0
Client linkdead: Sweetie
Dropping client: Process=false, ip=68.44.222.95, port=64689
[Status] Zone Shutdown: innothule (46)

m0oni9 · #7 12-02-2004, 08:26 AM

Quote:

Originally Posted by calranthe

Error loading NPCs from database. Bad query.
(many many of this line)
Error loading NPCs from database. Bad query.

That is probably happening because the server is having trouble reading from your npc_types table. If I remember correctly, it should not stop you from zoning in. Someone should probably add code to take out some redundant messages, al la syslog ("last message repeated 5 times").

For your testing purposes, this should be the query that the eqemu server is running on your DB that causes this error:

Code:

SELECT npc_types.id,npc_types.name,npc_types.level,
  npc_types.race,npc_types.class,npc_types.hp,
  npc_types.gender,npc_types.texture,npc_types.helmtexture,
  npc_types.size,npc_types.loottable_id,
  npc_types.merchant_id,npc_types.banish,npc_types.mindmg,
  npc_types.maxdmg,npc_types.npcspecialattks,
  npc_types.npc_spells_id,npc_types.d_meele_texture1,
  npc_types.d_meele_texture2,npc_types.walkspeed,
  npc_types.runspeed,npc_types.fixedz,
  npc_types.hp_regen_rate,npc_types.mana_regen_rate,
  npc_types.aggroradius,npc_types.bodytype,
  npc_types.npc_faction_id,npc_types.face,
  npc_types.see_invis,npc_types.see_invis_undead,
  npc_types.lastname,npc_types.qglobal,npc_types.AC,npc_types.npc_aggro
FROM npc_types,spawn2 WHERE spawn2.zone='innothule'
AND npc_types.id=spawn2.id

calranthe · #8 12-02-2004, 09:18 AM

All fixed thankyou for your help