Tuesday, September 27, 2011

Re: [android-developers] Error opening sqlite database

Yes you are correct. I changed the "PRAGMA journal_mode=DELETE" and it worked.  
Thanks

2011/9/27 Kostya Vasilyev <kmansoft@gmail.com>
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
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
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
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
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 android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

No comments:

Post a Comment