How to edit sms.db of 1.1.4?
My SMS.db has been corrupted by me trying to use SMSd on 1.1.3-firmware. Since then, one message that has been deleted is still marked as unread. So on every springboard reset, SMS icon shows one unread message.
I would like to fix this problem without losing all my saved messages. I already managed to open sms.db into various sqlite-editors, but whenever I try to delete the row containing the message or edit the value containing '1' unread in the specific group, I keep getting the same error "no such function: read". It doesn't matter which SQL-Program I use.
Does anybody know how to fix this or how to not only view but edit the sms.db file?