Limitation on number of files per folder on local storage

calvin · October 13, 2017, 3:53am

Steps to reproduce

Create local storage mount
Browse to subfolder with more than 1000 files.

Expected behaviour

Files show as usual

Actual behaviour

This directory is unavailable, please check the logs or contact the administrator

Server configuration

Operating system: Centos 7.4

Web server: Apache

Database: Sqlite

PHP version: 5.6

ownCloud version: 10.0.3.3

Updated from an older ownCloud or fresh install: fresh install

Where did you install ownCloud from: tarball

Signing status (ownCloud 9.0 and above): N/A

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.

The content of config/config.php:

https://gist.github.com/anonymous/f4329fb0be03b03c2089c3847c12ab9f

List of activated apps:

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder.

Are you using external storage, if yes which one: local

Are you using encryption: no

Are you using an external user-backend, if yes which one: No

Client configuration

Browser:

Operating system:

Logs

Web server error log

- - [13/Oct/2017:11:48:11 +0800] "GET /owncloud/index.php/avatar/xxxxx/28 HTTP/1.1" 200 33 "-" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:56.0) Gecko/20100101 Firefox/56.0"
- - [13/Oct/2017:11:48:11 +0800] "PROPFIND /owncloud/remote.php/webdav/CCloud/iphone/2012 HTTP/1.1" 500 14369 "-" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:56.0) Gecko/20100101 Firefox/56.0"
- - [13/Oct/2017:11:48:12 +0800] "GET /owncloud/index.php/apps/files_external/userglobalstorages/1?testOnly=false HTTP/1.1" 200 191 "-" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:56.0) Gecko/20100101 Firefox/56.0"
- - [13/Oct/2017:11:48:12 +0800] "PROPFIND /owncloud/remote.php/webdav/ HTTP/1.1" 207 3546 "-" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:56.0) Gecko/20100101 Firefox/56.0"
- - [13/Oct/2017:11:48:12 +0800] "GET /owncloud/index.php/avatar/xxxxx/28 HTTP/1.1" 200 33 "-" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:56.0) Gecko/20100101 Firefox/56.0"
- - [13/Oct/2017:11:48:12 +0800] "GET /owncloud/index.php/apps/files/ajax/getstoragestats.php?dir=%2F HTTP/1.1" 200 191 "-" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:56.0) Gecko/20100101 Firefox/56.0"

ownCloud log (data/owncloud.log)

{"reqId":"WeA3e0uMZY8omfzxOhHo4gAAAAM","level":4,"time":"2017-10-13T11:48:11+08:00","remoteAddr":"xxxxxxxx","user":"xxxxx","app":"webdav","method":"PROPFIND","url":"\/owncloud\/remote.php\/webdav\/CCloud\/iphone\/2012","message":"Exception: {\"Message\":\"An exception occurred while executing 'SELECT * FROM \\\"oc_share\\\" WHERE ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY \\\"id\\\" ASC' with params [\\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\"]:\\n\\nSQLSTATE[HY000]: General error: 1 too many SQL variables\",\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractSQLiteDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(855): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOSqlite\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'SELECT * FROM \\\"...', Array)\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(190): Doctrine\\\\DBAL\\\\Connection->executeQuery('SELECT * FROM \\\"...', Array, Array, NULL)\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(206): OC\\\\DB\\\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(141): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Share20\\\/DefaultShareProvider.php(514): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Share20\\\/Manager.php(924): OC\\\\Share20\\\\DefaultShareProvider->getAllSharesBy('xxxxx', Array, Array, false)\\n#7 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/SharesPlugin.php(145): OC\\\\Share20\\\\Manager->getAllSharesBy('xxxxx', Array, Array)\\n#8 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/SharesPlugin.php(195): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\SharesPlugin->getSharesForNodeIds(Array)\\n#9 [internal function]: OCA\\\\DAV\\\\Connector\\\\Sabre\\\\SharesPlugin->handleGetProperties(Object(Sabre\\\\DAV\\\\PropFind), Object(OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory))\\n#10 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#11 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1058): Sabre\\\\Event\\\\EventEmitter->emit('propFind', Array)\\n#12 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(980): Sabre\\\\DAV\\\\Server->getPropertiesByNode(Object(Sabre\\\\DAV\\\\PropFind), Object(OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory))\\n#13 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1665): Sabre\\\\DAV\\\\Server::getPropertiesIteratorForPath('CCloud\\\/iphone\\\/2...', Array, 1)\\n#14 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(355): Sabre\\\\DAV\\\\Server->generateMultiStatus(Object(Generator), false)\\n#15 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPropFind(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#16 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#17 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:PROPFIND', Array)\\n#18 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#19 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v1\\\/webdav.php(63): Sabre\\\\DAV\\\\Server->exec()\\n#20 \\\/var\\\/www\\\/owncloud\\\/remote.php(165): require_once('\\\/var\\\/www\\\/ownclo...')\\n#21 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractSQLiteDriver.php\",\"Line\":85,\"User\":\"xxxxx\"}"}

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log 
c) ...

jvillafanez · October 13, 2017, 8:06am

Could you open a ticket in github? This seems a bug...

Meanwhile I suggest to spread the files into different folders to prevent this error from happening.

calvin · October 13, 2017, 8:21am

Thanks.