NPCs GONE.

[DHalo]

Hi, I setup my Mangos server today, and finally got it working. I made a warrior (Human) character, but when I spawned, ALL NPCs were missing! Any suggestions on where to start?

[MentaL]

[wedtm]

Hi, I setup my Mangos server today, and finally got it working. I made a warrior (Human) character, but when I spawned, ALL NPCs were missing! Any suggestions on where to start?

agreed, I updated to 2831 today, and NPC's are non-existant...any help would be great.

[DHalo]

And how convenient is it for the day I make the server, NPC's disappear?

[Jelsoft]

If you are using Mangos 2813 make sure you are using SDB 0.5.3 changeset 24.

[rrhode]

I finally got the server running after staying up for 40 hours straight and then there were no npcs in the game :ohmy:

So I played with gm commands for awhile but now I wonder why there would be no npcs.

I found this and I tried to update my sql to SDB_0.5.3_Changeset_24-2813

gameobject.sql produces this error

Error occured at:2006-12-17 15:08:59
Line no.:2
Error Code: 1060 - Duplicate column name 'name'

Query:
REPLACE INTO `gameobject` VALUES
(23588,171717,0,-4807.6,-1130.1,499.3,2.2383,0,0,0.899731,0.436445,0,120000,0,0),
(29699,171717,0,-4763.5,-1117,499.5,4.37458,0,0,0.81591,-0.578179,0,120000,0,0)

Error occured at:2006-12-17 15:09:31
Line no.:6
Error Code: 1136 - Column count doesn't match value count at row 1

It still has no npcs, maybe I just don't know where they are though... however I did create an auctioneer in the middle of orgrimmar by typing .addspw 15677 and was able to put my jerky on the ah. However when I did .addspw 16043 the game crashed and exited. Any suggestions on what I should do ?

[xSinister]

Hm, Im using rev 2836, with SBD 0.5.3*change set 24 and everything goes fine =/.

[gforcegts]

were did you get 2836?

[anatem]

dude you're supposed to run a separate database file onto the db not the mangos.sql from the revision folder