Thread: KingFox Highscores syntax error

Results 1 to 3 of 3
  1. #1 KingFox Highscores syntax error 
    Owner of Colossus-PS
    combatx's Avatar
    Join Date
    Mar 2013
    Posts
    80
    Thanks given
    3
    Thanks received
    5
    Discord
    TheFruitCake#8949
    Rep Power
    3
    Good morning all of rune-server! or afternoon,

    I've been having a couple of issues but i'm stuck on this last issue and i've googled it it comes up with stuff but i genuinely just dont understand it.

    error:
    Code:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'VALUES ('iron qw', 13, 1, 333, 913746, 228150, 102600, 287550, 207400, 0, 3446, ' at line 1
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    	at java.lang.reflect.Constructor.newInstance(Unknown Source)
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    	at com.mysql.jdbc.Util.getInstance(Util.java:381)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
    	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
    	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
    	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
    	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
    	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1365)
    	at ethos.Highscores.Highscores.run(Highscores.java:76)
    	at java.lang.Thread.run(Unknown Source)
    I've read the error, but i haven't got the slightest idea, on the fix

    All help would be appreciated!

    Many thanks, combatx
    Reply With Quote  
     

  2. #2  
    Registered Member
    arch337's Avatar
    Join Date
    Sep 2008
    Posts
    2,712
    Thanks given
    170
    Thanks received
    285
    Discord
    Arch337#1337
    Rep Power
    631
    How is your code at Highscores.java, line 76?
    Cause there seems to be some issue with the values you are trying to put in to correspond to your rows.


    "A fail act is something you do regular, but a dumb act is something you can learn from"
    Spoiler for Problem?:
    Reply With Quote  
     

  3. #3  
    Banned

    Join Date
    Nov 2017
    Posts
    46
    Thanks given
    46
    Thanks received
    44
    Rep Power
    0
    Post the whole SQL query, please.
    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. HighScores - Logout Error
    By Kduffy45 in forum Help
    Replies: 1
    Last Post: 02-06-2011, 04:46 AM
  2. Replies: 6
    Last Post: 09-15-2010, 04:20 PM
  3. Replies: 1
    Last Post: 07-19-2010, 09:48 PM
  4. Highscore Logout Error!
    By Infexis in forum Help
    Replies: 3
    Last Post: 04-25-2010, 11:53 AM
  5. Highscores, Compile Error
    By Flamefire in forum Help
    Replies: 3
    Last Post: 01-07-2009, 03:52 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
  •