Regression Alert: Collection completely borked

[Mark Kretschmann]

On Fri, Jan 7, 2011 at 5:26 PM, Leo Franchi <lfranchi at kde.org> wrote:
> On Fri, Jan 7, 2011 at 11:16 AM, Mark Kretschmann <kretschmann at kde.org> wrote:
>> Ahoy,
>>
>> I just noticed that Amarok would play an album, say from Artist X, and
>> in reality it plays an album from Artist Y. Then, complete albums are
>> missing.
>>
>> I did a full rescan, it did not help. Then I nuked my database, but
>> the problem still persists: Genesis is now sounding a lot like Sting.
>>
>> Some debug output:
>>
>> amarok:     [WARNING] [SqlRegistryP] Insert failed.
>> amarok:     [ERROR__] [MySqlStorage] "GREPME MySQLe query failed!
>> (1062) Duplicate entry '0' for key 'statistics_url' on INSERT INTO
>> statistics (url,createdate,accessdate,score,rating,playcount,deleted)
>> VALUES (NULL,NULL,NULL,NULL,0,0,0),(1,NULL,NULL,NULL,0,0,0),(2,NULL,NULL,NULL,0,0,0),(3,NULL,NULL,NULL,0,0,0),(4,NULL,NULL,NULL,0,0,0),(5,NULL,NULL,NULL,0,0,0),(6,NULL,NULL,NULL,0,0,0),(7,NULL,NULL,NULL,0,0,0),(8,NULL,NULL,NULL,0,0,0),(9,NULL,
>> NULL,NULL,0,0,0),(10,NULL,NU
>>
>>
>> What's going on there?
>
> Not sure. FWIW, my collection works fine here, both current and after
> a rm -rf and clean rescan.

Ok, it seems the mistake was really on my side, or rather on Kubuntu's side:

I did have a distro package of Amarok installed (no idea why), and my
Amarok picked up some wrong plugins. Bleh.

-- 
Mark Kretschmann
Amarok Developer, CEO of Kretschmann Software Consulting
Fellow of the Free Software Foundation Europe
http://amarok.kde.org - http://fsfe.org - http://kde.org