EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Another No NPC thread (https://www.eqemulator.org/forums/showthread.php?t=38611)

Jarleb 08-13-2014 02:54 PM

Another No NPC thread
 
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 08-13-2014 04:06 PM

Did you get the files from... Here?

Jarleb 08-13-2014 11:52 PM

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 08-14-2014 12:00 AM

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:
Code:

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

NatedogEZ 08-14-2014 12:08 AM

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)
http://i.imgur.com/uUqw8LA.png

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

Akkadius 08-14-2014 12:31 AM

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 08-14-2014 01:20 AM

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 08-14-2014 08:57 AM

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 :)


All times are GMT -4. The time now is 04:54 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.