NPC issues

Post Reply
Wannabc5
Posts: 25
Joined: Tue Feb 24, 2015 8:28 am

NPC issues

Post by Wannabc5 » Tue Nov 17, 2015 9:17 pm

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?

User avatar
kjLotus
Special Guest
Posts: 1813
Joined: Sun Jul 22, 2012 2:16 pm

Re: NPC issues

Post by kjLotus » Tue Nov 17, 2015 9:58 pm

however you reran the .sql files didn't work with hex blobs

Wannabc5
Posts: 25
Joined: Tue Feb 24, 2015 8:28 am

Re: NPC issues

Post by Wannabc5 » Wed Nov 18, 2015 12:05 pm

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?

User avatar
demolish
Developer
Posts: 262
Joined: Thu Jul 26, 2012 7:12 am

Re: NPC issues

Post by demolish » Wed Nov 18, 2015 12:25 pm

ya the dump didn't retain the hex blob
<Giblet[NewBrain]> kj with this first step would be fine on my shit
Click here for a guide on scripting missions.

Wannabc5
Posts: 25
Joined: Tue Feb 24, 2015 8:28 am

Re: NPC issues

Post by Wannabc5 » Wed Nov 18, 2015 12:50 pm

Okay thanks. I'll make note not to dump those files again.

User avatar
kjLotus
Special Guest
Posts: 1813
Joined: Sun Jul 22, 2012 2:16 pm

Re: NPC issues

Post by kjLotus » Wed Nov 18, 2015 7:11 pm

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)

User avatar
TeoTwawki
Developer
Posts: 527
Joined: Mon Jul 15, 2013 9:50 pm

Re: NPC issues

Post by TeoTwawki » Wed Nov 18, 2015 7:40 pm

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
Hi, I run The Demiurge server.


Image
Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live. - Martin Golding
PLS USE [ code ] CODE TAGS [ /code ] WHEN POSTING CODE
DO NOT PRIVATE MESSAGE ME ABOUT BUGS

Post Reply