DISQUS

DISQUS Hello! Life is grand is using DISQUS, a powerful comment system, to manage its comments. Learn more.

Community Page

Jump to original thread »
Author

iPhone SMS woes

Started by paulmwatson · 10 months ago

Firstly; Don’t sign up for Zyb using your iPhone number. It sent me an SMS which crashes the iPhone SMS app. I cannot read any other SMS either, the iPhone SMS app. simply crashes everytime it starts up. Very annoying.

Now this solution isn’t for everyone but I found that I can SSH into the iPhone [...] ... Continue reading »

19 comments

  • The iPhone uses Linux?
  • It runs a version of OS X.
  • I tried this but When i open the sms.db file with notpad i can see all messages since i got the phone but when i open the sms.db file with the Sqlite browser i only see the one i got back when i restored the phone.. I want to be able to restore all of them... Any Ideas????
  • You can use the following command at command prompt to open the sms.db using the sqlite. Put the Sqlite.exe and sms.db in the same folder and then open the command prompt and go to the folder.

    after that consider now both the files are in C:\

    in cmd prompt go to C:\

    C:\sqlite3 sms.db

    and press enter

    then

    sqlite> select * from message;

    and press enter

    it will show all your messages.

    to delete the junk message. Look for the row number on the message list you got above after the select number and type this

    sqlite> delete from message where rowid=;

    thats all it will delete and it worked fine for me.

    Francis.
  • well yes i was reading your solution to the sms problem and found it hard to believe that this was the only way to fix my phone(it sounded to complicated, prob only a "computer geek" would do) so i took matters into my own hands. So pretty much i restored my phone using the old firmware 1.0.2 and pretty much went through the unlocking process again..There is no need for SQ lite files.. After the process was done my texting worked fine along with every other function on the phone...hope this helps.
  • Thanks "The Chap", that is an alternative solution. The problem is you loose any customisation you have made to your iPhone with that technique.
  • fixed it via stp download of sms.db from /Library/SMS on the iphone. then on the mac i edited the dB with Mesa SQLite. deleted the SMS entry with that caused the crash, then copied the sms.db file back to the iPhone without losing any other messages :)
  • i installed mobileTerminal and Erica's Utilities (contain sqlite3)
    this will allow me to enter into the terminal, run sqlite3 and remove the entry. useful if your iphone sms function crashes when you are out
  • i installed mobileTerminal and Erica's Utilities (contain sqlite3)
    this will allow me to enter into the terminal, run sqlite3 and remove the entry. useful if your iphone sms function crashes when you are out
  • Hi
    Could you explain in detail how to access mobileTerminal and run sqlite3 to delete the faulty smses?

    Would appreciate if you could point me in the right direction.

    Thank you!
  • Hi Peeinmypants,

    Could you please explain how to use mobileTerminal ?

    Thks.
  • thanks francis, works great
  • what if I'm using windows how can i access the sms.db to run the sqlite
  • hello.!
    im new to the iphone. i have installed nothing on it so far coz i havnt gotten any time off from work to really play with the iphone.. today i received a weired sms and my sms application has started crashing....im freaking out...i have a windows based laptop and i dont know wut to do and how to fix this problem. can anyone help me with this and please guide me step by step as to what i have to do to undo this problem.!!
  • what the effects if i remeove sms.db
  • Dear Paul,

    deleting the sms.db file works only for the 1.1.1 firmware iPhone. I'd try the same thing on my 1.0.2 iPhone and couldn't resolve the alphanumeric sms issue.

    Anyone with a solution to this problem?
  • I was running 1.0.2 at the time this happened Tantrik, seemed to work fine.
  • I just deleted SMS.db with mobile finder and now my SMS.app will open but when I send SMS it fails every time. Is there something I missed. Or what. I am pleased to be able to open SMS.app but was hoping to have a fully funtioning iPhone. Please advise
  • I HAVE IPHONE WITH VERSION 1.1.4 AND CANNOT OPEN SMS PAGE, WHEN I TRY TO OPEN, AFTER A WHILE IT RETURNS TO MAIN MENU PAGE,

Add New Comment

Returning? Login