Hello,
I meet a problem whith egroupware 20.1 and postgres 11.13 with the apps group.
When i tried to delete group or account, i have an error message:
egroupware-nginx | 2021/10/11 11:38:46 [error] 23#23: *1924 FastCGI sent in stderr: "PHP message: Erreur de base de données (EGroupware\Api\Db\Exception\InvalidSql): Invalid SQL: DELETE FROM egw_addressbook_shared WHERE 0
egroupware-nginx | ERROR: argument of WHERE must be type boolean, not type integer
egroupware-nginx | LINE 1: DELETE FROM egw_addressbook_shared WHERE 0
egroupware-nginx | ^ (-1)
PHP message: #0 /usr/share/egroupware/api/src/Db/Deprecated.php(64): EGroupware\Api\Db->query()
PHP message: #1 /usr/share/egroupware/api/src/Db.php(2053): EGroupware\Api\Db\Deprecated->query()
PHP message: #2 /usr/share/egroupware/api/src/Contacts/Sql.php(1166): EGroupware\Api\Db->delete()
PHP message: #3 /usr/share/egroupware/api/src/Contacts/Storage.php(974): EGroupware\Api\Contacts\Sql->delete()
PHP message: #4 /usr/share/egroupware/api/src/Contacts.php(1942): EGroupware\Api\Contacts\Storage->deleteaccount()
PHP message: #5 /usr/share/egroupware/api/src/loader/deprecated_factory.php(131): EGroupware\Api\Contacts->deleteaccount()
PHP message: #6 /usr/share/egroupware/api/src/Hooks.php(143): ExecMethod2()
PHP message: #7 /usr/share/egroupware/admin/inc/class.admin_cmd_delete_account.inc.php(211): EGroupware\Api\Hooks::single()
PHP message: #8 /usr/share/egroupware/admin/inc/class.admin_cmd_delete_account.inc.php(73): admin_cmd_delete_account->delete_account()
PHP message: #9 /usr/share/egroupware/admin/inc/class.admin_cmd.inc.php(239): admin_cmd_delete_account->exec()
PHP message: #10 /usr/share/egroupware/admin/inc/class.admin_account.inc.php(396): admin_cmd->run()
PHP message: #11 [internal function]: admin_account::ajax_delete_group()
PHP message: #12 /usr/share/egroupware/api/src/Json/Request.php(194): call_user_func_array()
PHP message: #13 /usr/share/egroupware/api/src/Json/Request.php(104): EGroupware\Api\Json\Request->handleRequest()
PHP message: #14 /usr/share/egroupware/json.php(125): EGroupware\Api\Json\Request->parseRequest()
PHP message: #15
This problem exist with postgres 9.4, 10.5 too. The same behavior with user accounts and addressbook.
Do you know this problem?
How resolve this please?
Thank you
