Updated to Rev535 now Error in instZOrgID

[Dssman007]

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.


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]

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

- Djeryv

[drakelord]

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]

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

-Djeryv

[cavedude]

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]

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]

New instance build is up as a download on SVN.

[Yeormom]

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.