Android. SQLite Exception: no such column _id Android. SQLite Exception: no such column _id sqlite sqlite

Android. SQLite Exception: no such column _id


If you created database for example with fields 'a', 'b' and 'c' and used this db then if you add new field (for ex. 'd') you need to recreate database on phone (just delete it).


You probably don't have a column _id in your database table. Pull the database and open it with SqliteViewer to check if it actually exists. The database is usually under /data/data/com.yourapp.package/databases/

You can use:http://sqlitebrowser.sourceforge.net/orhttp://www.navicat.com/en/products/navicat_sqlite/sqlite_overview.html (they also have a free lite version)


Try rowid instead of _id. It works for me.