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
    Thanks given
    Thanks received
    Rep Power
    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.

    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(
    	at com.mysql.jdbc.Util.getInstance(
    	at com.mysql.jdbc.SQLError.createSQLException(
    	at com.mysql.jdbc.SQLError.createSQLException(
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(
    	at com.mysql.jdbc.MysqlIO.sendCommand(
    	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
    	at com.mysql.jdbc.ConnectionImpl.execSQL(
    	at com.mysql.jdbc.PreparedStatement.executeInternal(
    	at com.mysql.jdbc.PreparedStatement.execute(
    	at 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
    Thanks given
    Thanks received
    Rep Power
    How is your code at, 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  

    Join Date
    Nov 2017
    Thanks given
    Thanks received
    Rep Power
    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)

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