From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Fri, 28 Jan 2011 19:48:22 +0000 (+0100)
Subject: fix order and burning is working again
X-Git-Url: http://git.rot13.org/?p=BackupPC.git;a=commitdiff_plain;h=a63fb961f9a5ea6a067b8e3b0f243f00858429c6

fix order and burning is working again
---

diff --git a/bin/BackupPC_ASA_BurnArchiveMedia b/bin/BackupPC_ASA_BurnArchiveMedia
index 86f20e1..2643918 100755
--- 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=?");