Hello,
currently i see some strange error messages inside my Egroupware server logs. I think this might be the reason for CardDAV not working anymore - always getting HTTP 500 on sync.
I have never seen before such an ORDER BY clause… This setup uses an local installation of Mysql server, not a containerized one.
2024/01/19 11:38:49 [error] 25#25: *2906 FastCGI sent in stderr: "PHP message: Datenbank Fehler (EGroupware\Api\Db\Exception\InvalidSql): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY list_owner<>8,list_name' at line 1 (1064);
PHP message: File: /api/src/Db.php, Line: 828;
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(2294): EGroupware\Api\Db\Deprecated->query();
PHP message: #2 /usr/share/egroupware/api/src/Contacts/Sql.php(805): EGroupware\Api\Db->select();
PHP message: #3 /usr/share/egroupware/api/src/Contacts/Storage.php(1221): EGroupware\Api\Contacts\Sql->get_lists();
PHP message: #4 /usr/share/egroupware/addressbook/inc/class.addressbook_groupdav.inc.php(386): EGroupware\Api\Contacts\Storage->read_lists();
PHP message: #5 /usr/share/egroupware/api/src/WebDAV/Server.php(792): addressbook_groupdav->propfind_generator();
PHP message: #6 /usr/share/egroupware/api/src/WebDAV/Server.php(755): HTTP_WebDAV_Server->multistatus_responses();
PHP message: #7 /usr/share/egroupware/api/src/CalDAV.php(1033): HTTP_WebDAV_Server->http_PROPFIND();
PHP message: #8 /usr/share/egroupware/api/src/WebDAV/Server.php(304): EGroupware\Api\CalDAV->http_REPORT();
PHP message: #9 /usr/share/egroupware/api/src/CalDAV.php(2358): HTTP_WebDAV_Server->ServeRequest();
PHP message: #10 /usr/share/egroupware/groupdav.php(43): EGroupware\Api\CalDAV->ServeRequest();
PHP message: #11 {main};
PHP message: # Instance=xxxx, User=stefan, Request=REPORT https://xxxx/egroupware/groupdav.php/stefan/addressbook/, User-agent=Mozilla/5.0 (X11; Linux x86_64; rv:115.0) Gecko/20100101 Thunderbird/115.6.0" while reading response header from upstream,
client: 172.19.0.1,
server: _,
request: "REPORT /egroupware/groupdav.php/stefan/addressbook/ HTTP/1.1",
upstream: "fastcgi://172.21.0.4:9000", host: "xxx"
Server with Debian, EGroupware installed via your DEB packages running in Docker.
This log is from the “egroupware-nginx” container. Ther is no error message in the “egroupware” container.
$ apt show egroupware-docker
Package: egroupware-docker
Version: 23.1.20230314-1
$ apt show mariadb-server
Package: mariadb-server
Version: 1:10.5.21-0+deb11u1
$ apt show base-files
Package: base-files
Version: 11.1+deb11u8
The same problem existed with a MariaDB 10.3 before, just updated to 10.5 to check if this strange ORDER By clause might be some new feature not present in older MariaDB version.
Best regards,
Stefan
