Results 1 to 4 of 4
Discuss editing SMS.db in 3.0... at the iOS 3.x (iPhone OS 3.x) - Hackint0sh.org; like everyone else, i want texts from my old phone on my iphone. i've figured ...
  1. #1
    Newbie Array

    Join Date
    Dec 2008
    Posts
    6
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default editing SMS.db in 3.0...

    like everyone else, i want texts from my old phone on my iphone. i've figured that the only way to do this is to edit SMS.db manually in sqlite database browser (or similar, but that's what i'm using - i'm on osx 10.4). i know how to do this, and to make sure the tables match up. but i get an error...so, i searched the forums, and there's plenty of threads on said error! buuut... a) they're all fairly old and b) none actually solve the problem, except this one. however, that workaround (with dropping the triggers then creating them) is either not working anymore in 3.0 or i can't get it to work.

    if that workaround is still working for anyone else on 3.0 can you tell me how you got it to work??

    (also, i should note, i was finding it easier to create a new conversation the real way [i was using my mom's phone to text myself], and then change the address, timestamp, and message in SQLite so that i didn't have to worry about numbering problems as the phone was creating the numbering scheme for me - not super relevant i know, but if this creates any other numbering problems i'm not forseeing let me know...)

    [edit] i also have an sms-legacy.db on my phone, no idea what this is but it's formatted the same as sms.db but with one less index, and has no texts in it (and gives the same error still). have no idea if something could be done with this but thought i'd throw it out there as i haven't seen anyone mention it yet...
    Last edited by moonlights; 07-02-2009 at 10:57 AM.



  2. #2
    Board Hero Array

    Join Date
    Dec 2007
    Posts
    1,044
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    74

    Default

    I usually backup the sms database before I upgrade and then put that back after the upgrade. Does that not work for you?
    iPhone 3GS / 3.1.2 JB (PwnageTool) / 04.26.08 carrier-locked, Carrier Logo Fixer / Cydia / 1000 posts on Hackint0sh

    Installing Cydia programs on a phone that has no internet connection: read this.

    Editing binary .plist, .strings, .nib and .xib files:
    * on your computer: Windows tool / conversion website.
    * on your iPhone: convert those files in a terminal with plutil (installed with Erica Utilities) or edit them with iFile (Cydia links).

  3. #3
    Newbie Array

    Join Date
    Dec 2008
    Posts
    6
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default

    the texts weren't on an iphone, so i have to manually put them in the iphone database. =/

  4. #4
    Senior Professional Array unl0cker's Avatar

    Join Date
    Jul 2007
    Location
    In my Mind
    Posts
    128
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    14

    Default

    *IF* :

    - You have a Mac
    - You have SSHD installed in the iPhone

    You can look at the iPhoneNotes App.

    The dude that created just discontinued the app because iTunes is now syncing Notes as well.

    Anyway, check it out, and try to open the db with the program, edit what you need, and then upload the db
    using the Save/Load option directly into the iPhone.


    Cheers
    Last edited by unl0cker; 07-06-2009 at 01:16 AM.
    .

 

 

Similar Threads

  1. editing sms.db timestamp, Please help!
    By oukeef in forum General
    Replies: 0
    Last Post: 10-10-2011, 04:40 PM
  2. No 3G APN Editing available
    By hemanshurpatel in forum iOS 4.x (iPhone OS 4.x)
    Replies: 7
    Last Post: 09-04-2010, 06:32 AM
  3. APN editing after redsn0w
    By DrNose in forum Redsn0w
    Replies: 6
    Last Post: 07-18-2009, 10:34 AM
  4. .Dylib editing
    By boz in forum iPhone Developer Exchange
    Replies: 3
    Last Post: 12-13-2008, 08:39 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 02:39 AM.
twitter, follow us!