View Full Version : iPhone SMS problem (solved)
HiroMacamura 10-05-2007, 09:53 PM Dear PhilMUGers,
I've recently unlocked my iPhone and have been using it well over a week now, using SMART as my carrier. Just this afternoon, somebody sent me an SMS, I did not have the chance to see who it was, as it only showed an ASCII character, something like the form of a square, plus the letter p. I clicked on "Ignore", to view the message later.
A few minutes later, when I've wanted to read my SMSs, upon tapping the SMS icon, it loaded the app, then exited. I tried it again, but to no avail. Apparently, I'm thinking, that message with really screwed up characters messed with the SMS app. When SMS app tries to load the index of messages, it exits when it gets across that message(just guessing).
I'm running 1.0.2, all the other functions of the iPhone seem to work well, except for the SMS app.
My question is, is there any way I can view all those messages in my inbox without having to run the native SMS app? I just need to delete that mal-message for SMS app to load properly.
Yours,
Hiro
HiroMacamura 10-05-2007, 10:41 PM Dear PhilMUGers,
I've recently unlocked my iPhone and have been using it well over a week now, using SMART as my carrier. Just this afternoon, somebody sent me an SMS, I did not have the chance to see who it was, as it only showed an ASCII character, something like the form of a square, plus the letter p. I clicked on "Ignore", to view the message later.
A few minutes later, when I've wanted to read my SMSs, upon tapping the SMS icon, it loaded the app, then exited. I tried it again, but to no avail. Apparently, I'm thinking, that message with really screwed up characters messed with the SMS app. When SMS app tries to load the index of messages, it exits when it gets across that message(just guessing).
I'm running 1.0.2, all the other functions of the iPhone seem to work well, except for the SMS app.
My question is, is there any way I can view all those messages in my inbox without having to run the native SMS app? I just need to delete that mal-message for SMS app to load properly.
Yours,
Hiro
OK, this is fixed. Here's how I did it.
1. Retrieve your sms.db from your iPhone, this is located in /private/var/root/Library/SMS
2. Open sms.db on your notebook/desktop using sqlite. You may download the Mac version here - >http://c-command.com/tools/sqlite
3. Open your sms.db via commandline, sqlite3 sms.db
4. Type : select * from message ;
5. Command should show you all of the messages you currently have in your inbox.
6. In my case, this is what I saw:
1344|ȩp|963174693||0|0|
1345|ȩp|963173793||0|0|
1346|ȩp|963172893||0|0|
1347|ȩp|963171993||0|0|
<rest of the messages in my inbox snipped out>
7. Type: delete from message where rowid=<rowid of screwed up message> ;
8. So , I did: delete from message where rowid=1344;
9. I did that for messages with rowids 1344-1347
10. Upload sms.db to where it was, /private/var/root/Library/SMS
11. Press sleep/wake button, then you should be able to access your inbox again.
Hope this helps :)
Ranma 10-05-2007, 10:46 PM Nice job! Kaito would be proud. :)
HiroMacamura 10-05-2007, 10:57 PM Hi,
Who's Kaito? Pardon my ignorance. :)
Ranma 10-05-2007, 11:08 PM Errr.. this would really be off topic though.. Kaito.. Hiro's father.
HiroMacamura 10-05-2007, 11:13 PM Oh, heh. Wasn't paying much attention to the other character's names. :p
Ranma 10-05-2007, 11:46 PM I think the troubleshooting steps you did though would be a good procedure to include in the iPhone FAQs in case someone else encounters a corrupted message that broke the SMS function.
sweetangel 10-06-2007, 02:30 PM hi there, would just like to ask if any have experienced my problem, i received an sms but when i tried opening it, clicking the SMS button in the home page, the sms opens up but is blank, then it goes to the home page automaticall, i tried creating a text message by going to the contacts then text message but i encountered the same error, it goes to sms page (blank) and back to home again :( i can receive txt messages but can view them..help please.. thanks
HiroMacamura 10-06-2007, 05:45 PM Hi sweetangel, you may try my fix above :)
elbert 10-06-2007, 06:17 PM Glad you worked it out. The simple explanation to this problem is that the message database got corrupt by that single message. You were able to identify that particular message and deleted it from the database.
It's also possible to fix this problem by deleting the entire db file, but that would mean losing all other saved SMS conversations as well.
HiroMacamura 10-06-2007, 06:52 PM Hi Elbert,
Youre right. In fact, I was almost on the verge of deleting my sms.db, but I had 22 unread SMSs in there which were actually important. :)
penmanila 10-06-2007, 09:23 PM so presuming we do want to wipe out our messages database instead of tediously deleting each individual conversation, deleting sms.db will do it safely?
It's also possible to fix this problem by deleting the entire db file, but that would mean losing all other saved SMS conversations as well.
itnetad 10-06-2007, 10:46 PM Hello everyone i only have this problem with SMART i can received calls but can't make outgoing calls it says "Your number cannot be completed as dialled check.... etc." i even tried changing combinations for example 0919-0000000 to +63919-0000000 still no go. I can receive and send messages through SMS but balance inquiry no go. Thanks
DON2003 10-06-2007, 11:02 PM Hello everyone i only have this problem with SMART i can received calls but can't make outgoing calls it says "Your number cannot be completed as dialled check.... etc." i even tried changing combinations for example 0919-0000000 to +63919-0000000 still no go. I can receive and send messages through SMS but balance inquiry no go. Thanks
try change it to a globe sim and see if error was fixed, but smart has some problem these 2 days, sms came in after more than 6 hours, and lots of drop calls, am in Binondo area.
post what happen, hope its the smart network problem and not your iPhone, good luck
itnetad 10-06-2007, 11:20 PM try change it to a globe sim and see if error was fixed, but smart has some problem these 2 days, sms came in after more than 6 hours, and lots of drop calls, am in Binondo area.
post what happen, hope its the smart network problem and not your iPhone, good luck
No problems with GLOBE just had this issue with SMART, but when i tried using another phone works fine i can call any number
HiroMacamura 10-07-2007, 09:15 AM so presuming we do want to wipe out our messages database instead of tediously deleting each individual conversation, deleting sms.db will do it safely?
Hi penmanila,
Not so sure if SMS.app will regenerate an sms.db if it can't find that file in the directory where it expects it to be. A safe solution though would be opening sms.db with sqlite then a little SQL: delete from message;
:)
penmanila 10-07-2007, 12:00 PM thanks, hiro--there's really only one way to find out, so i fugu'd into the sms.db file, backed it up, deleted it, then disconnected. my SMS box was clear. i tried to send an SMS message out, but couldn't; the app (not the phone) hanged. so i repeated the process, restored the SMS.db file to check that you could do that if you had to (it was OK), deleted it again, and this time i rebooted the iphone, and sent an SMS msg out, and it went out OK. am now waiting for an incoming text to confirm that all is ok both ways.
Hi penmanila,
Not so sure if SMS.app will regenerate an sms.db if it can't find that file in the directory where it expects it to be. A safe solution though would be opening sms.db with sqlite then a little SQL: delete from message;
:)
elbert 10-07-2007, 12:00 PM If you delete the SMS db, a new one will be created by the SMS app.
HiroMacamura 10-07-2007, 12:16 PM thanks, hiro--there's really only one way to find out, so i fugu'd into the sms.db file, backed it up, deleted it, then disconnected. my SMS box was clear. i tried to send an SMS message out, but couldn't; the app (not the phone) hanged. so i repeated the process, restored the SMS.db file to check that you could do that if you had to (it was OK), deleted it again, and this time i rebooted the iphone, and sent an SMS msg out, and it went out OK. am now waiting for an incoming text to confirm that all is ok both ways.
Thanks for the information as well penmanila.
Elbert, thanks din.
elbert 10-07-2007, 12:32 PM After you delete the SMS.db file, you should reboot the phone. I've tried it and it's the only way I found to hard erase SMS history in one go.
I read somewhere that when you clear conversations and delete messages using the SMS.app, the DB still stores those old messages but doesn't allow you to display them. I don't understand that logic.
Apple should just rewrite the SMS.app to include a way to delete all, or purge messages using age as parameters (i.e. delete all messages older than 1 week). Most of the guys at Apple (Jobs included), were using Treos before the iPhone. You would think that they would find a way to better the Treo's SMS implementation (which to this day I feel is the best SMS application out there). C'mon Apple, mind us field testers and fix that SMS app already! Please please please include group sending, forwarding, vCard, templates and copy and paste functions!
HiroMacamura 10-07-2007, 02:30 PM Would anybody on the list know if those features come with the recent 1.1.1 update for the iPhone? :)
..then hackers would have to work double time to crack 1.1.1 if those features _do_ come with the recent update.
:)
josecarlo1129 10-07-2007, 02:59 PM The said aspired sms features still lacks on the recent firmware release.
joemoso 10-07-2007, 08:06 PM Where can I find the Sms.db file? and can I delete it through finder.app? or do I have to use winSCP or fugu
HiroMacamura 10-07-2007, 08:29 PM Where can I find the Sms.db file? and can I delete it through finder.app? or do I have to use winSCP or fugu
Hello joemoso,
It's in /private/var/root/Library/SMS :)
sweetangel 10-09-2007, 08:54 AM thanks hiro, but my problem..i dont know how to execute your procedures :) ... but ill show it to the guy who unlocked my phone and give you feedback how it goes.. thanks :)
kameron4 10-09-2007, 09:24 AM Where can I find the Sms.db file? and can I delete it through finder.app? or do I have to use winSCP or fugu
yes you can use finder.app to delete it and in case there's a particular sms message you want to save you can move or rename the file using the same application without deleting it.
J5000 10-09-2007, 05:46 PM Hi. Just expereinced what happened to HiroMacamura re:SMS. Would like to try the fix that was posted but I'm using a Windows OS (Vista). Is there an sqlite for Windows? Can I use this with my iPhone?
Anybody knows where these text message of a p and a square comes from? Can it be avoided in the future?
Thanks.
randytamayo 10-09-2007, 06:54 PM 1344|ȩp|963174693||0|0|
1345|ȩp|963173793||0|0|
1346|ȩp|963172893||0|0|
1347|ȩp|963171993||0|0|
Is ȩp the screwed up message? Is it the same for all the screwed up messages?
I think you can go:
DELETE FROM message WHERE <column_name_of_ȩp> LIKE '%ȩp%';
J5000 10-09-2007, 07:19 PM In the fix that was posted by Hiro, the first step was to retrieve the sms.db from the iPhone.
How do I do this? Is there an app I need to do this?
Thanks.
HiroMacamura 10-09-2007, 09:51 PM In the fix that was posted by Hiro, the first step was to retrieve the sms.db from the iPhone.
How do I do this? Is there an app I need to do this?
Thanks.
Hi there.
You'll need software like CyberDuck to connect to your iPhone via sftp. Or, you can scp via the terminal from your Mac. :)
HiroMacamura 10-09-2007, 09:52 PM 1344|ȩp|963174693||0|0|
1345|ȩp|963173793||0|0|
1346|ȩp|963172893||0|0|
1347|ȩp|963171993||0|0|
Is ȩp the screwed up message? Is it the same for all the screwed up messages?
I think you can go:
DELETE FROM message WHERE <column_name_of_ȩp> LIKE '%ȩp%';
Hello there randy,
Yes that's that screwed up message alright. In fact, I received that again today.
J5000 10-09-2007, 11:04 PM Hi Hero,
Thanks for the reply. However, is there a CyberDuck for Windows? I'm using Windows Vista OS.
Will WinSCP do it the trick?
Regards
gang_armani 10-09-2007, 11:29 PM hi Hiro,
new mac user here please assist how do i open sms.db using sqlite.thanks
randytamayo 10-09-2007, 11:38 PM Hi clemente,
Try here: http://www.sqlite.org/sqlite.html or here: http://www.sqlite.org/docs.html
Hello there randy,
Yes that's that screwed up message alright. In fact, I received that again today.
2 of my friends got sms with the same content and it screwed up the sms app of their iphone.
deleting the sms.db will do the trick.
thanks Hiro for the tip!
HiroMacamura 10-10-2007, 01:00 AM 2 of my friends got sms with the same content and it screwed up the sms app of their iphone.
deleting the sms.db will do the trick.
thanks Hiro for the tip!
Hi there,
Deleting the sms.db will not only do the trick, it will also render you a blank inbox :)
You might want to do the sqlite trick if you have unread messages in your inbox, and if youre sure that there aren't any, then deleting sms.db should be ok. :)
HiroMacamura 10-10-2007, 01:10 AM Hi Hero,
Thanks for the reply. However, is there a CyberDuck for Windows? I'm using Windows Vista OS.
Will WinSCP do it the trick?
Regards
Use the latest version of FileZilla as it supports sftp already. WinSCP should also work just fine. :)
J5000 10-10-2007, 12:43 PM Hi Hiro,
Thanks for the suggestion of using FileZilla. I can't seem to get WinSCP to work. By the way, is it necessary for my laptop and my phone to be logged on to a wireless network? Or can I just use connect to our network using the regular network cable and just plug in my iPhone to my laptop thru the USB?
Also, where can I find the port setting being used by my iPhone?
I'm beginning to be desperate here. Haven;t been able to use my SMS for two dasy now.
edvelarde 10-10-2007, 11:45 PM From Hackintosh
GUIDE: SMS Backup, Single SMS Delete, Possible Crash Fix + Create Storing Thread
This Windows guide is designed to help people achieve the following:
1) backup their SMS's
2) delete a single SMS
3) possibly fix SMS application keep crashingIt may fix the crashing by investigating the sms.db file then editing it slightly to fix. Worth a try before deleting your whole SMS.db file!
Software you'll need:
- iBrickr (i'm using v0.8)
- SQLite Administrator (free GUI software - http://sqliteadmin.orbmu2k.de/) (http://sqliteadmin.orbmu2k.de/))STEP 1 - BACKUP SMS's ON COMPUTER
1) dock your iPhone with the computer
2) open iBrickr
3) click on 'Files'
4) in the phone on the right click on 'var', then 'root', then 'Library', then 'SMS'
5) click on 'sms.db'
6) click on 'Download'A copy of this SMS database file will now be in your iBricker directory.
Note: Incase you need to revert back to this file later make a second copy somewhere else and rename it (ie. sms_backup_todaysdate.db).
STEP 2 - DELETE / EDIT SINGLE SMS
1) download and unzip SQLite Administrator
2) you do not need to install, just enter the directory and run 'sqliteadmin.exe'
3) click 'Database' then 'Open' (or Cltr+O)
4) navigate to your 'sms.db' file and click 'Open'
5) on the right panel click on 'Edit Data'
6) click on 'Table' and select 'message'
- A complete list of your messages will now be displayed
7) scroll down the list and find the message you want to Edit or DeleteTo EDIT a message
Double click on the actual message under the 'text' heading.
A text box will then appear with the message. Just edit and click the tick or click the cross to cancel.
To DELETE a message
Click the desired ROWID number for the message you wish to delete then click the delete button (looks like a minus sign just below the 'Edit Data' tab).
Caution - Ensure you have the correct message highlighted as there is no 'Are you sure you wish to delete' popups. Although, it shouldn't really matter as you should have made a second sms.db back up file it you followed Step 1.
8) once finished making changes click 'Database' then 'Close' (or Clrl+W)
STEP 3 - UPLOAD THE UPDATED SMS.DB FILE
1) dock your iPhone with the computer
2) open iBrickr
3) click on 'Files'
4) in the phone on the right click on 'var', then 'root', then 'Library', then 'SMS'
5) click on 'sms.db'
6) click on 'Delete' then on 'OK' - to delete the current 'sms.db' file.
7) click on 'Upload file(s)'
8) navigate to your new 'sms.db' file
- the file must be named 'sms.db' and all lowercaseFINISHED - Open SMS and you should see the changes!
Always remember to backup so that you can just put the same file back if things go wrong.
FINAL NOTE ON ADDING SMS's: You could also add SMS's to the sms.db file using this program but be careful if you try to do this. There is a sqlite_sequence system table which contains the ROWID number for the next message. If you create a SMS with a ROWID number higher than any other ROWID number you will probably want to update this table as well otherwise you could run into problems later. I have successfully added a text message with a lower ROWID number without problems though.
Hope this helps - it's probably the simplest process at the moment.
UPDATE: CREATE STORING THREAD
Let's say you have friends that send you Jokes via SMS and you want to store these in a 'Jokes' thread, or your Girlfriend / Wife sends you nice messages and you want to store these separately http://www.hackint0sh.org/forum/images/smilies/wink.gif
1) Follow the steps in STEP 2 to open the 'sms.db' file in SQLite Administrator until you are looking at all your messages
2) Find the message you want to move into a new thread
3) Edit the value in the 'address' column
- Instead of the number just type 'Jokes' or 'Girlfriend Private' etc
4) Close database file
5) re-upload the 'sms.db' file (see STEP 3 above)
6) That's it! A new thread will appear in your SMS application and be labeled 'Jokes' or 'Girlfriend Private' etcFinal Comment: You can go one step further by alternating which side the message shows on by changing the value in Flag to '2' for left side or '3' for right side.
Worked fine for me - Let me know if you try it - always remember to backup first.
J5000 10-11-2007, 03:23 PM FINALLY got my SMS application up and running again after deleting the weird text message that I received which messed up the SMS app. :)
HiroMacamura, edvealrde and Hackintosh, THANK YOU so much for all the help and patience in answering my questions. :redface:
Regards.
sweetangel 10-11-2007, 09:55 PM hiro thanks for your guide, me and my friend have successfully fixed my sms problem :)
elbert 10-11-2007, 10:04 PM I learned that the iPhone is incompatible with flash messages, especially those from a sender with only 4-digits. The other day, I fixed a total of 5 iPhones with SMS problems. They were all Globe subs and they all experienced the problem at the same time. I suspect it had to do with a mass SMS promotion, something to do with an iPhone bidding promotion. Ironic, isn't it?
DarkCast 10-11-2007, 10:44 PM Strange. I've been receiving messages from Globe CP (Content Provider) numbers (the ones with 4 digits) without issue. Anyway, all of them are just alerts from 2007 (WAGI), 2327 (Citibank), 2977 (Globe Advisory), and 2350 (TAWAD).
Maybe it's the smart messages or ems that the iPhone cannot interpret properly (8-bit messages like ringtones and wbmp images, or WAP push messages).
Could someone confirm this?
elbert 10-12-2007, 04:06 PM here's the simplest way to resolve this SMS problem on the iPhone (negates the need for a computer)).
Take note that this solution will wipe out your SMS messages, but will quickly allow you to use the SMS application again.
- use Installer to install MobileFinder (it's under Productivity)
- launch Finder on the iPhone
- tap on the "~" button in the top right corner
- tap on Library, scroll down and tap on SMS, The sms.db file should appear and will be highlighted.
- tap on File in the bottom left corner
- tap on Delete in the bottom row
- click in the Home button to exit Finder
- reboot your iPhone
- tap on the SMS application to launch it.
You'll have a clean slate SMS application that now works.
elbert 10-12-2007, 04:11 PM Strange. I've been receiving messages from Globe CP (Content Provider) numbers (the ones with 4 digits) without issue. Anyway, all of them are just alerts from 2007 (WAGI), 2327 (Citibank), 2977 (Globe Advisory), and 2350 (TAWAD).
Maybe it's the smart messages or ems that the iPhone cannot interpret properly (7-bit messages like ringtones and wbmp images, or WAP push messages).
Could someone confirm this?
I'm talking about flash messages, the one that appears on your screen and normally can't be saved. I can't confirm this to be accurate, but it's what I'm suspecting. One thing's for sure, when it happens, it affects countless Globe iPhone users at the same time.
Another 6 people called me today about the same problem.
DarkCast 10-12-2007, 04:27 PM We may have to look into the DB entry. If weird characters are there, it's most probably an 8-bit message (a ringtone or a wbmp image). I'm not sure how the iPhone would behave when it receives smart messages (those with scripting included).
It's possible that the iPhones SMS system is very naive and does not implement a filter to just ignore messages it cannot parse.
jumpman23 10-12-2007, 05:08 PM Not everyone is techie. how do you open your sms.db?
benzng 10-12-2007, 05:11 PM this happened to my wife's globe phone. may text sya 4 messages unread and a corrupt sms.db. I dont understand sqlite so i tried winscp and i was able to connect to the sms.db.
when i opened it there is sqlite3 in there (i tried sqlite3 before this). I just deleted everything and when i disconnected to the iphone ok na sya but all the SMS were gone. My wife wasnt happy with the iphone. She removed Globe sim and installed SUN instead. =)
gene.go@mac.com 10-12-2007, 05:26 PM I experienced the exact same problem! Hiro thanks again for your fix but I am just about to try your solution.
benzng 10-12-2007, 05:37 PM btw, would this be true for those unlock by turbosim or say a legit At&t phone? I mean if this would happen in the US for regular subscribers of AT&T many would get pissed off. They have to learn how to hack the Iphone or maybe this is just an after effect of us hacking our iphones? just curious
elbert 10-12-2007, 06:42 PM I would presume that this is the case for any iPhone user, as the problem is an incompatibility in the SMS application. Unolocking, TurboSIM and the like have nothing to do with the SMS application.
benzng 10-12-2007, 08:39 PM i think i made a mistake in deleting sms.db, though it solve the problem but it removed all text messages as well. I manage to "access" sms.db file using WinSCP. Should I have downloaded the sms.db file to my PC and then use sqlite3 to edit it and upload again? Does this go for the same files like editing other .plist file from the iphone? appreciate the help guys. Thanks!
penmanila 10-12-2007, 09:00 PM in a word, yes. and always make a backup copy of sms.db first before tinkering with it ;)
i think i made a mistake in deleting sms.db, though it solve the problem but it removed all text messages as well. I manage to "access" sms.db file using WinSCP. Should I have downloaded the sms.db file to my PC and then use sqlite3 to edit it and upload again? Does this go for the same files like editing other .plist file from the iphone? appreciate the help guys. Thanks!
Help please :(
I had the same problem with the sms and figured it out with edvelarde`s (http://www.philmug.ph/forum/showthread.php?t=26522&page=4) guide. But
in sqlite i deleted all the sms. I didn`t made a backup for the initial sms.db .I uploaded it back to my iPhone but now i can-t send messages anymore( it remains on loading and nothing happens ) Could somebody upload on net a good sms.db file for me, or attach it on mail ? to put it in my iphone please...(my yahoo mail is: tz0ntz0n3L@yahoo.co.uk) Regards Ionut Biru
Lacry 10-16-2007, 08:15 AM Arrgh, I'm newbie here, would you kindly tell me,
How can I fix this SMS problem on Windows XP OS?
With MobileFinder? I didn't find it on the Internet...
Lacry 10-16-2007, 08:16 AM And, how can I reach the sms.vb file on the computer?
I cant see IPhone on my computer? Do I have to use special
program for it ?
lacry you need a program called "iBricker" . This will help you enter inside your iPhone.It-s a very nice program easy to use.
AND I DON`T NEED HELP ANYMORE THANKS . I didn`t know that if u delete the sms.db and you restart your iPhone it will generate a new functional one by itself :)
Lacry 10-16-2007, 08:49 AM I found an easier method...
Just go to '' Reset '' and ''Erase All Content and Settings''
Than resets Iphone... And SMS Screen has returned :)
mojako 10-16-2007, 02:19 PM is there a way you can send a text message to multiple receipients?
antski 10-16-2007, 02:42 PM i wish there was.. :)
benzng 10-16-2007, 06:20 PM I found an easier method...
Just go to '' Reset '' and ''Erase All Content and Settings''
Than resets Iphone... And SMS Screen has returned :)
did this erase your contact list, video or music files? just curious
elbert 10-16-2007, 06:56 PM Erase All Content and Settings will erase all media and data in the iPhone, bringing it back to an unused state. It does not, however, delete applications, even 3rd party ones.
J5000 11-09-2007, 10:56 PM I got again this weird text mesage which cause the SMS app to lock-up. This is the third time I got it in a months' time and it's really now becoming a pain in the neck. I really hope someone out there would finally find a permanent fix for this.
By the way, this time around, I just used elbert's method of using Finder and just totally erasing my sms.db instead of going thru the long and winded method of just erasing the the particular weird text message. Elbert's method worked fine for me.
josecarlo1129 11-09-2007, 11:59 PM There's a way on how to avoid those weird text messages that may corrupt and eventually lock your sms application. Try to install smsD via apptapp. You can erase a particular sms entry using this. I received one but managed to pull out without restoring my phone by simply using this so-called smsD.
hotslamdunk 11-13-2007, 07:19 PM hey ya , i'm new to this forum n also know that u guyz r pros but can u jus help me out with the same problem much more clearly and at the same time i have a windows n not a mac
ps help me out
thank ya
n thats a nice forum:o
Mr. Clean 11-13-2007, 11:27 PM here's the simplest way to resolve this SMS problem on the iPhone (negates the need for a computer)).
Take note that this solution will wipe out your SMS messages, but will quickly allow you to use the SMS application again.
- use Installer to install MobileFinder (it's under Productivity)
- launch Finder on the iPhone
- tap on the "~" button in the top right corner
- tap on Library, scroll down and tap on SMS, The sms.db file should appear and will be highlighted.
- tap on File in the bottom left corner
- tap on Delete in the bottom row
- click in the Home button to exit Finder
- reboot your iPhone
- tap on the SMS application to launch it.
You'll have a clean slate SMS application that now works.
sir, thanks, i encountered this sms problem earlier this afternoon and my search led me to this thread. Did this one and got my sms application working again. Thanks
hotslamdunk 11-15-2007, 11:50 PM but where can i find the mobilefinder n how do i hav to install it
iRgreen 11-15-2007, 11:53 PM U can get it on the installer app.
otikoy 11-17-2007, 11:18 PM I have aquestion? i accidentally deleted an impt sms. is their a way to retrieve it? need help in this.... very impt... thnks
jaytrixz 11-28-2007, 10:24 PM I'm using a Globe Autoload Retailer sim. When I'm checking my load wallet balance using the iPhone and Globe texts me, I receive a blank message but the iPhone recognizes the caller ID as "AutoloadMax". I'm using a 1.1.1 OTB. How can I fix this? Does the replies here answers my problem? When I'm using a Nokia phone, it doesn't also register any number but it displays that i came from "AutoloadMax" and it shows the contents of the text message.
antski 11-28-2007, 10:29 PM your only solution is to update your iphone to 1.1.2.
jaytrixz 11-28-2007, 11:51 PM Ok sir. I'll try updating mine. Thanks!
jaytrixz 11-29-2007, 12:16 AM I changed my mind. I'll try looking for other solutions first to my problem before upgrading it to 1.1.2. Any help aside from updating to 1.1.2 will be greatly appreciated.
hannibal 11-29-2007, 12:19 AM what made you change your mind? aside from the benefit of solving your problem, you'll also get a faster iPhone and slightly louder speaker volume. go for 1.1.2.
kameron4 11-29-2007, 12:34 AM your only solution is to update your iphone to 1.1.2.
or you can try this fix here (http://iphone.unlock.no/#SMS-problem).
jaytrixz 11-30-2007, 10:46 AM What are the other benefits of 1.1.2 aside from a louder speaker volume and the fix to my problem? Thanks!
jaytrixz 11-30-2007, 10:52 AM I'll try SMS Fix. Thanks for the tip kameron4.
jaytrixz 12-02-2007, 10:41 PM My problem was fixed by kameron4's tip! :) Thanks! Still running version 1.1.2.
jerichojanolo 12-03-2007, 09:56 PM My problem was fixed by kameron4's tip! :) Thanks! Still running version 1.1.2.
Hi. Just wanna clarify things. Did you upgrade your FW to 1.1.2? Or you're stiil at 1.0.2?
Thanks! :cool:
Jokwang2 12-03-2007, 10:05 PM Hi. Just wanna clarify things. Did you upgrade your FW to 1.1.2? Or you're stiil at 1.0.2?
Thanks! :cool:
Yes, me too is instered to know.
If this can be fixed without me updating the firmware (at least not yet) better.
TY
waltherp22 12-07-2007, 12:11 AM My nephew already upgraded my iphone to 1.1.2. But now I am having problems with my SMS. When i press the SMS button, blank ang page tapos bumabalik sa home. what do i do?
When i press recent calls in phone button it also returns to home. Thanks
leosolinap 12-07-2007, 12:55 AM @ waltherp22, go to install application install the iworld (tweak 1.1.2) , that will solve your problem.. thats the application that fixes the but from the 1.1.2 that was unlock by anysim..
waltherp22 12-07-2007, 01:34 AM thanks so much leosolinap. naayus ko na. i just used we tool to remove my old sms message and my recent call. everything is ok now.
waltherp22 12-07-2007, 09:46 AM ok na nagwork na when i placed iworld. thanks again leosolinap.
waltherp22 12-07-2007, 09:56 AM ngayon naman ayaw lumabas ng name na nagsend sa akin only their tel no.
courtside3 12-07-2007, 03:11 PM ngayon naman ayaw lumabas ng name na nagsend sa akin only their tel no.
Instead of running iWorld, sir waltherp22, you would have been better off replacing your AppSupport file with the one provided by sir DarkCast in his 1.1.2 Hacks folder. Apart from fixing the crashes that occur when you run the SMS and Phone apps, sir DarkCast's modified AppSupport file likewise allows for caller line identification even for calls emanating from landlines situated in provinces with four-digit area codes. :rolleyes:
waltherp22 12-07-2007, 06:00 PM i will try po. thank u po.
waltherp22 12-07-2007, 06:09 PM where ko po pwd makita yung kay sir DarkCast 1.1.2 Hack folder. sorry
courtside3 12-08-2007, 02:25 PM where ko po pwd makita yung kay sir DarkCast 1.1.2 Hack folder. sorry
You can download the folder from http://rapidshare.com/files/70177004/1.1.2_Hacks.zip. :rolleyes:
xerxes 12-09-2007, 02:55 AM Thank you very much to Hiro & edvelarde for the really big help. I was already becoming hopeless with the SMS feature of my iphone. When I woke up, I just saw 2 messages from a friend and 2 messages with sender name as "P" and the SMS could not be opened.:( I wasn't able to use my phone for a week and kept on researching and reading forums related to iphone, until I saw this philmug.ph forum!:D when I used sqlite admin, I noticed that the sender address or the number that triggered the problem was E@P and was sent twice? can this be something that was done intentionally to annoy hacked iphone users? Anyway, thanks again guys! I really owe you a lot! more power to you and philmug!;)
yertanian 12-10-2007, 09:35 PM @ waltherp22, go to install application install the iworld (tweak 1.1.2) , that will solve your problem.. thats the application that fixes the but from the 1.1.2 that was unlock by anysim..
HI,
would you axplain please where to find the iworld app and how to install the installer to the iphone (1.0.2)
iam totally new here and have the same sms problem.
regards,
Mano
spraederman 12-11-2007, 11:45 AM HI,
would you axplain please where to find the iworld app and how to install the installer to the iphone (1.0.2)
iam totally new here and have the same sms problem.
regards,
Mano
It's in the installer under Tweaks 1.1.2
chefjoy 12-11-2007, 07:18 PM i also have sms problem as waltherp22 had, but the only difference is im still on a 1.1.1 FW..is the iworld also a solution to it?
dummy 12-19-2007, 11:41 PM HELP!! I was also having the same problem with the SMS .. so I was trying to follow the solutions posted here.... the one with downloading finder, and going to the Library to Delete SMS.db.. but instead, I deleted MobileSMS.app from the applications library!!! does anyone know how I can restore this??? I already tried RESTORE ALL SETTINGS and ERASE CONTENTS AND SETTINGS.. nothing worked!! Though, I downloaded the SMSD from the Installer, I would still very much like to have the original application back!!!!! HELP HELP!!! :(
scardaoni 02-01-2008, 04:42 PM hi
I have a 1.1.2 OTB + stealth SIM and I can't send anymore sms (but I can receive sms)
I tried to edit the file sms.db through squlite but no way.
I also tried to delete the file sms.db and then let the phone creates a new one but no way; it seems the problem is in the stealth sim or somewhere else but there is not a corrupted sms.
Do you have an idea of what can I do?
thanks
doblezeta 02-01-2008, 05:40 PM hi
I have a 1.1.2 OTB + stealth SIM and I can't send anymore sms (but I can receive sms)
I tried to edit the file sms.db through squlite but no way.
I also tried to delete the file sms.db and then let the phone creates a new one but no way; it seems the problem is in the stealth sim or somewhere else but there is not a corrupted sms.
Do you have an idea of what can I do?
thanks
if you're on SMART, make sure your Settings-Phone-Show My Caller ID is set to ON.
jeyps11_c 02-09-2008, 08:33 PM Question...is iWorld a "regular" app in Installer or I have to create a new source.
If I need to create one what is the source that I need to add to get iWorld?
Thanks.
kenneth co 02-10-2008, 12:41 AM hi! just want to ask how could i transfer datas from my PC to my iPhone. would like to transfer contacts from microsoft outlook and some pictures from my PC folders. i'd appreciate it if anyone could help me. thanks in advance...
sibilly 02-11-2008, 01:37 PM You Have to sync them through iTunes....
hi! just want to ask how could i transfer datas from my PC to my iPhone. would like to transfer contacts from microsoft outlook and some pictures from my PC folders. i'd appreciate it if anyone could help me. thanks in advance...
fetch_status 02-20-2008, 03:32 PM How to use customize + customize addon to change my sms received tone?
xxnicoyxx 03-02-2008, 04:04 PM Hi there...
I browsed thru this thread because i was having the same problem with the sms feature of the iphone.
I tried to restore all the settings rendering the phone into "unused mode" as said by elbert, but after sending a message, the same problem came up. I am not able to view any of my messages and i am not able to look at my inbox. As i press the sms button i get redirected back to the home menu...
I am using Globe...
What should i do? should i install finder?
Thanks in advnance
elbert 03-02-2008, 04:43 PM What version is your iPhone on? The location of the database file has changed
In 1.1.4, the new location of the sms.db file is in /orivate/var/mobile/Library/SMS/.
I had a problem today and my SMS application would crash. I decided to just ditch my entire database and start from scratch. If you know how to SFTP into your iPhone, just navigate to that directory and drag the db file into a folder in your computer (just in case you have an important message in there that you may someday need).
xxnicoyxx 03-02-2008, 08:44 PM my iphone is version 1.1.2...
What would be the process of the solution you just said?
elbert 03-02-2008, 09:20 PM all you have to do is backtrack and read the previous posts in this thread. The answer to your question has already been posted.
japongs_17 03-02-2008, 11:16 PM hi question po... isms and smsd could not see the inbox message... but the default message inbox of the can... what may be the cause of the problem? the version is 1.1.2 upgraded to 1.1.4 and unlocked using ziphone thanks
xxnicoyxx 03-02-2008, 11:33 PM I will be doing that elbert, thanks....
By the way, if i will install Finder using the installer icon as you posted in one of the replys, will this solve my problem?
But i dont think that i recieved any message that would corrupt my sms database becoz all i did is send a message and after that i am not able to view my messages or even create an new message.
What do you think is the cause of this?
rspinzon 03-02-2008, 11:35 PM sa aken nagcracrash yung smsd at ismd wala maikitang txt at bulag
courtside3 03-03-2008, 09:13 AM hi question po... isms and smsd could not see the inbox message... but the default message inbox of the can... what may be the cause of the problem? the version is 1.1.2 upgraded to 1.1.4 and unlocked using ziphone thanks
Sir japongs_17, SMSD has a bug that restricts it from displaying messages via its "Inbox" in certain cases. However, you can use the "Conversations" feature of SMSD to view the Inbox messages exactly as the iPhone's native SMS app would display them. :rolleyes:
murmurr 03-03-2008, 07:25 PM hi Guys! i notice that my sms application seems too slow load, i have no problem with its just yake some time to load the messages. Any advice on how i can speed this this up..
also i have installed isms, how can i make this my default sms apps.?
elbert 03-03-2008, 08:13 PM hi Guys! i notice that my sms application seems too slow load, i have no problem with its just yake some time to load the messages. Any advice on how i can speed this this up..
also i have installed isms, how can i make this my default sms apps.?
Let me guess, you're on FW1.1.4, Yes, it's a problem that started with 1.1.3. It realy is slow, and it's the one thing that's driving me nuts with 1.1.4. I'm on the verge of downgrading to 1.1.2
josecarlo1129 03-03-2008, 08:42 PM my iphone is version 1.1.2...
What would be the process of the solution you just said?
Just install iWorld(form Installer app) and choose the country you're currently at. HTH
xxnicoyxx 03-03-2008, 09:54 PM @josecarlo1129
Hi there... in my application icon, i cannot find iWorld or even MobileFinder?
HOw will i be able to install these if it is not in my list?
How will i be able to add these installers int0 my list
Thanks
murmurr 03-03-2008, 10:40 PM Let me guess, you're on FW1.1.4, Yes, it's a problem that started with 1.1.3. It realy is slow, and it's the one thing that's driving me nuts with 1.1.4. I'm on the verge of downgrading to 1.1.2
Actually im still in 1.1.3fw, haven't found a way to speed it up... could it be that i do have a lot of SMS threads?
Simme 05-15-2008, 01:44 PM Firstly I like to thanks all for the efforts in solving the SMS folder opening problem. But all of them required some knowlegde about computer. How about the people that use the iphone as a usual phone user?! These things don't happen with NOKIA, SONY ERICSSON and other brands. And how about an user that doesn't have a PC or Mac in the moment that those problems happen?
Just wondering why Apple ignores the problem.
aikicodesurfer 05-25-2008, 06:13 PM what i'd like to see actually is if this problems occur on a LEGIT (ie. at&t activated) iphone, or does this just occur on unlocked iphones.
ms_chel 05-25-2008, 08:01 PM What version is your iPhone on? The location of the database file has changed
In 1.1.4, the new location of the sms.db file is in /orivate/var/mobile/Library/SMS/.
I had a problem today and my SMS application would crash. I decided to just ditch my entire database and start from scratch. If you know how to SFTP into your iPhone, just navigate to that directory and drag the db file into a folder in your computer (just in case you have an important message in there that you may someday need).
sir im also using 1.1.4 .. and my inbox kept on crashing this day. pardon the ignorance, i got this phone for my birthday just last may 20. I just want to ask, do i just delete the sms.db through iphone browser then it would generate a new one and everything would be fixed?
angelina 05-25-2008, 08:54 PM ms_chel, try to check your summerboard/smbprefs.. turn off dim wallpaper.. maybe that causes your sms to crash.
raynos13 05-27-2008, 08:37 PM hi..
just asking if you can surf the web using the GPRS ?
angelina 05-27-2008, 10:47 PM yes you can pero medyo may kamahalan..
hi..
just asking if you can surf the web using the GPRS ?
raynos13 05-29-2008, 03:59 PM ah.. okay... tanx
dummy 06-12-2008, 06:57 PM Hi!! can someone help me restore the sms icon on the main menu??!! i also had the same sms problem, so i explored all possible options to solve it (going in to the library and erasing sms.db) alas, i erased the sms icon from the screen... don't know how to get it back.....help help.. im temporarily using the SMSD, but i would like to have the original SMS back!!! help please!
mclovin 06-12-2008, 11:57 PM hi guys,
using 1.1.4 unlocked iphone.. since iv upgraded been having a problem with my sms
whenever im in the process of sending a message, and sometimes i also receive a message which i am sure of because it vibrates, however when i go back to the sms app. new message isnt there.
really havent received tons of messages because of this and its become such a hassle?
any of you guys experiencing the same problem? how do i fix this?
thanks!
batak 06-25-2008, 05:40 PM hello im having a problem with my incoming sms. i can send sms but i cannot receive any sms. im running on 102. any suggested fix on my dilemna? thanks.
Tuli$an 06-26-2008, 02:08 AM hi guys,
using 1.1.4 unlocked iphone.. since iv upgraded been having a problem with my sms
whenever im in the process of sending a message, and sometimes i also receive a message which i am sure of because it vibrates, however when i go back to the sms app. new message isnt there.
really havent received tons of messages because of this and its become such a hassle?
any of you guys experiencing the same problem? how do i fix this?
thanks!
have you by any chance installed iblacklist or mcleaner app in your iphone? It happened to me too and when I checked, mcleaner is blocking my messages by default lol
nostalgia 07-26-2008, 10:45 PM hi guys,
using 1.1.4 unlocked iphone.. since iv upgraded been having a problem with my sms
whenever im in the process of sending a message, and sometimes i also receive a message which i am sure of because it vibrates, however when i go back to the sms app. new message isnt there.
really havent received tons of messages because of this and its become such a hassle?
any of you guys experiencing the same problem? how do i fix this?
thanks!
I am experiencing the same problem. This has got to be the stupidest problem a phone could ever have!!! And this is NOT good for business!
Any fix available for this **** hole of a problem? Nakakagalit talaga -- makes me want to replace this iPhone for a Blackberry Bold
ipatluna 08-25-2008, 07:16 AM Sorry for this greenhorn post but I downloaded Cyberduck and Sqlite but I don't know how to go on from there to delete the SMS.db file. I kept trying to find the Iphone connection on Cyberduck but it always says connection failed. I first installed IBricker but apparently, that is only for Windows. Can anyone help?
The SMS application on the Iphone hung after only ONE day of use and am trying to fix it without having to go back to the Globe business office (where I doubt if anyone can help anyway except to replace the phone and I don't want to have to reload all my stuff to a new one).
Am also eager to install Wetool or iSMS, which would you guys recommend?
Polar Mac 08-25-2008, 08:51 AM since we're at the topic of iPhone SMS issues. Does anyone here receive the messages sent to them more than once? I'm based here in Australia, and when I text people back home I receive their reply (same message) at least 3x times. I'd assume they will just send it once, is it my carrier here or some glitch in the iPhone?
Do you guys experience that with your iPhone there?
courtside3 08-25-2008, 09:56 AM Sorry for this greenhorn post but I downloaded Cyberduck and Sqlite but I don't know how to go on from there to delete the SMS.db file. I kept trying to find the Iphone connection on Cyberduck but it always says connection failed. I first installed IBricker but apparently, that is only for Windows. Can anyone help?
The SMS application on the Iphone hung after only ONE day of use and am trying to fix it without having to go back to the Globe business office (where I doubt if anyone can help anyway except to replace the phone and I don't want to have to reload all my stuff to a new one).
Am also eager to install Wetool or iSMS, which would you guys recommend?
Does your iPhone have OpenSSH?
since we're at the topic of iPhone SMS issues. Does anyone here receive the messages sent to them more than once? I'm based here in Australia, and when I text people back home I receive their reply (same message) at least 3x times. I'd assume they will just send it once, is it my carrier here or some glitch in the iPhone?
Do you guys experience that with your iPhone there?
Nope. It could be a network glitch, before the era of the iPhone, there were already glitches like these, double or triple postings, sometimes you'll get the message - 'message failed' and so you'll send again when in fact your previous message was already sent. This led some users to accuse the telcos of 'robbing' them.
nostalgia 08-26-2008, 01:54 PM Nope. It could be a network glitch, before the era of the iPhone, there were already glitches like these, double or triple postings, sometimes you'll get the message - 'message failed' and so you'll send again when in fact your previous message was already sent. This led some users to accuse the telcos of 'robbing' them.
not a glitch. it can be an iphone problem. it happens to me. i seem to "receive" it three times but if i go back to the conversation only one message appears. the other two missing messages come from other people and i never get to read them.
ritzandrico 08-26-2008, 06:08 PM I need help. I cant seem to sync contacts from pc (workplace) to my iphone. iTunes and iPhone were updated this morning.
In the info tab I have:
1. Contacts : checked sync contacts with outlook
2. Calendars: sync calendars with outlook
then clicked apply. Not a single contact was transferred to the iPhone. After this process, the sync button appears but my choices are unticked.
I also tried ticking
3. Advanced : Contacts and Calendars
Same result. Please give me instructions.
courtside3 08-26-2008, 07:19 PM I need help. I cant seem to sync contacts from pc (workplace) to my iphone. iTunes and iPhone were updated this morning.
In the info tab I have:
1. Contacts : checked sync contacts with outlook
2. Calendars: sync calendars with outlook
then clicked apply. Not a single contact was transferred to the iPhone. After this process, the sync button appears but my choices are unticked.
I also tried ticking
3. Advanced : Contacts and Calendars
Same result. Please give me instructions.
Check out this link (http://support.apple.com/kb/HT1692). :)
ritzandrico 08-27-2008, 10:03 AM Thanks courtside3. I have done the first 2 suggestions, did not work. I will try the next recommended steps later. I will give a feedback later, I need to go back to work.
hi my native sms does not seem to mark messages as read even tough i read it alreay.. what should i do?
i used smsd as my default app and now i reverted to the native sms app, and this problem occured.. pls help..
gang_armani 09-16-2008, 09:41 AM guys i accdentally erased my sms which was very important, do you guys know where can I find the backup folder in finder? thanks and is it also possible to filter the backup and extract just the sms. thanks again.
grace-wong 12-03-2008, 09:49 AM From Hackintosh
FINAL NOTE ON ADDING SMS's: You could also add SMS's to the sms.db file using this program but be careful if you try to do this. There is a sqlite_sequence system table which contains the ROWID number for the next message. If you create a SMS with a ROWID number higher than any other ROWID number you will probably want to update this table as well otherwise you could run into problems later. I have successfully added a text message with a lower ROWID number without problems though.
Hope this helps - it's probably the simplest process at the moment.
Worked fine for me - Let me know if you try it - always remember to backup first.
Hi Hackintosh,
I'm hoping you can help me out here ... I followed your instructions for using sqliteadmin, and for the most part, I didn't have a problem with it ... however, I'm trying to merge two .db files together (from before and after a firmware upgrade-->downgrade ... long story, but suffice it to say, I'm left with two separate SMS .db files that I want to merge together), and trying to cut-and-paste 100 messages does *not* thrill me at all ... is there a way in sqliteadmin to do that ?? I've tried cutting and pasting, exporting and importing, and various and sundry other methods, and my head is spinning - and nothing's working, either ... I've also been trying to use SQLite Expert Professional, and I haven't had any luck with that either ... I should probably let you know that I know absolutely *nothing* about SQL or databases, so a lot of this is greek to me, I'm afraid. You do make mention above about adding, but I'm not having any luck doing it ... I must be doing *something* wrong, since you say it's possible, but I don't know what.
Any help you can provide would be greatly appreciated.
Thanks,
Grace
jaytrixz 12-03-2008, 07:04 PM i used smsd as my default app and now i reverted to the native sms app, and this problem occured.. pls help..
Try to receive a message from the default SMS.app and read the message. The pop-up should now be removed. This also happens to me when using BiteSMS or SMSD as a default app for texting. :)
philipe 01-23-2009, 09:56 PM hello there,i have problem with my iphone 3G and i hope you can help me out there guys.i bought my iphone 3G recently and updated to version 2.2 and i jailbroke it.at first,my WIFI shown an error and always stated "unable to join network" evrytime i tried to connect on my own router which was working with it previously.and after a week my SMS shown "error sending message" until now i cannot use my SMS and WIFI.hope you can help me guys.by the way,i restored it already many times.but still the problem occur..thanks in advance
philipe
Ejaxene 01-23-2009, 11:43 PM ^ Anything that has got to do with jailbreaking is not allowed here in PhilMUG.
philipe 01-25-2009, 12:28 PM so that means you cannot help me out there guys?
thanks a lot.
philipe 01-25-2009, 12:34 PM do you have any idea or suggestion if where can i consult with this kind of problem for my iphone?
viral_variance 01-25-2009, 02:20 PM www.applei.ph :)
philipe 01-25-2009, 02:47 PM okey maraming salamat sa tulong
recovery 12-18-2010, 01:53 AM Hello Everyone,
I I have a 3g Iphone I had ssh open and i accidentally deleted my sms.db file Not i can't send or receive messages. so i tired to restore my phone and now it's in DFU mode and I cant even turn it off please any help I would greatly appreciate I am running windows vista and i also tried redsn0w and blackra1n
Thanks
Eddie
mystavros 12-18-2010, 03:22 AM Use tinyumbrella
|