Problems with 6.0
 

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.

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

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.

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.

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

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?

Here you go:
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.

could you run this sql query and paste the resullts:

desc altadv_vars;

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

Here's mine:

mysql> desc altadv_vars;
+------------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------------+------+-----+---------+-------+
| skill_id | int(11) | | PRI | 0 | |
| name | varchar(128) | YES | | NULL | |
| cost | int(11) | YES | | NULL | |
| max_level | int(11) | YES | | NULL | |
| hotkey_sid | int(10) unsigned | | | 0 | |
| hotkey_sid2 | int(10) unsigned | | | 0 | |
| title_sid |int(10) unsigned | | | 0 | |
| desc_sid | int(10) unsigned | | | 0 | |
| type | tinyint(3) unsigned | | | 1 | |
| spellid | int(10) unsigned | | | 0 | |
| prereq_skill | int(10) unsigned | | | 0 | |
| prereq_minpoints | int(10) unsigned | | | 0 | |
| spell_type | int(10) unsigned | | | 0 | |
| spell_refresh | int(10) unsigned | | | 0 | |
| classes | int(10) unsigned | | | 65534 | |
| berserker | int(10) unsigned | | | 0 | |
+------------------+---------------------+------+-----+---------+-------+
16 rows in set (0.00 sec)

Also, as another test, I patched fully to live, can log into the "regular" everquest, but I can't get into any 6.0DR1 server.

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.

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.

Login issues - 6.0DR-1
 

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. =)

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.

Lol yeah I had run into the same problem. Took me a good 15-20 minutes to remember about that variable lol.

Edgar - Here's the steps I've followed:

Database
=======
- Blown away the database & created a new one
- Loaded up the PEQ_Classic database
- sourced the files listed on the 6.0DR1 DB page (aa_levels, altadv_vars, wr_update) => No errors observered
- Ran the sql command the world.exe process requested (about 'unknown008') => No errors observed

Client
====
- patched my client to live EQ to make sure its current

Server
=====
- Grabbed the latest software from WINCVS/compiled


Observations
==========
- I still get the black screen after I create a character and try to zone in (see detail below).
- When trying to zone in, the client will do a (quick) load of the first completion bar, will pause for about 10-15 seconds, will NOT do the second load I usually see, but just go straight to a black screen.
- Also, I get the same symptoms when trying to log into anyone else's 6.0DR1 servers.
- There's nothing that goes into the server error log

One thing I've noticed - when I run the process to load up the barebones database, I zone in fine and everything works as expected. Its only when using the PEQ database that I run into this.




WORLD.EXE OUTPUT:
===============
[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
Formatting drive C:
TCP listening on: www.flyfreak.com:9000
World server listening on: www.flyfreak.com:9000
Connected to LoginServer: newlogin1.eqemulator.net:5994
28250 New TCP connection: 10.120.26.211:3487
New zoneserver: #1 10.120.26.211:3487
Zoneserver SetConnectInfo: 10.120.26.211:3487: www.flyfreak.com:7998
28360 New TCP connection: 10.120.26.211:3488
28360 New TCP connection: 10.120.26.211:3489
28360 New TCP connection: 10.120.26.211:3490
28360 New TCP connection: 10.120.26.211:3491
New zoneserver: #2 10.120.26.211:3491
New zoneserver: #3 10.120.26.211:3490
New zoneserver: #4 10.120.26.211:3489
New zoneserver: #5 10.120.26.211:3488
Zoneserver SetConnectInfo: 10.120.26.211:3488: www.flyfreak.com:7999
Zoneserver SetConnectInfo: 10.120.26.211:3489: www.flyfreak.com:7997
Zoneserver SetConnectInfo: 10.120.26.211:3490: www.flyfreak.com:7996
Zoneserver SetConnectInfo: 10.120.26.211:3491: www.flyfreak.com:7995
90078 New client from ip: 10.120.26.113 port: 2404
Account Attempting to be created:zephyr325 0
Logged in: FirstLogin LS#62172: zephyr325
Received unknown opcode: 0x02eb size:0 bytes
Name approval request for:Zump race:1 class:7
Character creation request from zephyr325 LS#62172 (10.120.26.113:2404) :
Name: Zump
Race: 1 Class: 7 Gender: 0 Deity: 210 Start zone: 4
STR STA AGI DEX WIS INT CHA Total
80 100 85 85 75 75 75 575
Face: 0 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=4 AND player_class=7 AND player_deity=210 AND player_race=1

[Status] Found starting location in start_zones
Current location: freportw -239.00, -807.00, -10.00
Bind location: freportw -239.00, -807.00, -10.00
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (rac
e = 1 or race = 0) AND (class = 7 or class = 0) AND (deityid = 210 or deityid=0)
AND (zoneid = 9 or zoneid = 0) AND gm <= 0 ORDER BY id
Character creation successful: Zump
Read group ID for 'Zump': 0
0: 2C 30 2C 2E 5A 75 6D 70 - 2C 30 36 37 61 37 39 64 | ,0,.Zump,067a79d
16: 34 00 |
Attempting autobootup of freportw (9) for Zump
Zoneserver SetZone: www.flyfreak.com:7999 freportw (9)
Enter world: Zump: freportw (9)
Zoneserver SetZone: www.flyfreak.com:7999 freportw (9)
Received unknown opcode: 0x0376 size:0 bytes
Client disconnected
Removing client from ip:10.120.26.113 port:2404

ZONE.EXE OUTPUT:
================
[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
Map header: 42521 faces, 650 nodes, 56765 facelists
Loaded map: 127563 vertices, 42521 faces, 0 branch nodes, 0 final nodes
Map BB: (-1693.31 -> 1399.44, -783.69 -> 1637.34, -113.97 -> 149.94)
Map ./Maps/freportw.map loaded.
[Status] Weather should change in 12182 seconds
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 9; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for freportw ...
[Status] Done loading doors for freportw ...
[Status] Zone Bootup: freportw (9)
[Status] 125907 New client from ip:10.120.26.113 port:2406
Read group ID for 'Zump': 0
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x037f, size: 0
Unknown opcode: 0x01e5 size:8 Client:Zump
0: 0A 00 00 00 D2 3E 73 7D | .....>s}
Setting stats for BL Pet for Race: 3
No pet type modifications defined for race: 3
Summoning BeastLord Pet: 43
Setting stats for BL Pet for Race: 1
No pet type modifications defined for race: 1
Summoning BeastLord Pet: 43
Setting stats for BL Pet for Race: 5
No pet type modifications defined for race: 5
Summoning BeastLord Pet: 43
Setting stats for BL Pet for Race: 1
No pet type modifications defined for race: 1
Summoning BeastLord Pet: 43


Thanks for all your help with this.

I too am running into the exact same error when i left Erudin palace and into the heavier populated mob zone. Things seemed ok until then. I too am running 6.0 dr1 and had problems on other peoples servers, at least two others i tried, especially when zoning.

enable berserkers and it will fix this problem

How do you do that? I'm assuming its a sql/database command? I did a search for "enable beserker" and couldn't find a match.

I have no idea either, pretend i know nothing. Which is very true. What is the actual command ?

beserker
 

i think you have to put a 255 in the variable table under expansions

Re: beserker
 

If it is that, here's the command:

update variables set value=255 where varname like 'expansions';

That's already in my database; it's step 16 in this post (on page 6, Chrysm's post).

Mine has always been set to 255, same black screens. That's not the problem.

Black Screens
 

I too get these occasionally, with or without the 255 variable set.

Normally this happens after I've attempted(and failed) to load in due to some other issue with my DB.

To correct it, normally, all I do is reboot the system that EQEmu is running on and everything works normal.


After updating to the latest compiled release and getting the error about the rezzed field not being there, I started getting the black screen on login. I rebooted the system, and on the next login everything was fine.

Another small issue..
 

When fighting mobs with pets, if you kill the pet first, you cannot kill its master afterwards, unless it summons another pet.

I've noticed that when fighting a mob with a pet, when the pet is damaged by you, its not reflecting that its the pet, but its master instead. The pet itself takes the damage, but EQEmu does not show in the log that the pet is the one taking damage.

IE - I fight an Innoruuks Chosen who has an SK pet. My damage shield is constantly beating on this pet(and showing as though I'm doing the DS damage to the mob), and it dies before the chosen does. I can no longer do any damage to the chosen. I feign, wait for the mob to go back to spawn and recast a pet. As soon as the pet comes out, I break feign, and attack the chosen again, I'm able to do damage to the chosen now that another pet has popped.

Re: Black Screens
 

Interesting.. I'll try that tonight just for the hell of it. I haven't rebooted that box in probably 3 weeks.

Agreed - I'm going to try that now. If anyone wants to test to Zorpomatic server at about 2:00 PST CST and post back here to see if you can login, we can see if that clears the issue (I don't have access to an EQ client at work).

Sounds like me until I started running EQEmu... now I reboot that box every day or so. ^.^

I tried this when i got home today, when going into Erudin Palace i still get....

No pet type modifications defined for race: 3
Summoning Beastlord pet:43


Over and over again, but some zones seem fine.

Ok tried rebooting the computer, still hanging at black screen on zoning in.

I have the same problems, showing BL pet errors. I also tried rebooting and both server and client, same thing. I have some time this weekend to mess with it but i know nothing about SQL, at least not yet.