I just sent you my test database I created on Cyogenmod and I cannot read it on a standard Android environment.
It could be that SQLite on Cyogenmod is compiled with different options turned on and it's causing the problem, but the reason is irrelevant. The bottom line is that I cannot move the database back to a non-Cyogenmod system. And as I also mentioned, just yesterday I had a user having the same issue trying to move from Gingerbread to Froyo, so I don't believe this is only an issue with CM vs. stock Android. On Aug 4, 9:44 am, Miguel Morales <[email protected]> wrote: > Also just ran a test creating the database using the latest version > and reading it using the older version with the same results. > > > > > > On Wed, Aug 3, 2011 at 6:43 PM, Miguel Morales <[email protected]> > wrote: > > I just compiled two versions of sqlite lite. > > 3.7.7.1 2011-06-28 17:39:05 af0d91adf497f5f36ec3813f04235a6e195a605f > > and 3.6.11 > > > Created a table called test.db using 3.6.11 and it worked just fine > > when reading the data using the latest version. > > If I can find a version for the source of the versions you tried I can > > try those out as well. > > > I suspect the error has to do with your funky file name. > > > On Wed, Aug 3, 2011 at 6:24 PM, Miguel Morales <[email protected]> > > wrote: > >> Your app should support older versions of the sdk without the user > >> having the revert to an old (outdated) version of your app. > >> If you are going to support older versions, you should do so by > >> keeping your latest versions backward-compatible. > >> However, sqlite should be fine for this job. > >> This sounds like some weird bug. > > >> Anyway, what's "My Book #4" ? > >> Is that the name of the file of your database? > > >> On Wed, Aug 3, 2011 at 6:16 PM, Zsolt Vasvari <[email protected]> wrote: > >>>> If you are going to make claims about widespread fragmentation, it is > >>>> up to you to provide proof in the form of a reproducible test case. > > >>>> If you don't want to take the time to supply such proof, that's fine, > >>>> but then please expect us to be dubious of your claims, until somebody > >>>> else supplies such a reproducible test case. > > >>> Fair enough. I created a database on SQLite 3.7.2 (Cyognemod) and > >>> tried loading it into V3.6.22. > > >>> This is the error I am getting: > > >>> sqlite3 "My Book #4" > >>> SQLite version 3.6.22 > >>> Enter ".help" for instructions > >>> Enter SQL statements terminated with a ";" > >>> sqlite> .tables > >>> .tables > >>> Error: database disk image is malformed > > >>> I am sending you the database in a private e-mail. > > >>>> -- > >>>> Mark Murphy (a Commons > >>>> Guy)http://commonsware.com|http://github.com/commonsguyhttp://commonsware.com/blog|http://twitter.com/commonsguy > > >>>> Android Training in NYC:http://marakana.com/training/android/ > > >>> -- > >>> 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 > > >> -- > >> ~ Jeremiah:9:23-24 > >> Android 2D > >> MMORPG:http://solrpg.com/, http://www.youtube.com/user/revoltingx > > > -- > > ~ Jeremiah:9:23-24 > > Android 2D MMORPG:http://solrpg.com/, http://www.youtube.com/user/revoltingx > > -- > ~ Jeremiah:9:23-24 > Android 2D MMORPG:http://solrpg.com/, http://www.youtube.com/user/revoltingx- > Hide quoted text - > > - Show quoted text - -- 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
