I've come to you guys for help after originally posting this question on the Apple StackExchange website (original question here). I didn't receive a solution there so I'm hoping to find some more experienced people here who might be able to help!
You can read the original question at the link, but the short version is as follows:
It looks like my friend's iPhone SMS database is corrupt ever since some time in September. All the messages suddenly vanished. I've used a tool to extract the messages from a recent iTunes backup but it can't see them either, and on closer inspection of the SQLite database found from the iTunes backup the message with the earliest timestamp is as follows:
For reference the table schema is:
This corresponds to Tue, 13 Sep 2011 09:57:52 GMT which is the earliest message that the phone can also see. I'm not sure how a NULL sender could occur and the database seems to contain no instances of this.
Is it likely that the messages still exist on the device and can be extracted?
Is it possible to restore them so that the device can read them again?
Does anybody know what could have caused this problem?
Note that there are no backups from before the issue occurred.
Thanks a lot for any responses!
You can read the original question at the link, but the short version is as follows:
It looks like my friend's iPhone SMS database is corrupt ever since some time in September. All the messages suddenly vanished. I've used a tool to extract the messages from a recent iTunes backup but it can't see them either, and on closer inspection of the SQLite database found from the iTunes backup the message with the earliest timestamp is as follows:
Code:
INSERT INTO "message" VALUES(2,NULL,1315907872,NULL,131,0,NULL,1,0,0,0,0,NULL,NULL,NULL,NULL,1);For reference the table schema is:
Code:
CREATE TABLE message (ROWID INTEGER PRIMARY KEY AUTOINCREMENT, address TEXT, date INTEGER, text TEXT, flags INTEGER, replace INTEGER, svc_center TEXT, group_id INTEGER, association_id INTEGER, height INTEGER, UIFlags INTEGER, version INTEGER, subject TEXT, country TEXT, headers BLOB, recipients BLOB, read INTEGER);This corresponds to Tue, 13 Sep 2011 09:57:52 GMT which is the earliest message that the phone can also see. I'm not sure how a NULL sender could occur and the database seems to contain no instances of this.
Is it likely that the messages still exist on the device and can be extracted?
Is it possible to restore them so that the device can read them again?
Does anybody know what could have caused this problem?
Note that there are no backups from before the issue occurred.
Thanks a lot for any responses!