Page 1 of 1

NPC issues

Posted: Tue Nov 17, 2015 9:17 pm
by Wannabc5
After updating my server all of my npc are naked humes and Orc's. I've tried reinstalling my database and doing a fresh pull. What am i over looking?

Re: NPC issues

Posted: Tue Nov 17, 2015 9:58 pm
by kjLotus
however you reran the .sql files didn't work with hex blobs

Re: NPC issues

Posted: Wed Nov 18, 2015 12:05 pm
by Wannabc5
I reran my SQL files a few times lastnight. I'm starting to think its my npclist.sql. Reason I say that is because I dumped all of my modded files before I did my pull. Do you think the dump of the npclist could cause this problem?

Re: NPC issues

Posted: Wed Nov 18, 2015 12:25 pm
by demolish
ya the dump didn't retain the hex blob

Re: NPC issues

Posted: Wed Nov 18, 2015 12:50 pm
by Wannabc5
Okay thanks. I'll make note not to dump those files again.

Re: NPC issues

Posted: Wed Nov 18, 2015 7:11 pm
by kjLotus
Wannabc5 wrote:Okay thanks. I'll make note not to dump those files again.
you can dump them, but you have to use --hex-blob when you do (assuming you are using mysqldump on the command line)

Re: NPC issues

Posted: Wed Nov 18, 2015 7:40 pm
by TeoTwawki
And if you were using something without good support or controls for hex blobs (like say an ancient version of navicat) to dump them...Don't do that :P