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????
Francis
· 2 years ago
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.
the chap
· 2 years ago
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.
Paul Watson
· 2 years ago
Thanks "The Chap", that is an alternative solution. The problem is you loose any customisation you have made to your iPhone with that technique.
Peter
· 2 years ago
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 :)
peeInMyPantz
· 2 years ago
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
peeInMyPantz
· 2 years ago
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
David L
· 2 years ago
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!
Terence
· 2 years ago
Hi Peeinmypants,
Could you please explain how to use mobileTerminal ?
Thks.
efen
· 2 years ago
thanks francis, works great
Zee
· 2 years ago
what if I'm using windows how can i access the sms.db to run the sqlite
RICKY
· 1 year ago
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.!!
Ammar Ayed
· 1 year ago
what the effects if i remeove sms.db
The tantrik
· 1 year ago
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?
paulmwatson
· 1 year ago
I was running 1.0.2 at the time this happened Tantrik, seemed to work fine.
nickg
· 1 year ago
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
NECATI ILGUN
· 11 months ago
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,
All Comments
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.
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
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
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!
Could you please explain how to use mobileTerminal ?
Thks.
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.!!
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?