Yes you are correct. I changed the "PRAGMA journal_mode=DELETE" and it worked. Thanks
2011/9/27 Kostya Vasilyev <[email protected]> > Your database probably has WAL mode enabled (write-ahead logging). This is > a new (as of 3.7.0) transaction logging mode, which is not compatible with > earlier SQLite versions. > > You can check the mode by running "PRAGMA journal_mode". If the result is > WAL, disable it by using "PRAGMA journal_mode=DELETE" or "...=TRUNCATE" > before copying the database off to your device. > > -- Kostya > > 27.09.2011 23:55, ΠΑΣΧΑΛΗΣ ΠΛΙΑΧΑΣ пишет: > >> I created a sqlite database with sqlite manager firefox addon. I used this >> in my application on HTC legend updated to 2.2 version. It worked fine. >> The same database i used it with the same app on a new HTC Sensation >> Z710e. I opened and closed the database on this smartphone and after that i >> transfered the database on the HTC legend. When itried to open the database >> i got the error: 09-27 21:04:22.506: ERROR/AndroidRuntime(6807): >> java.lang.RuntimeException: Unable to start activity >> ComponentInfo{com.android.**MyApp/com.android.MyApp.MyApp}**: >> android.database.sqlite.**SQLiteDatabaseCorruptException**: database disk >> image is malformed: , while compiling: SELECT * FROM Tablename ORDER BY >> fieldname >> >> If i try to open the database back again with sqlite manager firefox addon >> i get no error. Does anybody know what is wrong? >> Thanks for help >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Android Developers" group. >> To post to this group, send email to android-developers@** >> googlegroups.com <[email protected]> >> To unsubscribe from this group, send email to >> android-developers+**[email protected]<android-developers%[email protected]> >> For more options, visit this group at >> http://groups.google.com/**group/android-developers?hl=en<http://groups.google.com/group/android-developers?hl=en> >> > > -- > Kostya Vasilyev > > -- > You received this message because you are subscribed to the Google > Groups "Android Developers" group. > To post to this group, send email to > android-developers@**googlegroups.com<[email protected]> > To unsubscribe from this group, send email to > android-developers+**[email protected]<android-developers%[email protected]> > For more options, visit this group at > http://groups.google.com/**group/android-developers?hl=en<http://groups.google.com/group/android-developers?hl=en> -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
