NPC Faction Lists

[Maewein]

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.

[cavedude]

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.

[Maewein]

Thank you. Worked like a charm