sabre-io/Baikal

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

lordrak007 opened this issue · 2 comments

lordrak007 commented

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| <D:sync-collection xmlns:D="DAV:"><D:sync-token /><D:prop><D:getetag /><D:getcontenttype /></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|
<d:error xmlns:d="DAV:" xmlns:s="http://sabredav.org/ns">
<s:sabredav-version>4.5.0</s:sabredav-version>
<s:exception>PDOException</s:exception>
<s:message>SQLSTATE[HY000]: General error: 1 too many SQL variables</s:message>
</d:error>

Steps to reproduce:

install baikal with SQLite (no upgrade), create user, setup EM-client (address https://baikal.domain.cz/html/dav.php/)

lordrak007 commented

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

lordrak007 commented

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