Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #16  
Old 10-01-2008, 03:53 PM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

Was worth a shot, but still no dice. I'll just be patient and wait for the next build to roll out here. Thanks for the idea =)

Back to your regularly scheduled thread, sorry for the hijack!
Reply With Quote
  #17  
Old 10-01-2008, 04:33 PM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

Think I found the issue -- Had to install the Microsoft .NET framework versions 2 and 3. Thanks for the help =)
Reply With Quote
  #18  
Old 10-01-2008, 06:16 PM
Digital
Fire Beetle
 
Join Date: Jan 2006
Posts: 9
Default

Hey Again!
I updated my EQEmu with the revision27 files but now i get this error wen i try logging in a char, and the zone crashes. What can i do about this?


Code:
Error in instZOrgID query in database.cpp GetZoneName'SELECT instZOrgID FROM cha racter_ WHERE instZflagNum=58' #1054: Unknown column 'instZOrgID' in 'field list ' Error in GetInstType query 'SELECT instZOrgID FROM character_ WHERE id=16' #1054 : Unknown column 'instZOrgID' in 'field list' Error in instZOrgID query in database.cpp GetZoneName'SELECT instZOrgID FROM cha racter_ WHERE instZflagNum=58' #1054: Unknown column 'instZOrgID' in 'field list '
Reply With Quote
  #19  
Old 10-01-2008, 06:22 PM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

The changelog.txt file should have a list of any SQL changes you need to apply to your database. The errors you are getting there relate to Zone instancing. I think these are all the SQL changes relating to that:

Code:
INSERT INTO variables VALUES ('curInstFlagNum', 2000, 'Determines what instance flag will be handed out next', '2008-09-05 04:46:47');
ALTER TABLE `zone` ADD column `insttype` tinyint (1) zerofill unsigned NOT NULL default '0';
ALTER table character_ ADD column `instZflagNum` int(10) unsigned NOT NULL default '0';
ALTER table character_ ADD column `instZOrgID` int(11) NOT NULL default '0';
INSERT INTO variables VALUES ('dfltInstZflag',1000, 'Used to determine if a zone is instanced, must be 1000 or greater', '2008-09-05 04:46:47');
Reply With Quote
  #20  
Old 10-02-2008, 07:09 AM
Digital
Fire Beetle
 
Join Date: Jan 2006
Posts: 9
Default

Ty Derision
You have been very helpful and most be a great asset to the EqEmu team.
Peace!
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 10:51 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3