--- core/DecodeShortURLs.pm 2022-12-14 07:03:20.000000000 +0100
+++ patch/DecodeShortURLs.pm 2023-01-29 21:50:51.576660227 +0100
@@ -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
+++ patch/DecodeShortURLs.pm 2023-01-29 21:50:51.576660227 +0100
@@ -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