Amarok 2.3.1. While managing the collection (moving songs, title edit, author edit... etc. these things) at some point, all the album art (about 11,000 tracks) are gone away! there is a painless method to make reappear the covers, or do I need to rebuild the entire collection? Initially, the covers had entered automatically as there is a cover.jpg (or similar) file in each folder.

EDIT: correct the title to better clarify

when you say lost album art do you mean none show in the collection on none show in the cover tool? if the cover tool restart Amarok.

unfortunately none show in the collection, as if he had lost the reference to all the covers automatically assigned the first time the collection has been created. Now I only have about ten covers in the collection (the only ones I had manually assigned in the past).

EDIT: I have the impression that we have spotted something in the mysql tables ... It may serve as an assistant: I remember that during the managing, amarok had moved an album under a wrong author, the first author in alphabetical order in this collection.

looking into the amarok mysqle table "albums" I notice that the image table could be the issue, for example :

Code: Select all

select * from albums where name like '%Elio%';
+------+--------------------------------------------------------------------------+--------+-------+
| id   | name                                                                     | artist | image |
+------+--------------------------------------------------------------------------+--------+-------+
|  408 | E.L.I.O. the Artist Formerly Known as Elio e le Storie Tese              |    214 |   373 |
| 1305 | Elio Samaga Hukapan Kariyana Turu                                        |    214 |  1404 |
| 1310 | The Los Sri Lanka Parakramabahu Brothers Featuring Elio e le Storie Tese |    214 |  1403 |
+------+--------------------------------------------------------------------------+--------+-------+

and in "images" table:

Code: Select all

select * from images where id=373 or id=1404 or id=1403;
+------+-------------------------------------------------------------------------------------+
| id   | path                                                                                |
+------+-------------------------------------------------------------------------------------+
| 1403 | /home/gio/.kde/share/apps/amarok/albumcovers/large/c290f0de539eaba3b26ede858cd60d8f |
| 1404 | /home/gio/.kde/share/apps/amarok/albumcovers/large/c029e580af4718f7a343e635ccd23543 |
+------+-------------------------------------------------------------------------------------+

there isn't an image id=373. In the "images" table I have just 30 rows, the number of the album art cover I have set manually in the past (set custom cover). Who deleted the row, in the images tables, with id 373?????

Workaround that has solved my issue without loosing collection statistics:

- Open Amarok -> Settings -> Configure Amarok -> Collection, then deselected all the music folders and close amarok.

- Open Amarok -> Settings -> Configure Amarok -> Collection, then re-selected all my music folders.

After complete scanning is done, I see come back the album art covers (not the ones manually setted in the past) and I haven't lost statistics.

To remark: now the mysqle images table have again about 1300 rows.
Who has deleted all the rows (all but not the rows that contains the path <userhome>/.kde/share/apps/amarok/albumcovers/large/<imagefile>) from the images table that has caused my issue???