You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

[0ktav1us]

Hello, I can't create group, please help; mysql Ver 8.0.20-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu)) PHP 7.4.3 (cli) (built: May 26 2020 12:24:22) ( NTS ) PHP 7.4.3 (cli) (built: May 26 2020 12:24:22) ( NTS )

[Tue Jul 14 15:51:29.248120 2020] [php7:warn] [pid 85779] [client 192.168.0.3:46664] PHP Warning:  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups WHERE gid="1000"' at line 1 in /var/www/proftpd/includes/ez_sql_mysqli.php on line 272, referer: http://192.168.0.3/proftpd/add_group.php
[Tue Jul 14 15:51:29.248154 2020] [php7:notice] [pid 85779] [client 192.168.0.3:46664] PHP Notice:  Trying to access array offset on value of type null in /var/www/proftpd/includes/ez_sql_core.php on line 170, referer: http://192.168.0.3/proftpd/add_group.php
[Tue Jul 14 15:51:29.248264 2020] [php7:warn] [pid 85779] [client 192.168.0.3:46664] PHP Warning:  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups (groupname,gid,members) VALUES ("admins","1000","")' at line 1 in /var/www/proftpd/includes/ez_sql_mysqli.php on line 272, referer: `http://192.168.0.3/proftpd/add_group.php`

[LiskoFINAL]

I have this problem too. Also after manually injecting a group, it isn't seen in webif and can't create any user. Ubuntu 20.04 x64

[LiskoFINAL]

I just switched from mysql to mariadb in my Ubuntu 20.04 server setup and all is working fine now. I had the syntax issue even with proftpd alone, now it's all back to normal.