Welcome to Apple iPhone news and Chat discussion forums. iPhone Discussions is dedicated to iPhone,Talk about iPhone modifications,software,reviews,Support, iPhone news , iphone mobile,iPhone OS and more...
Issue: iOS Music application either has items listed in the library that will not play; or has an empty library but iTunes reports that music is present on the device and taking up space; or a combination of these issues coupled with the inability to resolve the problem through the standard resolution steps of disabling music syncing to remove all music and then re-enabling or by enabling "manually manage library" and removing the items.
Additionally, attempting to restore from a back-up does not resolve the issue and the default response from the Apple Support Community is to factory restore the device and treat as new device, resulting in loss of all settings and basically starting from scratch.
Cause of issue: Corrupted iOS device iTunes library (MediaLibrary.sqlitedb). This database stores the iTunes Media records and related information such as playcount, lyrics etc. It does not store information and settings regarding iOS Applications as far as I am aware so this should be safe.
Resolution Steps:Perform a back-up to your local computer rather than iCloud if practical. This will be quicker in the event of issues.Download a iOS device manager such as Phone View (http://www.ecamm.com/mac/phoneview/) which will allow you to directly access the file structure of the device. (This will NOT require an illegal jailbreak to be performed!)Enable the Advanced View mode so the entire disk structure is accessible.Browse to the following file: iTunes_Control/iTunes/MediaLibrary.sqlitedbRename MediaLibrary.sqlitedb to MediaLibrary.sqlitedb-backup or similarHold down POWER and HOME on your iOS device until the Apple logo appears. Release both buttons.When device has rebooted, connect to iTunes and synchronise it.iTunes will detect that the Media Library on the device is missing and recreate it based on the items that it has listed in the iTunes synchronisation record for the device.
Resolution Steps: See main thread. Delete the MediaLibrary.sqlitedb to allow iTunes to recreate it upon the next synchronisation.
This is a similar fix to the Apple documented fix for corrupt iTunes Libraries: iTunes: How to re-create your iTunes library and playlists (http://support.apple.com/kb/ht1451).
NOTE: This also affected Books, AudioBooks and Podcasts for me. All Media which is stored in the library. The only thing I was able to use were Applications.
Oh my god! You are my saviour! I spent at least 8 hours trying to find why Music was crashing when I was going in the Songs tab or modifying a playlist. Tried all the steps documented on the web. Then, I used Xcode to see the error logs on my iPhone. And this is where I saw SQL errors and crashes. A quick search on Google brought me here, and your solution fixed my issues!!!!
Thanks to much!
I've found an easier way, just go to settings>general>usage>music. Then swipe it and press delete, i think this deletes the database described above, then re-sync, this worked for me anyway. Good luck, you need it with Apple software.
In my case, when I was going to settings>general>usage>music, it was simply crashing... no way to swipe and delete.
Reply something about Resolution Steps iPhone iPad or iPod Touch library corrupted and showing ghost entries which will not play or music on device in iTunes but inaccessible. or Post a New Thread