SQLiteException: no such table: (code 1)

Question

I'm attempting to execute an SQL Query via android - and I am currently unable to do so. I'm getting a fatal error and the application closes when attempting to perform a simple query which I have verified to be valid: SELECT * FROM TblMovie WHERE MovieYear = 1975

However - when I attempt to do so within my app:

MainActivity:

protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    dbhelper = new DBHelper(this);

    List<String> list = dbhelper.getData();

    TextView textView1 = (TextView) findViewById(R.id.textView1);
    TextView textView2 = (TextView) findViewById(R.id.textView2);


    textView1.setText(list.get(0));
    textView2.setText(list.get(1));

...

DBHelper:

 public List<String> getData() {  
     db = this.getReadableDatabase();  
     List<String> data = new ArrayList<String>();  
     Cursor c = db.rawQuery("SELECT * FROM TblMovie WHERE MovieYear = 1975", null);  
     while (c.moveToNext()) {  
         data.add(c.getString(0));  
         data.add(c.getString(1));



     }  
     c.close();  
     db.close();  
     return data;  
    }

Logcat:

05-19 10:24:59.983: E/AndroidRuntime(24736): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.app/com.example.app.MainActivity}: android.database.sqlite.SQLiteException: no such table: TblMovie (code 1): , while compiling: SELECT * FROM TblMovie WHERE MovieYear = 1975



http://pastebin.com/0mAD87jJ

Also - I have found this article as reference:

No such table: (code 1) while compiling: SELECT * FROM event

I have tried running it on my tablet instead of the emulator - still does not work. I also tried clearing data - that does not work either. I have the database in my assets folder so I'm unsure as to why it isn't working.

EDIT:

Why the downvote? I'm pretty sure this is a valid and not terribly written / documented / researched issue.

DB Screenshot:

https://i.stack.imgur.com/IwkDQ.png

check this question: http://stackoverflow.com/questions/513084/how-to-ship-an-android-application-with-a-database — samgak, May 19 '15 at 14:42
Yeah, that's a good suggest @AAnkit, and if it doesn't worked, POST your CREATE TABLE Query. — theapache64, May 19 '15 at 14:44
Show you CREATE TABLE code. It seems there is an error in that instruction. — Phantômaxx, May 19 '15 at 15:14
I uninstalled and reinstalled - still crashing. I am using a precreated database in my assets folder - I do not use CREATE TABLE code :) — Jackie Deezner, May 19 '15 at 15:20
So, simply there is no TblMovie table in your db: `no such table: TblMovie` — Phantômaxx, May 19 '15 at 15:56
use sqlite tool(in sdk/platform tools) to check tables and their structure in the database. — AAnkit, May 19 '15 at 17:12
I suspect the OpenHelper isn't pointing to the right database, then. Can you edit with the code from `onCreate()` inside your SQLiteOpenHelper class? — AdamMc331, May 29 '15 at 16:15

score 0 · Answer 1 · edited May 19 '15 at 16:19

0

Try this:

String sql ="SELECT * FROM TblMovie WHERE MovieYear=?";
Cursor c = db.rawQuery(sql, new String[]{ String.valueOf(1975) });

edited May 19 '15 at 16:19

Brian

14,610
7
35
43

answered May 19 '15 at 14:45

Robust

2,415
2
22
37

I tried it - it resulted in SQLiteException: no such table: TblMovie (code 1): , while compiling: SELECT * FROM TblMovie WHERE MovieYear=? – Jackie Deezner May 19 '15 at 15:08
oh, your table is not exist. – Robust May 19 '15 at 15:16
My table does exist... it is in a database in my assets folder – Jackie Deezner May 19 '15 at 15:21
ah, you have to copy this database to app before using it. You can't read database from assets folder via DatabaseHelper – Robust May 19 '15 at 15:26

score 0 · Answer 2 · answered May 19 '15 at 14:45

0

Do you have an onCreate function defined with a create script? the following tutorial from google explains this in detail: http://developer.android.com/guide/topics/data/data-storage.html#db