Wierd Mysql Problem

[friendofdar]

Okay so I am using Chrispee's Newest Repack and it's working fine and all but here is my problem.
Well i had this database before and had to delete it and execute it again this time changing some display ids and such before i executed it but the changes don't work they are the same as the were before i reinstalled it and even it my tables it shows them as the display ID or NAME i want them to be but on the game it doesn't show up right.
Help please +rep for any useful information.

[Daxo]

For some reason this is a bug...
It works after a server restart and if that doesn't work do a comp restart
I had have this happen and a restart fixed it for some reason... maybe something to do with the mysqld-nt thats running in the back round.

[friendofdar]

Well i tried restarting my computer and everything but nothing works.
I even tried uninstalling MYsql and installing it again but something messed up with the starting of the service but the server worked anyway so I don't Know what to do.

[weaselking1973]

its in the MySQL files

for some reason, i dont know, the program leaves data in the directory it stores the database instead of droping it out.

i have had the same issue just trying to restart / reload parts of the database as i have made changes.

once i had to go as far as uninstalling MySQl and reinstalling it

[friendofdar]

Hmmm...Well so i should just keep messing with deleting and putting back up the databse and mysql and stuff?

[Daxo]

Try .reload creature_names and .reload creature_proto then restart the server

[friendofdar]

Still doesnt work dang any more ideas..?

[Daxo]

Make a new npc... just make a new npc inside of creature_names and use a creature proto that is already in use... change faction and stuff

[friendofdar]

yeah but will it still be able to teleport people im using the teleport npc

[Daxo]

Hmm, make a back up then test it out

[Illidan1]

In the Sql table "Creature_spawns" there is a Display Id format
Just get the Npc's Id that has wired Display Id and delete him and Re-spawn him if that
is what you are talking about

[friendofdar]

Idk what is wrong and why i can't just like restart the server and it work just forget it ill work on fixing it somehow.