EQEmulator Forums - (Blank screen) after server list. full info help.

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - (Blank screen) after server list. full info help. (https://www.eqemulator.org/forums/showthread.php?t=17221)

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

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.

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.

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

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.

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

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

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

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

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)

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

All fixed thankyou for your help