Database values issue

Post Reply
bladegary
Posts: 3
Joined: Sat Jan 05, 2013 9:47 am

Database values issue

Post by bladegary » Sat Jan 05, 2013 12:48 pm

Hey,
I discovered the project a few days ago so first of all I'd like to say thank you for all the work you've done so far ! :)

I followed the wiki to build the server and configure the client and everything works fine except for one thing : it seems that the hex values from the .sql files don't insert as they should in the database. So, when I log into the game, I can't see my character, the npcs, the monsters,... since the tables don't have the correct value :

Image

So, is this an encoding issue ?

Here are the database properties, maybe I have to change something there ?

Character set : utf8 -- UTF-8 Unicode

Collation : utf8_general_ci

User avatar
whasf
Site Admin
Posts: 1312
Joined: Thu Jul 19, 2012 9:11 pm

Re: Database values issue

Post by whasf » Sat Jan 05, 2013 1:16 pm

Try HeidiSQL , I think the version of NaviCat you're using doesn't show blobs correctly.
-- Whasf

bladegary
Posts: 3
Joined: Sat Jan 05, 2013 9:47 am

Re: Database values issue

Post by bladegary » Sat Jan 05, 2013 2:09 pm

Thanks !
I can indeed see the correct values with HeidiSQL, so I guess my issue is something else since PC and NPC are still invisible when i launch the game =/

PrBlahBlahtson
Developer
Posts: 539
Joined: Sun Jul 22, 2012 12:17 am

Re: Database values issue

Post by PrBlahBlahtson » Sat Jan 05, 2013 5:55 pm

I'd check the setup and bug forums a little more thoroughly. This has been encountered before. If it's selectively invisible, you're missing an expansion. If it's "everything's invisible," I forget what the solution was.

bladegary
Posts: 3
Joined: Sat Jan 05, 2013 9:47 am

Re: Database values issue

Post by bladegary » Sat Jan 05, 2013 6:18 pm

I found the thread in the bug forum, missed it the first time I looked, sorry about that.

So it was because the game used the intel graphic card instead of the nvidia one, I just had to change that in the nvidia control panel and now everything works fine. Thx !

Post Reply