title: Android, SQL Database Failure 1 syntax error? Can't find what catlog is talking about
body: <blockquote>
    <p>Database - Failure 1 (near "text" : syntax error) on 0x25c768 when preparing...</p>
  </blockquote>
  
  <p>This is the error that shows up in LogCat when I try to run my app. I have the following code setting up the database: </p>
  
  <pre><code>private static final String DATABASE_NAME = "recipesDB";
  private static final String DATABASE_TABLE = "recipes";
  private static int DATABASE_VERSION = 1;
  
  public static final String KEY_NAME = "name";
  public static final String KEY_TYPE = "type";
  public static final String KEY_INGREDIENTS = "ingredients";
  public static final String KEY_NOTES = "notes";
  public static final String KEY_BOIL = "boil";
  public static final String KEY_PRIMARY = "primary";
  public static final String KEY_SECONDARY = "secondary";
  public static final String KEY_ROWID = "_id";
  private DatabaseHelper mDbHelper; // DatabaseHelper is an inner class extending SQLiteOpenHelper
  
  private SQLiteDatabase mDb;
  
  private static final String DATABASE_CREATE = 
      "create table " + DATABASE_TABLE + " ("
      + KEY_ROWID + " integer primary key autoincrement, "
      + KEY_INGREDIENTS + " text not null, "
      + KEY_NOTES + " text not null, "
      + KEY_BOIL + " text not null, "
      + KEY_PRIMARY + " text not null, "
      + KEY_SECONDARY + " text not null); ";
  
  private final Context cntx;
  
  public recipesDB(Context cnt){
      this.cntx = cnt;
  }
  </code></pre>
  
  <p>I'm pretty lost as to why I am getting this error since the code and syntax seem to be fine. I get a run-time error when I run the app on my phone and click on the button which opens up the activityList. There is more code not shown that opens up and catches a <code>SQLExpection</code> on <code>open()</code>, etc. </p>
  
  <p>Any suggestions?</p>