From: Steinar H. Gunderson <sesse@debian.org>
Date: Mon, 25 Dec 2006 20:40:04 +0000 (+0100)
Subject: Fix more SQL typos.
X-Git-Url: https://git.sesse.net/?p=pr0n;a=commitdiff_plain;h=25522869d2a8d6b61274e6324be81dab8e429ea1;hp=150143c86481611f06d86a0956b6b7965b1c0c88

Fix more SQL typos.
---

diff --git a/perl/Sesse/pr0n/WebDAV.pm b/perl/Sesse/pr0n/WebDAV.pm
index 9d23bb9..cfaa0ec 100644
--- a/perl/Sesse/pr0n/WebDAV.pm
+++ b/perl/Sesse/pr0n/WebDAV.pm
@@ -466,7 +466,7 @@ EOF
 					
 				$dbh->do('INSERT INTO images (id,event,uploadedby,takenby,filename) VALUES (?,?,?,?,?);',
 					undef, $newid, $event, $user, $takenby, $filename);
-				$dbh->do('UPDATE events SET last_update=CURRENT_TIMESTAMP WHERE event=?',
+				$dbh->do('UPDATE events SET last_update=CURRENT_TIMESTAMP WHERE id=?',
 					undef, $event);
 
 				# Now save the file to disk