EQEmulator Forums - Updated to Rev535 now Error in instZOrgID

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

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

- - Updated to Rev535 now Error in instZOrgID (https://www.eqemulator.org/forums/showthread.php?t=28255)

Dssman007

05-18-2009 05:03 AM

Updated to Rev535 now Error in instZOrgID

I decided to start compiling my own windows binaries as per your wiki guide. After tonight's update with Rev535 I now get this error when I try to log my character in from the character select screen.

Code:

Error in instZOrgID query in database.cpp GetZoneName'SELECT instZOrgID FROM cha

racter_ WHERE instZflagNum=77' #1054: Unknown column 'instZOrgID' in 'field list

'

[Debug] [WORLD__CLIENT_ERR] dssman007: Zone not found in database zone_id=77, mo

veing char to arena character:Arkinid

Error in GetInstType query 'SELECT instZOrgID FROM character_ WHERE id=5' #1054:

 Unknown column 'instZOrgID' in 'field list'

Error in instZOrgID query in database.cpp GetZoneName'SELECT instZOrgID FROM cha

racter_ WHERE instZflagNum=77' #1054: Unknown column 'instZOrgID' in 'field list

'

djeryv

05-18-2009 09:49 AM

I get this as well...with the same rev you describe. I am using PEQ 16 for 535 as well.

- Djeryv

drakelord

05-18-2009 10:00 AM

I just tested the binaries and I did not get this issue. Are you sure you are using the latest source for both the server and the PEQ databse?

I ask because the newest PEQ database no longer has the instZOrgID field in it. So the fact that it is try to look for it is highly suspicious.

djeryv

05-18-2009 10:07 AM

I did not compile it myself...but got the binaries from Angelox website. The rev levels match for PEQ and EQEMU.

-Djeryv

cavedude

05-18-2009 10:32 AM

That's a compatibility problem. TGC is testing out the instance branch because it is now pretty stable (and works very well!) and so the old instancing system was removed in the DB.

To make a long story short, I'll build the instance branch and post it on SVN later, as well as the normal branch. The PEQ database will work with that, and I'll even include the custom Perl script I wrote to text out instances on TGC so everybody can easily get their feet wet in this insanely awesome new system. Just give me some time on the SVN build, I just got home from a weekend of hospital visits :(

djeryv

05-18-2009 10:42 AM

Sorry about your hospitalized (friend[s]). I hope all is going well.

I only have a couple of friends who play on my server, and they are playing WOW and UO on it right now and not EQ, so I can try these things out without them calling me and complaining. I will try the new builds later when you get them up...and see what happens.

-Djeryv

cavedude

05-18-2009 06:37 PM

New instance build is up as a download on SVN.

Yeormom

05-18-2009 07:34 PM

I noticed this when attempting to put up a quick empty environment to test a third party bug. There's several repercussions beyond new characters having their zone set to null, like npcs not spawning in any zones and what not.

I'll try to look through your SVN again and see if you had a revision number before you went to the instanting structure laters if I remember.

All times are GMT -4. The time now is 05:31 AM.