Hi Folks...
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...

Thanx...

Well nevermind..... I found it myself... I deleted the sms.db and restarted everting got fixed...

hi,

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....

Koray Birand

Ohhh sorry I forgot to answer your question... Yes you can ethir delete it with fugu or mobilefinder...


Koray Birand

Originally Posted by koraybirand

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....

Koray Birand

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

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....

Viola...

Koray Birand

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

type
rm /private/var/root/Library/SMS/sms.db

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.

volkspost