Resolution Steps: iPhone, iPad or iPod Touch library corrupted and showing ghost entries which will not play or music that is on the device in iTunes but inaccessible.

This solution has helped me a number of times and I thank you for your help.

The problem will be a recurring one until Apple fixes iOS so that it can handle iTunes purchased movies(.m4v), iTunes rentals(.m4v) and imported .mp4's. The new TV app will not allow for the proper import of movies from these three categories at the same time. It does not matter if the iPad mini or iPad Air 2 have music synched or not as was claimed in other posts.

It is my conclusion that the TV app's database can't accept the three types of files, as the old movie app did at one time. The only solution that works consistently is to only synch purchased iTunes content to the 'broken' TV app. Any movie files that you have in iTunes that were created with Handbrake or another source need to uploaded to the VLC app, which works better than the TV app anyway. I have wasted days worth of time trying to synch videos to the native apple movie app and this TV app prior to a flight.

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.

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.

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

This really helped me! It worked like a charm. I took another route in deleting the file because I work on Windows systems. I usediPhoneBrowser 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!

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!

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

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!

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 🙂