Thread: Mysql dodian server

Results 1 to 5 of 5
  1. #1 Mysql dodian server 
    pkin3
    Guest
    hello i was wondering if any1 had the server because every one i get dosnt save on logout and gives this error


    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.ja va:2001)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:11 68)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1279)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 2281)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java
    :1825)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java
    :1667)
    at client.saveStats(client.java:2486)
    at client.run(client.java:2160)
    at java.lang.Thread.run(Unknown Source)
    Reply With Quote  
     

  2. #2  
    Donator

    Aeronix's Avatar
    Join Date
    Sep 2008
    Posts
    435
    Thanks given
    2
    Thanks received
    8
    Rep Power
    134
    Get a new Mysql version driver.
    Reply With Quote  
     

  3. #3  
    pkin3
    Guest
    is that all it is i thought it was the srv

    ok i got the new driver testing now http://dev.mysql.com/get/Downloads/C...m/pick#mirrors
    Last edited by pkin3; 01-20-2009 at 08:51 AM. Reason: Double posting is not allowed!
    Reply With Quote  
     

  4. #4  
    Donator

    Aeronix's Avatar
    Join Date
    Sep 2008
    Posts
    435
    Thanks given
    2
    Thanks received
    8
    Rep Power
    134
    Well, Does it work? I've just noticed
    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
    Reply With Quote  
     

  5. #5  
    pkin3
    Guest
    now i get
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: You have an error in
    your SQL syntax; check the manual that corresponds to your MySQL server version
    for the right syntax to use near 'range = 0, prayer = 0, magic = 0, cooking = 0,
    woodcutting = 0, fletching = 0, f' at line 1
    at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

    at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
    rce)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
    at com.mysql.jdbc.Util.getInstance(Util.java:381)
    at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1030)
    at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:956)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3515)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3447)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 51)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2101)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2554)
    at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.ja
    va:1761)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java
    :2046)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java
    :1964)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java
    :1949)
    at client.saveStats(client.java:2412)
    at client.logout(client.java:2296)
    at client.parseIncomingPackets(client.java:9438)
    at client.process(client.java:5966)
    at PlayerHandler.process(PlayerHandler.java:192)
    at process.run(process.java:18)
    at java.lang.Thread.run(Unknown Source)

    lol im starting a new project cause im bored of euro-scape and i need a stable source dor my dedi and i like mysql but i am looking for codes
    Last edited by pkin3; 01-20-2009 at 08:59 AM. Reason: Double posting is not allowed!
    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
  •