,Summoninglvl` needs to be ,`Summoninglvl`
|
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.
,Summoninglvl` needs to be ,`Summoninglvl`
Change this:
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`)
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`)
« Previous Thread | Next Thread » |
Thread Information |
Users Browsing this ThreadThere are currently 1 users browsing this thread. (0 members and 1 guests) |