problem about sqlite database, no such table:

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

But the log.e show the information:

  • Logcat is often out of work
  • Radio group onclick event not firing, how do I tell which is selected?
  • Visual studio android emulator will not start fully
  • Swipe To Choose Android
  • Get WebView version number for lollipop?
  • How to get the ID of the clicked child view added dynamically to a LinearLayout?
  • 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?

    Related posts:

    Android animation does not repeat
    HTTP get with headers using RestTemplate
    Unable to find instrumentation target package:
    How to create an app widget with a configuration activity, and update it for the first time?
    Padding lost using <merge> tag with Custom Compound Component
    What does “Error receiving broadcast Intent {…}” mean?
  • how to calibrate the orientation sensor in android?
  • Android file chooser
  • How does density value calculate in android
  • Android : Getting “Cannot reload AVD list:” error at the time of execution
  • Honeycomb notifications - How to set largeIcon to the right size?
  • How to Migrate Twitter API from v1 to v1.1?
  • 6 Solutions collect form web for “problem about sqlite database, no such table:”

    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 :

    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.

    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:

    Some people have been able to solve the problem using the steps mentioned here. It seems to me that this problem exists on certain versions of Android 2.2. I have incorporated this change in my code, though I’m still looking for Beta testers with to see if it actually works.

    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.


    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.

    Android Babe is a Google Android Fan, All about Android Phones, Android Wear, Android Dev and Android Games Apps and so on.