For those experiencing issues with databases such as addressbook or sms database being reset, deleted or otherwise modified after making a change to it, is due to the rejection of the database. This is usually caused after a user replaces the database from a back or other Chaim file, usually during a 'rollback' of an operating system on the iPhone. The system actively rejects te database as corrupt or unrecognizable due to changes made to the structure of the database by Apple, and thus the additional fields or metadata is incompatible with the current .app that controls such database. In turn, te system usually deletes and creates a new database during startup. You will usually see an apple logo and loader bar and circle appear flickering over the existing screen.
Solution:
You need to use a database program to access the intended sqlite file and compare the structure with the structure of a functional database, and make modifications to make the database structure match. Additionally, look for the metadata for the database itself, so that you can change the version number to that which is to work by default.
Showing posts with label sqlite. Show all posts
Showing posts with label sqlite. Show all posts
Sunday, October 3, 2010
Tuesday, July 6, 2010
Dead/Gone iPhone, Getting new iPhone, but not till next week... how do I get contacts/texts?
Another recent question:
When you plug your SIM into your go-phone, you will get all your missed texts, but you will not see missed phone calls during the time of not having a connected phone. Texts that arrive to your temporary phone will not show up on your new iPhone. I recommend actually disabling the text function of the temp phone so when you plug in your new iPhone, you get all your messages on your iPhone (make sure you do this AFTER restoring from backup otherwise you'll loose them)
Note: the iPhone does not write it's contacts to the sim card, so likely you'll only have the contacts that we on the phone you had previously to your broken iPhone
Feel free to contact us with more questions at griffinconcepts.com or springfieldiphonerepair.com
---- HOW TO GET YOUR CONTACTS FROM YOUR BACKUP -----
Sometimes even severely damaged iPhones that won't display anything will still boot enough to sync to a computer, I'd try that first. If you do have a backup synced to a computer, you can sometimes extract the iPhone contacts.
Required items:
To extract the address book from the backup file, used a tool called Backup Extractor for iPhone. You can download the free version, which will turn out to satisfy your temporary 1-time need.
Source(s):
http://www.griffinconcepts.com/?cat=repair&device=iPhone_3G
http://www.springfieldiPhoneRepair.com
http://mela.ertale.com/blog/?p=47
HELP with a broken iphone PLEASE:(?
ok so my iphone 3g is broken dead completly gone and i have to wait 2 to 3 weeks to get the the iphone 4
my phone has been broken for a week now and they told me in the meantime to buy a gophone and use the sim card now if i do this will it let me see my missed texts and calls?
will it import my contacts?
but most imprtantly will i be able to see my texts msgs from this week when my phone was broken?
When you plug your SIM into your go-phone, you will get all your missed texts, but you will not see missed phone calls during the time of not having a connected phone. Texts that arrive to your temporary phone will not show up on your new iPhone. I recommend actually disabling the text function of the temp phone so when you plug in your new iPhone, you get all your messages on your iPhone (make sure you do this AFTER restoring from backup otherwise you'll loose them)
Note: the iPhone does not write it's contacts to the sim card, so likely you'll only have the contacts that we on the phone you had previously to your broken iPhone
Feel free to contact us with more questions at griffinconcepts.com or springfieldiphonerepair.com
---- HOW TO GET YOUR CONTACTS FROM YOUR BACKUP -----
Sometimes even severely damaged iPhones that won't display anything will still boot enough to sync to a computer, I'd try that first. If you do have a backup synced to a computer, you can sometimes extract the iPhone contacts.
Required items:
- iTunes
- iTunes backup of the device
- Firefox
- SQLite Manager Addon (Add this by going to the "Tools" menu, selecting "Add-ons" and searching for "sqlite manager".
To extract the address book from the backup file, used a tool called Backup Extractor for iPhone. You can download the free version, which will turn out to satisfy your temporary 1-time need.
- Run the program: You will get a list of backup files to restore (You should see all the available device backups you have done on your computer). Typically, you should choose the latest backup.
- The restore wizard brought up two options. I had to choose the second option (manual) as the first option is not available in the free version of the software.
- Navigate to "Library" -> "AddressBook" and checked "AddressBook.sqlitedb".
- Put the restored file in C:\restored. When the process finished, you should have the file "C:\restored\AddressBook.sqlitedb". You will then have to rename the extension of this file from ".sqlitedb" to ".sqlite".
- In Firefox, open the SQLite Manager in the 'Tools' drop-down menu, and 'connect to database' by opening the database you just saved.
- Go to the “Execute SQL” tab in SQLite Manager window in Firefox, and paste the query below and run it. It should give you your contacts in a table
select ABPerson.prefix, ABPerson.first,ABPerson.last, ABMultiValue.value from ABPerson,ABMultiValue where ABMultiValue.record_id=ABPerson.ROWID
- From there you can manually add them to your temporary Phone, or export to excel database. (Select all and then right-click to get advanced copy options to paste into a new excel spreadsheet).
Source(s):
http://www.griffinconcepts.com/?cat=repair&device=iPhone_3G
http://www.springfieldiPhoneRepair.com
http://mela.ertale.com/blog/?p=47
Subscribe to:
Posts (Atom)