Thread: [dodian] wierd sql saving error (reward: $5 dollars paypal)

Results 1 to 8 of 8
  1. #1 [dodian] wierd sql saving error (reward: $5 dollars paypal) 
    ⚓Manic-Owner⚓


    Join Date
    Nov 2007
    Posts
    2,711
    Thanks given
    47
    Thanks received
    9
    Rep Power
    650
    I am willing to reward anyone who can help fix this error. Well, my server works fine on my own computer but when I try uploading to my friends dedi and I run the server, runs fine, when I login, everything seems to work, but then everytime I logout, nothing is saved and I get this error in run.cmd

    Code:
    Uber Server 3.0 - Created by Winten - http://dodian.com
    -------------------------------------------------------
    Loading npcs... drops... spawn list...done!
    Connection from adsl-76-211-142-122.dsl.irvnca.sbcglobal.net:3331
    [client-1-Bakatool]: dbId=1
    [client-1-Bakatool]: Loading Process Completed  [0, 1, 16]
    [client-1-Bakatool]: ab=50235
    [client-1-Bakatool]: ab=24133
    [client-1-Bakatool]: Case 185: Action Button: 24133
    [client-1-Bakatool]: ab=9154
    java.sql.SQLException: Syntax error or access violation message from server: "Yo
    u have an error in your SQL syntax; check the manual that corresponds to your My
    SQL server version for the right syntax to use near 'range = 1500000, prayer = 1
    500000, magic = 1500000, cooking = 1500000, woodcutti' at line 1"
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:2281)
            at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
    :1825)
            at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
    :1667)
            at client.saveStats(client.java:2607)
            at client.logout(client.java:2491)
            at client.parseIncomingPackets(client.java:10307)
            at client.process(client.java:6299)
            at PlayerHandler.process(PlayerHandler.java:192)
            at process.run(process.java:18)
            at java.lang.Thread.run(Unknown Source)
    [client-1-Bakatool]: Save Exception: 1, Bakatool
    [client-1-Bakatool]: Logout
    Game saved for player Bakatool
    ClientHandler: Client Bakatool disconnected (adsl-76-211-142-122.dsl.irvnca.sbcg
    lobal.net)
    This happened on both of his dedicated servers. It works fine on my own computer though. Why doe sit do this?
    MY DISCORD:
    bluejay#1504
    Reply With Quote  
     

  2. #2  
    iPhoneGuy
    Guest
    You entered the wrong SQL information

    Free 5 bucks pl0x?
    Reply With Quote  
     

  3. #3  
    ⚓Manic-Owner⚓


    Join Date
    Nov 2007
    Posts
    2,711
    Thanks given
    47
    Thanks received
    9
    Rep Power
    650
    how?
    MY DISCORD:
    bluejay#1504
    Reply With Quote  
     

  4. #4  
    SERGEANT OF THE MASTER SERGEANTS MOST IMPORTANT PERSON OF EXTREME SERGEANTS TO THE MAX!

    cube's Avatar
    Join Date
    Jun 2007
    Posts
    8,871
    Thanks given
    1,854
    Thanks received
    4,745
    Rep Power
    5000
    Show your MySQL saving method.

    Attached image

    Reply With Quote  
     

  5. #5  
    Registered Member

    Join Date
    Sep 2007
    Age
    32
    Posts
    2,396
    Thanks given
    5
    Thanks received
    436
    Rep Power
    902
    yeah show the whole query
    Hyperion V2 Martin's Updates.

    Scar says:
    i hate it when it hits your face
    Reply With Quote  
     

  6. #6  
    Registered Member
    Join Date
    Nov 2006
    Posts
    98
    Thanks given
    11
    Thanks received
    0
    Rep Power
    18
    You also migth want to get a fresh database and reimport the .sql file.
    Reply With Quote  
     

  7. #7  
    pkin3
    Guest
    tryed that and cant find the saving query and its basic dodian and the database info is correct
    Reply With Quote  
     

  8. #8  
    Registered Member P A N I C's Avatar
    Join Date
    Jan 2007
    Posts
    174
    Thanks given
    0
    Thanks received
    0
    Rep Power
    58
    If your database is on a webhost, you have to configure the wild cards in which can connect to your server. Try adding it to your wildcard list, worked for me.
    Exactly.
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •