Discuss Weird SMS and Mobile SMS is gone at the General - Hackint0sh.org; Hi Folks...
Today I received a weird sms... I actually do not remember where it ...
Weird SMS and Mobile SMS is gone
Today I received a weird sms... I actually do not remember where it was from but the pop up was something like Iéx-a ... I really do not remember... I live in Turkey... I used Iphonesimfree to unlock and everytjhing was going flawless till I got this message... My only problem is that when I try to enter to my sms messages the app closes it self... Is there a way to reset the sms database or to edit to erase that specific message...
Well nevermind..... I found it myself... I deleted the sms.db and restarted everting got fixed...
where is the sms.bd?
i have faced the same problem twice, and i had to restore to get rid of it. however u say u deleted sms.db. how did u find it and how did u delete it? using mobile finder???? or ifuntastic, fugu,etc??
also did u loose all sms or just the one which created this mess? would be good to know, just so i dont have to go through the entire process again
Okay... now I have a better solution...
In my case I received a alphanumeric message and somehow my db got corrupted therefore mobilesms.app failed to display and closed itself... I went to /private/var/root/library/sms/ and before deleting sms.db (if you know how to handle db files back it up otherwise delete it but you will loose your sms texts but you will have a working app again) I copied it to my mac (through sftp).. After deleting the file you have to restart the iphone. and viola... SMS app works again... But you loose all your sms texts....
If you are capable of editing sqlite databases then you have the chance to restore your sms. What yo do is open your file with a db editor (in my case I used RazorSQL)
make a query -----
SELECT * from messages
suspect your message which corrupts your database and get its ROWID
then make an other query...
DEL from messages where ROWid = x (x will be the rowid of the stupid message)
ok now you are good to go.....
upload your sms.db to the same location by replacing... and restart your iphone...
Everything is now how it is supposed to be....
Ohhh sorry I forgot to answer your question... Yes you can ethir delete it with fugu or mobilefinder...
I opened the file with razorSQL but I can't seem to able enter to enter any SQL queries. How do I enter the queries?. I opened the file using File->Open(No Connection)->sms.db
Originally Posted by koraybirand
Use sqllitebrowser to open the sms.db file and then from the browse data tab open messages table select the corrupted message and delete that row by hitting the delete record button... then replace the original sms.db file with the edited one....
Thanks. I got it working already. The thing I was missing is that I had to select a connection to a sqllite DB first.
Had the same today and used the hint here to download sms.db, delete the record and reload sms.db. After reboot (hold home and start button until the apple appears) all is fine again.
If it helps, I could post the text and stuff i extracted (from that message)
How-to on a Mac:
On a Mac you can use MesaSQlite (freeware) to be found at http://www.mesamysql.com/?realmesa_home if you want to manipulate the table on the Mac.
1. Download the file /private/var/root/Library/SMS/sms.db with the SFTP of your choice from the iPhone to your Mac.
2. Start MesaSQlite on the Mac and open the sms.db file that sits on the desktop (of your Mac).
3. On the top left pulldown menu choose "Messages". In the pulldown below choose "text" and in the pulldown right from that choose "is non empty". Then hit "Search" and you will see all sms. aktivate the one you wanna kill and hit delete on the keyboard. Save.
4. Use your SFTP client to upload the file sms.db to exact the directory on the phone you downloaded it from and replace the one on the phone.
5. Reboot the iPhone (hold home and start button until the apple appears).
6. You will have all the sms you got but the corrupt one.
If you are on the go and dont have access to a Mac or PC do do so, there is a way BUT YOU LOOSE ALL SMS you got before.
You need to have a terminal installed on your iPhone, start it
Upper- lowercase matters. This will delete the sms.db file on the phone. After a reboot sms is working again, but all received sms are gone.
BTW: Any idea where this SMS comes from. never had that kind of sms on my Nokia or the other phones I used before.
Last edited by volkspost; 09-26-2007 at 09:35 AM.
Read the stickies and search the forum before posting!
If you want to become a Hackint0sh supporter click here
---------- iPhone 4 factory unlocked, iOS 4.3.1, jailbroken
iPad Wi-Fi + 3G (1G), iOS 4.3.1, jailbroken
By Ostrovsky in forum Installation
Last Post: 08-16-2009, 11:11 PM
By madcow in forum iPhone "2G" (Rev. 1)
Last Post: 02-04-2008, 10:35 PM
By ZeRaWaReZ in forum iPhone "2G" (Rev. 1)
Last Post: 01-11-2008, 12:42 AM
By JSN1 in forum iPhone "2G" (Rev. 1)
Last Post: 09-24-2007, 04:50 AM
By haggisclown in forum General
Last Post: 09-16-2007, 07:30 PM