I'm using SVN commit 960901, and I'll admit I had to hack the source a bit to get it to compile at all (see my other post).  However, it compiled, and managed to open up and start scanning my collection.  I didn't get very far in when Amarok crashed with errors from MySQLe.

Here is a partial dump of the errors I got:

Code: Select all

amarok:              [ERROR!] GREPME MySQLe query failed! Table 'urls' is marked as crashed and should be repaired  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.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 urls LEFT JOIN tracks ON urls.id = tracks.url LEFT JOIN statistics ON urls.id = statistics.url 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 WHERE urls.deviceid = 3 AND urls.rpath = './sn0/sn0/! Audiobooks !/J.K. Rowling/Harry Potter And The Chamber Of Secrets/J.K. Rowling - 1999 - Harry Potter And The Chamber Of Secrets (Disc 5) [Unabridged]/22 - Chapter 11 - The Dueling Club (Part 12 Of 13).mp3';"
amarok:              not a track no match
amarok: BEGIN: virtual bool SqlPodcastProvider::possiblyContainsTrack(const KUrl&) const
amarok: END__: virtual bool SqlPodcastProvider::possiblyContainsTrack(const KUrl&) const - Took 0.00059s
amarok:              [CUEFILE]:  "/mnt/music/sn0/sn0/! Audiobooks !/J.K. Rowling/Harry Potter And The Chamber Of Secrets/J.K. Rowling - 1999 - Harry Potter And The Chamber Of Secrets (Disc 5) [Unabridged]/22 - Chapter 11 - The Dueling Club (Part 12 Of 13).cue"  - Shoot blindly and missed, searching for other cue files.
amarok:              [CUEFILE]: - Didn't find any matching cue file.

amarok:             [CollectionManager] Creating MetaFile::Track
amarok:              "Read metadata from file for: Chapter 11 - The Dueling Club (Part 12 Of 13)"
amarok:              track url:  "/mnt/music/sn0/sn0/! Audiobooks !/J.K. Rowling/Harry Potter And The Chamber Of Secrets/J.K. Rowling - 1999 - Harry Potter And The Chamber Of Secrets (Disc 5) [Unabridged]/22 - Chapter 11 - The Dueling Club (Part 12 Of 13).mp3"
amarok:              line:  "23 - Chapter 11 - The Dueling Club (Part 13 Of 13).mp3"
amarok:              relative url
amarok:              [ERROR!] GREPME MySQLe query failed! Table 'urls' is marked as crashed and should be repaired  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.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 urls LEFT JOIN tracks ON urls.id = tracks.url LEFT JOIN statistics ON urls.id = statistics.url 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 WHERE urls.deviceid = 3 AND urls.rpath = './sn0/sn0/! Audiobooks !/J.K. Rowling/Harry Potter And The Chamber Of Secrets/J.K. Rowling - 1999 - Harry Potter And The Chamber Of Secrets (Disc 5) [Unabridged]/23 - Chapter 11 - The Dueling Club (Part 13 Of 13).mp3';"
amarok:              not a track no match
amarok: BEGIN: virtual bool SqlPodcastProvider::possiblyContainsTrack(const KUrl&) const
amarok: END__: virtual bool SqlPodcastProvider::possiblyContainsTrack(const KUrl&) const - Took 0.00055s
amarok:              [CUEFILE]:  "/mnt/music/sn0/sn0/! Audiobooks !/J.K. Rowling/Harry Potter And The Chamber Of Secrets/J.K. Rowling - 1999 - Harry Potter And The Chamber Of Secrets (Disc 5) [Unabridged]/23 - Chapter 11 - The Dueling Club (Part 13 Of 13).cue"  - Shoot blindly and missed, searching for other cue files.
amarok:              [CUEFILE]: - Didn't find any matching cue file.

amarok:             [CollectionManager] Creating MetaFile::Track
amarok:              "Read metadata from file for: Chapter 11 - The Dueling Club (Part 13 Of 13)"
amarok:              track url:  "/mnt/music/sn0/sn0/! Audiobooks !/J.K. Rowling/Harry Potter And The Chamber Of Secrets/J.K. Rowling - 1999 - Harry Potter And The Chamber Of Secrets (Disc 5) [Unabridged]/23 - Chapter 11 - The Dueling Club (Part 13 Of 13).mp3"
amarok: END__: bool Meta::M3UPlaylist::loadM3u(QTextStream&) - Took 3.9s
amarok: END__: Meta::M3UPlaylist::M3UPlaylist(const KUrl&) - Took 4s
amarok: BEGIN: virtual bool SqlUserPlaylistProvider::save(const Meta::TrackList&, const QString&)
amarok:            saving  23  tracks to db with name "J"
amarok: BEGIN: bool Meta::SqlPlaylist::saveToDb(bool)
amarok:              Creating new playlist
amarok:              [ERROR!] GREPME MySQLe query failed! Incorrect key file for table '/home/wad/.kde/share/apps/amarok/mysqle/amarok/playlists.MYI'; try to repair it  on  "INSERT INTO playlists ( parent_id, name, description, urlid ) VALUES ( -1, 'J', '', '' );"
amarok:              [ERROR!] GREPME MySQLe query failed! Incorrect key file for table 'ome/wad/.kde/share/apps/amarok/mysqle/amarok/playlist_tracks.MYI'; try to repair it  on  "INSERT INTO playlist_tracks ( playlist_id, track_num, url, title, album, artist, length, uniqueid ) VALUES ( 0, 1, 'file:///mnt/music/sn0/sn0/!%20Audiobooks%20!/J.K.%20Rowling/Harry%20Potter%20And%20The%20Chamber%20Of%20Secrets/J.K.%20Rowling%20-%201999%20-%20Harry%20Potter%20And%20The%20Chamber%20Of%20Secrets%20(Disc%205)%20%5BUnabridged%5D/01%20-%20Chapter%2010%20-%20The%20Rogue%20Bludger%20(Part%201%20Of%2010).mp3


I'm not sure if this is related to my hacking around or not, but I don't see how it could be.  I used the latest 5.1 source of MySQL to build that requirement.

Any thoughts?