1. Sign up for news, events and more!

    You're currently visiting the official DarkRP Forums as a guest. Sign up now to participate in our community and we'll let you know when we have news.

Converted to MySQL, Money/Name not matching

Discussion in 'DarkRP Modding Questions & Help' started by nzkfc, Oct 8, 2014.

  1. nzkfc

    nzkfc Member

    So I used ESF Database Migration (pro) to convert our sv.db to MySQL.

    It seemed to go over alright but when I join the server it sees me as a new player and asks for RP name and gives me $1000 money (default)

    If I change my name it says it's in use.

    How can I fix that? someone mentioned it's to do with userID changes?
     
  2. nzkfc

    nzkfc Member

    Checked both converted DB and sv.db and I can see the UID's are different and duplicated? :S

    [​IMG]
     
  3. Cake

    Cake Active Member

    Have you tried just importing the sv.db directly and then dropping all the tables you don't need? (Granted i don't know if it uses some special formatting for the sv.db)
     
  4. nzkfc

    nzkfc Member

    That's what I did :)
     
  5. Cake

    Cake Active Member

    Well you said you used something to convert it....
     
  6. nzkfc

    nzkfc Member

    Yeah... I converted the SQLlite file (sv.db) to MySQL......

    How else do you do it?
     
  7. Cake

    Cake Active Member

    Do not have a lot of experience with databases (only just started using them myself) was unaware that it used SQLlite.
     
  8. Bo98

    Bo98 Moderator Staff Member Contributor

    The 'uid' column should be of type BIGINT. It looks like it's a SHORTINT.

    Run the following query on your database and tell me what it outputs.

    Code (SQL):
    SELECT data_type FROM information_schema.COLUMNS WHERE TABLE_NAME = 'darkrp_player' AND column_name = 'uid'
     
  9. nzkfc

    nzkfc Member

    Not sure if i'm doing this right...

    [​IMG]
     
  10. Cake

    Cake Active Member

    Well based on what he has said, its the wrong type...
     
  11. Bo98

    Bo98 Moderator Staff Member Contributor

    Is it possible for you to run the query on the whole server rather than just the DarkRP database, if not then go into the information_schema database and run this:

    Code (SQL):
    SELECT data_type FROM COLUMNS WHERE TABLE_NAME = 'darkrp_player' AND column_name = 'uid'
     
  12. Cake

    Cake Active Member

Share This Page