X-Git-Url: http://git.rot13.org/?p=BackupPC.git;a=blobdiff_plain;f=bin%2FBackupPC_ASA_SearchUpdate;h=929e848dc85e76543c7f8bba20727ae77e37ecb7;hp=cb2dcd1481d9f530f82b70924544b78b5eafd5b6;hb=1e64554b4812c6fccce5aa853aee8a7a6a85987f;hpb=9fecbd8a0fc6460ca8837c6b38dc9c03ed21c05e 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 --;