kesselb
commented
3 months ago Try to disable integration_whiteboard
Closed gdudas closed 3 months ago
kesselb
commented
3 months ago Try to disable integration_whiteboard
gdudas
commented
3 months ago I have disabled, but the issue is still present.
gdudas
commented
3 months ago {
"reqId": "mRimDF6Yav7oVnr4WC95",
"level": 3,
"time": "2024-06-26T20:11:26+00:00",
"remoteAddr": "***CENSORED***",
"user": "***CENSORED***",
"app": "webdav",
"method": "PROPFIND",
"url": "/remote.php/dav/files/***CENSORED***/",
"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 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36",
"version": "29.0.3.4",
"exception": {
"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/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1943,
"function": "convert",
"class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
"type": "->",
"args": [
[
"Doctrine\\DBAL\\Driver\\PDO\\Exception"
],
[
"Doctrine\\DBAL\\Query"
]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1885,
"function": "handleDriverException",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
[
"Doctrine\\DBAL\\Driver\\PDO\\Exception"
],
[
"Doctrine\\DBAL\\Query"
]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1106,
"function": "convertExceptionDuringQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
[
"Doctrine\\DBAL\\Driver\\PDO\\Exception"
],
"SELECT `sh`.`id`, `sh`.`share_type`, `sh`.`share_with`, `sh`.`uid_owner`, `sh`.`uid_initiator`, `sh`.`parent`, `sh`.`item_type`, `sh`.`item_source`, `sh`.`item_target`, `sh`.`file_source`, `sh`.`file_target`, `sh`.`permissions`, `sh`.`attributes`, `sh`.`stime`, `sh`.`accepted`, `sh`.`expiration`, `sh`.`token`, `sh`.`mail_send`, `sh_cc`.`unique_id` AS `sh_cc_unique_id`, `sh_cc`.`name` AS `sh_cc_name`, `sh_cc`.`display_name` AS `sh_cc_display_name`, `sh_cc`.`sanitized_name` AS `sh_cc_sanitized_name`, `sh_cc`.`source` AS `sh_cc_source`, `sh_cc`.`description` AS `sh_cc_description`, `sh_cc`.`settings` AS `sh_cc_settings`, `sh_cc`.`config` AS `sh_cc_config`, `sh_cc`.`contact_addressbook` AS `sh_cc_contact_addressbook`, `sh_cc`.`contact_groupname` AS `sh_cc_contact_groupname`, `sh_cc`.`creation` AS `sh_cc_creation`, `sh_cc_wn`.`circle_id` AS `sh_cc_wn_circle_id`, `sh_cc_wn`.`member_id` AS `sh_cc_wn_member_id`, `sh_cc_wn`.`single_id` AS `sh_cc_wn_single_id`, `sh_cc_wn`.`user_id` AS `sh_cc_wn_user_id`, `sh_cc_wn`.`instance` AS `sh_cc_wn_instance`, `sh_cc_wn`.`user_type` AS `sh_cc_wn_user_type`, `sh_cc_wn`.`level` AS `sh_cc_wn_level`, `sh_cc_wn`.`status` AS `sh_cc_wn_status`, `sh_cc_wn`.`note` AS `sh_cc_wn_note`, `sh_cc_wn`.`contact_id` AS `sh_cc_wn_contact_id`, `sh_cc_wn`.`cached_name` AS `sh_cc_wn_cached_name`, `sh_cc_wn`.`cached_update` AS `sh_cc_wn_cached_update`, `sh_cc_wn`.`contact_meta` AS `sh_cc_wn_contact_meta`, `sh_cc_wn`.`joined` AS `sh_cc_wn_joined` FROM `oc_share` `sh` LEFT JOIN `oc_circles_circle` `sh_cc` ON `sh_cc`.`unique_id` = `sh`.`share_with` LEFT JOIN `oc_circles_member` `sh_cc_wn` ON (`sh_cc_wn`.`circle_id` = `sh_cc`.`unique_id`) AND (`sh_cc_wn`.`level` = ?) WHERE (`sh`.`share_type` = ?) AND (()) AND (`sh`.`parent` IS NULL)",
[
9,
7
],
[
1,
1
]
]
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 328,
"function": "executeQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"SELECT `sh`.`id`, `sh`.`share_type`, `sh`.`share_with`, `sh`.`uid_owner`, `sh`.`uid_initiator`, `sh`.`parent`, `sh`.`item_type`, `sh`.`item_source`, `sh`.`item_target`, `sh`.`file_source`, `sh`.`file_target`, `sh`.`permissions`, `sh`.`attributes`, `sh`.`stime`, `sh`.`accepted`, `sh`.`expiration`, `sh`.`token`, `sh`.`mail_send`, `sh_cc`.`unique_id` AS `sh_cc_unique_id`, `sh_cc`.`name` AS `sh_cc_name`, `sh_cc`.`display_name` AS `sh_cc_display_name`, `sh_cc`.`sanitized_name` AS `sh_cc_sanitized_name`, `sh_cc`.`source` AS `sh_cc_source`, `sh_cc`.`description` AS `sh_cc_description`, `sh_cc`.`settings` AS `sh_cc_settings`, `sh_cc`.`config` AS `sh_cc_config`, `sh_cc`.`contact_addressbook` AS `sh_cc_contact_addressbook`, `sh_cc`.`contact_groupname` AS `sh_cc_contact_groupname`, `sh_cc`.`creation` AS `sh_cc_creation`, `sh_cc_wn`.`circle_id` AS `sh_cc_wn_circle_id`, `sh_cc_wn`.`member_id` AS `sh_cc_wn_member_id`, `sh_cc_wn`.`single_id` AS `sh_cc_wn_single_id`, `sh_cc_wn`.`user_id` AS `sh_cc_wn_user_id`, `sh_cc_wn`.`instance` AS `sh_cc_wn_instance`, `sh_cc_wn`.`user_type` AS `sh_cc_wn_user_type`, `sh_cc_wn`.`level` AS `sh_cc_wn_level`, `sh_cc_wn`.`status` AS `sh_cc_wn_status`, `sh_cc_wn`.`note` AS `sh_cc_wn_note`, `sh_cc_wn`.`contact_id` AS `sh_cc_wn_contact_id`, `sh_cc_wn`.`cached_name` AS `sh_cc_wn_cached_name`, `sh_cc_wn`.`cached_update` AS `sh_cc_wn_cached_update`, `sh_cc_wn`.`contact_meta` AS `sh_cc_wn_contact_meta`, `sh_cc_wn`.`joined` AS `sh_cc_wn_joined` FROM `oc_share` `sh` LEFT JOIN `oc_circles_circle` `sh_cc` ON `sh_cc`.`unique_id` = `sh`.`share_with` LEFT JOIN `oc_circles_member` `sh_cc_wn` ON (`sh_cc_wn`.`circle_id` = `sh_cc`.`unique_id`) AND (`sh_cc_wn`.`level` = ?) WHERE (`sh`.`share_type` = ?) AND (()) AND (`sh`.`parent` IS NULL)",
[
9,
7
],
[
1,
1
],
null
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line": 344,
"function": "executeQuery",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"SELECT `sh`.`id`, `sh`.`share_type`, `sh`.`share_with`, `sh`.`uid_owner`, `sh`.`uid_initiator`, `sh`.`parent`, `sh`.`item_type`, `sh`.`item_source`, `sh`.`item_target`, `sh`.`file_source`, `sh`.`file_target`, `sh`.`permissions`, `sh`.`attributes`, `sh`.`stime`, `sh`.`accepted`, `sh`.`expiration`, `sh`.`token`, `sh`.`mail_send`, `sh_cc`.`unique_id` AS `sh_cc_unique_id`, `sh_cc`.`name` AS `sh_cc_name`, `sh_cc`.`display_name` AS `sh_cc_display_name`, `sh_cc`.`sanitized_name` AS `sh_cc_sanitized_name`, `sh_cc`.`source` AS `sh_cc_source`, `sh_cc`.`description` AS `sh_cc_description`, `sh_cc`.`settings` AS `sh_cc_settings`, `sh_cc`.`config` AS `sh_cc_config`, `sh_cc`.`contact_addressbook` AS `sh_cc_contact_addressbook`, `sh_cc`.`contact_groupname` AS `sh_cc_contact_groupname`, `sh_cc`.`creation` AS `sh_cc_creation`, `sh_cc_wn`.`circle_id` AS `sh_cc_wn_circle_id`, `sh_cc_wn`.`member_id` AS `sh_cc_wn_member_id`, `sh_cc_wn`.`single_id` AS `sh_cc_wn_single_id`, `sh_cc_wn`.`user_id` AS `sh_cc_wn_user_id`, `sh_cc_wn`.`instance` AS `sh_cc_wn_instance`, `sh_cc_wn`.`user_type` AS `sh_cc_wn_user_type`, `sh_cc_wn`.`level` AS `sh_cc_wn_level`, `sh_cc_wn`.`status` AS `sh_cc_wn_status`, `sh_cc_wn`.`note` AS `sh_cc_wn_note`, `sh_cc_wn`.`contact_id` AS `sh_cc_wn_contact_id`, `sh_cc_wn`.`cached_name` AS `sh_cc_wn_cached_name`, `sh_cc_wn`.`cached_update` AS `sh_cc_wn_cached_update`, `sh_cc_wn`.`contact_meta` AS `sh_cc_wn_contact_meta`, `sh_cc_wn`.`joined` AS `sh_cc_wn_joined` FROM `oc_share` `sh` LEFT JOIN `oc_circles_circle` `sh_cc` ON `sh_cc`.`unique_id` = `sh`.`share_with` LEFT JOIN `oc_circles_member` `sh_cc_wn` ON (`sh_cc_wn`.`circle_id` = `sh_cc`.`unique_id`) AND (`sh_cc_wn`.`level` = :dcValue2) WHERE (`sh`.`share_type` = :dcValue1) AND (()) AND (`sh`.`parent` IS NULL)",
[
7,
9
],
[
1,
1
],
null
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line": 384,
"function": "executeQuery",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 280,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php",
"line": 1046,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php",
"line": 942,
"function": "getRows",
"class": "OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder",
"type": "->",
"args": [
[
[
"OCA\\Circles\\Db\\CoreQueryBuilder"
],
"parseSimpleSelectSql"
],
"OCA\\Circles\\Model\\ShareWrapper",
[]
]
},
{
"file": "/var/www/html/apps/circles/lib/Db/ShareWrapperRequestBuilder.php",
"line": 120,
"function": "asItems",
"class": "OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder",
"type": "->",
"args": [
"OCA\\Circles\\Model\\ShareWrapper"
]
},
{
"file": "/var/www/html/apps/circles/lib/Db/ShareWrapperRequest.php",
"line": 294,
"function": "getItemsFromRequest",
"class": "OCA\\Circles\\Db\\ShareWrapperRequestBuilder",
"type": "->",
"args": [
[
"OCA\\Circles\\Db\\CoreQueryBuilder"
]
]
},
{
"file": "/var/www/html/apps/circles/lib/Service/ShareWrapperService.php",
"line": 204,
"function": "getSharesByFileIds",
"class": "OCA\\Circles\\Db\\ShareWrapperRequest",
"type": "->",
"args": [
[],
true
]
},
{
"file": "/var/www/html/apps/circles/lib/ShareByCircleProvider.php",
"line": 664,
"function": "getSharesByFileIds",
"class": "OCA\\Circles\\Service\\ShareWrapperService",
"type": "->",
"args": [
[],
true
]
},
{
"file": "/var/www/html/lib/private/Share20/Manager.php",
"line": 1691,
"function": "getAccessList",
"class": "OCA\\Circles\\ShareByCircleProvider",
"type": "->",
"args": [
[],
false
]
},
{
"file": "/var/www/html/lib/private/Encryption/File.php",
"line": 100,
"function": "getAccessList",
"class": "OC\\Share20\\Manager",
"type": "->",
"args": [
[
"OC\\Files\\Node\\Folder"
]
]
},
{
"file": "/var/www/html/lib/private/Files/Stream/Encryption.php",
"line": 282,
"function": "getAccessList",
"class": "OC\\Encryption\\File",
"type": "->",
"args": [
"/***CENSORED***/files/Readme.md"
]
},
{
"function": "stream_open",
"class": "OC\\Files\\Stream\\Encryption",
"type": "->",
"args": [
"ocencryption://",
"r",
0,
null
]
},
{
"file": "/var/www/html/lib/private/Files/Stream/Encryption.php",
"line": 212,
"function": "fopen",
"args": [
"ocencryption://",
"r",
false,
null
]
},
{
"file": "/var/www/html/lib/private/Files/Stream/Encryption.php",
"line": 187,
"function": "wrapSource",
"class": "OC\\Files\\Stream\\Encryption",
"type": "::",
"args": [
null,
null,
"ocencryption",
"OC\\Files\\Stream\\Encryption",
"r"
]
},
{
"file": "/var/www/html/lib/private/Files/Storage/Wrapper/Encryption.php",
"line": 489,
"function": "wrap",
"class": "OC\\Files\\Stream\\Encryption",
"type": "::",
"args": [
null,
"files/Readme.md",
"/***CENSORED***/files/Readme.md",
[
"OC_DEFAULT_MODULE",
"AES-256-CTR",
"true"
],
"***CENSORED***",
[
"OCA\\Encryption\\Crypto\\Encryption"
],
[
"OC\\Files\\Storage\\Wrapper\\Quota",
null,
null,
null,
null,
null
],
[
"OC\\Files\\Storage\\Wrapper\\Encryption",
null,
null,
null,
null,
null
],
[
"OC\\Encryption\\Util"
],
[
"OC\\Encryption\\File"
],
"r",
8292,
1,
8192,
true
]
},
{
"file": "/var/www/html/lib/private/Files/Storage/Wrapper/Encryption.php",
"line": 236,
"function": "fopen",
"class": "OC\\Files\\Storage\\Wrapper\\Encryption",
"type": "->",
"args": [
"files/Readme.md",
"r"
]
},
{
"file": "/var/www/html/lib/private/Files/Storage/Wrapper/Wrapper.php",
"line": 253,
"function": "file_get_contents",
"class": "OC\\Files\\Storage\\Wrapper\\Encryption",
"type": "->",
"args": [
"files/Readme.md"
]
},
{
"file": "/var/www/html/apps/files_accesscontrol/lib/StorageWrapper.php",
"line": 169,
"function": "file_get_contents",
"class": "OC\\Files\\Storage\\Wrapper\\Wrapper",
"type": "->",
"args": [
"files/Readme.md"
]
},
{
"file": "/var/www/html/lib/private/Files/View.php",
"line": 1171,
"function": "file_get_contents",
"class": "OCA\\FilesAccessControl\\StorageWrapper",
"type": "->",
"args": [
"files/Readme.md"
]
},
{
"file": "/var/www/html/lib/private/Files/View.php",
"line": 584,
"function": "basicOperation",
"class": "OC\\Files\\View",
"type": "->",
"args": [
"file_get_contents",
"/***CENSORED***/files/Readme.md",
[
"read"
]
]
},
{
"file": "/var/www/html/lib/private/Files/Node/File.php",
"line": 54,
"function": "file_get_contents",
"class": "OC\\Files\\View",
"type": "->",
"args": [
"/***CENSORED***/files/Readme.md"
]
},
{
"file": "/var/www/html/apps/text/lib/DAV/WorkspacePlugin.php",
"line": 119,
"function": "getContent",
"class": "OC\\Files\\Node\\File",
"type": "->",
"args": []
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/PropFind.php",
"line": 95,
"function": "OCA\\Text\\DAV\\{closure}",
"class": "OCA\\Text\\DAV\\WorkspacePlugin",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/text/lib/DAV/WorkspacePlugin.php",
"line": 117,
"function": "handle",
"class": "Sabre\\DAV\\PropFind",
"type": "->",
"args": [
"{http://nextcloud.org/ns}rich-workspace",
[
"Closure"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
"line": 89,
"function": "propFind",
"class": "OCA\\Text\\DAV\\WorkspacePlugin",
"type": "->",
"args": [
[
"Sabre\\DAV\\PropFind"
],
[
"OCA\\DAV\\Files\\FilesHome"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1052,
"function": "emit",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"propFind",
[
[
"Sabre\\DAV\\PropFind"
],
[
"OCA\\DAV\\Files\\FilesHome"
]
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 984,
"function": "getPropertiesByNode",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Sabre\\DAV\\PropFind"
],
[
"OCA\\DAV\\Files\\FilesHome"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1662,
"function": "getPropertiesIteratorForPath",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"files/***CENSORED***",
[
"{DAV:}getcontentlength",
"{DAV:}getcontenttype",
"{DAV:}getetag",
"{DAV:}getlastmodified",
"{DAV:}quota-available-bytes",
"And 22 more entries, set log level to debug to see all entries"
],
1
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1647,
"function": "writeMultiStatus",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Sabre\\Xml\\Writer",
[],
"/remote.php/dav/",
[
"d",
"s",
"oc",
"nc"
],
[]
],
[
"Generator"
],
false
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
"line": 346,
"function": "generateMultiStatus",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Generator"
],
false
]
},
{
"file": "/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
"line": 89,
"function": "httpPropFind",
"class": "Sabre\\DAV\\CorePlugin",
"type": "->",
"args": [
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 472,
"function": "emit",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"method:PROPFIND",
[
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 253,
"function": "invokeMethod",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 321,
"function": "start",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/dav/lib/Server.php",
"line": 379,
"function": "exec",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/dav/appinfo/v2/remote.php",
"line": 35,
"function": "exec",
"class": "OCA\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/remote.php",
"line": 172,
"args": [
"/var/www/html/apps/dav/appinfo/v2/remote.php"
],
"function": "require_once"
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
"Line": 86,
"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/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"line": 132,
"function": "new",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
"type": "::",
"args": [
[
"PDOException",
[
"42000",
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"
]
]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1099,
"function": "execute",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 328,
"function": "executeQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"SELECT `sh`.`id`, `sh`.`share_type`, `sh`.`share_with`, `sh`.`uid_owner`, `sh`.`uid_initiator`, `sh`.`parent`, `sh`.`item_type`, `sh`.`item_source`, `sh`.`item_target`, `sh`.`file_source`, `sh`.`file_target`, `sh`.`permissions`, `sh`.`attributes`, `sh`.`stime`, `sh`.`accepted`, `sh`.`expiration`, `sh`.`token`, `sh`.`mail_send`, `sh_cc`.`unique_id` AS `sh_cc_unique_id`, `sh_cc`.`name` AS `sh_cc_name`, `sh_cc`.`display_name` AS `sh_cc_display_name`, `sh_cc`.`sanitized_name` AS `sh_cc_sanitized_name`, `sh_cc`.`source` AS `sh_cc_source`, `sh_cc`.`description` AS `sh_cc_description`, `sh_cc`.`settings` AS `sh_cc_settings`, `sh_cc`.`config` AS `sh_cc_config`, `sh_cc`.`contact_addressbook` AS `sh_cc_contact_addressbook`, `sh_cc`.`contact_groupname` AS `sh_cc_contact_groupname`, `sh_cc`.`creation` AS `sh_cc_creation`, `sh_cc_wn`.`circle_id` AS `sh_cc_wn_circle_id`, `sh_cc_wn`.`member_id` AS `sh_cc_wn_member_id`, `sh_cc_wn`.`single_id` AS `sh_cc_wn_single_id`, `sh_cc_wn`.`user_id` AS `sh_cc_wn_user_id`, `sh_cc_wn`.`instance` AS `sh_cc_wn_instance`, `sh_cc_wn`.`user_type` AS `sh_cc_wn_user_type`, `sh_cc_wn`.`level` AS `sh_cc_wn_level`, `sh_cc_wn`.`status` AS `sh_cc_wn_status`, `sh_cc_wn`.`note` AS `sh_cc_wn_note`, `sh_cc_wn`.`contact_id` AS `sh_cc_wn_contact_id`, `sh_cc_wn`.`cached_name` AS `sh_cc_wn_cached_name`, `sh_cc_wn`.`cached_update` AS `sh_cc_wn_cached_update`, `sh_cc_wn`.`contact_meta` AS `sh_cc_wn_contact_meta`, `sh_cc_wn`.`joined` AS `sh_cc_wn_joined` FROM `oc_share` `sh` LEFT JOIN `oc_circles_circle` `sh_cc` ON `sh_cc`.`unique_id` = `sh`.`share_with` LEFT JOIN `oc_circles_member` `sh_cc_wn` ON (`sh_cc_wn`.`circle_id` = `sh_cc`.`unique_id`) AND (`sh_cc_wn`.`level` = ?) WHERE (`sh`.`share_type` = ?) AND (()) AND (`sh`.`parent` IS NULL)",
[
9,
7
],
[
1,
1
],
null
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line": 344,
"function": "executeQuery",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"SELECT `sh`.`id`, `sh`.`share_type`, `sh`.`share_with`, `sh`.`uid_owner`, `sh`.`uid_initiator`, `sh`.`parent`, `sh`.`item_type`, `sh`.`item_source`, `sh`.`item_target`, `sh`.`file_source`, `sh`.`file_target`, `sh`.`permissions`, `sh`.`attributes`, `sh`.`stime`, `sh`.`accepted`, `sh`.`expiration`, `sh`.`token`, `sh`.`mail_send`, `sh_cc`.`unique_id` AS `sh_cc_unique_id`, `sh_cc`.`name` AS `sh_cc_name`, `sh_cc`.`display_name` AS `sh_cc_display_name`, `sh_cc`.`sanitized_name` AS `sh_cc_sanitized_name`, `sh_cc`.`source` AS `sh_cc_source`, `sh_cc`.`description` AS `sh_cc_description`, `sh_cc`.`settings` AS `sh_cc_settings`, `sh_cc`.`config` AS `sh_cc_config`, `sh_cc`.`contact_addressbook` AS `sh_cc_contact_addressbook`, `sh_cc`.`contact_groupname` AS `sh_cc_contact_groupname`, `sh_cc`.`creation` AS `sh_cc_creation`, `sh_cc_wn`.`circle_id` AS `sh_cc_wn_circle_id`, `sh_cc_wn`.`member_id` AS `sh_cc_wn_member_id`, `sh_cc_wn`.`single_id` AS `sh_cc_wn_single_id`, `sh_cc_wn`.`user_id` AS `sh_cc_wn_user_id`, `sh_cc_wn`.`instance` AS `sh_cc_wn_instance`, `sh_cc_wn`.`user_type` AS `sh_cc_wn_user_type`, `sh_cc_wn`.`level` AS `sh_cc_wn_level`, `sh_cc_wn`.`status` AS `sh_cc_wn_status`, `sh_cc_wn`.`note` AS `sh_cc_wn_note`, `sh_cc_wn`.`contact_id` AS `sh_cc_wn_contact_id`, `sh_cc_wn`.`cached_name` AS `sh_cc_wn_cached_name`, `sh_cc_wn`.`cached_update` AS `sh_cc_wn_cached_update`, `sh_cc_wn`.`contact_meta` AS `sh_cc_wn_contact_meta`, `sh_cc_wn`.`joined` AS `sh_cc_wn_joined` FROM `oc_share` `sh` LEFT JOIN `oc_circles_circle` `sh_cc` ON `sh_cc`.`unique_id` = `sh`.`share_with` LEFT JOIN `oc_circles_member` `sh_cc_wn` ON (`sh_cc_wn`.`circle_id` = `sh_cc`.`unique_id`) AND (`sh_cc_wn`.`level` = :dcValue2) WHERE (`sh`.`share_type` = :dcValue1) AND (()) AND (`sh`.`parent` IS NULL)",
[
7,
9
],
[
1,
1
],
null
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line": 384,
"function": "executeQuery",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 280,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php",
"line": 1046,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php",
"line": 942,
"function": "getRows",
"class": "OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder",
"type": "->",
"args": [
[
[
"OCA\\Circles\\Db\\CoreQueryBuilder"
],
"parseSimpleSelectSql"
],
"OCA\\Circles\\Model\\ShareWrapper",
[]
]
},
{
"file": "/var/www/html/apps/circles/lib/Db/ShareWrapperRequestBuilder.php",
"line": 120,
"function": "asItems",
"class": "OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder",
"type": "->",
"args": [
"OCA\\Circles\\Model\\ShareWrapper"
]
},
{
"file": "/var/www/html/apps/circles/lib/Db/ShareWrapperRequest.php",
"line": 294,
"function": "getItemsFromRequest",
"class": "OCA\\Circles\\Db\\ShareWrapperRequestBuilder",
"type": "->",
"args": [
[
"OCA\\Circles\\Db\\CoreQueryBuilder"
]
]
},
{
"file": "/var/www/html/apps/circles/lib/Service/ShareWrapperService.php",
"line": 204,
"function": "getSharesByFileIds",
"class": "OCA\\Circles\\Db\\ShareWrapperRequest",
"type": "->",
"args": [
[],
true
]
},
{
"file": "/var/www/html/apps/circles/lib/ShareByCircleProvider.php",
"line": 664,
"function": "getSharesByFileIds",
"class": "OCA\\Circles\\Service\\ShareWrapperService",
"type": "->",
"args": [
[],
true
]
},
{
"file": "/var/www/html/lib/private/Share20/Manager.php",
"line": 1691,
"function": "getAccessList",
"class": "OCA\\Circles\\ShareByCircleProvider",
"type": "->",
"args": [
[],
false
]
},
{
"file": "/var/www/html/lib/private/Encryption/File.php",
"line": 100,
"function": "getAccessList",
"class": "OC\\Share20\\Manager",
"type": "->",
"args": [
[
"OC\\Files\\Node\\Folder"
]
]
},
{
"file": "/var/www/html/lib/private/Files/Stream/Encryption.php",
"line": 282,
"function": "getAccessList",
"class": "OC\\Encryption\\File",
"type": "->",
"args": [
"/***CENSORED***/files/Readme.md"
]
},
{
"function": "stream_open",
"class": "OC\\Files\\Stream\\Encryption",
"type": "->",
"args": [
"ocencryption://",
"r",
0,
null
]
},
{
"file": "/var/www/html/lib/private/Files/Stream/Encryption.php",
"line": 212,
"function": "fopen",
"args": [
"ocencryption://",
"r",
false,
null
]
},
{
"file": "/var/www/html/lib/private/Files/Stream/Encryption.php",
"line": 187,
"function": "wrapSource",
"class": "OC\\Files\\Stream\\Encryption",
"type": "::",
"args": [
null,
null,
"ocencryption",
"OC\\Files\\Stream\\Encryption",
"r"
]
},
{
"file": "/var/www/html/lib/private/Files/Storage/Wrapper/Encryption.php",
"line": 489,
"function": "wrap",
"class": "OC\\Files\\Stream\\Encryption",
"type": "::",
"args": [
null,
"files/Readme.md",
"/***CENSORED***/files/Readme.md",
[
"OC_DEFAULT_MODULE",
"AES-256-CTR",
"true"
],
"***CENSORED***",
[
"OCA\\Encryption\\Crypto\\Encryption"
],
[
"OC\\Files\\Storage\\Wrapper\\Quota",
null,
null,
null,
null,
null
],
[
"OC\\Files\\Storage\\Wrapper\\Encryption",
null,
null,
null,
null,
null
],
[
"OC\\Encryption\\Util"
],
[
"OC\\Encryption\\File"
],
"r",
8292,
1,
8192,
true
]
},
{
"file": "/var/www/html/lib/private/Files/Storage/Wrapper/Encryption.php",
"line": 236,
"function": "fopen",
"class": "OC\\Files\\Storage\\Wrapper\\Encryption",
"type": "->",
"args": [
"files/Readme.md",
"r"
]
},
{
"file": "/var/www/html/lib/private/Files/Storage/Wrapper/Wrapper.php",
"line": 253,
"function": "file_get_contents",
"class": "OC\\Files\\Storage\\Wrapper\\Encryption",
"type": "->",
"args": [
"files/Readme.md"
]
},
{
"file": "/var/www/html/apps/files_accesscontrol/lib/StorageWrapper.php",
"line": 169,
"function": "file_get_contents",
"class": "OC\\Files\\Storage\\Wrapper\\Wrapper",
"type": "->",
"args": [
"files/Readme.md"
]
},
{
"file": "/var/www/html/lib/private/Files/View.php",
"line": 1171,
"function": "file_get_contents",
"class": "OCA\\FilesAccessControl\\StorageWrapper",
"type": "->",
"args": [
"files/Readme.md"
]
},
{
"file": "/var/www/html/lib/private/Files/View.php",
"line": 584,
"function": "basicOperation",
"class": "OC\\Files\\View",
"type": "->",
"args": [
"file_get_contents",
"/***CENSORED***/files/Readme.md",
[
"read"
]
]
},
{
"file": "/var/www/html/lib/private/Files/Node/File.php",
"line": 54,
"function": "file_get_contents",
"class": "OC\\Files\\View",
"type": "->",
"args": [
"/***CENSORED***/files/Readme.md"
]
},
{
"file": "/var/www/html/apps/text/lib/DAV/WorkspacePlugin.php",
"line": 119,
"function": "getContent",
"class": "OC\\Files\\Node\\File",
"type": "->",
"args": []
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/PropFind.php",
"line": 95,
"function": "OCA\\Text\\DAV\\{closure}",
"class": "OCA\\Text\\DAV\\WorkspacePlugin",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/text/lib/DAV/WorkspacePlugin.php",
"line": 117,
"function": "handle",
"class": "Sabre\\DAV\\PropFind",
"type": "->",
"args": [
"{http://nextcloud.org/ns}rich-workspace",
[
"Closure"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
"line": 89,
"function": "propFind",
"class": "OCA\\Text\\DAV\\WorkspacePlugin",
"type": "->",
"args": [
[
"Sabre\\DAV\\PropFind"
],
[
"OCA\\DAV\\Files\\FilesHome"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1052,
"function": "emit",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"propFind",
[
[
"Sabre\\DAV\\PropFind"
],
[
"OCA\\DAV\\Files\\FilesHome"
]
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 984,
"function": "getPropertiesByNode",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Sabre\\DAV\\PropFind"
],
[
"OCA\\DAV\\Files\\FilesHome"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1662,
"function": "getPropertiesIteratorForPath",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"files/***CENSORED***",
[
"{DAV:}getcontentlength",
"{DAV:}getcontenttype",
"{DAV:}getetag",
"{DAV:}getlastmodified",
"{DAV:}quota-available-bytes",
"And 22 more entries, set log level to debug to see all entries"
],
1
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1647,
"function": "writeMultiStatus",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Sabre\\Xml\\Writer",
[],
"/remote.php/dav/",
[
"d",
"s",
"oc",
"nc"
],
[]
],
[
"Generator"
],
false
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
"line": 346,
"function": "generateMultiStatus",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Generator"
],
false
]
},
{
"file": "/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
"line": 89,
"function": "httpPropFind",
"class": "Sabre\\DAV\\CorePlugin",
"type": "->",
"args": [
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 472,
"function": "emit",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"method:PROPFIND",
[
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 253,
"function": "invokeMethod",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 321,
"function": "start",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/dav/lib/Server.php",
"line": 379,
"function": "exec",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/dav/appinfo/v2/remote.php",
"line": 35,
"function": "exec",
"class": "OCA\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/remote.php",
"line": 172,
"args": [
"/var/www/html/apps/dav/appinfo/v2/remote.php"
],
"function": "require_once"
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
"Line": 28,
"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/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"line": 130,
"function": "execute",
"class": "PDOStatement",
"type": "->",
"args": [
null
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1099,
"function": "execute",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 328,
"function": "executeQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"SELECT `sh`.`id`, `sh`.`share_type`, `sh`.`share_with`, `sh`.`uid_owner`, `sh`.`uid_initiator`, `sh`.`parent`, `sh`.`item_type`, `sh`.`item_source`, `sh`.`item_target`, `sh`.`file_source`, `sh`.`file_target`, `sh`.`permissions`, `sh`.`attributes`, `sh`.`stime`, `sh`.`accepted`, `sh`.`expiration`, `sh`.`token`, `sh`.`mail_send`, `sh_cc`.`unique_id` AS `sh_cc_unique_id`, `sh_cc`.`name` AS `sh_cc_name`, `sh_cc`.`display_name` AS `sh_cc_display_name`, `sh_cc`.`sanitized_name` AS `sh_cc_sanitized_name`, `sh_cc`.`source` AS `sh_cc_source`, `sh_cc`.`description` AS `sh_cc_description`, `sh_cc`.`settings` AS `sh_cc_settings`, `sh_cc`.`config` AS `sh_cc_config`, `sh_cc`.`contact_addressbook` AS `sh_cc_contact_addressbook`, `sh_cc`.`contact_groupname` AS `sh_cc_contact_groupname`, `sh_cc`.`creation` AS `sh_cc_creation`, `sh_cc_wn`.`circle_id` AS `sh_cc_wn_circle_id`, `sh_cc_wn`.`member_id` AS `sh_cc_wn_member_id`, `sh_cc_wn`.`single_id` AS `sh_cc_wn_single_id`, `sh_cc_wn`.`user_id` AS `sh_cc_wn_user_id`, `sh_cc_wn`.`instance` AS `sh_cc_wn_instance`, `sh_cc_wn`.`user_type` AS `sh_cc_wn_user_type`, `sh_cc_wn`.`level` AS `sh_cc_wn_level`, `sh_cc_wn`.`status` AS `sh_cc_wn_status`, `sh_cc_wn`.`note` AS `sh_cc_wn_note`, `sh_cc_wn`.`contact_id` AS `sh_cc_wn_contact_id`, `sh_cc_wn`.`cached_name` AS `sh_cc_wn_cached_name`, `sh_cc_wn`.`cached_update` AS `sh_cc_wn_cached_update`, `sh_cc_wn`.`contact_meta` AS `sh_cc_wn_contact_meta`, `sh_cc_wn`.`joined` AS `sh_cc_wn_joined` FROM `oc_share` `sh` LEFT JOIN `oc_circles_circle` `sh_cc` ON `sh_cc`.`unique_id` = `sh`.`share_with` LEFT JOIN `oc_circles_member` `sh_cc_wn` ON (`sh_cc_wn`.`circle_id` = `sh_cc`.`unique_id`) AND (`sh_cc_wn`.`level` = ?) WHERE (`sh`.`share_type` = ?) AND (()) AND (`sh`.`parent` IS NULL)",
[
9,
7
],
[
1,
1
],
null
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line": 344,
"function": "executeQuery",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"SELECT `sh`.`id`, `sh`.`share_type`, `sh`.`share_with`, `sh`.`uid_owner`, `sh`.`uid_initiator`, `sh`.`parent`, `sh`.`item_type`, `sh`.`item_source`, `sh`.`item_target`, `sh`.`file_source`, `sh`.`file_target`, `sh`.`permissions`, `sh`.`attributes`, `sh`.`stime`, `sh`.`accepted`, `sh`.`expiration`, `sh`.`token`, `sh`.`mail_send`, `sh_cc`.`unique_id` AS `sh_cc_unique_id`, `sh_cc`.`name` AS `sh_cc_name`, `sh_cc`.`display_name` AS `sh_cc_display_name`, `sh_cc`.`sanitized_name` AS `sh_cc_sanitized_name`, `sh_cc`.`source` AS `sh_cc_source`, `sh_cc`.`description` AS `sh_cc_description`, `sh_cc`.`settings` AS `sh_cc_settings`, `sh_cc`.`config` AS `sh_cc_config`, `sh_cc`.`contact_addressbook` AS `sh_cc_contact_addressbook`, `sh_cc`.`contact_groupname` AS `sh_cc_contact_groupname`, `sh_cc`.`creation` AS `sh_cc_creation`, `sh_cc_wn`.`circle_id` AS `sh_cc_wn_circle_id`, `sh_cc_wn`.`member_id` AS `sh_cc_wn_member_id`, `sh_cc_wn`.`single_id` AS `sh_cc_wn_single_id`, `sh_cc_wn`.`user_id` AS `sh_cc_wn_user_id`, `sh_cc_wn`.`instance` AS `sh_cc_wn_instance`, `sh_cc_wn`.`user_type` AS `sh_cc_wn_user_type`, `sh_cc_wn`.`level` AS `sh_cc_wn_level`, `sh_cc_wn`.`status` AS `sh_cc_wn_status`, `sh_cc_wn`.`note` AS `sh_cc_wn_note`, `sh_cc_wn`.`contact_id` AS `sh_cc_wn_contact_id`, `sh_cc_wn`.`cached_name` AS `sh_cc_wn_cached_name`, `sh_cc_wn`.`cached_update` AS `sh_cc_wn_cached_update`, `sh_cc_wn`.`contact_meta` AS `sh_cc_wn_contact_meta`, `sh_cc_wn`.`joined` AS `sh_cc_wn_joined` FROM `oc_share` `sh` LEFT JOIN `oc_circles_circle` `sh_cc` ON `sh_cc`.`unique_id` = `sh`.`share_with` LEFT JOIN `oc_circles_member` `sh_cc_wn` ON (`sh_cc_wn`.`circle_id` = `sh_cc`.`unique_id`) AND (`sh_cc_wn`.`level` = :dcValue2) WHERE (`sh`.`share_type` = :dcValue1) AND (()) AND (`sh`.`parent` IS NULL)",
[
7,
9
],
[
1,
1
],
null
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line": 384,
"function": "executeQuery",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 280,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php",
"line": 1046,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php",
"line": 942,
"function": "getRows",
"class": "OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder",
"type": "->",
"args": [
[
[
"OCA\\Circles\\Db\\CoreQueryBuilder"
],
"parseSimpleSelectSql"
],
"OCA\\Circles\\Model\\ShareWrapper",
[]
]
},
{
"file": "/var/www/html/apps/circles/lib/Db/ShareWrapperRequestBuilder.php",
"line": 120,
"function": "asItems",
"class": "OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder",
"type": "->",
"args": [
"OCA\\Circles\\Model\\ShareWrapper"
]
},
{
"file": "/var/www/html/apps/circles/lib/Db/ShareWrapperRequest.php",
"line": 294,
"function": "getItemsFromRequest",
"class": "OCA\\Circles\\Db\\ShareWrapperRequestBuilder",
"type": "->",
"args": [
[
"OCA\\Circles\\Db\\CoreQueryBuilder"
]
]
},
{
"file": "/var/www/html/apps/circles/lib/Service/ShareWrapperService.php",
"line": 204,
"function": "getSharesByFileIds",
"class": "OCA\\Circles\\Db\\ShareWrapperRequest",
"type": "->",
"args": [
[],
true
]
},
{
"file": "/var/www/html/apps/circles/lib/ShareByCircleProvider.php",
"line": 664,
"function": "getSharesByFileIds",
"class": "OCA\\Circles\\Service\\ShareWrapperService",
"type": "->",
"args": [
[],
true
]
},
{
"file": "/var/www/html/lib/private/Share20/Manager.php",
"line": 1691,
"function": "getAccessList",
"class": "OCA\\Circles\\ShareByCircleProvider",
"type": "->",
"args": [
[],
false
]
},
{
"file": "/var/www/html/lib/private/Encryption/File.php",
"line": 100,
"function": "getAccessList",
"class": "OC\\Share20\\Manager",
"type": "->",
"args": [
[
"OC\\Files\\Node\\Folder"
]
]
},
{
"file": "/var/www/html/lib/private/Files/Stream/Encryption.php",
"line": 282,
"function": "getAccessList",
"class": "OC\\Encryption\\File",
"type": "->",
"args": [
"/***CENSORED***/files/Readme.md"
]
},
{
"function": "stream_open",
"class": "OC\\Files\\Stream\\Encryption",
"type": "->",
"args": [
"ocencryption://",
"r",
0,
null
]
},
{
"file": "/var/www/html/lib/private/Files/Stream/Encryption.php",
"line": 212,
"function": "fopen",
"args": [
"ocencryption://",
"r",
false,
null
]
},
{
"file": "/var/www/html/lib/private/Files/Stream/Encryption.php",
"line": 187,
"function": "wrapSource",
"class": "OC\\Files\\Stream\\Encryption",
"type": "::",
"args": [
null,
null,
"ocencryption",
"OC\\Files\\Stream\\Encryption",
"r"
]
},
{
"file": "/var/www/html/lib/private/Files/Storage/Wrapper/Encryption.php",
"line": 489,
"function": "wrap",
"class": "OC\\Files\\Stream\\Encryption",
"type": "::",
"args": [
null,
"files/Readme.md",
"/***CENSORED***/files/Readme.md",
[
"OC_DEFAULT_MODULE",
"AES-256-CTR",
"true"
],
"***CENSORED***",
[
"OCA\\Encryption\\Crypto\\Encryption"
],
[
"OC\\Files\\Storage\\Wrapper\\Quota",
null,
null,
null,
null,
null
],
[
"OC\\Files\\Storage\\Wrapper\\Encryption",
null,
null,
null,
null,
null
],
[
"OC\\Encryption\\Util"
],
[
"OC\\Encryption\\File"
],
"r",
8292,
1,
8192,
true
]
},
{
"file": "/var/www/html/lib/private/Files/Storage/Wrapper/Encryption.php",
"line": 236,
"function": "fopen",
"class": "OC\\Files\\Storage\\Wrapper\\Encryption",
"type": "->",
"args": [
"files/Readme.md",
"r"
]
},
{
"file": "/var/www/html/lib/private/Files/Storage/Wrapper/Wrapper.php",
"line": 253,
"function": "file_get_contents",
"class": "OC\\Files\\Storage\\Wrapper\\Encryption",
"type": "->",
"args": [
"files/Readme.md"
]
},
{
"file": "/var/www/html/apps/files_accesscontrol/lib/StorageWrapper.php",
"line": 169,
"function": "file_get_contents",
"class": "OC\\Files\\Storage\\Wrapper\\Wrapper",
"type": "->",
"args": [
"files/Readme.md"
]
},
{
"file": "/var/www/html/lib/private/Files/View.php",
"line": 1171,
"function": "file_get_contents",
"class": "OCA\\FilesAccessControl\\StorageWrapper",
"type": "->",
"args": [
"files/Readme.md"
]
},
{
"file": "/var/www/html/lib/private/Files/View.php",
"line": 584,
"function": "basicOperation",
"class": "OC\\Files\\View",
"type": "->",
"args": [
"file_get_contents",
"/***CENSORED***/files/Readme.md",
[
"read"
]
]
},
{
"file": "/var/www/html/lib/private/Files/Node/File.php",
"line": 54,
"function": "file_get_contents",
"class": "OC\\Files\\View",
"type": "->",
"args": [
"/***CENSORED***/files/Readme.md"
]
},
{
"file": "/var/www/html/apps/text/lib/DAV/WorkspacePlugin.php",
"line": 119,
"function": "getContent",
"class": "OC\\Files\\Node\\File",
"type": "->",
"args": []
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/PropFind.php",
"line": 95,
"function": "OCA\\Text\\DAV\\{closure}",
"class": "OCA\\Text\\DAV\\WorkspacePlugin",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/text/lib/DAV/WorkspacePlugin.php",
"line": 117,
"function": "handle",
"class": "Sabre\\DAV\\PropFind",
"type": "->",
"args": [
"{http://nextcloud.org/ns}rich-workspace",
[
"Closure"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
"line": 89,
"function": "propFind",
"class": "OCA\\Text\\DAV\\WorkspacePlugin",
"type": "->",
"args": [
[
"Sabre\\DAV\\PropFind"
],
[
"OCA\\DAV\\Files\\FilesHome"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1052,
"function": "emit",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"propFind",
[
[
"Sabre\\DAV\\PropFind"
],
[
"OCA\\DAV\\Files\\FilesHome"
]
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 984,
"function": "getPropertiesByNode",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Sabre\\DAV\\PropFind"
],
[
"OCA\\DAV\\Files\\FilesHome"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1662,
"function": "getPropertiesIteratorForPath",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"files/***CENSORED***",
[
"{DAV:}getcontentlength",
"{DAV:}getcontenttype",
"{DAV:}getetag",
"{DAV:}getlastmodified",
"{DAV:}quota-available-bytes",
"And 22 more entries, set log level to debug to see all entries"
],
1
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1647,
"function": "writeMultiStatus",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Sabre\\Xml\\Writer",
[],
"/remote.php/dav/",
[
"d",
"s",
"oc",
"nc"
],
[]
],
[
"Generator"
],
false
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
"line": 346,
"function": "generateMultiStatus",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Generator"
],
false
]
},
{
"file": "/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
"line": 89,
"function": "httpPropFind",
"class": "Sabre\\DAV\\CorePlugin",
"type": "->",
"args": [
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 472,
"function": "emit",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"method:PROPFIND",
[
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 253,
"function": "invokeMethod",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 321,
"function": "start",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/dav/lib/Server.php",
"line": 379,
"function": "exec",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/dav/appinfo/v2/remote.php",
"line": 35,
"function": "exec",
"class": "OCA\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/remote.php",
"line": 172,
"args": [
"/var/www/html/apps/dav/appinfo/v2/remote.php"
],
"function": "require_once"
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"Line": 130
}
},
"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"
}
}
joshtrichards
commented
3 months ago "loglevel": 0,
Please set your loglevel to something reasonable (such as 2) so that you have a chance of seeing the actual error.
"apps_paths": [
{
"path": "\/var\/www\/html\/apps",
"url": "\/apps",
"writable": true
},
{
"path": "\/var\/www\/html\/custom_apps",
"url": "\/custom_apps",
"writable": true
}
],This is not a valid config for the Docker image. The /var\/www\/html\/apps cannot be writable. You likely have broken your instance changing this.
"app_install_overwrite": [
"spreed",
"files_accesscontrol",
"mindmap_app",
"bruteforcesettings",
"socialsharing_email",
"announcementcenter",
"files_mindmap",
"integration_whiteboard",
"music"
],And please disable any of the above that are enabled unless you can confirm their compatibility with v29. The above is a list of apps you've forced enabled at some point, which will override all compatibility checks. We cannot look too deeply into bug reports if the environment has problems like this.
Please address these and also utilize the help forum to find some help unraveling things if need be: https://help.nextcloud.com
kesselb
commented
3 months ago The last error shows an invalid sql query related to circles. Does it work when you disable circles?
kesselb
commented
3 months ago Might be fixed by https://github.com/nextcloud/circles/pull/1615/files
brotkastn
commented
3 months ago I have just found out i am hitting this bug, and yes, it is fixed by circles.
It may be worth to push this fix with high priority, seeing the files list come back empty is quite scary and might result in lost trust.
joshtrichards
commented
3 months ago The last error shows an invalid sql query related to circles.
That SQL one looks like #46196
⚠️ This issue respects the following points: ⚠️
Bug description
After upgrade from 29.0.2 to 29.0.3 no files shown in files app:
No files in here Upload some content or sync with your devices!
Steps to reproduce
Expected behavior
Files most be visilbe in files app.
Installation method
Community Docker image
Nextcloud Server version
29
Operating system
Debian/Ubuntu
PHP engine version
PHP 8.2
Web server
Apache (supported)
Database engine version
MariaDB
Is this bug present after an update or on a fresh install?
Updated from a MINOR version (ex. 22.1 to 22.2)
Are you using the Nextcloud Server Encryption module?
Encryption is Enabled
What user-backends are you using?
Configuration report
List of activated Apps
Nextcloud Signing status
Nextcloud Logs
Additional info
No response