$dbh->do('INSERT INTO images (id,event,uploadedby,takenby,filename) VALUES (?,?,?,?,?);',
undef, $newid, $event, $user, $takenby, $filename);
- $dbh->do('UPDATE images 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
$dbh->do('DELETE FROM images WHERE event=? AND filename=?;',
undef, $event, $filename)
or dberror($r, "Couldn't remove file");
- $dbh->do('UPDATE images SET last_update=CURRENT_TIMESTAMP WHERE event=?',
+ $dbh->do('UPDATE events SET last_update=CURRENT_TIMESTAMP WHERE id=?',
undef, $event)
or dberror($r, "Couldn't invalidate cache");
$r->status(200);