Thread: Highscores(Quick fix) WILL THANK + REP

Results 1 to 4 of 4
  1. #1 Highscores(Quick fix) WILL THANK + REP 
    So when I'm free, I'm free


    Jay Gatsby's Avatar
    Join Date
    Jun 2010
    Posts
    2,307
    Thanks given
    1,148
    Thanks received
    1,982
    Rep Power
    5000
    I followed this tutorial:
    http://www.rune-server.org/runescape...ighscores.html

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

    My SQL.java:
    http://pastebin.com/Yz9guADk

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

  2. #2  
    CodexBot


    Join Date
    Sep 2011
    Age
    30
    Posts
    884
    Thanks given
    136
    Thanks received
    153
    Rep Power
    148
    ,Summoninglvl` needs to be ,`Summoninglvl`
    - CodexBot
    Reply With Quote  
     

  3. Thankful user:


  4. #3  
    So when I'm free, I'm free


    Jay Gatsby's Avatar
    Join Date
    Jun 2010
    Posts
    2,307
    Thanks given
    1,148
    Thanks received
    1,982
    Rep Power
    5000
    bump
    Reply With Quote  
     

  5. #4  
    Enthimia Founder
    Ap4che's Avatar
    Join Date
    Jan 2014
    Posts
    180
    Thanks given
    0
    Thanks received
    65
    Rep Power
    30
    Change this:
    Code:
     query("INSERT INTO `skills` (`playerName`,`Attacklvl`,`Attackxp`,`Defencelvl`,`Defencexp`,`Strengthlvl`,`Strengthxp`,`Hitpointslvl`,`Hitpointsxp`,`Rangelvl`,`Rangexp`,`Prayerlvl`,`Prayerxp`,`Magiclvl`,`Magicxp`,`Cookinglvl`,`Cookingxp`,`Woodcuttinglvl`,`Woodcuttingxp`,`Fletchinglvl`,`Fletchingxp`,`Fishinglvl`,`Fishingxp`,`Firemakinglvl`,`Firemakingxp`,`Craftinglvl`,`Craftingxp`,`Smithinglvl`,`Smithingxp`,`Mininglvl`,`Miningxp`,`Herblorelvl`,`Herblorexp`,`Agilitylvl`,`Agilityxp`,`Thievinglvl`,`Thievingxp`,`Slayerlvl`,`Slayerxp`,`Farminglvl`,`Farmingxp`,`Runecraftlvl`,`Runecraftxp`,`Hunterlvl`,`Hunterxp`,Summoninglvl`,`Summoningxp`)
    To this:

    Code:
     query("INSERT INTO `skills` (`playerName`,`Attacklvl`,`Attackxp`,`Defencelvl`,`Defencexp`,`Strengthlvl`,`Strengthxp`,`Hitpointslvl`,`Hitpointsxp`,`Rangelvl`,`Rangexp`,`Prayerlvl`,`Prayerxp`,`Magiclvl`,`Magicxp`,`Cookinglvl`,`Cookingxp`,`Woodcuttinglvl`,`Woodcuttingxp`,`Fletchinglvl`,`Fletchingxp`,`Fishinglvl`,`Fishingxp`,`Firemakinglvl`,`Firemakingxp`,`Craftinglvl`,`Craftingxp`,`Smithinglvl`,`Smithingxp`,`Mininglvl`,`Miningxp`,`Herblorelvl`,`Herblorexp`,`Agilitylvl`,`Agilityxp`,`Thievinglvl`,`Thievingxp`,`Slayerlvl`,`Slayerxp`,`Farminglvl`,`Farmingxp`,`Runecraftlvl`,`Runecraftxp`,`Hunterlvl`,`Hunterxp`, `Summoninglvl`,`Summoningxp`)
    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

Similar Threads

  1. [PI] amAdding hitmarks will thank + rep
    By AddictivePkz in forum Help
    Replies: 1
    Last Post: 09-15-2012, 01:53 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. 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
  •