--- copycover-offline.py.org 2008-12-29 21:50:41.000000000 -0500
+++ copycover-offline.py 2008-12-29 22:01:40.000000000 -0500
@@ -116,7 +116,7 @@ for artist_tuple in artists:
inc = inc + 1
if inc >= len(progress):
inc = 0
- dcop_albums = commands.getoutput('''dcop amarok collection query "SELECT DISTINCT album.name, CONCAT(devices.lastmountpoint,'/',tags.dir) FROM tags, album, devices ''' \
+ dcop_albums = commands.getoutput('''dcop amarok collection query "SELECT DISTINCT album.name, devices.lastmountpoint || '/' || tags.dir FROM tags, album, devices ''' \
+'''WHERE tags.album = album.id AND tags.deviceid = devices.id AND album.name != '' AND tags.artist = %s"''' % artist_tuple[0])
if not dcop_albums: