title: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'Knight' in 'field list'
body: <p>I have no clue why this doesn't want to cooperate when the rest of the code using MySQL works perfectly, It's just when I try to set a string.</p>
  
  <p>The MySQLManager class:</p>
  
  <p><a href="http://pastebin.com/RWavasPh" rel="nofollow">http://pastebin.com/RWavasPh</a></p>
  
  <p>I do alter a table to add another column in:</p>
  
  <pre><code>try
  {
      McInfected.getMySQLManager().execute("ALTER TABLE McInfected ADD Rank VARCHAR(20);");
  }
  catch (SQLException e)
  {
  }
  </code></pre>
  
  <p>Then my RanksManager class(The one that gets an sets the ranks)</p>
  
  <p><a href="http://pastebin.com/T0nRKkv7" rel="nofollow">http://pastebin.com/T0nRKkv7</a></p>
  
  <p>Any help would be greatly appreciated as I am almost ready to throw my computer...</p>
  
  <p>I have tried to look at the other questions for an answer but I'm not really able to understand how to fix it in my instance, As far as I could tell it had to do with the access type, but I'm not to sure what to do to fix it...</p>
  
  <p>This is the error</p>
  
  <p><code>11:29:49 PM [WARNING] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'Knight' in 'field list'
  11:29:49 PM [WARNING]   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  11:29:49 PM [WARNING]   at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
  11:29:49 PM [WARNING]   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
  11:29:49 PM [WARNING]   at java.lang.reflect.Constructor.newInstance(Unknown Source)
  11:29:49 PM [WARNING]   at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
  11:29:49 PM [WARNING]   at com.mysql.jdbc.Util.getInstance(Util.java:382)
  11:29:50 PM [WARNING]   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
  11:29:50 PM [WARNING]   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
  11:29:50 PM [WARNING]   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
  11:29:50 PM [WARNING]   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
  11:29:50 PM [WARNING]   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
  11:29:50 PM [WARNING]   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
  11:29:50 PM [WARNING]   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
  11:29:50 PM [WARNING]   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
  11:29:50 PM [WARNING]   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
  11:29:50 PM [WARNING]   at com.bimmr.mcinfected.MySQL.MySQLManager.updateString(MySQLManager.java:338)
  11:29:50 PM [WARNING]   at me.bimmr.mcinfectedranks.Ranks.RankManager.setPlayersRank(RankManager.java:173)</code></p>