Problems with 6.0

Elkay · #1 10-15-2004, 09:53 AM

Couple problems I've encountered so far. Got the latest CVS, compiled fine after the second update hit SF. Ran the SQL update for WR. Launched World and Zones, everything appeared fine, stating it was running 6.0. However, I get to server select, and I see a couple 6.0 servers, yet mine still reports 5.9dr3. I was still able to connect to my server, get to character select, however as soon as I tried to get into the game, I was booted to server select and I noticed that the Zone.exe that World tried to send my character to had closed (assuming it crashed). Not sure where to go from here since I can't see any error codes, it just closes down the Zone.exe silently.

A little extra information:

World.exe shows right before the crash:

Enter world: Toonx: podisease (205)
Broadcasting a world time update
Zoneserver SetZone: aostang.dyndns.org:8780 podisease (205)
Received unknown opcode: 0x0376 size:0 bytes
127.0.0.1:2066: TCPConnection::RecvData(): Error: 10054
Removing zoneserver from ip:0.0.0.0 port:0 (aostang.dyndns.org:8780)
Client disconnected
Removing client from ip:192.168.1.103 port:1175

Zone.exe displays (before it closes):

[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000
Got new group id set: 3001 -> 4000
Map ./Maps/podisease.map not found.
[Status] Weather should change in 12146 seconds
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 205; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for podisease ...
[Status] Done loading doors for podisease ...
[Status] Zone Bootup: podisease (205)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [9:20 am]

I have been running fine since 5.7 .. then 5.8 .. then 5.9dr1/dr2/dr3 all without problems up until now. I also tried creating a fresh character from scratch and upon trying to enter Gloomingdeep got the same problem.

Elkay · #2 10-16-2004, 03:24 AM

Just an update.. I sourced a clean database and ran the emu.. was able to log in fine. I also verified that all of the table changes took in the sql updates, and they did. Knowing this, either some data somewhere in my database is no longer compatible, or there is some specific piece of data in my database that most poeple don't have but I do, and the code does not support it for whatever the reason. I'll try to narrow it down today 1 table at a time.

Elkay · #3 10-16-2004, 05:48 AM

Ok I've been messing around with it for a while now. I've narrowed it down but have no idea why what's breaking is. I can load any zone fine that has no mobs in it, but as soon as I try to zone in with 1 mob in the zone it won't load. I tried an interesting experiment. I wiped my entire spawn2 spawnarea spawnentry and spawngroup table, and removed all records from npc_types except for 1 mob with ogre race that I set to ID 1 with 0 faction and 0 loot. I zoned into gfaydark and loaded fine. I issued '#dbspawn 1' and the mob was spawned fine. I issued '#npcspawn add' and it said it added the spawn record successfully. I issued '#repop' and the zone repopped without the mob spawning, which is normal but I had forgotten that. The zone did not crash at that point however. I camped, and then tried to load back into gfaydark, at which point my Zone.exe closed (or silently crashed). I'm pretty stumped at this point and starting to think the problem is in the code and not in any of the data I am using. Anyone else having this problem? I also compare all of the spawn and npc tables to the barebones database and all columns are the same, though a few are in a different order in my database (AC being the last column and lastname being right after name in my database).

Edit:

Ok I may have figured out the problem, but I can't test because World.exe crashes on my now. Apparently I downloaded from CVS mid update, so some of my files were not updated. Weird that it still compiled with no errors though lol.

mystic414 · #4 10-16-2004, 09:16 AM

I'm having the same problem. If I start up zone.exe from the command prompt, it only gets as far as "loading doors" for the particular zone before it just silently crashes.

I'm pretty sure the problem isn't that you got your files mid-update, because I got mine pre-compiled from CVS.

FYI, I'm using the PEQ Classic database and I sourced the wr_update.sql mentioned on the main page.

Edgar1898 · #5 10-16-2004, 09:40 AM

Could both of you post the last couple of lines from your eqemudebug.log file. It should be located in the same directory from where you are running the zone. I dont have any of those problems (or I would have fixed them).

zephyr325 · #6 10-16-2004, 11:46 AM

I'm having the problem where I create a brand-new 6.0 DR1+ db as shown, I can create my character, the client hangs. I'm using the current compiled source code.

Note - I was having a different problem (the zone would show the client getting disconnected almost immediately) but I patched the client and now I'm getting something different in the zone window.

Here's the text from the world window:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR1
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=34229, max id=77505
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Warning: Pants may change during online play.
TCP listening on: www.flyfreak.com:9000
World server listening on: www.flyfreak.com:9000
Connected to LoginServer: newlogin1.eqemulator.net:5994
27375 New TCP connection: 10.120.26.211:4862
New zoneserver: #1 10.120.26.211:4862
Zoneserver SetConnectInfo: 10.120.26.211:4862: www.flyfreak.com:7995
27516 New TCP connection: 10.120.26.211:4863
27516 New TCP connection: 10.120.26.211:4864
27516 New TCP connection: 10.120.26.211:4865
27532 New TCP connection: 10.120.26.211:4866
New zoneserver: #2 10.120.26.211:4866
New zoneserver: #3 10.120.26.211:4865
New zoneserver: #4 10.120.26.211:4864
New zoneserver: #5 10.120.26.211:4863
Zoneserver SetConnectInfo: 10.120.26.211:4863: www.flyfreak.com:7999
Zoneserver SetConnectInfo: 10.120.26.211:4864: www.flyfreak.com:7998
Zoneserver SetConnectInfo: 10.120.26.211:4865: www.flyfreak.com:7997
Zoneserver SetConnectInfo: 10.120.26.211:4866: www.flyfreak.com:7996
338922 New client from ip: 10.120.26.113 port: 1249
Account Attempting to be created:booga3339 0
Logged in: FirstLogin LS#62173: booga3339
Received unknown opcode: 0x02eb size:0 bytes
Name approval request for:Fooba race:2 class:1
Character creation request from booga3339 LS#62173 (10.120.26.113:1249) :
Name: Fooba
Race: 2 Class: 1 Gender: 0 Deity: 396 Start zone: 2
STR STA AGI DEX WIS INT CHA Total
123 113 94 70 70 60 55 585
Face: 7 Eye colors: 0 0
Hairstyle: 0 Haircolor: 0
Beard: 0 Beardcolor: 0
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=2 AND player_class=1 AND player_deity=396 AND player_race=2

[Status] Found starting location in start_zones
Current location: halas 560.00, -456.00, -26.00
Bind location: halas 560.00, -456.00, -26.00
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (rac
e = 2 or race = 0) AND (class = 1 or class = 0) AND (deityid = 396 or deityid=0)
AND (zoneid = 29 or zoneid = 0) AND gm <= 0 ORDER BY id
Character creation successful: Fooba
Read group ID for 'Fooba': 0
0: 2C 30 2C 2E 46 6F 6F 62 - 61 2C 30 36 37 61 37 39 | ,0,.Fooba,067a79
16: 64 34 00 | d4.
Attempting autobootup of halas (29) for Fooba
Zoneserver SetZone: www.flyfreak.com:7999 halas (29)
Enter world: Fooba: halas (29)
Zoneserver SetZone: www.flyfreak.com:7999 halas (29)
Client disconnected
Removing client from ip:10.120.26.113 port:1249

Here's the text from the zone window:

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR1
[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 Loot tables from database...
[Status] Loading doors
[Status] Loading Doors from database...
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'hp' defaulting to access level 0!
[Status] command_init(): Warning: Command 'pf' defaulting to access level 0!
[Status] command_init(): Warning: Command 'bestz' defaulting to access level 0!
[Status] command_init(): Warning: Command 'ginfo' defaulting to access level 0!
[Status] 170 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 10.120.26.211:9000
Got new group id set: 4001 -> 5000
Map header: 26977 faces, 207 nodes, 36231 facelists
Loaded map: 80931 vertices, 26977 faces, 0 branch nodes, 0 final nodes
Map BB: (-562.78 -> 492.81, -805.69 -> 708.72, -131.94 -> 602.94)
Map ./Maps/halas.map loaded.
[Status] Weather should change in 1566 seconds
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 29; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for halas ...
[Status] Done loading doors for halas ...
[Status] Zone Bootup: halas (29)
[Status] 375516 New client from ip:10.120.26.113 port:1251
Read group ID for 'Fooba': 0
Loaded group id 0 from DB.
Dumping inventory on load:
Worn items:
Inventory items:
Slot 22: A Worn Candle (1)
Slot 23: Short Sword* (1)
Slot 24: Skin of Milk (20)
Slot 25: Bread Cakes* (20)
Bank items:
Shared Bank items:

[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x037f, size: 0
Unknown opcode: 0x01e5 size:8 Client:Fooba
0: 0A 00 00 00 D2 3E 73 7D | .....>s}
Setting stats for BL Pet for Race: 2
Summoning BeastLord Pet: 43

Any thoughts here?

mystic414 · #7 10-16-2004, 06:41 PM

Quote:

Originally Posted by Edgar1898

Could both of you post the last couple of lines from your eqemudebug.log file. It should be located in the same directory from where you are running the zone. I dont have any of those problems (or I would have fixed them).

Here you go:

Code:

2004/10/16 21:11:49 GMT: Zone 8780 crashed. Errorcode: 1/6. Current zone loaded:neriaka. Current clients:0. Caused by:

That's the only error in the entire log file, just repeated 5 or 6 times. There is nothing after "Caused by:". Let me know if you'd like any more info.

Edgar1898 · #8 10-16-2004, 07:10 PM

could you run this sql query and paste the resullts:

desc altadv_vars;

finwe · #9 10-17-2004, 01:14 AM

i have a problem with 6.0 precompiled version too... alll works fine but when i chose the charapter and click enter world i got black screen and nothing loads... world.exe windows shows that:

Attempting autobootup of felwithea (61) for Finwes
Zoneserver SetZone: 212.170.xxx.xxx:8780 felwithea (61)
Enter world: Finwes: felwithea (61)
Zoneserver SetZone: 212.170.xxx.xxx:8780 felwithea (61)
Received unknown opcodo: 0x0376 size:0 bytes
Client disconnectd

And i always get the same result when trying to connect.
world loads nice and boot5zonees too but i have this problem. I have client patched to live. Any clue????

Tks

zephyr325 · #10 10-17-2004, 02:57 AM

Quote:

Originally Posted by Edgar1898

could you run this sql query and paste the resullts:

desc altadv_vars;

Elkay · #11 10-17-2004, 03:32 AM

Ed, I've fixed this problem but am onto the next problem I have where nothing crashes now but my client hangs at a black screen zoning into most zones if there are any mobs in the zone. I have that discussion going in a different thread. The problem I actually had here was that my copy from CVS was missing a couple updates. Guess I jumped the gun by a couple minutes and caught it mid-update. Now onto the next problem.. lol.

Edgar1898 · #12 10-17-2004, 04:23 AM

Most (if not all) of the zone crashes that result in a 1/6 errorcode is causes by an incompatible database. Make sure you have done the sets outlined here:

http://www.eqemulator.net/databases_v6.php

Elkay · #13 10-17-2004, 05:00 AM

Quote:

Originally Posted by Edgar1898

Most (if not all) of the zone crashes that result in a 1/6 errorcode is causes by an incompatible database. Make sure you have done the sets outlined here:

http://www.eqemulator.net/databases_v6.php

Yeah I'm pretty sure it's something DB related. It's just a matter of finding out what. I've done that conversion from 5.9dr3 to 60.dr1 so many times restoring it from testing what's broken that I'm sure I got the process right and could probably do it with my eyes closed lol. It's definitely a spawn related issue, as I have no problems anywhere if I remove all the spawns from the zone. It's just a matter of narrowing it down now. I thought it was pathing for a while but it was too inconsistent with my testing to be just that. I'm thinking I actually have a couple problems that together are making it hard to track down. I'll keep you updated.

Xothin · #14 10-17-2004, 08:20 AM

Quote:

New zoneserver: #2 172.16.12.2:4612
New zoneserver: #3 172.16.12.2:4611
New zoneserver: #4 172.16.12.2:4610
Zoneserver SetConnectInfo: 172.16.12.2:4610: dxmedia.homeip.net:7998
Zoneserver SetConnectInfo: 172.16.12.2:4611: dxmedia.homeip.net:7996
Zoneserver SetConnectInfo: 172.16.12.2:4612: dxmedia.homeip.net:7997
71242 New TCP connection: 172.16.12.2:4613
New zoneserver: #5 172.16.12.2:4613
Zoneserver SetConnectInfo: 172.16.12.2:4613: dxmedia.homeip.net:7999
109898 New client from ip: 172.16.12.31 port: 2238
Login with '62747' and 'XDLQVDM9J6'
172.16.12.31: Wrong name/pass: name='62747'
Removing client from ip:172.16.12.31 port:2238
351225 New client from ip: 172.16.12.31 port: 2259
Login with '62747' and 'QCMSFL9SYM'
172.16.12.31: Wrong name/pass: name='62747'
Removing client from ip:172.16.12.31 port:2259
906944 New client from ip: 68.80.241.69 port: 1213
Login with '20970' and 'HP6YFG9CHU'
68.80.241.69: Wrong name/pass: name='20970'
Removing client from ip:68.80.241.69 port:1213

I just dumped my DB last night, and recreated according to the instructions posted on the database thread. This is a brand new fresh database. =/ As you can see, it's not just me having issues logging in to my server here. Just get dumped back to the server select screen with a 1017.

I had set the server to use minilogin, but have since reversed the changes made to do this.

Anyone have any ideas what could be causing this?

I run the Xothins Playland server. =)

Edgar1898 · #15 10-17-2004, 09:03 AM

you forgot to remove the ServerType variable from your variables table. You can just rename the value to anything except minilogin and it will work again.