X-Git-Url: http://git.rot13.org/?p=BackupPC.git;a=blobdiff_plain;f=bin%2FBackupPC_ASA_SearchUpdate;h=929e848dc85e76543c7f8bba20727ae77e37ecb7;hp=cb2dcd1481d9f530f82b70924544b78b5eafd5b6;hb=06017d5181d9c62f8cbd1c6d58d831f54d7d4ad1;hpb=488bb662f6d144d42376b3d14e9b1e438e00e6f8 diff --git a/bin/BackupPC_ASA_SearchUpdate b/bin/BackupPC_ASA_SearchUpdate index cb2dcd1..929e848 100755 --- a/bin/BackupPC_ASA_SearchUpdate +++ b/bin/BackupPC_ASA_SearchUpdate @@ -710,8 +710,8 @@ create table archive_burned ( --from backups --join shares on backups.shareid=shares.id --join hosts on shares.hostid = hosts.id ---left outer join archive_backup on backups.id = archive_backup.backup_id ---left outer join archive on archive_backup.archive_id = archive.id +--left outer join archive_backup_parts on backups.id = archive_backup_parts.backup_id +--left outer join archive on archive_backup_parts.archive_id = archive.id --where backups.parts > 0 and size > 0 --order by backups.date --;