X-Git-Url: http://git.rot13.org//?p=BackupPC.git;a=blobdiff_plain;f=bin%2FBackupPC_ASA_removeBurnedArchives;fp=bin%2FBackupPC_ASA_removeBurnedArchives;h=38627d64f6164286cdeeaec6e03c0da0874dd321;hp=798b1fa5bfe3497f4e5306220d3983ebeffbc0c5;hb=1e64554b4812c6fccce5aa853aee8a7a6a85987f;hpb=9fecbd8a0fc6460ca8837c6b38dc9c03ed21c05e

diff --git a/bin/BackupPC_ASA_removeBurnedArchives b/bin/BackupPC_ASA_removeBurnedArchives
index 798b1fa..38627d6 100755
--- a/bin/BackupPC_ASA_removeBurnedArchives
+++ b/bin/BackupPC_ASA_removeBurnedArchives
@@ -20,8 +20,8 @@ my $sql = q{
 	FROM backups
 		INNER JOIN hosts ON (hosts.id=backups.hostid)
 		INNER JOIN shares ON (shares.id=backups.shareid)
-		INNER JOIN archive_backup ON (archive_backup.backup_id=backups.id)
-		INNER JOIN archive_burned ON (archive_burned.archive_id=archive_backup.archive_id)
+		INNER JOIN archive_backup_parts ON (archive_backup_parts.backup_id=backups.id)
+		INNER JOIN archive_burned ON (archive_burned.archive_id=archive_backup_parts.archive_id)
 	GROUP BY 1, 2, 3
 	HAVING MAX(archive_burned.copy)>=2;
 };