Unable to upload file to root dir atfer Update to 29.0.3

I am getting the following error when upload a file direct to root:

Fehler beim Hochladen: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ‘)) AND (sh.parent IS NULL)’ at line 1

[/details]

Nextcloud version 29.0.3
Operating system and version (eg, Ubuntu 29.04): 22.04
Apache or nginx version (eg, Apache 2.4.25): Apache 2.4.59
PHP version (eg, 8.3): 8.2
mariaDB 10.6.18

Is this the first time you’ve seen this error? (Y/N):y

Steps to replicate it:

  1. Upload a single file to root dir

The output of your Nextcloud log in Admin > Logging:

SyntaxErrorException An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ')) AND (`sh`.`parent` IS NULL)' at line 1

Can you provide the full raw log entry?

I confirm the issue on 27.1.11.
Below requested log enrty:

,“app”:“webdav”,“method”:“PUT”,“url”:“/remote.php/webdav/6iovzc.jpg”,“message”:“An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ‘)) AND (sh.parent IS NULL)’ at line 1”,“userAgent”:“Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0”,“version”:“27.1.11.3”,“exception”:{“Exception”:“Sabre\DAV\Exception”,“Message”:“An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ‘)) AND (sh.parent IS NULL)’ at line 1”,“Code”:0,“Trace”:[{“file”:“/var/www/nextcloud/apps/dav/lib/Connector/Sabre/File.php”,“line”:318,“function”:“convertToSabreException”,“class”:“OCA\DAV\Connector\Sabre\File”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php”,“line”:149,“function”:“put”,“class”:“OCA\DAV\Connector\Sabre\File”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:1098,“function”:“createFile”,“class”:“OCA\DAV\Connector\Sabre\Directory”,“type”:“->”,“args”:[“*** sensitive parameters replaced “]},{“file”:”/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",“line”:504,“function”:“createFile”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[" sensitive parameters replaced “]},{“file”:”/var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",“line”:89,“function”:“httpPut”,“class”:“Sabre\DAV\CorePlugin”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:472,“function”:“emit”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:253,“function”:“invokeMethod”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:321,“function”:“start”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/dav/appinfo/v1/webdav.php”,“line”:85,“function”:“exec”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/remote.php”,“line”:172,“args”:[“/var/www/nextcloud/apps/dav/appinfo/v1/webdav.php”],“function”:“require_once”}],“File”:“/var/www/nextcloud/apps/dav/lib/Connector/Sabre/File.php”,“Line”:755,“Previous”:{“Exception”:“Doctrine\DBAL\Exception\SyntaxErrorException”,“Message”:“An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ‘)) AND (sh.parent IS NULL)’ at line 1”,“Code”:1064,“Trace”:[{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1814,“function”:“convert”,“class”:“Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1749,“function”:“handleDriverException”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1055,“function”:“convertExceptionDuringQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/Connection.php”,“line”:267,“function”:“executeQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php”,“line”:345,“function”:“executeQuery”,“class”:“OC\DB\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:280,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php”,“line”:1046,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php”,“line”:942,“function”:“getRows”,“class”:“OCA\Circles\Tools\Db\ExtendedQueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequestBuilder.php”,“line”:120,“function”:“asItems”,“class”:“OCA\Circles\Tools\Db\ExtendedQueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequest.php”,“line”:298,“function”:“getItemsFromRequest”,“class”:“OCA\Circles\Db\ShareWrapperRequestBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/Service/ShareWrapperService.php”,“line”:204,“function”:“getSharesByFileIds”,“class”:“OCA\Circles\Db\ShareWrapperRequest”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/ShareByCircleProvider.php”,“line”:664,“function”:“getSharesByFileIds”,“class”:“OCA\Circles\Service\ShareWrapperService”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Share20/Manager.php”,“line”:1789,“function”:“getAccessList”,“class”:“OCA\Circles\ShareByCircleProvider”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Encryption/File.php”,“line”:100,“function”:“getAccessList”,“class”:“OC\Share20\Manager”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Files/Stream/Encryption.php”,“line”:282,“function”:“getAccessList”,“class”:“OC\Encryption\File”,“type”:“->”},{“function”:“stream_open”,“class”:“OC\Files\Stream\Encryption”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Files/Stream/Encryption.php”,“line”:212,“function”:“fopen”},{“file”:“/var/www/nextcloud/lib/private/Files/Stream/Encryption.php”,“line”:187,“function”:“wrapSource”,“class”:“OC\Files\Stream\Encryption”,“type”:“::”},{“file”:“/var/www/nextcloud/lib/private/Files/Storage/Wrapper/Encryption.php”,“line”:483,“function”:“wrap”,“class”:“OC\Files\Stream\Encryption”,“type”:“::”},{“file”:“/var/www/nextcloud/lib/private/Files/Storage/Wrapper/Encryption.php”,“line”:1089,“function”:“fopen”,“class”:“OC\Files\Storage\Wrapper\Encryption”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php”,“line”:653,“function”:“writeStream”,“class”:“OC\Files\Storage\Wrapper\Encryption”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/dav/lib/Connector/Sabre/File.php”,“line”:248,“function”:“writeStream”,“class”:“OC\Files\Storage\Wrapper\Wrapper”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php”,“line”:149,“function”:“put”,“class”:“OCA\DAV\Connector\Sabre\File”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:1098,“function”:“createFile”,“class”:“OCA\DAV\Connector\Sabre\Directory”,“type”:“->”,“args”:[" sensitive parameters replaced “]},{“file”:”/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",“line”:504,“function”:“createFile”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[" sensitive parameters replaced “]},{“file”:”/var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",“line”:89,“function”:“httpPut”,“class”:“Sabre\DAV\CorePlugin”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:472,“function”:“emit”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:253,“function”:“invokeMethod”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:321,“function”:“start”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/dav/appinfo/v1/webdav.php”,“line”:85,“function”:“exec”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/remote.php”,“line”:172,“args”:[“/var/www/nextcloud/apps/dav/appinfo/v1/webdav.php”],“function”:“require_once”}],“File”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php”,“Line”:88,“Previous”:{“Exception”:“Doctrine\DBAL\Driver\PDO\Exception”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1064 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 ‘)) AND (sh.parent IS NULL)’ at line 1”,“Code”:1064,“Trace”:[{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php”,“line”:103,“function”:“new”,“class”:“Doctrine\DBAL\Driver\PDO\Exception”,“type”:“::”},{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1045,“function”:“execute”,“class”:“Doctrine\DBAL\Driver\PDO\Statement”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/Connection.php”,“line”:267,“function”:“executeQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php”,“line”:345,“function”:“executeQuery”,“class”:“OC\DB\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:280,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php”,“line”:1046,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php”,“line”:942,“function”:“getRows”,“class”:“OCA\Circles\Tools\Db\ExtendedQueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequestBuilder.php”,“line”:120,“function”:“asItems”,“class”:“OCA\Circles\Tools\Db\ExtendedQueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequest.php”,“line”:298,“function”:“getItemsFromRequest”,“class”:“OCA\Circles\Db\ShareWrapperRequestBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/Service/ShareWrapperService.php”,“line”:204,“function”:“getSharesByFileIds”,“class”:“OCA\Circles\Db\ShareWrapperRequest”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/ShareByCircleProvider.php”,“line”:664,“function”:“getSharesByFileIds”,“class”:“OCA\Circles\Service\ShareWrapperService”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Share20/Manager.php”,“line”:1789,“function”:“getAccessList”,“class”:“OCA\Circles\ShareByCircleProvider”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Encryption/File.php”,“line”:100,“function”:“getAccessList”,“class”:“OC\Share20\Manager”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Files/Stream/Encryption.php”,“line”:282,“function”:“getAccessList”,“class”:“OC\Encryption\File”,“type”:“->”},{“function”:“stream_open”,“class”:“OC\Files\Stream\Encryption”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Files/Stream/Encryption.php”,“line”:212,“function”:“fopen”},{“file”:“/var/www/nextcloud/lib/private/Files/Stream/Encryption.php”,“line”:187,“function”:“wrapSource”,“class”:“OC\Files\Stream\Encryption”,“type”:“::”},{“file”:“/var/www/nextcloud/lib/private/Files/Storage/Wrapper/Encryption.php”,“line”:483,“function”:“wrap”,“class”:“OC\Files\Stream\Encryption”,“type”:“::”},{“file”:“/var/www/nextcloud/lib/private/Files/Storage/Wrapper/Encryption.php”,“line”:1089,“function”:“fopen”,“class”:“OC\Files\Storage\Wrapper\Encryption”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php”,“line”:653,“function”:“writeStream”,“class”:“OC\Files\Storage\Wrapper\Encryption”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/dav/lib/Connector/Sabre/File.php”,“line”:248,“function”:“writeStream”,“class”:“OC\Files\Storage\Wrapper\Wrapper”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php”,“line”:149,“function”:“put”,“class”:“OCA\DAV\Connector\Sabre\File”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:1098,“function”:“createFile”,“class”:“OCA\DAV\Connector\Sabre\Directory”,“type”:“->”,“args”:[" sensitive parameters replaced “]},{“file”:”/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",“line”:504,“function”:“createFile”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[" sensitive parameters replaced “]},{“file”:”/var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",“line”:89,“function”:“httpPut”,“class”:“Sabre\DAV\CorePlugin”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:472,“function”:“emit”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:253,“function”:“invokeMethod”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:321,“function”:“start”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/dav/appinfo/v1/webdav.php”,“line”:85,“function”:“exec”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/remote.php”,“line”:172,“args”:[“/var/www/nextcloud/apps/dav/appinfo/v1/webdav.php”],“function”:“require_once”}],“File”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php”,“Line”:30,“Previous”:{“Exception”:“PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1064 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 ‘)) AND (sh.parent IS NULL)’ at line 1”,“Code”:“42000”,“Trace”:[{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php”,“line”:101,“function”:“execute”,“class”:“PDOStatement”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1045,“function”:“execute”,“class”:“Doctrine\DBAL\Driver\PDO\Statement”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/Connection.php”,“line”:267,“function”:“executeQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php”,“line”:345,“function”:“executeQuery”,“class”:“OC\DB\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:280,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php”,“line”:1046,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php”,“line”:942,“function”:“getRows”,“class”:“OCA\Circles\Tools\Db\ExtendedQueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequestBuilder.php”,“line”:120,“function”:“asItems”,“class”:“OCA\Circles\Tools\Db\ExtendedQueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequest.php”,“line”:298,“function”:“getItemsFromRequest”,“class”:“OCA\Circles\Db\ShareWrapperRequestBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/Service/ShareWrapperService.php”,“line”:204,“function”:“getSharesByFileIds”,“class”:“OCA\Circles\Db\ShareWrapperRequest”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/circles/lib/ShareByCircleProvider.php”,“line”:664,“function”:“getSharesByFileIds”,“class”:“OCA\Circles\Service\ShareWrapperService”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Share20/Manager.php”,“line”:1789,“function”:“getAccessList”,“class”:“OCA\Circles\ShareByCircleProvider”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Encryption/File.php”,“line”:100,“function”:“getAccessList”,“class”:“OC\Share20\Manager”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Files/Stream/Encryption.php”,“line”:282,“function”:“getAccessList”,“class”:“OC\Encryption\File”,“type”:“->”},{“function”:“stream_open”,“class”:“OC\Files\Stream\Encryption”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Files/Stream/Encryption.php”,“line”:212,“function”:“fopen”},{“file”:“/var/www/nextcloud/lib/private/Files/Stream/Encryption.php”,“line”:187,“function”:“wrapSource”,“class”:“OC\Files\Stream\Encryption”,“type”:“::”},{“file”:“/var/www/nextcloud/lib/private/Files/Storage/Wrapper/Encryption.php”,“line”:483,“function”:“wrap”,“class”:“OC\Files\Stream\Encryption”,“type”:“::”},{“file”:“/var/www/nextcloud/lib/private/Files/Storage/Wrapper/Encryption.php”,“line”:1089,“function”:“fopen”,“class”:“OC\Files\Storage\Wrapper\Encryption”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php”,“line”:653,“function”:“writeStream”,“class”:“OC\Files\Storage\Wrapper\Encryption”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/dav/lib/Connector/Sabre/File.php”,“line”:248,“function”:“writeStream”,“class”:“OC\Files\Storage\Wrapper\Wrapper”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php”,“line”:149,“function”:“put”,“class”:“OCA\DAV\Connector\Sabre\File”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:1098,“function”:“createFile”,“class”:“OCA\DAV\Connector\Sabre\Directory”,“type”:“->”,“args”:[" sensitive parameters replaced “]},{“file”:”/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",“line”:504,“function”:“createFile”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[" sensitive parameters replaced ***”]},{“file”:“/var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php”,“line”:89,“function”:“httpPut”,“class”:“Sabre\DAV\CorePlugin”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:472,“function”:“emit”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:253,“function”:“invokeMethod”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:321,“function”:“start”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/dav/appinfo/v1/webdav.php”,“line”:85,“function”:“exec”,“class”:“Sabre\DAV\Server”,“type”:“->”},{“file”:“/var/www/nextcloud/remote.php”,“line”:172,“args”:[“/var/www/nextcloud/apps/dav/appinfo/v1/webdav.php”],“function”:“require_once”}],“File”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php”,“Line”:101}}},“message”:“An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ‘)) AND (sh.parent IS NULL)’ at line 1”,“exception”:{},“CustomMessage”:“An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ‘)) AND (sh.parent IS NULL)’ at line 1”}}

Just short update. Looks like the app causing the issue is Circles so you can disable it until fix is released.

1 Like

Bug tracking here: https://github.com/nextcloud/server/issues/46196
PR with fix pending merger here if anyone wishes to test: [Bug]: SQL syntax error when upgrading from NC 29.0.2 to 29.0.3 · Issue #46196 · nextcloud/server · GitHub

This topic was automatically closed 8 days after the last reply. New replies are no longer allowed.