As posted my response here, https://discussions.apple.com/message/19792359#19792359
I dont know how come apple had not sensed it earlier.
This message issues is blowing my head after updgrade. Actually i need to blam my Indian trai and service providers, for iphone . If i receive a bank message it would be LM-HDFC or AM-ICICI but i my iphone reads it as LMHDFC or AMICICI.
Once ios6 is upgraded on my iphone4. I have enabled imessages and facetime immediatley. So when iphone messages are read, possibly it shows blank page because imessage reads the message as a contact name rather no number is available on those transaction / promotional messages sent in India. So it had corrupted all the messages in my iphone4 ( i hope ).
As everyone said, its booooom. I would have read these topic before upgrade, unfortunatelly missed my 3000 messages. Have to wait for ios6.1 update for apple to fix it, if they notice. Or all messages are gone.
i have also noticed soemthing funny with the company messages. after the ios upgrade, teh old company messages were deleted. and not, whne i get new ones the following happens:
- the phone is locked and i receive an sms
- i see teh preview on the lock screen
- i slide to unlock the phone and read the sms
- teh message icone does not display the number (1) on teh icon indicating that i have one unread sms.
- with normal messages received from numbers or people in the contact list, it functions normally and whenever i get a new sms and i unlock the phone, the message icon indicates the number of unread sms that i have.
anyone else noticed this???
When I've detected the SMS bug, I have stopped iCloud backup (not explicit, but I did not turn on WiFi when I charge my phone).
Today I have connected my phone to iTunes, and made a "direct" backup (from the popup menu, you can overwrite the "backup to iCloud" situation). Then I searched the files, and I have found the original sms database, so probably the good sms.db file exists on the update phones, but it is not used becaused of the conversion described by Cray7. So I hope, SMS can somehow came back without any iOS5 backup.
If you lost your messages database when updating from iOS 5 to iOS 6, the upgrade process most likely failed to convert your sms.db to newer iOS6 format then - and ended up initializing a new message database for your device.
However, while most of us effected by this bug lost all messages, some users have reported here that they are seeing messages partially in the Messages App. This is probably caused by partially failed conversion where only message indexes are transferred but the actual data table is not (messages app shows headers, but no content). I have not been able to duplicate this result myself.
If you now upgrade to iOS 6.0.1 or newer your messages will not - obviously - reappear because they no longer exist on your device at all due to previously failed/buggy data conversion.
Only hope left is to have a iCloud or iTunes device backup made before iOS 6.0 upgrade. You can try restoring that to device running 6.0.1 or newer and see if the sms.db conversion bug has been fixed.
I currently have one iOS 5 backup (with years full of my message history) made just before iOS 6 upgrade. I lost all my messages due to the sms.db conversion bug when upgrading and I'm going to try to restore that backup to iOS 6.0.1 iPhone (and possibly with 6.1 dev release) and see if conversion bug has been fixed...
Ok, reporting back:
I can confirm that Messages App database (sms.db) conversion bug has *not* been fixed in iOS 6.0.1:
1. Upgraded a fresh iPhone from 6.0 to 6.0.1
2. Reset iPhone to factory defaults (all data, all settings)
3. Started restoring backup made with iOS 5 (confirmed restoreable to iOS 5 without data loss, but restore to 6.0 triggers the conversion bug)
4. Interrupted upgrade process when backup data had been transferred (after first reboot during restore)
5. Fetched sms.db from the phone using custom software (verified to contain all messages in iOS 5 format, all ok so far)
6. Allowed the phone to proceed with converting the database to iOS 6.0.1 format (sms.db schema has changed for iOS 6)
7. All messages lost - a newly created sms.db on the phone - just like earlier iOS 6.0
-> The bug has not been fixed.
I also tried running the same process without interrupting the upgrade (which allows me to verify the bug) and doing it "the official way".. same results: messages lost and iOS 6.0.1 ends up initializing a new/empty sms.db database for Messages App. After that happens any later upgrade can *not* restore the messages.. if you dont hold on to your old backup made with iOS 5.
I would also like to point out that this bug affects probably very small number of users. So far I've upgraded dozens of devices from iOS 5 to iOS 6.x and only two has experienced sms.db conversion issues with lost messages.
Next week I am able to test the new dev version of iOS 6.1 and see if this has been fixed there..
Cray7, thank you for the technical analysis.....sadly., doesn't help me.
I can't believe that so many weeks...months after OS6 release., this *issue* hasn't been remedied by Apple.
I have a 4S back-up on my computer, and in iCloud. I haven't had a successful restore yet on my i5. ALL my msgs are gone. Everything else restore perfectly .
It's really quite dissapointing that Apple wants premium pricing for their devices, but arguably thee most integral and important aspect of a cellphones' usage (txt capability) is grossly mismanaged in the OS rollout process.
In addition to my back-ups, I used iFunBox to manually extract the sms.db and in fact entire sms folder from my 4S for safe keeping.
I'm THIS close to paying the $19 to backuptrans to get this resolved, but really, Apple needs to resolve this issue.
What's annoying is this isn't affecting EVERYBODY...only random devices....are we being profiledperhaps? lol.
As I said previewsly my sms are all back and I updated to 6.0.1 and everything is there. So use the software if yours sms are so important as mine.
Oct 20, 2012 3:28 AM (in response to sidburk)
I just bought "BackupTrans iPhone SMS Backup And Restore" and I managed to get back my sms!
I admit that I did not belived that in first place but I gave the 30 euros and bought it.
I managed to get back my sms and to unify them with me new ones. You just have to have your old database.
I just successfully recovered all of my SMS and imessages from my iPhone 4 iOS 5 backup and have them on my new iPhone 5 with iOS 6!
I was receiving the same problem as most of the other posters: my messages were failing to be converted to the new sms.db format of the iPhone 5 (which I believe was to address the iphone text spoofing issue). I spent about 7 hours being completely infuriated and ready to return this phone, sell my other three iphones, sell my shares of aapl, and buy... I hate to say it... a Galaxy SIII.
Here is what I did:
First of all, my original backup from iOS 5 was encrypted which I now believe to be the root cause of the conversion error. I repeatedly restored my new phone to various back ups without success. I scoured the interwebs for ideas of how to fix this. I then broke down and paid the **** $23.05 (after taxes) for Backuptrans. However, I was not able to use it because my backup was still encrypted. I then kept trying over and over to restore my phone to my iOS 5 backup again, but the phone kept turning off 8 minutes into the 9 minute backup. After tinkering with different settings trying to fix this new issue, I went back to Settings > General > Reset > Erase All Content and Settings. I then re-backed up the phone to the iOS 5 backup - successfully! - then unchecked Encrypt Local Backup, put in the password and let it do the update to the backup. I was going to go the Backuptrans again now that it was no longer encrypted, but before I even got there I decided to check my phone again and the messages were all there and in working order.
I'm sure this won't work for everyone, but the main point is to try decrypting the backup if your iOS 5 backup is encrypted (which would also explain why most people aren't having this issue).