Bug#993784: SQL syntax errors in proftpd-mod-pgsql

[Hilmar Preuße]

On 9/6/21 2:32 PM, Philipp Ewald wrote:

Hi,

> as in "https://github.com/proftpd/proftpd/issues/1149" wrote there is a
> Systax error.
>
Patch has been applied to the repository, tagged pending.

> by trying to Insert there was adding extra single quotes.
>
> proftpd[4984] 127.0.0.1 (62.96.182.48[62.96.182.48]): mod_sql/4.5:
> unrecoverable backend error: (mod_sql_postgres/4.0.4) ERROR:  syntax
> error at or near "cms"
> LINE 1: INSERT INTO users_website_tallies VALUES (''cms'', 0.000000)
>
> There are already patches but maybe not ready when bullseye released?
>
Well, we could have applied the patch at that time. Unfortunately we
don't follow upstreams bug tracker, hence I wasn't aware of the issue.

Hilmar
--
#206401 http://counter.li.org