diff options
| author | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2007-06-11 08:29:22 +0000 |
|---|---|---|
| committer | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2007-06-11 08:29:22 +0000 |
| commit | 6b272003385ccd0269cca358e6c00f8a205c976a (patch) | |
| tree | 3ea1b3fff03bd4d855d5d32993c691ac76173694 /lib/class | |
| parent | 05c406e1f751ece06a7d54bc636275837f9f0169 (diff) | |
| download | ampache-6b272003385ccd0269cca358e6c00f8a205c976a.tar.gz ampache-6b272003385ccd0269cca358e6c00f8a205c976a.tar.bz2 ampache-6b272003385ccd0269cca358e6c00f8a205c976a.zip | |
fixed clean so that it properly cleaned album_data
Diffstat (limited to 'lib/class')
| -rw-r--r-- | lib/class/catalog.class.php | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/lib/class/catalog.class.php b/lib/class/catalog.class.php index 06e786f7..dd1ea064 100644 --- a/lib/class/catalog.class.php +++ b/lib/class/catalog.class.php @@ -1345,6 +1345,14 @@ class Catalog { $sql = "DELETE FROM album USING album LEFT JOIN song ON song.album = album.id WHERE song.id IS NULL"; $db_results = Dba::query($sql); + /* Now remove any album art that is now dead */ + $sql = "DELETE FROM `album_data` USING `album_data` LEFT JOIN `album` ON `album`.`id`=`album_data`.`album_id` WHERE `album`.`id` IS NULL"; + $db_results = Dba::query($sql); + + // This can save a lot of space so always optomize + $sql = "OPTIMIZE TABLE `album_data`"; + $db_results = Dba::query($sql); + } // clean_albums /** |