Almostthere *PLEASE READ*

[neirra02]

Hi, I am almost complete with my server. I hit World.exe and then Boot5zones.bat and it gets going. Then my Zone.exe (Boot5zones.bat) stops at
[Status] Loading npcs
[Status] Loading Npc Faction lists
^
|
stopped right after that or ..

after about 5 minutes the window just closes out. Any ideas? I think it's something wrong with the Faction but how can I fix it.

[aragon]

What's the error are you getting? You must see a line saying ERROR:XXXXX

[rojadruid]

I am having the same problem as above. There is no error that i can see the window automaticaly closes right after 5min with no error visible during that time.

Tried Runing it in a CMD Prompt here is the error that is displayed
E:\EQEMU>zone . 209.91.186.18 8780 127.0.0.1
[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
Error in DBLoadNPCFactionLists query3 'SELECT npc_faction_id, faction_id, value,
npc_value FROM npc_faction_entries order by npc_faction_id' #1054: Unknown column 'npc_value' in 'field list'
Error: EMuShareMem: DLLLoadNPCFactionLists: !cbDBLoadNPCFactionLists
[Error] Loading npcs faction lists FAILED!

Is there a fix for this, if I read this right it says that I have no faction tables.

[Sarepean]

Do you have an npc_value column in your database?

[rojadruid]

Upon checking the database it does not apear to be there how would this be fixed, is there a .sql file that I need to download that I missed? If so could I get a link or a cut and paste of the code?

Would really love to get this to work.

[cavedude]

neirra02: I get that problem all the time. Just reboot your server. I think there is a memory leak in the Emu code somewhere.

[Sarepean]

There are a ton of SQL fixes that might have to be done, but I don't remember what they are. You might try searching the Windows Server Support forums for them.


EDIT::: Here ya go, run this.

ALTER TABLE npc_faction_entries ADD COLUMN `npc_value` int(11) unsigned NOT NULL default '0';

[rojadruid]

Thank you very much for your help, I got past that error and the server enters sleep mode now. There is still one error thou. It apears to be related to tributes. I am assuming that was because I could not find a tributes.sql file anywhere that still worked. If anyone has one can they link it or paste in the code.

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR2
[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 doors
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading tributes
[Error] Error in LoadTributes first query 'SELECT id,name,descr FROM tributes':
#1146: Table 'eq.tributes' doesn't exist
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 172 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 192.168.1.100:9000


I am assuming that the game will still load with out tributes but I am going for a no error loading. Can anyone help?

[mikeGreen]

i got it from cvs if you want i can email you the tribute files

[rojadruid]

That would be great.

My E-mail is: rojadruid@yahoo.com.

Thank you, got the files they sourced great and the server went into sleep mode without any errors. Now I am getting 1017 when trying to login to test it out.