Sunday, October 3, 2010

sqlite databases (.db files) delete after iPhone restarts

For those experiencing issues with databases such as addressbook or sms database being reset, deleted or otherwise modified after making a change to it, is due to the rejection of the database. This is usually caused after a user replaces the database from a back or other Chaim file, usually during a 'rollback' of an operating system on the iPhone. The system actively rejects te database as corrupt or unrecognizable due to changes made to the structure of the database by Apple, and thus the additional fields or metadata is incompatible with the current .app that controls such database. In turn, te system usually deletes and creates a new database during startup. You will usually see an apple logo and loader bar and circle appear flickering over the existing screen.

Solution:

You need to use a database program to access the intended sqlite file and compare the structure with the structure of a functional database, and make modifications to make the database structure match. Additionally, look for the metadata for the database itself, so that you can change the version number to that which is to work by default.

No comments:

Post a Comment