search

sabre-io / Baikal

Baïkal is a Calendar+Contacts server
https://sabre.io/baikal/
GNU General Public License v3.0
2.42k stars 281 forks source link

Database error SQLSTATE[HY000]: General error: 1 too many SQL variables #1245

Closed lordrak007 closed 3 months ago

lordrak007 commented 3 months ago

Baikal version: 0.9.4

Expected behaviour: working without error

Current behaviour: setup EM-client as client but i does not working. In the log file i found SynchronizeItemsCommand executing on ( /d3cd3557-7af7-4e63-9473-0074feed87fe/1/0) 07:57:25.808|024| Request: 07:57:25.808|024| Method: REPORT, RequestUri: 'https://baikal.domain.cz/html/dav.php/addressbooks/myuser/0/', Version: 1.1, Content: System.Net.Http.StreamContent, Headers: 07:57:25.808|024| { 07:57:25.809|024| Accept: text/xml 07:57:25.809|024| Brief: t 07:57:25.809|024| Depth: 1 07:57:25.809|024| User-Agent: eMClient/9.2.2157.0 07:57:25.809|024| Content-Type: text/xml; charset=utf-8 07:57:25.809|024| } 07:57:25.809|024| <?xml version="1.0" encoding="utf-8"?></D:prop></D:sync-collection> 07:57:25.809|024|
07:57:25.809|024| Response: 07:57:25.881|025| StatusCode: 500, ReasonPhrase: 'Internal Server Error', Version: 1.1, Content: System.Net.Http.HttpConnectionResponseContent, Headers: 07:57:25.881|025| { 07:57:25.881|025| Date: Tue, 19 Mar 2024 06:57:25 GMT 07:57:25.881|025| Server: Apache 07:57:25.881|025| Cache-Control: no-store, no-cache, must-revalidate 07:57:25.881|025| Pragma: no-cache 07:57:25.882|025| X-Sabre-Version: 4.5.0 07:57:25.882|025| Vary: User-Agent 07:57:25.882|025| Connection: close 07:57:25.882|025| Transfer-Encoding: chunked 07:57:25.882|025| Expires: Thu, 19 Nov 1981 08:52:00 GMT 07:57:25.882|025| Content-Type: application/xml; charset=utf-8 07:57:25.882|025| } 07:57:25.882|025| <?xml version="1.0" encoding="utf-8"?>

4.5.0 PDOException SQLSTATE[HY000]: General error: 1 too many SQL variables **Steps to reproduce**: install baikal with SQLite (no upgrade), create user, setup EM-client (address https://baikal.domain.cz/html/dav.php/)
lordrak007 commented 3 months ago

I captured packet how to simulate in fiddler, every time i run this request i got the error abowe

REPORT http://baikal.domain.cz/html/dav.php/addressbooks/myuser/0/ HTTP/1.1 Host: baikal.server.cz Accept: text/xml Brief: t Depth: 1 User-Agent: eMClient/9.2.2157.0 Accept-Encoding: gzip, deflate Authorization: Basic bWAyZds6Nzd3X2ptzZI= Cookie: PHPSESSID=b2e7f2fccc8f5fd026481bd92ccfe2e7 Content-Type: text/xml; charset=utf-8 Content-Length: 158

<?xml version="1.0" encoding="utf-8"?></D:prop></D:sync-collection>

lordrak007 commented 3 months ago

Ok, probably some limit on php vs sqlite. After migration to MariaDB (MySQL) problem is solved.