Databases
StackOverflow2013
Postsdbo
POno such table when i add a new table
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POno such table when i add a new table
    primarykey
    data
    text
    <p>i think function onUpgrade is not working becuase before i add a new table .it's not error. when i add category table (a new table) . i change database_version = 2 from 1 when i run emulator .log cat sue "No such table category" and i don't know how to modify it. please check and tell me why onUpgrade isn't work.</p> <p>This is my code (BookDBHelper)</p> <pre><code>import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteDatabase.CursorFactory; import android.database.sqlite.SQLiteOpenHelper; public class BooksDBHelper extends SQLiteOpenHelper { //databse_name public static String DATABSE_NAME = "bookguk"; // database_version protected static final int DATABASE_VERSION = 2; // &lt;&lt;&lt;---i have changed it to version 2 from version 1 when add a new table category //table name public static String TABLE_BOOK = "books"; public static String TABLE_IMAGE = "images"; public static String TABLE_INGREDIENT = "ingredients"; public static String TABLE_CATEGORY = "category"; //column_name public static String KEY_ID = "id"; public static String KEY_TITLE = "title"; public static String KEY_SOLUTION = "solution"; public static String KEY_BOK_ID = "bookID"; public static String KEY_fILEPATH = "filepath"; public static String KEY_VALUE = "value" ; public static String KEY_UNIT = "unit"; public static String KEY_NAME = "name"; public static String KEY_CAT_ID = "cat_id"; public static String BOOK_CREATE_SQL = "CREATE TABLE IF NOT EXISTS " + TABLE_BOOK + "(" + ""+KEY_ID+" INTEGER PRIMARY KEY AUTOINCREMENT," + ""+KEY_TITLE+" TEXT(50) not null," + ""+KEY_SOLUTION+" TEXT(255) not null," + ""+KEY_CAT_ID+" INTEGER(11)," + " FOREIGN KEY("+KEY_CAT_ID+") REFERENCE "+TABLE_CATEGORY+" ("+KEY_ID+"))"; public static String IMAGE_CREATE_SQL = "CREATE TABLE IF NOT EXISTS " + TABLE_IMAGE + "(" + ""+KEY_ID+" INTEGER PRIMARY KEY AUTOINCREMENT," + ""+KEY_fILEPATH+" VACHAR(255)," + ""+KEY_BOK_ID+" INTEGER(11)," + " FOREIGN KEY("+KEY_BOK_ID+") REFERENCES "+TABLE_BOOK+" ("+KEY_ID+"))"; public static String INGREDIENT_CREATE_SQL = "CREATE TABLE IF NOT EXISTS " + TABLE_INGREDIENT + "(" + ""+KEY_ID+" INTEGER PRIMARY KEY AUTOINCREMENT," + ""+KEY_VALUE+" DOUBLE(11)," + ""+KEY_UNIT+" VACHAR(50)," + ""+KEY_fILEPATH+" VACHAR(255)," + ""+KEY_BOK_ID+" INTEGER(11)," + " FOREIGN KEY("+KEY_BOK_ID+")REFERENCES "+TABLE_BOOK+" ("+KEY_ID+"))"; public static String CATEGORY_CREATE_SQL = "CREATE TABLE IF NOT EXISTS " + TABLE_CATEGORY + "(" + ""+KEY_ID+" INTEGER PRIMARY KEY AUTOINCREMENT," + ""+KEY_NAME+" VACHAR(50) " + ")"; //constructor public BooksDBHelper(Context context) { super(context, DATABSE_NAME, null, DATABASE_VERSION); // TODO Auto-generated constructor stub } //create @Override public void onCreate(SQLiteDatabase db) { db.execSQL(CATEGORY_CREATE_SQL); db.execSQL(BOOK_CREATE_SQL); db.execSQL(IMAGE_CREATE_SQL); db.execSQL(INGREDIENT_CREATE_SQL); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { // TODO Auto-generated method stub db.execSQL("DROP TABLE IF EXISTS " + TABLE_BOOK ); db.execSQL("DROP TABLE IF EXISTS " + TABLE_IMAGE ); db.execSQL("DROP TABLE IF EXISTS " + TABLE_INGREDIENT ); db.execSQL("DROP TABLE IF EXISTS " + TABLE_CATEGORY ); onCreate(db); } } </code></pre> <p><strong>This is my operator (insert data to table category)</strong></p> <pre><code>package com.example.mutitablesql.db; import java.util.ArrayList; import com.example.mutitablesql.entry.BookEntry; import com.example.mutitablesql.entry.CategoryEntry; import com.example.mutitablesql.entry.ImageEntry; import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; public class BooksDB { //นำ class booksDBHelper มาสร้างเป็น object private BooksDBHelper helper; private SQLiteDatabase db; //สร้าง constructor public BooksDB(Context context){ // คำสั่ง เรียก constructor ของclass BooksDBHelper helper = new BooksDBHelper(context); db = helper.getWritableDatabase(); } //insert into table category public long insertCategory(String name){ ContentValues values = new ContentValues(); values.put(BooksDBHelper.KEY_NAME, name); return db.insert(BooksDBHelper.TABLE_CATEGORY, null, values); } </code></pre> <p><strong>my mainactivity code</strong></p> <pre><code>protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); context = this; db = new BooksDB(context); db.insertCategory("ต้ม"); db.insertCategory("ผัด"); db.insertCategory("แกง"); db.insertCategory("ทอด"); db.insertCategory("ประเภทเส้น"); db.insertCategory("เครื่องดื่ม"); db.insertCategory("ของหวาน"); } </code></pre> <p><strong>this is my logcat edit</strong></p> <pre><code>09-02 09:47:29.869: E/SQLiteLog(1220): (1) near "REFERENCE": syntax error 09-02 09:47:29.889: D/AndroidRuntime(1220): Shutting down VM 09-02 09:47:29.889: W/dalvikvm(1220): threadid=1: thread exiting with uncaught exception (group=0x40a71930) 09-02 09:47:29.919: E/AndroidRuntime(1220): FATAL EXCEPTION: main 09-02 09:47:29.919: E/AndroidRuntime(1220): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.mutitablesql/com.example.mutitablesql.MainActivity}: android.database.sqlite.SQLiteException: near "REFERENCE": syntax error (code 1): , while compiling: CREATE TABLE IF NOT EXISTS books(id INTEGER PRIMARY KEY AUTOINCREMENT,title TEXT(50) not null,solution TEXT(255) not null,cat_id INTEGER(11), FOREIGN KEY(cat_id) REFERENCE category (id)) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.app.ActivityThread.access$600(ActivityThread.java:141) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.os.Handler.dispatchMessage(Handler.java:99) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.os.Looper.loop(Looper.java:137) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.app.ActivityThread.main(ActivityThread.java:5041) 09-02 09:47:29.919: E/AndroidRuntime(1220): at java.lang.reflect.Method.invokeNative(Native Method) 09-02 09:47:29.919: E/AndroidRuntime(1220): at java.lang.reflect.Method.invoke(Method.java:511) 09-02 09:47:29.919: E/AndroidRuntime(1220): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793) 09-02 09:47:29.919: E/AndroidRuntime(1220): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560) 09-02 09:47:29.919: E/AndroidRuntime(1220): at dalvik.system.NativeStart.main(Native Method) 09-02 09:47:29.919: E/AndroidRuntime(1220): Caused by: android.database.sqlite.SQLiteException: near "REFERENCE": syntax error (code 1): , while compiling: CREATE TABLE IF NOT EXISTS books(id INTEGER PRIMARY KEY AUTOINCREMENT,title TEXT(50) not null,solution TEXT(255) not null,cat_id INTEGER(11), FOREIGN KEY(cat_id) REFERENCE category (id)) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.database.sqlite.SQLiteProgram.&lt;init&gt;(SQLiteProgram.java:58) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.database.sqlite.SQLiteStatement.&lt;init&gt;(SQLiteStatement.java:31) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1663) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1594) 09-02 09:47:29.919: E/AndroidRuntime(1220): at com.example.mutitablesql.db.BooksDBHelper.onCreate(BooksDBHelper.java:67) 09-02 09:47:29.919: E/AndroidRuntime(1220): at com.example.mutitablesql.db.BooksDBHelper.onUpgrade(BooksDBHelper.java:82) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:257) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:164) 09-02 09:47:29.919: E/AndroidRuntime(1220): at com.example.mutitablesql.db.BooksDB.&lt;init&gt;(BooksDB.java:23) 09-02 09:47:29.919: E/AndroidRuntime(1220): at com.example.mutitablesql.MainActivity.onCreate(MainActivity.java:21) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.app.Activity.performCreate(Activity.java:5104) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080) 09-02 09:47:29.919: E/AndroidRuntime(1220): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144) 09-02 09:47:29.919: E/AndroidRuntime(1220): ... 11 more </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USuser2738443
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload