fix order and burning is working again

[BackupPC.git] / bin / BackupPC_ASA_BurnArchiveMedia

diff --git a/bin/BackupPC_ASA_BurnArchiveMedia b/bin/BackupPC_ASA_BurnArchiveMedia
index 86f20e1..2643918 100755 (executable)
--- a/bin/BackupPC_ASA_BurnArchiveMedia
+++ b/bin/BackupPC_ASA_BurnArchiveMedia
@@ -113,6 +113,7 @@ sub dumpArchive2XML($$$)
        my $backups_sql = q{
                SELECT
                        backup_id,
+                       backup_part_id,
                        host,
                        num,
                        date,
@@ -120,8 +121,7 @@ sub dumpArchive2XML($$$)
                        size
                FROM archive_backup_parts
                WHERE archive_id = ?
-               ORDER BY
-                       hosts.name, shares.name, backups.num
+               ORDER BY backup_part_id
        };
 
        my $sth = $dbh->prepare("SELECT dvd_nr, total_size, note, username, date, id FROM archive WHERE dvd_nr=?");