Can't delete users in proftpd admin

[danielezer]

HI,
When I try to delete a user in the proftpd admin web console, I get the following error:

Cannot remove user "test" from group ""; see log files for more information

Can you please advise?

[ChristianBeer]

It seems there is an empty additional group assigned to the user. Did you somehow delete a group that still had this user assigned?

[danielezer]

No, it is only in one group - and it still exists.

[danielezer]

I also get an error message when trying to update a user:

Can you tell me where those logs are?

[danielezer]

The only thing I see in stdout is this:

[ChristianBeer]

Which DB interface do you use? SQlite? I still haven't tested this recently.

[danielezer]

I’m using MySQL

[ChristianBeer]

Strange. I don't see those errors on my test system. Can you check that your DB schema matches with your config.php file?

[danielezer]

It does. Everything but deleting and updating the users works - I can create a user and I can login with it, and I can also see the current users

[danielezer]

any thoughts?

[ChristianBeer]

I don't have a clue as I can't reproduce the problem.

[doreplado]

I have the same issue with updating or deleting users. It started after I added ez_sql_mysqli.php because I switched to php 7.2 and traditional mysql drivers are deprecated.

[Fri Jun 22 22:50:44.906270 2018] [core:notice] [pid 82] AH00094: Command line: '/usr/sbin/apache2 -D FOREGROUND'
[Fri Jun 22 22:52:46.302138 2018] [php7:notice] [pid 84] [client 10.42.115.18:43880] PHP Notice:  Array to string conversion in /var/www/proftpd/add_user.php on line 202, referer: https://ftp.mysite.com/users.php
[Fri Jun 22 22:53:35.242427 2018] [php7:notice] [pid 85] [client 10.42.115.18:44606] PHP Notice:  Undefined index: ad_gid in /var/www/proftpd/add_user.php on line 142, referer: https://ftp.mysite.com/add_user.php
[Fri Jun 22 22:53:35.242582 2018] [php7:warn] [pid 85] [client 10.42.115.18:44606] PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /var/www/proftpd/add_user.php on line 204, referer: https://ftp.mysite.com/add_user.php
[Fri Jun 22 22:53:35.242593 2018] [php7:warn] [pid 85] [client 10.42.115.18:44606] PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /var/www/proftpd/add_user.php on line 204, referer: https://ftp.mysite.com/add_user.php
[Fri Jun 22 22:53:35.242598 2018] [php7:warn] [pid 85] [client 10.42.115.18:44606] PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /var/www/proftpd/add_user.php on line 204, referer: https://ftp.mysite.com/add_user.php
[Fri Jun 22 22:53:58.927630 2018] [php7:notice] [pid 83] [client 10.42.115.18:44976] PHP Notice:  Undefined index: ad_gid in /var/www/proftpd/edit_user.php on line 176, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46
[Fri Jun 22 22:53:58.927779 2018] [php7:warn] [pid 83] [client 10.42.115.18:44976] PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /var/www/proftpd/edit_user.php on line 303, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46
[Fri Jun 22 22:53:58.927790 2018] [php7:warn] [pid 83] [client 10.42.115.18:44976] PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /var/www/proftpd/edit_user.php on line 303, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46
[Fri Jun 22 22:53:58.927795 2018] [php7:warn] [pid 83] [client 10.42.115.18:44976] PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /var/www/proftpd/edit_user.php on line 303, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46
[Fri Jun 22 22:54:14.947371 2018] [php7:notice] [pid 84] [client 10.42.115.18:45230] PHP Notice:  Undefined index: ad_gid in /var/www/proftpd/edit_user.php on line 176, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46
[Fri Jun 22 22:54:14.947518 2018] [php7:warn] [pid 84] [client 10.42.115.18:45230] PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /var/www/proftpd/edit_user.php on line 303, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46
[Fri Jun 22 22:54:14.947530 2018] [php7:warn] [pid 84] [client 10.42.115.18:45230] PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /var/www/proftpd/edit_user.php on line 303, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46
[Fri Jun 22 22:54:14.947535 2018] [php7:warn] [pid 84] [client 10.42.115.18:45230] PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /var/www/proftpd/edit_user.php on line 303, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46
[Fri Jun 22 22:54:37.691727 2018] [php7:notice] [pid 99] [client 10.42.115.18:45564] PHP Notice:  Undefined index: ad_gid in /var/www/proftpd/edit_user.php on line 176, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46
[Fri Jun 22 22:54:37.691930 2018] [php7:warn] [pid 99] [client 10.42.115.18:45564] PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /var/www/proftpd/edit_user.php on line 303, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46
[Fri Jun 22 22:54:37.691942 2018] [php7:warn] [pid 99] [client 10.42.115.18:45564] PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /var/www/proftpd/edit_user.php on line 303, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46
[Fri Jun 22 22:54:37.691947 2018] [php7:warn] [pid 99] [client 10.42.115.18:45564] PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /var/www/proftpd/edit_user.php on line 303, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46
[Fri Jun 22 23:02:36.670863 2018] [php7:notice] [pid 99] [client 10.42.115.18:52872] PHP Notice:  Undefined variable: ggroup in /var/www/proftpd/remove_user.php on line 44, referer: https://ftp.mysite.com/remove_user.php?action=remove&id=46
[Fri Jun 22 23:03:00.376260 2018] [php7:notice] [pid 85] [client 10.42.115.18:53238] PHP Notice:  Undefined index: ad_gid in /var/www/proftpd/edit_user.php on line 176, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46
[Fri Jun 22 23:03:00.376454 2018] [php7:warn] [pid 85] [client 10.42.115.18:53238] PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /var/www/proftpd/edit_user.php on line 303, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46
[Fri Jun 22 23:03:00.376466 2018] [php7:warn] [pid 85] [client 10.42.115.18:53238] PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /var/www/proftpd/edit_user.php on line 303, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46
[Fri Jun 22 23:03:00.376471 2018] [php7:warn] [pid 85] [client 10.42.115.18:53238] PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /var/www/proftpd/edit_user.php on line 303, referer: https://ftp.mysite.com/edit_user.php?action=show&id=46

Currently trying to identify why ad_gid is null and not an array. Will update if I make any progress.

[doreplado]

All resolved for me. I didn't see that the project updated support for mysqli so I just redeployed with latest master using mysqli / php7.2 and all is well.

[OlafV83]

I have problems adding new users. Edit users who have been manually added through MySQL works and also adding new groups.

[php7:warn] [pid 13143] [client IP:6007] PHP Warning: array_key_exists() expects parameter 2 to be array, null given in /var/www/html/ftpadmin/add_user.php on line 212, referer: /add_user.php

I'm using Ubuntu 18.04 with PHP7.2

[spunkthpunkt]

I don't have a clue as I can't reproduce the problem.

We did have the same Problem. When u create a user TEST an then a User TEST_T or RWF and RWF_QSS then u get the error. The same is, User TEST an 2nd user TESTTEST. U cant change the user RWF or TEST When u delete the user RWF_QSS or TESTEST then all works fine. We Using Ubuntu 18.04 with PHP 7.2