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

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

Reply
 
Thread Tools Display Modes
  #1  
Old 06-15-2010, 07:22 AM
Tibador
Fire Beetle
 
Join Date: Jul 2009
Location: -
Posts: 2
Default

Well i think i figured out how to fix this with the help of Rumzuck in irc the issue is the revision 1404 if it loads with errors

ALTER TABLE `faction_list` ADD COLUMN `mod_r42` smallint(6) NOT NULL default '0' AFTER `mod_r14`;
ALTER TABLE `faction_list` ADD COLUMN `mod_r367` smallint(6) NOT NULL default '0' AFTER `mod_r330`;
ALTER TABLE `faction_list` ADD COLUMN `mod_r522` smallint(6) NOT NULL default '0' AFTER `mod_r367`;
UPDATE faction_list SET mod_r367 = mod_r60;
UPDATE faction_list SET mod_r42 = mod_r120;
ALTER TABLE `faction_list` DROP COLUMN `mod_r60`;
ALTER TABLE `faction_list` DROP COLUMN `mod_r120`;

The Above code does not work and will error out on every line because for whatever reason it cant find mod_r60 even though 1404 says to drop it on line 6 but 1496 is still looking for it.



Rumzuck gave me this query

ALTER TABLE `faction_list` ADD COLUMN `mod_r60` smallint(6) NOT NULL default '0' AFTER `mod_r14`;
ALTER TABLE `faction_list` ADD COLUMN `mod_r120` smallint(6) NOT NULL default '0' AFTER `mod_r108`;

It fixed the error that was happening in zone.exe the only way to find it was to pause the cmd window line by line to check because the logs would not show the error of factions not loading because it was missing mod_r60.

Now i am not sure of the issues with the initial 1404 revision and i hope one of the Devs can come by and help figure out how to fix those Mod's but it does fix all mobs are indifferent issue.

**Warning have not checked all mobs as its late at this post and i am tired lol**
Reply With Quote
  #2  
Old 06-15-2010, 12:55 PM
Secrets's Avatar
Secrets
Demi-God
 
Join Date: May 2007
Location: b
Posts: 1,449
Default

I think it's an issue with the compiled binaries that were posted. I had someone who had this issue download latest source and it worked fine.
Reply With Quote
Reply

Thread Tools
Display Modes

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 04:33 AM.


 

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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3