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?