Mailing List Archive

works for me
--- 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
Re: works for me [ In reply to ]
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
Re: works for me [ In reply to ]
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