It scans my collection successfully. I can look in the database and see everything there. They just suddenly quit showing up in the listings under "Local Collection." It just says "0 tracks" for all volumes listed there. There is probably some bug causing this, but I don't know enough about how this state came to be to report it. I do know all the songs on my playlist disappeared at the same time.

In any case, any idea how I can get them displaying again? (2.3.0)

When you quit (control-Q) and restart, do you see your collection?

If not, please run from console,

Code: Select all

amarok -d --nofork

and see if you can see anything in the debug output.

Also, 2.3.0 is rather old, 2.3.2 beta is already out. Just updating might be all you need. http://amarok.kde.org/wiki/Download

Valorie

A lot gets printed, but this error kind of jumps out at me:

amarok: [ERROR!] "GREPME MySQL-server query failed! (144) Table './amarok/tracks' is marked as crashed and last (automatic?) repair failed on SELECT urls.deviceid, urls.rpath, urls.uniqueid, tracks.id, tracks.title, tracks.comment, tracks.tracknumber, tracks.discnumber, statistics.score, statistics.rating, tracks.bitrate, tracks.length, tracks.filesize, tracks.samplerate, statistics.createdate, statistics.accessdate, statistics.playcount, tracks.filetype, tracks.bpm, tracks.createdate, tracks.albumgain, tracks.albumpeakgain, tracks.trackgain, tracks.trackpeakgain, artists.name, artists.id, albums.name, albums.id, albums.artist, genres.name, genres.id, composers.name, composers.id, years.name, years.id FROM tracks INNER JOIN urls ON tracks.url = urls.id LEFT JOIN artists ON tracks.artist = artists.id LEFT JOIN albums ON tracks.album = albums.id LEFT JOIN genres ON tracks.genre = genres.id LEFT JOIN composers ON tracks.composer = composers.id LEFT JOIN years ON tracks.year = years.id LEFT JOIN statistics ON urls.id = statistics.url WHERE 1 AND urls.deviceid in (1,2,-1) AND ( 1 AND NOT tracks.title = '' ) ORDER BY statistics.accessdate DESC LIMIT 5 OFFSET 0 ;"

Would dropping the damaged table and recreating it, then rescanning my collection work?

Please update your Amarok version: http://kubuntu.org/news/amarok-2.3.1

Indeed your database seems to be corrupt, are you using the default embedded or an external MySQL server?

I'm not unhappy with the version I have and would rather wait til the release of Kubuntu Maverick to upgrade if that's alright. It's an external MySQL server. I'll just try dropping the database and recreating it. I'll lose a lot of downloaded/hand-entered lyrics, but I've pretty much lost them anyway.