One bad thing happened to my phone just a few nights ago. Somehow due to receiving a malformed SMS, the conversations and call history database was corrupted. This prevented the Conversations windows from working. I could not access any of my previous messages & new messages were not stored anymore.
It was not pretty, but this is what I had to do to fix it. I first copied the database file out to my PC to back it up, the file is ~/.rtcom-eventlogger/el-v1.db
Then I deleted the file, ran touch to create a new empty one & rebooted.
This fixed the issue, however all the messages & call history was lost.
Fortunately it is possible to access the data inside the el-v1.db from a PC, because it's an SQLite database file. I used SQLite Database Browser to access the file & retrieved the imported stuff. They're all in the Event table.
It was a nightmare, I hope nobody else gets this problem.
Showing posts with label SQLite. Show all posts
Showing posts with label SQLite. Show all posts
Saturday, January 15, 2011
Subscribe to:
Posts (Atom)