SQLite android column not found

by

It looks like you have changed the table schema inside DBHandler#onCreate() after running the app at least once. If so you need to increment DB_VERSION = 2.

The database won’t check the code inside onCreate() for a new schema on it’s own, you need to tell the database to look for changes after you have made them. The easiest way to do this is by increasing the DB_VERSION.

More Related Contents:

  1. Android SQLite data display to ListView
  2. How can I avoid concurrency problems when using SQLite on Android?
  3. Android SQLite database: slow insertion
  4. Pros and Cons of SQLite and Shared Preferences [closed]
  5. Share SQLite database between 2 android apps?
  6. Android: upgrading DB version and adding new table
  7. How do I view the SQLite database on an Android device? [duplicate]
  8. Best way to work with dates in Android SQLite [closed]
  9. Android SQLite Example [closed]
  10. Android database encryption
  11. Best place to close database connection
  12. Cursor adapter and sqlite example [closed]
  13. How to add new Column to Android SQLite Database?
  14. How to retrieve data from sqlite database in android and display it in TextView
  15. What is a Full Android Database Helper class for an existing SQLite database? [closed]
  16. How do I create a database in android? [closed]
  17. How to save images into Database
  18. Android SimpleCursorAdapter doesn’t update when database changes
  19. Android SQLite Database, WHY drop table and recreate on upgrade
  20. SQLite simultaneous reading and writing
  21. How does one check if a table exists in an Android SQLite database?
  22. Create SQLite database in android
  23. Could not allocate CursorWindow
  24. android, how to exec a sql file in sqlitedatabase
  25. SQLiteOpenHelper – creating database on SD card
  26. How to store JSON object in SQLite database
  27. H2 Database vs SQLite on Android [closed]
  28. SQLiteOpenHelper onUpgrade() Confusion Android
  29. Using COLLATE in Android SQLite – Locales is ignored in LIKE statement
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment