Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Fix an unread SMS count issue on jailbroken iPhones iOS devices
A few days ago my iPhone started reporting a bogus unread SMS message, and there was no way to get rid of it -- I tried to re-read all SMS (tedious task) to no avail. My iPhone (firmware 2.2) is jailbroken, so I was able to solve the problem in this manner. Open a terminal on the iPhone, either directly with the Terminal app or via ssh from another machine, then enter this command:
$ cd /private/var/mobile/Library/SMS
In this directory you will find the file sms.db; now perform the following commands:
$ sqlite3 sms.db
$ update msg_group set unread_count = 0;
$ .exit
$ reboot
Your iPhone will reboot and the unread SMS count will now be correct. Note: it is better if you sign off from your cellular network before you attempt these steps, in case a new SMS arrives while you are editing the database.
    •    
  • Currently 2.60 / 5
  • 1
  • 2
  • 3
  • 4
  • 5
  (5 votes cast)
 
[17,919 views]  

Fix an unread SMS count issue on jailbroken iPhones | 4 comments | Create New Account
Click here to return to the 'Fix an unread SMS count issue on jailbroken iPhones' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Anything for non-jailbroken phones ?
Authored by: Louije on Dec 20, '08 03:58:22AM

I've got the same problem, but my phone's not jailbroken. Anyone came up with a more artisanal fix? I'm sure erasing conversations would help, but I'd rather not have to resort to this extremity...



[ Reply to This | # ]
Anything for non-jailbroken phones ?
Authored by: ghay on Dec 20, '08 04:49:13AM

Isn't mobileterminal in the app store?



[ Reply to This | # ]
Anything for non-jailbroken phones ?
Authored by: bompi on Dec 22, '08 07:26:38AM

I'd be interested as well ;-)

I got the same issue about two months ago and it (miraculously) disappeared all by itself some days later, simply by receiving another SMS in the same conversation.

Unfortunately it came back and I still don't know how to get rid of it.
Jailbreaking the iPhone not being an option, of course.


---
Emmanuel Bompard

Paris, France



[ Reply to This | # ]
Fix an unread SMS count issue on jailbroken iPhones
Authored by: FLiPPP on Dec 20, '08 11:08:47AM

Hello.

The hint works flawless, but not to forget ppl need to install "sqlite3" from cydia first.

Ciao Ciao
FLiPPP



[ Reply to This | # ]