Fatal webdav Doctrine\DBAL\DBALException

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version (eg, 20.0.5): 20.0.8
Operating system and version (eg, Ubuntu 20.04): Ubuntu 20.04.2 LTS
Apache or nginx version (eg, Apache 2.4.25): Apache/2.4.41 (Ubuntu)
PHP version (eg, 7.4): PHP 7.4.3

The issue you are facing:
When reviewing the log in Settings - Administration - Logging, I see the following fatal exception:

Fatal webdav Doctrine\DBAL\DBALException: An exception occurred while executing ‘INSERT INTO oc_properties (userid,propertypath,propertyname,propertyvalue) VALUES(?,?,?,?)’ with params [“xxxxxx”, “addressbooks/users/xxxxxx”, “{http://calendarserver.org/ns/}me-card”, {}]: Object of class Sabre\DAV\Xml\Property\Href could not be converted to string

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

Steps to replicate it:

  1. I am not sure what is triggering it. It may have to do with adding calendar events in Apple Calendar synced to NC.

The output of your Nextcloud log in Admin > Logging:

Fatal	webdav	Doctrine\DBAL\DBALException: An exception occurred while executing 'INSERT INTO `oc_properties` (`userid`,`propertypath`,`propertyname`,`propertyvalue`) VALUES(?,?,?,?)' with params ["xxxxxx", "addressbooks\/users\/xxxxxx", "{http:\/\/calendarserver.org\/ns\/}me-card", {}]: Object of class Sabre\DAV\Xml\Property\Href could not be converted to string

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'instanceid' => 'xxxx',
  'passwordsalt' => 'xxx',
  'secret' => 'xxx',
  'trusted_domains' => 
  array (
    0 => 'nextcloud.example.com',
  ),
  'datadirectory' => '/var/www/nextcloud-data/',
  'dbtype' => 'mysql',
  'version' => '20.0.8.1',
  'overwrite.cli.url' => 'https://nextcloud.example.com',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost:3306',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'xxx',
  'dbpassword' => 'xxx',
  'installed' => true,
  'mail_smtpmode' => 'smtp',
  'mail_sendmailmode' => 'pipe',
  'mail_from_address' => 'xxx',
  'mail_domain' => 'example.com',
  'mail_smtpauth' => 1,
  'mail_smtphost' => 'localhost',
  'mail_smtpport' => '1025',
  'mail_smtpname' => 'xxx@example.com',
  'mail_smtppassword' => 'xxx',
  'mail_smtptimeout' => 30,
  'remember_login_cookie_lifetime' => 1296000,
  'session_lifetime' => 2700,
  'session_keepalive' => false,
  'auto_logout' => true,
  'memcache.distributed' => '\\OC\\Memcache\\Redis',
  'memcache.local' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' => 
  array (
    'host' => 'localhost',
    'port' => 6379,
  ),
  'maintenance' => false,
  'updater.release.channel' => 'stable',
  'theme' => '',
  'loglevel' => 2,
);

The output of your Apache/nginx/system log in /var/log/____:

PASTE HERE

I am still having this issue. Can anyone please help? I have now upgraded to latest NC… the error log reads:

{"reqId":"doX3uLeFEYuq6KkirIT2","level":4,"time":"2021-06-06T16:27:49+00:00","remoteAddr":"192.168.1.100","user":"xxxxxx","app":"webdav","method":"PROPPATCH","url":"/remote.php/dav/addressbooks/users/xxxxxx/","message":{"Exception":"Error","Message":"Object of class Sabre\\DAV\\Xml\\Property\\Href could not be converted to string","Code":0,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":82,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1138,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":257,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1747,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":236,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php","line":75,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/apps/dav/lib/DAV/CustomPropertiesBackend.php","line":270,"function":"executeUpdate","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud/apps/dav/lib/DAV/CustomPropertiesBackend.php","line":148,"function":"updateProperties","class":"OCA\\DAV\\DAV\\CustomPropertiesBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/PropPatch.php","line":288,"function":"OCA\\DAV\\DAV\\{closure}","class":"OCA\\DAV\\DAV\\CustomPropertiesBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/PropPatch.php","line":227,"function":"doCallBackMultiProp","class":"Sabre\\DAV\\PropPatch","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1263,"function":"commit","class":"Sabre\\DAV\\PropPatch","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":373,"function":"updateProperties","class":"Sabre\\DAV\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropPatch","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/lib/Server.php","line":332,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/remote.php","line":167,"args":["/var/www/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":82,"CustomMessage":"--"},"userAgent":"Mac OS X/10.15.7 (19H1217) AddressBookCore/1","version":"21.0.2.1"}