From: Steinar H. Gunderson <sesse@debian.org>
Date: Sun, 12 Dec 2010 23:03:24 +0000 (+0100)
Subject: Fix a typo in a query against shadow_files.
X-Git-Url: https://git.sesse.net/?p=pr0n;a=commitdiff_plain;h=5953f63c8c3a887f3d5af26cc10ebd859e591d90

Fix a typo in a query against shadow_files.
---

diff --git a/perl/Sesse/pr0n/WebDAV.pm b/perl/Sesse/pr0n/WebDAV.pm
index 73ca79c..ebef010 100644
--- a/perl/Sesse/pr0n/WebDAV.pm
+++ b/perl/Sesse/pr0n/WebDAV.pm
@@ -368,7 +368,7 @@ EOF
 		} else {
 			# check if we have a "shadow file" for this
 			if (defined($autorename) && $autorename eq "autorename/") {
-				my $ref = $dbh->selectrow_hashref('SELECT id FROM shadow_files WHERE host=? AND event=? AND filename=? AND expires_at > now()',
+				my $ref = $dbh->selectrow_hashref('SELECT id FROM shadow_files WHERE vhost=? AND event=? AND filename=? AND expires_at > now()',
 					undef, $r->get_server_name, $event, $filename);
 				if (defined($ref)) {
 				 	($fname, $size, $mtime) = Sesse::pr0n::Common::stat_image_from_id($r, $ref->{'id'});