title: Android SQLite Exception no such column
body: <p>I have a problem with my database in Android app. Here's some code:</p>
  
  <pre><code>private static final String QUESTIONS_TABLE = "questions";
  /* questions keys */
  public static final String KEY_ROWID = "_id";
  public static final String KEY_TYPE = "type";
  public static final String KEY_CONTENT = "content";
  public static final String KEY_A = "answerA";
  public static final String KEY_B = "answerB";
  public static final String KEY_C = "answerC";
  public static final String KEY_D = "answerD";
  
  private static final String QUESTIONS_TABLE_CREATE = 
      "create table "+ QUESTIONS_TABLE +" (" + KEY_ROWID + " integer primary key autoincrement, "
      + KEY_TYPE + "integer not null,"
      + KEY_CONTENT + " text not null, "
      + KEY_A + " text, "
      + KEY_B + "text, "
      + KEY_C + "text, "
      + KEY_D + "text); ";
  
  //--- QUESTIONS SECTION ---
  //--- inserts a close question ---
  public long insertCloseQuestion(int type, String content, String[] answers) {
      ContentValues initValues = new ContentValues();
      initValues.put(KEY_TYPE, type);
      initValues.put(KEY_CONTENT, content);
      if(answers != null &amp;&amp; answers.length &gt; 0) {
          initValues.put(KEY_A, answers[0]);
          initValues.put(KEY_B, answers[1]);
          initValues.put(KEY_C, answers[2]);
          initValues.put(KEY_D, answers[3]);
      }
      Log.d("VM", initValues.toString());
  
      return db.insertOrThrow(QUESTIONS_TABLE, null, initValues);
  }
  </code></pre>
  
  <p>When I call insertCloseQuestion method, Android returns an Exception:</p>
  
  <pre><code>android.database.sqlite.SQLiteException: table questions has no column named answerD: , while compiling: INSERT INTO questions(answerD, content, answerB, answerC, type, answerA) VALUES(?, ?, ?, ?, ?, ?);
  </code></pre>
  
  <p>Do you have any ideas how to fix it? I know there are is a couple of topics like this, but none of the solutions help me. </p>