Previous 1 2 3 Next 36 Replies Latest reply: Nov 17, 2015 5:05 PM by DNfromMA
GeekDad3 Level 1 (0 points)

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:

  1. Perform a back-up to your local computer rather than iCloud if practical.  This will be quicker in the event of issues.
  2. 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!)
  3. Enable the Advanced View mode so the entire disk structure is accessible.
  4. Browse to the following file:  iTunes_Control/iTunes/MediaLibrary.sqlitedb
  5. Rename MediaLibrary.sqlitedb to MediaLibrary.sqlitedb-backup or similar
  6. Hold down POWER and HOME on your iOS device until the Apple logo appears.  Release both buttons.
  7. When device has rebooted, connect to iTunes and synchronise it.
  8. 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.

iPhone 4, iOS 5.1
  • GeekDad3 Level 1 (0 points)

    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).

  • GeekDad3 Level 1 (0 points)

    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.

  • Hugo Frappier Level 1 (0 points)

    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!

  • ThisUserNameHasNotBeenTaken Level 1 (0 points)

    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.

  • Hugo Frappier Level 1 (0 points)

    In my case, when I was going to settings>general>usage>music, it was simply crashing... no way to swipe and delete.

  • GeekDad3 Level 1 (0 points)

    In my instance, manually deleting the music did not resolve it either.  I had just under 1000 ghost entries on my iPhone and I manually deleted them all, rebooted and they came back.  That was an hour or so of my life totally wasted.  However, I didn't try it with the master "music" record as you describribe, so yes, that is well worth attempting first.

  • ThisUserNameHasNotBeenTaken Level 1 (0 points)

    Oh i see, my problem was slightly different, iTunes said there were songs on my iphone, but they werent showing on my iphone, yet iTunes showed under the iphone section that they were. I think i still had a corrupted database, and totally wiping all the songs off and re-synced solved my issue.

  • GeekDad3 Level 1 (0 points)

    Yes, this was the same problem we had but neither iTunes or the iPhone would delete them.  The fix above is a last ditch solution to the ghost library entries before you have to factory reset and treat the phone as if it is brand new and start from scratch.

  • graz1ano Level 1 (0 points)

    This totally solved my problem -- after weeks of searching.  Many thanks!

  • thescientist8371 Level 1 (0 points)

    This really helped me! It worked like a charm. I took another route in deleting the file because I work on Windows systems. I used iPhoneBrowser in order to view the files. Then, I created a backup of the file, and renamed it to something else. Like you said, iTunes generated the missing file and all the media played again.

     

    Just a heads up for whoever might encounter this. I believe this error is cause by doing some sort of force quit while the ipod or iphone is syncing. Allow it to finish syncing or you may encounter this type of corrupt files all the time.

     

    Thanks again for your help!

  • jbreeden86 Level 1 (0 points)

    I signed up to apple communities to give my most sincere thanks for this solution. My phone was not displaying cover art when I would use the "Convert Higher Bitrate Songs to ---KBps AAC" feature. After using this solution, then unsyncing and resyncing my music library, my collection looks beautiful, and I can carry much more, now that I'm not carrying around full lossless files.

     

    Grazie!

  • JeanneNE25 Level 1 (0 points)

    michaelfromstockton on tees wrote:

     

    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.

     

    I don't have a large library of music on my iPhone 4s since I've only had it since Oct 2012, but since the update to iTunes 11 in early December, my album artwork has been all messed up.  Everytime I would try to add new music, it would assign the wrong album artwork to anything new coming in.  And in addition to that, it would also mess up album artwork of music already on my phone.  Everything looked correct in iTunes, but on my phone, not so much.  After trying to unsynch, then synching again, my frustration level was at an all-time high. This problem seems to be everywhere online, but no concrete solution for everyone. 

     

    I finally came across your simple solution (at least for me because of my small inventory of music) of just deleting all the music through the settings, and then re-synching to add back my music.  Now all of the album artwork is correct again.  I'm almost afraid to add new music for fear the artwork will get mixed up all over again! I still think my issue is somehow connected to the iTunes 11 update because up until then I had no issues whatsoever. Anyway, thanks for an easy solution that worked for me.

  • cherylbGA Level 1 (0 points)

    michaelfromstockton on tees wrote:

     

    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.

     

    This was "the ticket" for me, after months of frustration!  I had the "ghost" songs on my iPhone 4s, from a time that I was syncing with iTunes on a different computer.  I just could NOT figure out how to make them disappear!!  THIS solution was SO simple, and it worked perfectly for my situation.  THANK YOU!

  • Rizo67 Level 1 (0 points)

    Thanks for this, it was driving me nuts! The settings > general > music > delete didnt work for me, but the ecamm . db rename fix worked a treat. Thanks for restoring my faith in the community

Previous 1 2 3 Next