You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Note the <limit><nresults>100</nresults></limit> part which requests max. 100 results.
Nextcloud returns this 500 Internal server error:
<d:error xmlns:d="DAV:" xmlns:s="http://sabredav.org/ns">
<s:exception>Doctrine\DBAL\Exception\SyntaxErrorException</s:exception>
<s:message>An exception occurred while executing 'SELECT `uri`, `operation` FROM `oc_addressbookchanges` WHERE `synctoken` >= ? AND `synctoken` < ? AND `addressbookid` = ? ORDER BY `synctoken` `LIMIT` 100' with params ["5", "8", "6"]:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`LIMIT` 100' at line 1</s:message>
</d:error>
Also, when requesting an initial sync (no sync-token) with limit nresults=100, the server sends all results without batching. Instead, it should send 507.
When truncation occurs, the DAV:sync-token value returned in the
response MUST represent the correct state for the partial set of
changes returned. That allows the client to use the returned
DAV:sync-token to fetch the next set of changes. In this way, the
client can effectively "page" through the entire set of changes in a
consistent manner.
Steps to reproduce
Note the
<limit><nresults>100</nresults></limit>
part which requests max. 100 results.Also, when requesting an initial sync (no sync-token) with limit nresults=100, the server sends all results without batching. Instead, it should send 507.
Expected behaviour
Nextcloud should return either up to 100 results, or, if this is not supported, HTTP 507 and an appropriate postcondition error code, see RFC 6578 3.12 Example: DAV:sync-collection Report with Unsupported Limit
Server configuration
Nextcloud version: 13.0.2
Signing status: No errors have been found.
Nextcloud configuration:
Config report
Are you using encryption: no
The text was updated successfully, but these errors were encountered: