So when I upgraded to 1.4.2, things went hectic...

I have tried th following:
- Compiled taglib
- Compiled both 'stable' amarok versions, along with latest SVN versions
- Put some files in a 'clean' directory (this worked)
- Deleted the files the dialog complained about

What is happening?:
- The collection scan errors out. The files don't add.
- Adding files manually works fine, even on the files listed in the 'error' dialog
- Lots of errors spit out to the console

What are my comp details?:
- Distro is Arch Linux 0.7.2
- Kernel is 2.6.17-ck1
- Processor is 800mhz Intel Pentium III
- RAM is 384mb
- If you need more info, http://osaka.deadfrog.us/cpu for my phpsysinfo page

The errors in the console are of this kind:

Code: Select all

amarok:     [CollectionDB] [ERROR!] columns url, deviceid are not unique
amarok:     [CollectionDB] [ERROR!] on insert: INSERT INTO tags_temp ( url, dir, deviceid, createdate, modifydate, album, artist, composer, genre, year, title, comment, track, discnumber, bpm, sampler, length, bitrate, samplerate, filesize, filetype ) VALUES ('./Music/The Smashing Pumpkins-Mellon Collie and the Infinite Sadness/Disc2_10_-We_Only_Come_Out_At_Night.mp3','./Music/The Smashing Pumpkins-Mellon Collie and the Infinite Sadness',3,1157781684,1141820523,54,81,1,3,'9','We Only Come Out At Night','Track 10', 10 , 0 , 0 , NULL,245,213,44100,6546445,1)
amarok:     [CollectionDB] [ERROR!] [virtual int SqliteConnection::insert(const QString&, const QString&)] sqlite_step error.
amarok:     [CollectionDB] [ERROR!] columns url, deviceid are not unique
amarok:     [CollectionDB] [ERROR!] on insert: INSERT INTO tags_temp ( url, dir, deviceid, createdate, modifydate, album, artist, composer, genre, year, title, comment, track, discnumber, bpm, sampler, length, bitrate, samplerate, filesize, filetype ) VALUES ('./Music/The Smashing Pumpkins-Mellon Collie and the Infinite Sadness/Disc1_03_-Jellybelly.mp3','./Music/The Smashing Pumpkins-Mellon Collie and the Infinite Sadness',3,1157781676,1141819633,53,81,1,31,'9','Jellybelly','Track 3', 3 , 0 , 0 , NULL,181,166,44100,3781948,1)
amarok:     [CollectionDB] [ERROR!] [virtual int SqliteConnection::insert(const QString&, const QString&)] sqlite_step error.
amarok:     [CollectionDB] [ERROR!] columns url, deviceid are not unique
amarok:     [CollectionDB] [ERROR!] on insert: INSERT INTO tags_temp ( url, dir, deviceid, createdate, modifydate, album, artist, composer, genre, year, title, comment, track, discnumber, bpm, sampler, length, bitrate, samplerate, filesize, filetype ) VALUES ('./Music/The Smashing Pumpkins-Mellon Collie and the Infinite Sadness/Disc1_10_-Cupid_De_Locke.mp3','./Music/The Smashing Pumpkins-Mellon Collie and the Infinite Sadness',3,1157781689,1141820727,53,81,1,31,'9','Cupid De Locke','Track 10', 10 , 0 , 0 , NULL,170,183,44100,3913338,1)

With MySQL, the errors are different, but similar. My collection doesn't have many dupes, so I can't be too sure that this is the issue.

What else have I tried? Well, I moved all of the music I could find to a single folder structure instead of scanning for files in areas with more than just music. Initially, it was parsing torrents and gifs and jpegs, and counting those towards the 'total' error count. It was also erroring out on the same file(s) multiple times, as seen here:
[img]http://osaka.deadfrog.us/dialog.png[/img]
[img]http://osaka.deadfrog.us/dialog2.png[/img]

Anyways, I tried to load one of the files it errored out on during the collection scan manually, and it loaded/played fine:
[img]http://osaka.deadfrog.us/dialog1.png[/img]

Anyways, by moving/deleting files it was complaining about, it finds new files to complain about. My latest 'error' dialog is this one:
[img]http://osaka.deadfrog.us/dialog3.png[/img]

As I said, I have compiled a clean taglib, old one uninstalled completely. I have also been able to get the collection scanner to work when copying a few hundred files to a clean directory, it seems to work perfectly fine then.. However, Amarok appears to be upset with my folder structure/layout, or the files themselves. It's not a very well sorted collection, I really just dump files into directories and rely on Amarok to sort them, which makes it unbearable to not have a working amarok... Browsing thousand file directories with little or no organization with audacious and the notorious GTK file chooser is obviously quite painful. Please help me, or at least guide me in the right direction! I have downgraded to amarok 1.4.1 with no problem, but I refuse to stay downgraded, I've already gone back to latest SVN after proving 1.4.1 worked (just to see if it would), and I wanna get back to rediscovering my music (that was very very cheesy/corny, I know). So any help anyone can provide would be hugely appreciated, thank you.

EDIT: also noting that I am using xine engine

I'm also looking for a solution... I've tried uninstalling/reinstalling amarok (not downgrading though, doing that right now), uninstalling/reinstalling taglib, deleting config files, moving music, etc. Apparently, some people over at the Ubuntu forums have been having the same problem. I've tried troubleshooting it at the Sabayon forums.

EDIT:  These threads seem to be about the same problem, as well

http://amarok.kde.org/forum/index.php/t ... 970.0.html
http://amarok.kde.org/forum/index.php/t ... 948.0.html

There is clearly something wrong with 1.4.2 and 1.4.3 and collections of music.  I posted another collection-related problem that I have been having since I updated to 1.4.2 and the same problem is there with 1.4.3 after I updated again:

http://amarok.kde.org/forum/index.php/t ... 902.0.html

check your distros... there's a patch for 1.4.3 that should improve problems people are having with scanning tracks.

Thanks for the advice... I was just about to think the whole Amarok community was asleep!!

Now I guess I can re-rediscover my music. Thanks again!