Mailing List Archive: Error message when creating groups

Error message when creating groups

Apr 26, 2023, 3:27 AM

Post #1 of 3 (263 views)

Hello everyone,
I can create groups in the admin panel, but when I call up the group page
(https://calendar.example.de/admin.php?action=edit&t=principal&id=1019)
I get this error message under "Group membership":

Exception [42601] SQLSTATE[42601]: Syntax error: 7 FEHLER: Müll folgt
auf numerische Konstante bei »1019O«
ZEILE 1: ...member WHERE group_id = 1019) AND principal_id != 1019ORDER ...
^
At line 95 of /usr/share/awl/inc/AwlDatabase.php
================= Stack Trace ===================
/usr/share/davical/htdocs/admin.php[50] Browser->Render()
/usr/share/awl/inc/classBrowser.php[852] edit_group_row()
/usr/share/davical/inc/ui/principal-edit.php[591] Editor->Render()
/usr/share/awl/inc/classEditor.php[669] preg_replace_callback()
[0] Editor->ReplaceEditorPart()
/usr/share/awl/inc/classEditor.php[597] EntryField::BuildOptionList()
/usr/share/awl/inc/DataEntry.php[306] AwlQuery->Exec()
/usr/share/awl/inc/AwlQuery.php[585] AwlQuery->Execute()
/usr/share/awl/inc/AwlQuery.php[396] AwlDatabase->query()
/usr/share/awl/inc/AwlDatabase.php[95] PDO->query()
and I am unable to add users to groups.

there are also the following error messages in the Davical error log

2023/04/26 11:38:59 [error] 330989#330989: *17 FastCGI sent in stderr:
"PHP message: PHP Early Exception: [42601] SQLSTATE[42601]: Syntax
error: 7 FEHLER: Müll folgt auf numerische Konstante bei »1019O«
ZEILE 1: ...member WHERE group_id = 1019) AND principal_id != 1019ORDER ...
^ at /usr/share/awl/inc/AwlDatabase.php:95" while reading upstream,
client: 192.168.100.2, server: calendar.example.de, request: "GET
/admin.php?action=edit&t=principal&id=1019 HTTP/2.0", upstream:
"fastcgi://unix:/run/php/php8.1-fpm.sock:", host:
"calendar.example.de"

The postgresql error log says:

2023-04-26 11:59:29.228 CEST [333501] davical_app@davical ANWEISUNG:
SELECT principal_id, coalesce(displayname,fullname,username) FROM
dav_principal WHERE principal_id NOT IN (SELECT member_id FROM
group_member WHERE group_id = 1019) AND principal_id != 1019ORDER BY 2
I checked the php8.1-fpm.sock, both in the www.conf and in the
corresponding nginx config the link to the socket is correct.
The php8.1.-fpm.sock is available, user rights and owner seem to be
set correctly.
Maybe I missed something, or is there an error in the postgresql database?
Can anybody help me further?

Thanks!

Re: Error message when creating groups [ In reply to ]

hiernemo at gmail

Apr 26, 2023, 5:33 AM

Post #2 of 3 (262 views)

Permalink

there seems to be a bug in davical see:
https://stackoverflow.com/questions/76109931/adding-groups-in-davical-lead-to-errors

Am Mi., 26. Apr. 2023 um 12:27 Uhr schrieb Nikolas Weber <hiernemo@gmail.com
>:

> Hello everyone,
> I can create groups in the admin panel, but when I call up the group page
> (https://calendar.example.de/admin.php?action=edit&t=principal&id=1019)
> I get this error message under "Group membership":
>
> Exception [42601] SQLSTATE[42601]: Syntax error: 7 FEHLER: Müll folgt auf numerische Konstante bei »1019O«
> ZEILE 1: ...member WHERE group_id = 1019) AND principal_id != 1019ORDER ...
> ^
> At line 95 of /usr/share/awl/inc/AwlDatabase.php
> ================= Stack Trace ===================
> /usr/share/davical/htdocs/admin.php[50] Browser->Render()
> /usr/share/awl/inc/classBrowser.php[852] edit_group_row()
> /usr/share/davical/inc/ui/principal-edit.php[591] Editor->Render()
> /usr/share/awl/inc/classEditor.php[669] preg_replace_callback()
> [0] Editor->ReplaceEditorPart()
> /usr/share/awl/inc/classEditor.php[597] EntryField::BuildOptionList()
> /usr/share/awl/inc/DataEntry.php[306] AwlQuery->Exec()
> /usr/share/awl/inc/AwlQuery.php[585] AwlQuery->Execute()
> /usr/share/awl/inc/AwlQuery.php[396] AwlDatabase->query()
> /usr/share/awl/inc/AwlDatabase.php[95] PDO->query()
> and I am unable to add users to groups.
>
> there are also the following error messages in the Davical error log
>
> 2023/04/26 11:38:59 [error] 330989#330989: *17 FastCGI sent in stderr: "PHP message: PHP Early Exception: [42601] SQLSTATE[42601]: Syntax error: 7 FEHLER: Müll folgt auf numerische Konstante bei »1019O«
> ZEILE 1: ...member WHERE group_id = 1019) AND principal_id != 1019ORDER ...
> ^ at /usr/share/awl/inc/AwlDatabase.php:95" while reading upstream, client: 192.168.100.2, server: calendar.example.de, request: "GET /admin.php?action=edit&t=principal&id=1019 HTTP/2.0", upstream: "fastcgi://unix:/run/php/php8.1-fpm.sock:", host: "calendar.example.de"
>
> The postgresql error log says:
>
> 2023-04-26 11:59:29.228 CEST [333501] davical_app@davical ANWEISUNG: SELECT principal_id, coalesce(displayname,fullname,username) FROM dav_principal WHERE principal_id NOT IN (SELECT member_id FROM group_member WHERE group_id = 1019) AND principal_id != 1019ORDER BY 2
> I checked the php8.1-fpm.sock, both in the www.conf and in the corresponding nginx config the link to the socket is correct.
> The php8.1.-fpm.sock is available, user rights and owner seem to be set correctly.
> Maybe I missed something, or is there an error in the postgresql database?
> Can anybody help me further?
>
> Thanks!
>
>
>

Re: Error message when creating groups [ In reply to ]

andrew at etc

Apr 30, 2023, 3:52 AM

Post #3 of 3 (261 views)

Permalink

Hi Nikolas,

You're right!

I've fixed this in
commit https://gitlab.com/davical-project/davical/-/commit/e8f3a3e6f2c27e78c2778e0040b385b430dfc9fc
.

Thank you for raising this issue!

Cheers,
Andrew

On Wed, 2023-04-26 at 14:33 +0200, Nikolas Weber wrote:
> there seems to be a bug in davical see:
> https://stackoverflow.com/questions/76109931/adding-groups-in-davical-lead-to-errors
>
> Am Mi., 26. Apr. 2023 um 12:27 Uhr schrieb Nikolas Weber
> <hiernemo@gmail.com>:
> > Hello everyone,
> > I can create groups in the admin panel, but when I call up the group page
> > (https://calendar.example.de/admin.php?action=edit&t=principal&id=1019)
> > I get this error message under "Group membership":
> >
> > Exception [42601] SQLSTATE[42601]: Syntax error: 7 FEHLER: Müll folgt auf numerische Konstante bei »1019O«
> > ZEILE 1: ...member WHERE group_id = 1019) AND principal_id != 1019ORDER ...
> > ^
> > At line 95 of /usr/share/awl/inc/AwlDatabase.php
> > ================= Stack Trace ===================
> > /usr/share/davical/htdocs/admin.php[50] Browser->Render()
> > /usr/share/awl/inc/classBrowser.php[852] edit_group_row()
> > /usr/share/davical/inc/ui/principal-edit.php[591] Editor->Render()
> > /usr/share/awl/inc/classEditor.php[669] preg_replace_callback()
> > [0] Editor->ReplaceEditorPart()
> > /usr/share/awl/inc/classEditor.php[597] EntryField::BuildOptionList()
> > /usr/share/awl/inc/DataEntry.php[306] AwlQuery->Exec()
> > /usr/share/awl/inc/AwlQuery.php[585] AwlQuery->Execute()
> > /usr/share/awl/inc/AwlQuery.php[396] AwlDatabase->query()
> > /usr/share/awl/inc/AwlDatabase.php[95] PDO->query()
> >
> > and I am unable to add users to groups.
> >
> >
> > there are also the following error messages in the Davical error log
> > 2023/04/26 11:38:59 [error] 330989#330989: *17 FastCGI sent in stderr: "PHP message: PHP Early Exception: [42601] SQLSTATE[42601]: Syntax error: 7 FEHLER: Müll folgt auf numerische Konstante bei »1019O«
> > ZEILE 1: ...member WHERE group_id = 1019) AND principal_id != 1019ORDER ...
> > ^ at /usr/share/awl/inc/AwlDatabase.php:95" while reading upstream, client: 192.168.100.2, server: calendar.example.de, request: "GET /admin.php?action=edit&t=principal&id=1019 HTTP/2.0", upstream: "fastcgi://unix:/run/php/php8.1-fpm.sock:", host: "calendar.example.de"
> >
> >
> > The postgresql error log says:
> >
> > 2023-04-26 11:59:29.228 CEST [333501] davical_app@davical ANWEISUNG: SELECT principal_id, coalesce(displayname,fullname,username) FROM dav_principal WHERE principal_id NOT IN (SELECT member_id FROM group_member WHERE group_id = 1019) AND principal_id != 1019ORDER BY 2
> >
> > I checked the php8.1-fpm.sock, both in the www.conf and in the corresponding nginx config the link to the socket is correct.
> > The php8.1.-fpm.sock is available, user rights and owner seem to be set correctly.
> > Maybe I missed something, or is there an error in the postgresql database?
> > Can anybody help me further?
> > Thanks!
> >
> >
> _______________________________________________
> Davical-general mailing list
> Davical-general@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/davical-general

--
Andrew Ruthven, Wellington, New Zealand
andrew@etc.gen.nz |
Catalyst Cloud: | This space intentionally left blank
https://catalystcloud.nz |