From 6b272003385ccd0269cca358e6c00f8a205c976a Mon Sep 17 00:00:00 2001 From: Karl 'vollmerk' Vollmer Date: Mon, 11 Jun 2007 08:29:22 +0000 Subject: fixed clean so that it properly cleaned album_data --- lib/class/catalog.class.php | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'lib/class') 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 /** -- cgit