Another No NPC thread

[Jarleb]

As the topic states, I'm not getting NPC's to load on my server.
I've read the other posts about this, but have not been able to get it to work with those tips.

Heres what I have done.
loaded peqbeta.sql
loaded spells_new.sql
loaded player_tables.sql
loaded Special_Abilities.sql
All these are the most recent files..

Is there anything I am missing at this point?

[NatedogEZ]

Did you get the files from... Here?

[Jarleb]

peqbeta_2014-08-11-02:01.tar.gz was downloaded there yes.

2014_08_02_spells_new and
2013_07_11_NPC_Special_Abilities was downloaded from github..

[Kingly_Krab]

Seems like your source is newer than your database, maybe the PEQ Daily Dump you grabbed wasn't updated to when they added a new column to the npc_types table:

ALTER TABLE `npc_types` ADD `raid_target` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `no_target_hotkey`;

[NatedogEZ]

Check your npc_types table for these three fields....
ammo_idfile
ranged_type
Avoidance

If they are missing.. run.. "2014_07_10_npc_spells.sql"

Check your Source folder
.\utils\sql\git\required

for that file... (Note: this is an up to date folder)


if there are any other files after it.. run them if the changes are not already done to your database..

[Akkadius]

I'm working on a versioning solution for our databases so that all people have to do is run a script that is included with our source.

[demonstar55]

Cavedude has been busy with real life and hasn't been able to update PEQ in a while, so it's a bit behind. You need to run at least 2014_07_10_npc_spells.sql+

[Jarleb]

There we go. I was missing 2014_07_10_npc_spells.sql, and 2014_08_12_NPC_raid_targets
Thanks alot for the help guys