Get a new Mysql version driver.
|
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)
Get a new Mysql version driver.
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!
Well, Does it work? I've just noticedjava.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
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!
« Previous Thread | Next Thread » |
Thread Information |
Users Browsing this ThreadThere are currently 1 users browsing this thread. (0 members and 1 guests) |