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 01-21-2008, 12:16 PM
Maewein
Fire Beetle
 
Join Date: Feb 2006
Posts: 3
Default NPC Faction Lists

I am running EQEmu .70 with MySql 5.0. The world server starts with no problems but when I try to start a zone i receive the following error:

Error in DBLoadNPCFactionLists query2 'SELECT id, primaryfaction, ignore_primary_assist from npc_faction' #1054: Unknown column 'ignore_primary_assist' in 'field list'
Error: EMuShareMem: DLLLoadNPCFactionLists: !cbDBLoadNPCFactionLists
[Debug] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!


I have searched for this problem on the forums and have found that it is usually a problem with one of the fields in the index. I ran the querry that would usually fix the problem but it did not because the column had already existed. I then deleted the row and reran the querry and it recreated the row, but this did not work either. I believe the table in question is described as:

mysql> describe npc_faction
-> ;
+----------------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+----------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | tinytext | YES | | NULL | |
| primaryfaction | int(11) | NO | | 0 | |
+----------------+----------+------+-----+---------+----------------+
3 rows in set (0.03 sec)


If anyone needs any more information to help I would be happy to provide it. Thank you.
Reply With Quote
  #2  
Old 01-21-2008, 12:23 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Code:
alter table npc_faction add column ignore_primary_assist tinyint(3) not null default 0;
Will do it, or you can use the newest version of PEQ. Both the release and CVS have that column.
Reply With Quote
  #3  
Old 01-21-2008, 03:34 PM
Maewein
Fire Beetle
 
Join Date: Feb 2006
Posts: 3
Default Thank

Thank you. Worked like a charm
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 11:09 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