I've been having major SMS database problems following a backup and restore to my new phone. I can't delete messages or threads, Certain messages just won't restore, and some messages show as being received December 31, 1969. Also, sending and receiving are sporadic. These problems have persisted no matter what SMS program I use and no matter what program I use to back up from my old phone.
However, I think I can solve this problem and share my solution with the world. All my messages are in my db file, even the ones that wouldn't restore to my new phone, and the ones that show up as December 31, 1969.
My idea is to just delete all the records around the "problem date" (it seems to stall when restoring from July 31st, 2010 and stop there) as well as anything reading as 1969 and anything from short and unneeded threads, just for extra cleanup. My hope is that whatever is the source of the corruption will be gone, and the database will start to work properly again, adding and deleting records when requested.
But I will die of old age before I get this done with SQLite db editor. Not that there's anything wrong with the software. But I would just have way too many records to individually delete. If I could see this on a computer screen, and even sort, highlight multiple records, etc, I could have this done in under an hour. But excel doesn't read these files, and I don't know what else I could try. Any suggestions?