Mailing List Archive

Author: gbechis
Date: Mon Mar 20 07:53:49 2023
New Revision: 1908549

URL: http://svn.apache.org/viewvc?rev=1908549&view=rev
Log:
fix sql syntax, from Benny Pedersen

Modified:
spamassassin/trunk/lib/Mail/SpamAssassin/Plugin/DecodeShortURLs.pm

Modified: spamassassin/trunk/lib/Mail/SpamAssassin/Plugin/DecodeShortURLs.pm
URL: http://svn.apache.org/viewvc/spamassassin/trunk/lib/Mail/SpamAssassin/Plugin/DecodeShortURLs.pm?rev=1908549&r1=1908548&r2=1908549&view=diff
==============================================================================
--- spamassassin/trunk/lib/Mail/SpamAssassin/Plugin/DecodeShortURLs.pm (original)
+++ spamassassin/trunk/lib/Mail/SpamAssassin/Plugin/DecodeShortURLs.pm Mon Mar 20 07:53:49 2023
@@ -593,7 +593,7 @@ sub initialise_url_shortener_cache {
");
$self->{sth_delete} = $self->{dbh}->prepare("
DELETE FROM short_url_cache
- WHERE short_url ? = AND created < CAST(EXTRACT(epoch FROM NOW()) AS INT) - $conf->{url_shortener_cache_ttl}
+ WHERE short_url = ? AND created < CAST(EXTRACT(epoch FROM NOW()) AS INT) - $conf->{url_shortener_cache_ttl}
");
$self->{sth_clean} = $self->{dbh}->prepare("
DELETE FROM short_url_cache