Your favorite Apple, iPhone, iPad, iOS, Jailbreak, and Cydia site.
08-03-2010, 09:30 AM #1
how do you merge two sms.db files? [texts from two iphones]
hi, i backed up my sms/texts [\private\var\mobile\Library\SMS] from my iphone 3g. then i went out and got the iphone 4. it took a month for the jailbreakme.com to come out, so i couldn’t load my backup from my 3g to iphone 4 on release day. question: how do i MERGE my iphone 3g sms backup with my iphone 4 sms backup?
i tried this site (https://smsmerge.homedns.org/) even though it said it wouldn’t work with frimwares 3.0 and up without any results (no surprise, i had to try)
08-03-2010, 11:58 AM #2
Download a sqlite database explorer/manager. I can't think of the name of the one I used right now. That should allow you to open the sms.db files, and depending on which manager you find, possibly let you merge them.
08-04-2010, 09:31 AM #3
yeah i downloaded sqlite manager plugin for firefox and got this error when trying to add a new record in the "message" table:
SQLiteManager: Create statement failed (executeWithParams): INSERT INTO "main"."message" ("ROWID") VALUES (4325345) [ no such function: read ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement] and sqlitemanager from sqlabs.
then i used sqlitemanager from sqlabs and got a similar error when trying to add a new record:
no such function: read
error code: 1
i think the errors are causes by the triggers that involve deleting and inserting. has anybody tried merging two sms.db in this forum with success?
08-04-2010, 10:13 AM #4
Found this on another forum, by username: Piranha:
"they put the triggers on the tables which use internal functions of sms framework.
So if you try changing values by hand, outside of SMS app, those functions are not defined and they will fail."
08-04-2010, 10:39 AM #5
09-29-2010, 03:09 PM #6
10-09-2010, 10:25 PM #7
10-14-2010, 07:59 PM #8
Same issue here.
The gateway did not receive a timely response from the upstream server or application.
11-09-2010, 12:25 PM #9
04-20-2011, 03:34 PM #10