Page 1 of 2 12 LastLast
Results 1 to 10 of 16
Discuss GUIDE: SMS Backup, Single SMS Delete + Possible Crash Fix at the General - Hackint0sh.org; This Windows guide is designed to help people achieve the following: 1) backup their SMS's ...
  1. #1
    Senior Professional Array

    Join Date
    Sep 2007
    Posts
    370
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    29

    Default 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 crashing

    It 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/)

    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 Delete

    To 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 lowercase

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

    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' etc

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

    Thanks goes to Snowbird (for suggesting SQLite as a way to fix my problem) and other forum members who's information i've used.
    Last edited by rjshearman; 10-08-2007 at 03:15 PM. Reason: Added: Create Storing Thread



  2. #2
    Respected Professional Array Sassha's Avatar

    Join Date
    Jul 2007
    Location
    Croatia
    Posts
    687
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    46

    Default

    Very nice!

  3. #3
    Rookie Array

    Join Date
    Sep 2007
    Posts
    23
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default

    nice guide

    but i still cant fix the incoming SMSs problem , got any guide for it?

  4. #4
    Respected Professional Array

    Join Date
    Aug 2007
    Location
    Paris, France
    Posts
    533
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    34

    Default

    Quote Originally Posted by aerus View Post
    nice guide

    but i still cant fix the incoming SMSs problem , got any guide for it?
    What's the problem?

  5. #5
    Respected Professional Array

    Join Date
    Aug 2007
    Location
    Paris, France
    Posts
    533
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    34

    Default

    Quote Originally Posted by rjshearman View Post
    This Windows guide is designed to help people achieve the following:
    Great work rjshearman! When you going to come over to the wild-side and get yourself a REAL computer -- a Mac! That way you can put together Mac guide as well.

    Once you go Mac, you never go back.....


  6. #6
    Senior Professional Array

    Join Date
    Sep 2007
    Posts
    370
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    29

    Default

    Thanks for the comments.

    Quote Originally Posted by aerus View Post
    nice guide

    but i still cant fix the incoming SMSs problem , got any guide for it?
    Try this thread : http://www.hackint0sh.org/forum/showthread.php?t=9554

    Quote Originally Posted by Snowbird View Post
    Great work rjshearman! When you going to come over to the wild-side and get yourself a REAL computer -- a Mac! That way you can put together Mac guide as well.
    Hopefully soon actually. I'm just looking into a bit more and reading up on them before taking the plunge. I probably wouldn't have considered a Mac before getting an iPhone.

    Quote Originally Posted by Snowbird View Post
    Once you go Mac, you never go back.....
    OK, you convinced me.

  7. #7
    Senior Professional Array

    Join Date
    Sep 2007
    Posts
    370
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    29

    Default

    Added 'Create Storing Thread' - See first post.

  8. #8
    Professional Array

    Join Date
    Aug 2007
    Location
    Sydney, Australia
    Posts
    50
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    9

    Default deleting single sms on a mac

    Hi,

    I'm using the SuperSim method in Australia, on Telstra Network.

    Yesterday I recived an sms, there was no number just some characters and signs.
    When I started to view the sms it brought me (the iPhone) back to the main menue (the one when you press the home button).
    Friends messaged me as well, i could see the preview but when I went again to sms, it tried to access and went back to the main menue.

    Is there any software or way to connect my iPhone to my PowerBook Mac G4 and to access the sms folder by this way and to delet the sms I got which causes the problem?
    Is this maybe a virus? A bug ore something else?

    Thank you for any help!!!

    Cheers

    Moritz

  9. #9
    Professional Array

    Join Date
    Aug 2007
    Location
    Sydney, Australia
    Posts
    50
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    9

    Default

    Of course I searched the forum, but no proper answer was available for my problem.

    And because I don't have a windows computer, neither do I have an intel Mac or virtual PC to run windows on my PowerBook G4. So I can't use iBrick :-(

    I downloaded breezy but this also doesn't help :-(

    Anyone an other idea?

    How to solve this problem?

    And what did I get in this sms and by whom to make my sms function crash?

    Thank you for you help!!! (you must know I don't know so much about computers)

    Cheers

    Moritz

  10. #10
    Professional Array

    Join Date
    Aug 2007
    Location
    Sydney, Australia
    Posts
    50
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    9

    Default is there

    Hi mates,

    is there any SQLite Administrator for mac so that I can use my sms menu again or something else, without being forced to restore my iPhone? :-(

    Thanks

    Moritz


 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Can't delete any app's. It wiggle and the x shows but won't delete
    By w.32.da.bagle in forum iOS 3.x (iPhone OS 3.x)
    Replies: 0
    Last Post: 04-16-2010, 09:48 AM
  2. Replies: 16
    Last Post: 09-08-2008, 07:08 AM
  3. MacNN: Tri-BACKUP 5.1 aids FTP backup, e-mail notes, more
    By hackint0sh in forum Latest Headlines
    Replies: 0
    Last Post: 09-01-2008, 07:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Powered by vBulletin®
Copyright © 2014 vBulletin Solutions, Inc. All rights reserved.
Search Engine Friendly URLs by vBSEO
(c) 2006-2012 Hackint0sh.org
All times are GMT +2. The time now is 03:27 PM.
twitter, follow us!