Thread: Highscores(Quick fix) WILL THANK + REP

Results 1 to 2 of 2
  1. #1 Highscores(Quick fix) WILL THANK + REP 
    Jay Gatsby
    Jay Gatsby is offline
    All you gotta do is speak on Ye

    Jay Gatsby's Avatar
    Join Date
    Jun 2010
    Posts
    2,263
    Thanks given
    1,053
    Thanks received
    1,634
    Discord
    View profile
    Rep Power
    5000
    Default 01-27-2014, 09:05 PM
    I followed this tutorial:
    [Only registered and activated users can see links. ]

    I get this error when I log out:
    Code:
    [1/27/14 7:02 PM]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '`) VALUES ('harry',99,14014480,99,14000000,99,14274840,99,14091329,99,14000000,9' at line 1
[1/27/14 7:02 PM]: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[1/27/14 7:02 PM]: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[1/27/14 7:02 PM]: 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[1/27/14 7:02 PM]: 	at java.lang.reflect.Constructor.newInstance(Unknown Source)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.Util.getInstance(Util.java:381)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1634)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1553)
[1/27/14 7:02 PM]: 	at engine.util.SQL.query(SQL.java:29)
[1/27/14 7:02 PM]: 	at engine.util.SQL.saveHighScore(SQL.java:54)
[1/27/14 7:02 PM]: 	at game.Client.logout(Client.java:648)
[1/27/14 7:02 PM]: 	at rs2.core.packets.ClickingButtons.processPacket(ClickingButtons.java:2005)
[1/27/14 7:02 PM]: 	at rs2.core.packets.PacketHandler.processPacket(PacketHandler.java:110)
[1/27/14 7:02 PM]: 	at game.Client.processQueuedPackets(Client.java:1132)
[1/27/14 7:02 PM]: 	at game.player.PlayerHandler.process(PlayerHandler.java:173)
[1/27/14 7:02 PM]: 	at game.Server$2.execute(Server.java:178)
[1/27/14 7:02 PM]: 	at engine.event.Task.tick(Task.java:118)
[1/27/14 7:02 PM]: 	at engine.event.TaskScheduler.run(TaskScheduler.java:103)
[1/27/14 7:02 PM]: 	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[1/27/14 7:02 PM]: 	at java.lang.Thread.run(Unknown Source)
[1/27/14 7:02 PM]: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'xp' at row 1
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3534)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1634)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1553)
[1/27/14 7:02 PM]: 	at engine.util.SQL.query(SQL.java:29)
[1/27/14 7:02 PM]: 	at engine.util.SQL.saveHighScore(SQL.java:55)
[1/27/14 7:02 PM]: 	at game.Client.logout(Client.java:648)
[1/27/14 7:02 PM]: 	at rs2.core.packets.ClickingButtons.processPacket(ClickingButtons.java:2005)
[1/27/14 7:02 PM]: 	at rs2.core.packets.PacketHandler.processPacket(PacketHandler.java:110)
[1/27/14 7:02 PM]: 	at game.Client.processQueuedPackets(Client.java:1132)
[1/27/14 7:02 PM]: 	at game.player.PlayerHandler.process(PlayerHandler.java:173)
[1/27/14 7:02 PM]: 	at game.Server$2.execute(Server.java:178)
[1/27/14 7:02 PM]: 	at engine.event.Task.tick(Task.java:118)
[1/27/14 7:02 PM]: 	at engine.event.TaskScheduler.run(TaskScheduler.java:103)
[1/27/14 7:02 PM]: 	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[1/27/14 7:02 PM]: 	at java.lang.Thread.run(Unknown Source)
[1/27/14 7:02 PM]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '`) VALUES ('harry',99,14014480,99,14000000,99,14274840,99,14091329,99,14000000,9' at line 1
[1/27/14 7:02 PM]: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[1/27/14 7:02 PM]: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[1/27/14 7:02 PM]: 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[1/27/14 7:02 PM]: 	at java.lang.reflect.Constructor.newInstance(Unknown Source)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.Util.getInstance(Util.java:381)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1634)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1553)
[1/27/14 7:02 PM]: 	at engine.util.SQL.query(SQL.java:29)
[1/27/14 7:02 PM]: 	at engine.util.SQL.saveHighScore(SQL.java:54)
[1/27/14 7:02 PM]: 	at game.Client.logout(Client.java:648)
[1/27/14 7:02 PM]: 	at rs2.core.packets.ClickingButtons.processPacket(ClickingButtons.java:2005)
[1/27/14 7:02 PM]: 	at rs2.core.packets.PacketHandler.processPacket(PacketHandler.java:110)
[1/27/14 7:02 PM]: 	at game.Client.processQueuedPackets(Client.java:1132)
[1/27/14 7:02 PM]: 	at game.player.PlayerHandler.process(PlayerHandler.java:173)
[1/27/14 7:02 PM]: 	at game.Server$2.execute(Server.java:178)
[1/27/14 7:02 PM]: 	at engine.event.Task.tick(Task.java:118)
[1/27/14 7:02 PM]: 	at engine.event.TaskScheduler.run(TaskScheduler.java:103)
[1/27/14 7:02 PM]: 	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[1/27/14 7:02 PM]: 	at java.lang.Thread.run(Unknown Source)
[1/27/14 7:02 PM]: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'xp' at row 1
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3534)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1634)
[1/27/14 7:02 PM]: 	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1553)
[1/27/14 7:02 PM]: 	at engine.util.SQL.query(SQL.java:29)
[1/27/14 7:02 PM]: 	at engine.util.SQL.saveHighScore(SQL.java:55)
[1/27/14 7:02 PM]: 	at game.Client.logout(Client.java:648)
[1/27/14 7:02 PM]: 	at rs2.core.packets.ClickingButtons.processPacket(ClickingButtons.java:2005)
[1/27/14 7:02 PM]: 	at rs2.core.packets.PacketHandler.processPacket(PacketHandler.java:110)
[1/27/14 7:02 PM]: 	at game.Client.processQueuedPackets(Client.java:1132)
[1/27/14 7:02 PM]: 	at game.player.PlayerHandler.process(PlayerHandler.java:173)
[1/27/14 7:02 PM]: 	at game.Server$2.execute(Server.java:178)
[1/27/14 7:02 PM]: 	at engine.event.Task.tick(Task.java:118)
[1/27/14 7:02 PM]: 	at engine.event.TaskScheduler.run(TaskScheduler.java:103)
[1/27/14 7:02 PM]: 	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[1/27/14 7:02 PM]: 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[1/27/14 7:02 PM]: 	at java.lang.Thread.run(Unknown Source)
    My SQL.java:
    [Only registered and activated users can see links. ]

    Would appreciate it if someone could tell me how to fix this.

    Quote Originally Posted by combatx View Post
    Kris let me help your undeveloped mind set, I need new opcodes to support the 184 version?
    Quote Originally Posted by z3rk3ms View Post
    Do not try to treat us like idiots, you will be clowned and then smacked.
    Quote Originally Posted by Hitsplat317 View Post
    I've recently Purchased a Launcher, obviously it's came as a .psd





    Reply With Quote  
     
  2. #2  
    sircarl3
    sircarl3 is offline
    Registered Member
    Join Date
    Dec 2007
    Posts
    641
    Thanks given
    110
    Thanks received
    57
    Rep Power
    75
    01-27-2014, 10:58 PM
    The error message explains whats wrong. The
    Code:
    VALUES ('harry',99,14014480,99,14000000,99,14274840,99,14091329,99,14000000,9' at line 1
    arguments you're using aren't matching the structure of your table you have created.
    Reply With Quote  
     

« Error | need eco reset asap »
Thread Information
Users Browsing this Thread

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

User Tag List

Similar Threads

  1. Highscores(Quick fix) WILL THANK + REP
    By Jay Gatsby in forum Help
    Replies: 3
    Last Post: 01-27-2014, 12:22 PM
  2. [PI] Compiling Error - Will thank +rep
    By AddictivePkz in forum Help
    Replies: 7
    Last Post: 07-26-2012, 04:37 PM
  3. 5 Errors (need help) will thank+rep!
    By RS2006Phat in forum Help
    Replies: 12
    Last Post: 02-04-2012, 11:04 AM
  4. Wtf. annoying problem will thank+rep for help
    By RS2006Phat in forum Help
    Replies: 2
    Last Post: 02-01-2012, 02:14 AM
  5. rsinterface errors for pouch creation[will thank+Rep] ;)
    By OodlesOfNoodles in forum Help
    Replies: 0
    Last Post: 01-22-2012, 08:17 PM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules