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.

Will do it, or you can use the newest version of PEQ. Both the release and CVS have that column.

Thank
 

Thank you. Worked like a charm