My owncloud 10.6 server got php packages upgraded from 7.4.16 to 7.4.18 by the nightly ‘yum update’ process. After that requests to the database stated to fail.
Expected behaviour
database requests should work
Actual behaviour
Tell us what happens instead
the web interface displays the “Directory not available” message
and postgres server logs
< 2021-04-29 08:57:09.670 CEST > ERROR: operator does not exist: character varying = integer at character 124
< 2021-04-29 08:57:09.670 CEST > HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
< 2021-04-29 08:57:09.670 CEST > STATEMENT: SELECT "object_id" AS "id", COUNT("object_id") AS "count" FROM "oc_comments" c WHERE ("object_type" = $1) AND ("object_id" IN ($2, $3, $4, $5)) AND ("object_id" NOT IN (SELECT "
object_id" FROM "oc_comments_read_markers" crm WHERE (crm."user_id" = $6) AND (crm."marker_datetime" >= c."creation_timestamp") AND (c."object_id" = crm."object_id"))) GROUP BY "object_id"
Reverting (yum downgrade) to php 7.4.16 packages fixes the server.
Server configuration
Operating system:
CentOS Linux release 7.9.2009 (Core)
Web server:
Server version: Apache/2.4.6 (CentOS)
Server built: Nov 16 2020 16:18:20
Database:
postgres (PostgreSQL) 9.6.21
PHP version:
7.4.18
ownCloud version: (see ownCloud admin page)
10.6.0
Updated from an older ownCloud or fresh install:
Updated from olfer verson
Where did you install ownCloud from:
soruce tarball
Signing status (ownCloud 9.0 and above):
No errors have been found.
The content of config/config.php:
{
"basic": {
"license key": "***REMOVED SENSITIVE VALUE***",
"date": "Thu, 29 Apr 2021 14:54:41 +0000",
"ownCloud version": "10.6.0.5",
"ownCloud version string": "10.6.0",
"ownCloud edition": "Community",
"server OS": "Linux",
"server OS version": "Linux wellington 3.10.0-1160.24.1.el7.x86_64 #1 SMP Thu Apr 8 19:51:47 UTC 2021 x86_64",
"server SAPI": "apache2handler",
"webserver version": "Apache\/2.4.6 (CentOS) OpenSSL\/1.0.2k-fips PHP\/7.4.16",
"hostname": "cloud.laas.fr",
"logged-in user": "root"
},
"stats": {
"users": {
"LDAP": {
"count": 998,
"seen": 592,
"logged in (30 days)": 285
},
"Database": {
"count": 1,
"seen": 1,
"logged in (30 days)": 1
}
},
"groups": {
"OC\\Group\\Database": 1,
"OCA\\User_LDAP\\Group_Proxy": 277
}
},
"config": {
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"datadirectory": "\/owncloud\/data",
"dbtype": "pgsql",
"version": "10.6.0.5",
"dbname": "clouddb",
"dbhost": "localhost:\/var\/run\/postgresql\/.s.PGSQL.5432",
"dbtableprefix": "oc_",
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"ldapIgnoreNamingRules": false,
"theme": "",
"logfile": "\/owncloud\/data\/owncloud.log",
"loglevel": 2,
"log_rotate_size": 104857600,
"log_authfailip": true,
"instanceid": "50b52a8c63484",
"maintenance": false,
"forcessl": true,
"trusted_domains": [
"cloud.laas.fr",
"bespin.laas.fr"
],
"share_folder": "\/Shared",
"mail_smtpmode": "smtp",
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"singleuser": false,
"has_internet_connection": true,
"filelocking.enabled": true,
"memcache.local": "\\OC\\Memcache\\APCu",
"redis": {
"host": "\/var\/run\/redis\/redis.sock",
"port": 0,
"password": "***REMOVED SENSITIVE VALUE***"
},
"memcache.locking": "\\OC\\Memcache\\Redis",
"trashbin_retention_obligation": "auto, 90",
"appstore.experimental.enabled": true,
"integrity.ignore.missing.app.signature": [
"theme-laas"
]
},
"integritychecker": {
"passing": true,
"enabled": true,
"result": []
},
"core": {
"installedat": "1340978856.2958",
"remote_ampache": "media\/remote.php",
"remote_core.css": "\/core\/minimizer.php",
"remote_core.js": "\/core\/minimizer.php",
"remote_filesync": "files\/appinfo\/filesync.php",
"public_documents": "documents\/public.php",
"remote_contactthumbnail": "contacts\/thumbnail.php",
"public_shorty_relay": "shorty\/relay.php",
"public_shorty_qrcode": "shorty\/qrcode.php",
"public_shorty_query": "shorty\/query.php",
"backgroundjobs_mode": "cron",
"public_calendar": "calendar\/share.php",
"public_caldav": "calendar\/share.php",
"public_files": "files_sharing\/public.php",
"public_gallery": "gallery\/public.php",
"shareapi_enforce_expire_date": "no",
"repairlegacystoragesdone": "yes",
"backgroundjobs_step": "queued_tasks",
"umgmt_show_storage_location": "true",
"remote_files": "dav\/appinfo\/v1\/webdav.php",
"remote_contacts": "dav\/appinfo\/v1\/carddav.php",
"remote_carddav": "dav\/appinfo\/v1\/carddav.php",
"remote_calendar": "dav\/appinfo\/v1\/caldav.php",
"remote_caldav": "dav\/appinfo\/v1\/caldav.php",
"public_webdav": "dav\/appinfo\/v1\/publicwebdav.php",
"shareapi_expire_after_n_days": "15",
"backgroundjobs_task": "",
"outgoing_server2server_share_enabled": "no",
"shareapi_allow_resharing": "no",
"shareapi_allow_mail_notification": "yes",
"shareapi_enforce_links_password_read_only": "***REMOVED SENSITIVE VALUE***",
"vendor": "owncloud",
"OC_Channel": "stable",
"shareapi_default_expire_date": "yes",
"umgmt_show_backend": "true",
"global_cache_gc_lastrun": "1441897202",
"shareapi_allow_public_notification": "yes",
"incoming_server2server_share_enabled": "yes",
"shareapi_enforce_links_password_read_write": "***REMOVED SENSITIVE VALUE***",
"shareapi_enforce_links_password_write_only": "***REMOVED SENSITIVE VALUE***",
"updater.secret.created": "1609869671",
"remote_webdav": "dav\/appinfo\/v1\/webdav.php",
"remote_dav": "dav\/appinfo\/v2\/remote.php",
"lastcron": "1619707516",
"lastupdatedat": "1619706433",
"lastupdateResult": "{\"version\":\"10.7.0\",\"versionstring\":\"ownCloud 10.7.0\",\"url\":\"https:\\\/\\\/download.owncloud.org\\\/community\\\/owncloud-10.7.0.zip\",\"web\":\"https:\\\/\\\/doc.owncloud.org\\\/server\\\/10.6\\\/admin_manual\\\/maintenance\\\/upgrade.html\"}"
},
/* ... redacted... */
"phpinfo": {
"apache2handler": {
"Apache Version": "Apache\/2.4.6 (CentOS) OpenSSL\/1.0.2k-fips PHP\/7.4.16",
"Apache API Version": "20120211",
"Server Administrator": "root@localhost",
"Hostname:Port": "cloud.laas.fr:0",
"User\/Group": "apache(48)\/48",
"Max Requests": "Per Child: 0 - Keep Alive: on - Max Per Connection: 100",
"Timeouts": "Connection: 60 - Keep-Alive: 5",
"Virtual Server": "Yes",
"Server Root": "\/etc\/httpd",
"Loaded Modules": "core mod_so http_core mod_access_compat mod_actions mod_alias mod_allowmethods mod_auth_basic mod_auth_digest mod_authn_anon mod_authn_core mod_authn_dbd mod_authn_dbm mod_authn_file mod_authn_socache mod_authz_core mod_authz_dbd mod_authz_dbm mod_authz_groupfile mod_authz_host mod_authz_owner mod_authz_user mod_autoindex mod_cache mod_cache_disk mod_data mod_dbd mod_deflate mod_dir mod_dumpio mod_echo mod_env mod_expires mod_ext_filter mod_filter mod_headers mod_include mod_info mod_log_config mod_logio mod_mime_magic mod_mime mod_negotiation mod_remoteip mod_reqtimeout mod_rewrite mod_setenvif mod_slotmem_plain mod_slotmem_shm mod_socache_dbm mod_socache_memcache mod_socache_shmcb mod_status mod_substitute mod_suexec mod_unique_id mod_unixd mod_userdir mod_version mod_vhost_alias mod_dav mod_dav_fs mod_dav_lock mod_lua prefork mod_proxy mod_lbmethod_bybusyness mod_lbmethod_byrequests mod_lbmethod_bytraffic mod_lbmethod_heartbeat mod_proxy_ajp mod_proxy_balancer mod_proxy_connect mod_proxy_express mod_proxy_fcgi mod_proxy_fdpass mod_proxy_ftp mod_proxy_http mod_proxy_scgi mod_proxy_wstunnel mod_ssl mod_systemd mod_cgi mod_php7 mod_xsendfile",
"engine": "1",
"last_modified": "0",
"xbithack": "0"
},
}
List of activated apps:
Enabled:
- calendar: 1.6.4
- comments: 0.3.0
- configreport: 0.2.0
- contacts: 1.5.5
- dav: 0.6.0
- federatedfilesharing: 0.5.0
- federation: 0.1.0
- files: 1.5.2
- files_external: 0.7.1
- files_pdfviewer: 0.12.1
- files_sharing: 0.14.0
- files_trashbin: 0.9.1
- files_videoplayer: 0.10.1
- firstrunwizard: 1.2.0
- gallery: 16.1.1
- impersonate: 0.5.0
- market: 0.6.0
- notifications: 0.5.2
- provisioning_api: 0.5.0
- systemtags: 0.3.0
- tasks: 0.9.7
- theme-laas: 1.0.2
- updatenotification: 0.2.1
- user_ldap: 0.15.2
Disabled:
- encryption
- external
- files_mediaviewer
- files_versions
- user_external
Are you using external storage, if yes which one: local/smb/sftp/…
no
Are you using encryption: yes/no
no
Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/…
yes LDAP
LDAP configuration (delete this part if not used)
+-------------------------------+--------------------------------------+
| Configuration | |
+-------------------------------+--------------------------------------+
| hasMemberOfFilterSupport | |
| hasPagedResultSupport | |
| homeFolderNamingRule | |
| lastJpegPhotoLookup | 0 |
| ldapAgentName | |
| ldapAgentPassword | *** |
| ldapAttributesForGroupSearch | |
| ldapAttributesForUserSearch | cn;uid |
| ldapBackupHost | |
| ldapBackupPort | 389 |
| ldapBase | dc=laas,dc=fr |
| ldapBaseGroups | ou=groups,dc=laas,dc=fr |
| ldapBaseUsers | ou=users,dc=laas,dc=fr |
| ldapCacheTTL | 600 |
| ldapConfigurationActive | 1 |
| ldapDynamicGroupMemberURL | |
| ldapEmailAttribute | laas-mainMail |
| ldapExperiencedAdmin | 0 |
| ldapExpertUUIDGroupAttr | entryuuid |
| ldapExpertUUIDUserAttr | entryuuid |
| ldapExpertUsernameAttr | uid |
| ldapGroupDisplayName | cn |
| ldapGroupFilter | (&(|(objectclass=laas-group))) |
| ldapGroupFilterGroups | |
| ldapGroupFilterMode | 0 |
| ldapGroupFilterObjectclass | laas-group |
| ldapGroupMemberAssocAttr | memberUid |
| ldapHost | ldap.laas.fr |
| ldapIgnoreNamingRules | |
| ldapLoginFilter | (&(objectclass=laas-user)(uid=%uid)) |
| ldapLoginFilterAttributes | |
| ldapLoginFilterEmail | 1 |
| ldapLoginFilterMode | 1 |
| ldapLoginFilterUsername | 1 |
| ldapNestedGroups | 0 |
| ldapNetworkTimeout | 2 |
| ldapOverrideMainServer | 0 |
| ldapPagingSize | 500 |
| ldapPort | 389 |
| ldapQuotaAttribute | 35GB |
| ldapQuotaDefault | |
| ldapTLS | 1 |
| ldapUserDisplayName | uid |
| ldapUserDisplayName2 | |
| ldapUserFilter | (|(objectclass=laas-user)) |
| ldapUserFilterGroups | |
| ldapUserFilterMode | 1 |
| ldapUserFilterObjectclass | laas-user |
| ldapUserName | samaccountname |
| ldapUuidGroupAttribute | auto |
| ldapUuidUserAttribute | auto |
| turnOffCertCheck | 0 |
| useMemberOfToDetectMembership | 1 |
+-------------------------------+--------------------------------------+
Client configuration
Browser:
Firefox 88.0
Operating system:
Linux Ubuntu 20.04
Logs
Web server error log
Insert your webserver log here
ownCloud log (data/owncloud.log)
{"reqId":"YIpYxbPqq7OeL0@3olX1gQAAAB0","level":4,"time":"2021-04-29T06:57:09+00:00","remoteAddr":"140.93.9.233","user":"marribat","app":"webdav","method":"PROPFIND","url":"/remote.php/dav/files/marribat/PartageGabinMathieu","message":"Exception: An exception occurred while executing 'SELECT "object_id" AS "id", COUNT("object_id") AS "count" FROM "oc_comments" c WHERE ("object_type" = ?) AND ("object_id" IN (?, ?, ?, ?)) AND ("object_id" NOT IN (SELECT "object_id" FROM "oc_comments_read_markers" crm WHERE (crm."user_id" = ?) AND (crm."marker_datetime" >= c."creation_timestamp") AND (c."object_id" = crm."object_id"))) GROUP BY "object_id"' with params ["files", 19040197, 19046758, 19042384, 19048301, "marribat"]: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = integer LINE 1: ...ts" c WHERE ("object_type" = $1) AND ("object_id" IN ($2, $3...^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.: {"Exception":"Doctrine\DBAL\Exception\DriverException","Message":"An exception occurred while executing 'SELECT "object_id" AS "id", COUNT("object_id") AS "count" FROM "oc_comments" c WHERE ("object_type" = ?) AND ("object_id" IN (?, ?, ?, ?)) AND ("object_id" NOT IN (SELECT "object_id" FROM "oc_comments_read_markers" crm WHERE (crm."user_id" = ?) AND (crm."marker_datetime" >= c."creation_timestamp") AND (c."object_id" = crm."object_id"))) GROUP BY "object_id"' with params ["files", 19040197, 19046758, 19042384, 19048301, "marribat"]: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = integer
LINE 1: ...ts" c WHERE ("object_type" = $1) AND ("object_id" IN ($2, $3...^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.","Code":0,"Trace":"
#0 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(172): D\
octrine\DBAL\Driver\AbstractPostgreSQLDriver->convertException()
#1 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(151): Doctrine\DBAL\DBALException::wrapException()
#2 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(918): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
#3 /var/www/owncloud/lib/private/DB/Connection.php(187): Doctrine\DBAL\Connection->executeQuery()
#4 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(207): OC\DB\Connection->executeQuery()
#5 /var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\QueryBuilder->execute()
#6 /var/www/owncloud/lib/private/Comments/Manager.php(411): OC\DB\QueryBuilder\QueryBuilder->execute()
#7 /var/www/owncloud/apps/dav/lib/Connector/Sabre/CommentPropertiesPlugin.php(114): OC\Comments\Manager->getNumberOfUnreadCommentsForNodes()
#8 /var/www/owncloud/lib/composer/sabre/event/lib/WildcardEmitterTrait.php(89): OCA\DAV\Connector\Sabre\CommentPropertiesPlugin->handleGetProperties()
#9 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(1052): Sabre\DAV\Server->emit()
#10 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(984): Sabre\DAV\Server->getPropertiesByNode()
#11 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(1661): Sabre\DAV\Server->getPropertiesIteratorForPath()
#12 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(1646): Sabre\DAV\Server->writeMultiStatus()
#13 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/CorePlugin.php(346): Sabre\DAV\Server->generateMultiStatus()
#14 /var/www/owncloud/lib/composer/sabre/event/lib/WildcardEmitterTrait.php(89): Sabre\DAV\CorePlugin->httpPropFind()
#15 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(472): Sabre\DAV\Server->emit()
#16 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(253): Sabre\DAV\Server->invokeMethod()
#17 /var/www/owncloud/apps/dav/lib/Server.php(330): Sabre\DAV\Server->start()
#18 /var/www/owncloud/apps/dav/appinfo/v2/remote.php(31): OCA\DAV\Server->exec()
#19 /var/www/owncloud/remote.\
php(165): require_once('/var/www/ownclo...')
#20 {main}","File":"/var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php","Line":89}"}
{"reqId":"YIpYxbPqq7OeL0@3olX1gQAAAB0","level":4,"time":"2021-04-29T06:57:09+00:00","remoteAddr":"140.93.9.233","user":"marribat","app":"webdav","method":"PROPFIND","url":"/remote.php/dav/files/marribat/PartageGabinMathieu","message":"Caused by: {"Exception":"Doctrine\DBAL\Driver\PDOException","Message":"SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = integer
LINE 1: ...ts" c WHERE ("object_type" = $1) AND ("object_id" IN ($2, $3...^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.","Code":"42883","Trace":"
#0 /var/www/owncloud/lib/co\
mposer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(906): Doctrine\DBAL\Driver\PDOStatement->execute()
#1 /var/www/owncloud/lib/private/DB/Connection.php(187): Doctrine\DBAL\Connection->executeQuery()
#2 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(207): OC\DB\Connection->executeQuery()
#3 /var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\QueryBuilder->execute()
#4 /var/www/owncloud/lib/private/Comments/Manager.php(411): OC\DB\QueryBuilder\QueryBuilder->execute()
#5 /var/www/owncloud/apps/dav/lib/Connector/Sabre/CommentPropertiesPlugin.php(114): OC\Comments\Manager->getNumberOfUnreadCommentsForNodes()
#6 /var/www/owncloud/lib/composer/sabre/event/lib/WildcardEmitterTrait.php(89): OCA\DAV\Connector\Sabre\CommentPropertiesPlugin->handleGetProperties()
#7 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(1052): Sabre\DAV\Server->emit()
#8 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(984): Sabre\DAV\Server->getPropertiesByNode()
#9 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(1661): Sabre\DAV\Server->getPropertiesIteratorForPath()
#10 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(1646): Sabre\DAV\Server->writeMultiStatus()
#11 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/CorePlugin.php(346): Sabre\DAV\Server->generateMultiStatus()
#12 /var/www/owncloud/lib/composer/sabre/event/lib/WildcardEmitterTrait.php(89): Sabre\DAV\CorePlugin->httpPropFind()
#13 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(472): Sabre\DAV\Server->emit()
#14 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(253): Sabre\DAV\Server->invokeMethod()
#15 /var/www/owncloud/apps/dav/lib/Server.php(330): Sabre\DAV\Server->start()
#16 /var/www/owncloud/apps/dav/appinfo/v2/remote.php(31): OCA\DAV\Server->exec()
#17 /var/www/owncloud/remote.php(165): require_once('/var/www/ownclo...')
#18 {main}","File":"/var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":131}"}
{"reqId":"YIpYxbPqq7OeL0@3olX1gQAAAB0","level":4,"time":"2021-04-29T06:57:09+00:00","remoteAddr":"140.93.9.233","user":"marribat","app":"webdav","method":"PROPFIND","url":"/remote.php/dav/files/marribat/PartageGabinMathieu","message":"Caused by: {"Exception":"PDOException","Message":"SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = integer
LINE 1: ...ts" c WHERE ("object_type" = $1) AND ("object_id" IN ($2, $3...^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.","Code":"42883","Trace":"
#0 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(129): PDOStatement->execute()
#1 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(906): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/owncloud/lib/private/DB/Connection.php(187): Doctrine\DBAL\Connection->executeQuery()
#3 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(207): OC\DB\Connection->executeQuery()
#4 /var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /var/www/owncloud/lib/private/Comments/Manager.php(411): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /var/www/owncloud/apps/dav/lib/Connector/Sabre/CommentPropertiesPlugin.php(114): OC\Comments\Manager->getNumberOfUnreadCommentsForNodes()
#7 /var/www/owncloud/lib/composer/sabre/event/lib/WildcardEmitterTrait.php(89): OCA\DAV\Connector\Sabre\CommentPropertiesPlugin->handleGetProperties()
#8 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(1052): Sabre\DAV\Server->emit()
#9 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(984): Sabre\DAV\Server->getPropertiesByNode()
#10 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(1661): Sabre\DAV\Server->getPropertiesIteratorForPath()
#11 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(1646): Sabre\DAV\Server->writeMultiStatus()
#12 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/CorePlugin.php(346): Sabre\DAV\Server->generateMultiStatus()
#13 /var/www/owncloud/lib/composer/sabre/event/lib/WildcardEmitterTrait.php(89): Sabre\DAV\CorePlugin->httpPropFind()
#14 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(472): Sabre\DAV\Server->emit()
#15 /var/www/owncloud/lib/composer/sabre/dav/lib/DAV/Server.php(253): Sabre\DAV\Server->invokeMethod()
#16 /var/www/owncloud/apps/dav/lib/Server.php(330): Sabre\DAV\Server->start()
#17 /var/www/owncloud/apps/dav/appinfo/v2/remote.php(31): OCA\DAV\Server->exec()
#18 /var/www/owncloud/remote.php(165): require_once('/var/www/ownclo...')
#19 {main}","File":"/var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":129}"}
Browser log
Browser log
Insert your browser log here, this could for example include:
a) The javascript console log
b) The network log
c) ...
database log
< 2021-04-29 08:57:09.670 CEST > ERROR: operator does not exist: character varying = integer at character 124
< 2021-04-29 08:57:09.670 CEST > HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
< 2021-04-29 08:57:09.670 CEST > STATEMENT: SELECT "object_id" AS "id", COUNT("object_id") AS "count" FROM "oc_comments" c WHERE ("object_type" = $1) AND ("object_id" IN ($2, $3, $4, $5)) AND ("object_id" NOT IN (SELECT "object_id" FROM "oc_comments_read_m
arkers" crm WHERE (crm."user_id" = $6) AND (crm."marker_datetime" >= c."creation_timestamp") AND (c."object_id" = crm."object_id"))) GROUP BY "object_id"
< 2021-04-29 08:57:10.024 CEST > ERROR: operator does not exist: character varying = integer at character 124
< 2021-04-29 08:57:10.024 CEST > HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
< 2021-04-29 08:57:10.024 CEST > STATEMENT: SELECT "object_id" AS "id", COUNT("object_id") AS "count" FROM "oc_comments" c WHERE ("object_type" = $1) AND ("object_id" IN ($2, $3, $4, $5, $6, $7, $8)) AND ("object_id" NOT IN (SELECT "object_id" FROM "oc_com
ments_read_markers" crm WHERE (crm."user_id" = $9) AND (crm."marker_datetime" >= c."creation_timestamp") AND (c."object_id" = crm."object_id"))) GROUP BY "object_id"
< 2021-04-29 08:57:29.335 CEST > ERROR: operator does not exist: character varying = integer at character 124
