Re: works for me

[Benny Pedersen]

Giovanni Bechis skrev den 2023-03-20 08:54:

On Sun, Mar 19, 2023 at 12:41:07PM +0100, Benny Pedersen wrote:

--- 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

Committed, thanks.
 Giovanni

confirmed