From 23926a46e17e555219eb3901573ad0e8c0cf248a Mon Sep 17 00:00:00 2001 From: Ian Beckwith Date: Fri, 24 Sep 2010 00:57:39 +0100 Subject: [PATCH] fix album_tracks --- lib/ID3FS/DB.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/ID3FS/DB.pm b/lib/ID3FS/DB.pm index f2151e4..5217484 100644 --- a/lib/ID3FS/DB.pm +++ b/lib/ID3FS/DB.pm @@ -267,7 +267,7 @@ sub album_tracks { my($self, $album_id)=@_; my $sql=("SELECT files.name FROM files\n\t" . - "INNER JOIN files_x_albums ON albums.id=files_x_albums.albums_id\n\t" . + "INNER JOIN files_x_albums ON files.id=files_x_albums.files_id\n\t" . "INNER JOIN albums ON albums.id=files_x_albums.albums_id\n\t" . "WHERE albums.id=?\n\t" . "GROUP BY files.name\n"); -- 2.11.0