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

2021-09-06 Thread 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.00)

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



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

2021-09-06 Thread Philipp Ewald

Package: proftpd-mod-pgsql
Version: 1.3.7a+dfsg-12


as in "https://github.com/proftpd/proftpd/issues/1149; wrote there is a Systax 
error.


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.00)


There are already patches but maybe not ready when bullseye released?



Kind regards
Philipp Ewald


--
Philipp Ewald
Administrator

DigiOnline GmbH, Probsteigasse 15 - 19, 50670 Köln
Fax: +49 221 6500-690, E-Mail: philipp.ew...@digionline.de

AG Köln HRB 27711, St.-Nr. 5215 5811 0640
Geschäftsführer: Werner Grafenhain

Informationen zum Datenschutz: www.digionline.de/ds