problem about sqlite database, no such table:

Question

I open a sqlite database and use rawquery to get data.

But the log.e show the information:

android.database.sqlite.SQLiteException: no such table: types:

But, I really have this table.

And i also try to use the other sql ,But also get the error message such as

android.database.sqlite.SQLiteException: no such table: malls:

I am sure there are this two tables. So why get the error message?

hey there, what does the rawquery look like? are the table names "types:" and "malls:" ? — TheChange
– TheChange, Commented Feb 26, 2010 at 14:45
Actually, i already have a database file. So i just put it in the "assets" folder. And i crate a custom SQLiteOpenHelper to copy this file to path : /data/data/com.SGMalls/databases/mallMapv2.sqlite Then to use Sqlitedatabse.open(); to open this database and try to get data — user275788
– user275788, Commented Feb 26, 2010 at 15:00
The rawquery Cursor cursor=myDataBase.rawQuery(queryString, null); And i have test this queryString in Sqlitebrowser. It's ok. Can get the data — user275788
– user275788, Commented Feb 26, 2010 at 15:04
This database is large. So this is the problem? Because i write the custom SQLiteOpenHelper from "Using your own SQLite database in Android applications" reigndesign.com/blog/… So the copy file code may be can not copy the complete file. Yes? — user275788
– user275788, Commented Feb 26, 2010 at 15:15

CommonsWare · Accepted Answer · 2010-02-26 16:13:24Z

11

If this is on the emulator, use DDMS File Explorer or adb pull to download a copy of the database file and confirm its contents.

And i crate a custom SQLiteOpenHelper to copy this file to path : /data/data/com.SGMalls/databases/mallMapv2.sqlite

If you are attempting to copy the file in SQLiteOpenHelper's onCreate(), you are too late. I would do it before then.

So the copy file code may be can not copy the complete file.

It is more likely you would get an error about a corrupt file in that case.

answered Feb 26, 2010 at 16:13

CommonsWare

1.0m195 gold badges2.4k silver badges2.7k bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user275788 Over a year ago

OK. thanks very much. So. if i want to test this code in device. Also need paste the sqlite database in the device first? O...i need to read a tutorial carefully Thanks

user275788 Over a year ago

Hi.As you said: I use to ddms file explorer to pull the database file. And i find there are three floder : data,sdcared and system. So any one is ok? and the path of this file also is /data/data/com.SGMalls/databases/mallMapv2.sqlite? Thanks. Pls help me

Shashank Degloorkar Over a year ago

>>>>If you are attempting to copy the file in SQLiteOpenHelper's onCreate(), you are too late. I would do it before then.<<<<<< THAT WORKED FOR ME THANKS... +1

Ashwin Over a year ago

@CommonsWare : In my android phone there is not path like data/data. Can that be the reason "table not found error". Because data/data is not present in my phone, is not able to copy my database from the assets folder into data/data/com.myapp/databases. Is this the problem?

biegleux · Accepted Answer · 2012-09-29 19:43:56Z

2

I think this error occurs when you change the table structure. To solve this, clean the data (Settings -> Manage application -> Clear data) before installing the new application.

Regards.

edited Sep 29, 2012 at 19:43

biegleux

13.3k11 gold badges47 silver badges52 bronze badges

answered Aug 14, 2012 at 6:23

zacharia

1,0832 gold badges10 silver badges22 bronze badges

Comments

dev.serghini · Accepted Answer · 2013-05-10 18:15:16Z

2

If you have multiple contents providers, you might think that your table exists while it does not. In which case the error you are getting is legitimate.

Take a look here for details and solution: http://devserghini.blogspot.com/2010/11/android-sqliteopenhelper-and-multiple.html

edited May 10, 2013 at 18:15

answered Nov 5, 2010 at 23:02

dev.serghini

2,9791 gold badge19 silver badges8 bronze badges

Comments

j0k · Accepted Answer · 2012-10-03 07:24:23Z

1

SQLiteDatabase.execSQL() interpretation takes a single string sql, ending with ";". Two lines have not interpreted.

Creating tables in a few lines sql just not executed.

edited Oct 3, 2012 at 7:24

j0k

22.8k28 gold badges81 silver badges90 bronze badges

answered Oct 3, 2012 at 1:00

3DRaven

111 bronze badge

Collectives™ on Stack Overflow

problem about sqlite database, no such table:

4 Answers 4

4 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related