search

hevelius / files_external_onedrive

:mega: :floppy_disk: External storage support for Microsoft OneDrive
GNU General Public License v2.0
72 stars 21 forks source link

this directory is unavailable, please check the logs or contact the administrator. #6

Closed enljm115 closed 5 years ago

enljm115 commented 5 years ago

Version: 16.0.3 Prompt: this directory is unavailable, please check the logs or contact the administrator. I configured it as required, but this error occurred and could not be used. This is the log in nextcloud.

{"reqId":"D3r97MSldZqYyy3VspQJ","level":3,"time":"2019-08-06T13:26:12+00:00","remoteAddr":"58.22.177.64","user":"admin","app":"lib","method":"PROPFIND","url":"/remote.php/webdav","message":{"Exception":"Doctrine\DBAL\Exception\DriverException","Message":"An exception occurred while executing 'INSERT INTO oc_filecache (mimepart, mimetype, mtime, size, etag, storage_mtime, permissions, checksum, path_hash, path, parent, name, storage) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\"1\", \"2\", {\"path\":\"hildren\/\",\"timestamp\":false,\"size\":null,\"bytes\":null,\"type\":\"dir\",\"mimetype\":null,\"link\":null}, -1, \"5d497ff3f3d47\", {\"path\":\"hildren\/\",\"timestamp\":false,\"size\":null,\"bytes\":null,\"type\":\"dir\",\"mimetype\":null,\"link\":null}, 23, \"\", \"d41d8cd98f00b204e9800998ecf8427e\", \"\", -1, \"\", 25]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'Array' for column nextcloud_db.oc_filecache.mtime at row 1","Code":0,"Trace":[{"file":"/mnt/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":184,"function":"convertException","class":"Doctrine\DBAL\Driver\AbstractMySQLDriver","type":"->","args":["An exception occurred while executing 'INSERT INTO oc_filecache (mimepart, mimetype, mtime, size, etag, storage_mtime, permissions, checksum, path_hash, path, parent, name, storage) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\"1\", \"2\", {\"path\":\"hildren\/\",\"timestamp\":false,\"size\":null,\"bytes\":null,\"type\":\"dir\",\"mimetype\":null,\"link\":null}, -1, \"5d497ff3f3d47\", {\"path\":\"hildren\/\",\"timestamp\":false,\"size\":null,\"bytes\":null,\"type\":\"dir\",\"mimetype\":null,\"link\":null}, 23, \"\", \"d41d8cd98f00b204e9800998ecf8427e\", \"\", -1, \"\", 25]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'Array' for column nextcloud_db.oc_filecache.mtime at row 1",{"errorInfo":["22007",1366,"Incorrect integer value: 'Array' for column nextcloud_db.oc_filecache.mtime at row 1"],"class":"Doctrine\DBAL\Driver\PDOException"}]},{"file":"/mnt/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":158,"function":"wrapException","class":"Doctrine\DBAL\DBALException","type":"::","args":[{"class":"Doctrine\DBAL\Driver\PDOMySql\Driver"},{"errorInfo":["22007",1366,"Incorrect integer value: 'Array' for column nextcloud_db.oc_filecache.mtime at row 1"],"class":"Doctrine\DBAL\Driver\PDOException"},"An exception occurred while executing 'INSERT INTO oc_filecache (mimepart, mimetype, mtime, size, etag, storage_mtime, permissions, checksum, path_hash, path, parent, name, storage) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\"1\", \"2\", {\"path\":\"hildren\/\",\"timestamp\":false,\"size\":null,\"bytes\":null,\"type\":\"dir\",\"mimetype\":null,\"link\":null}, -1, \"5d497ff3f3d47\", {\"path\":\"hildren\/\",\"timestamp\":false,\"size\":null,\"bytes\":null,\"type\":\"dir\",\"mimetype\":null,\"link\":null}, 23, \"\", \"d41d8cd98f00b204e9800998ecf8427e\", \"\", -1, \"\", 25]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'Array' for column nextcloud_db.oc_filecache.mtime at row 1"]},{"file":"/mnt/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1088,"function":"driverExceptionDuringQuery","class":"Doctrine\DBAL\DBALException","type":"::","args":[{"class":"Doctrine\DBAL\Driver\PDOMySql\Driver"},{"errorInfo":["22007",1366,"Incorrect integer value: 'Array' for column nextcloud_db.oc_filecache.mtime at row 1"],"class":"Doctrine\DBAL\Driver\PDOException"},"INSERT INTO oc_filecache (mimepart, mimetype, mtime, size, etag, storage_mtime, permissions, checksum, path_hash, path, parent, name, storage) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",{"1":"1","2":"2","3":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"4":-1,"5":"5d497ff3f3d47","6":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"7":23,"8":"","9":"d41d8cd98f00b204e9800998ecf8427e","10":"","11":-1,"12":"","13":25}]},{"file":"/mnt/nextcloud/lib/private/DB/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\DBAL\Connection","type":"->","args":["INSERT INTO oc_filecache (mimepart, mimetype, mtime, size, etag, storage_mtime, permissions, checksum, path_hash, path, parent, name, storage) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",["1","2",{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},-1,"5d497ff3f3d47",{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},23,"","d41d8cd98f00b204e9800998ecf8427e","",-1,"",25],[2,2,2,2,2,2,2,2,2,2,2,2,2]]},{"file":"/mnt/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":222,"function":"executeUpdate","class":"OC\DB\Connection","type":"->","args":["INSERT INTO oc_filecache (mimepart, mimetype, mtime, size, etag, storage_mtime, permissions, checksum, path_hash, path, parent, name, storage) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10, :dcValue11, :dcValue12, :dcValue13)",{"dcValue1":"1","dcValue2":"2","dcValue3":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"dcValue4":-1,"dcValue5":"5d497ff3f3d47","dcValue6":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"dcValue7":23,"dcValue8":"","dcValue9":"d41d8cd98f00b204e9800998ecf8427e","dcValue10":"","dcValue11":-1,"dcValue12":"","dcValue13":25},{"dcValue1":2,"dcValue2":2,"dcValue3":2,"dcValue4":2,"dcValue5":2,"dcValue6":2,"dcValue7":2,"dcValue8":2,"dcValue9":2,"dcValue10":2,"dcValue11":2,"dcValue12":2,"dcValue13":2}]},{"file":"/mnt/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Cache.php","line":291,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":128,"function":"insert","class":"OC\Files\Cache\Cache","type":"->","args":["",{"mimetype":"httpd/unix-directory","mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"size":-1,"etag":"5d497ff3f3d47","storage_mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"permissions":23,"scan_permissions":23,"checksum":"","path":"","parent":-1,"name":""}]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":128,"function":"insert","class":"OC\Files\Cache\Wrapper\CacheWrapper","type":"->","args":["",{"mimetype":"httpd/unix-directory","mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"size":-1,"etag":"5d497ff3f3d47","storage_mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"permissions":23,"scan_permissions":23,"checksum":""}]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":114,"function":"insert","class":"OC\Files\Cache\Wrapper\CacheWrapper","type":"->","args":["",{"mimetype":"httpd/unix-directory","mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"size":-1,"etag":"5d497ff3f3d47","storage_mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"permissions":23,"scan_permissions":23,"checksum":""}]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Scanner.php","line":292,"function":"put","class":"OC\Files\Cache\Wrapper\CacheWrapper","type":"->","args":["",{"mimetype":"httpd/unix-directory","mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"size":-1,"etag":"5d497ff3f3d47","storage_mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"permissions":23,"scan_permissions":23,"checksum":""}]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Scanner.php","line":221,"function":"addToCache","class":"OC\Files\Cache\Scanner","type":"->","args":["",{"mimetype":"httpd/unix-directory","mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"size":-1,"etag":"5d497ff3f3d47","storage_mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"permissions":23,"scan_permissions":23,"checksum":""},-1]},{"file":"/mnt/nextcloud/lib/private/Files/View.php","line":1482,"function":"scanFile","class":"OC\Files\Cache\Scanner","type":"->","args":[""]},{"file":"/mnt/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php","line":265,"function":"getDirectoryContent","class":"OC\Files\View","type":"->","args":["/"]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php","line":195,"function":"getChildren","class":"OCA\DAV\Connector\Sabre\Directory","type":"->","args":[]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":899,"function":"getChildren","class":"Sabre\DAV\Tree","type":"->","args":[""]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":978,"function":"generatePathNodes","class":"Sabre\DAV\Server","type":"->","args":[{"class":"Sabre\DAV\PropFind"},[{"class":"Sabre\DAV\PropFind"},{"class":"OCA\DAV\Connector\Sabre\Directory"}]]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1666,"function":"getPropertiesIteratorForPath","class":"Sabre\DAV\Server","type":"->","args":["",["{DAV:}resourcetype"],1]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":355,"function":"generateMultiStatus","class":"Sabre\DAV\Server","type":"->","args":[{"class":"Generator"},false]},{"function":"httpPropFind","class":"Sabre\DAV\CorePlugin","type":"->","args":[{"absoluteUrl":"https://npxnb.55555.io/remote.php/webdav","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/mnt/nextcloud/3rdparty/sabre/event/lib/EventEmitterTrait.php","line":105,"function":"call_user_func_array","args":[[{"__class__":"Sabre\\DAV\\CorePlugin"},"httpPropFind"],[{"absoluteUrl":"https://npxnb.55555.io/remote.php/webdav","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":479,"function":"emit","class":"Sabre\\Event\\EventEmitter","type":"->","args":["method:PROPFIND",[{"absoluteUrl":"https://npxnb.55555.io/remote.php/webdav","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":254,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[{"absoluteUrl":"https://npxnb.55555.io/remote.php/webdav","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/mnt/nextcloud/apps/dav/appinfo/v1/webdav.php","line":80,"function":"exec","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"/mnt/nextcloud/remote.php","line":163,"args":["/mnt/nextcloud/apps/dav/appinfo/v1/webdav.php"],"function":"require_once"}],"File":"/mnt/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php","Line":125,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'Array' for column nextcloud_db.oc_filecache.mtime at row 1","Code":"22007","Trace":[{"file":"/mnt/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1079,"function":"execute","class":"Doctrine\DBAL\Driver\PDOStatement","type":"->","args":[]},{"file":"/mnt/nextcloud/lib/private/DB/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\DBAL\Connection","type":"->","args":["INSERT INTO oc_filecache (mimepart, mimetype, mtime, size, etag, storage_mtime, permissions, checksum, path_hash, path, parent, name, storage) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",["1","2",{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},-1,"5d497ff3f3d47",{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},23,"","d41d8cd98f00b204e9800998ecf8427e","",-1,"",25],[2,2,2,2,2,2,2,2,2,2,2,2,2]]},{"file":"/mnt/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":222,"function":"executeUpdate","class":"OC\DB\Connection","type":"->","args":["INSERT INTO oc_filecache (mimepart, mimetype, mtime, size, etag, storage_mtime, permissions, checksum, path_hash, path, parent, name, storage) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10, :dcValue11, :dcValue12, :dcValue13)",{"dcValue1":"1","dcValue2":"2","dcValue3":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"dcValue4":-1,"dcValue5":"5d497ff3f3d47","dcValue6":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"dcValue7":23,"dcValue8":"","dcValue9":"d41d8cd98f00b204e9800998ecf8427e","dcValue10":"","dcValue11":-1,"dcValue12":"","dcValue13":25},{"dcValue1":2,"dcValue2":2,"dcValue3":2,"dcValue4":2,"dcValue5":2,"dcValue6":2,"dcValue7":2,"dcValue8":2,"dcValue9":2,"dcValue10":2,"dcValue11":2,"dcValue12":2,"dcValue13":2}]},{"file":"/mnt/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Cache.php","line":291,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":128,"function":"insert","class":"OC\Files\Cache\Cache","type":"->","args":["",{"mimetype":"httpd/unix-directory","mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"size":-1,"etag":"5d497ff3f3d47","storage_mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"permissions":23,"scan_permissions":23,"checksum":"","path":"","parent":-1,"name":""}]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":128,"function":"insert","class":"OC\Files\Cache\Wrapper\CacheWrapper","type":"->","args":["",{"mimetype":"httpd/unix-directory","mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"size":-1,"etag":"5d497ff3f3d47","storage_mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"permissions":23,"scan_permissions":23,"checksum":""}]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":114,"function":"insert","class":"OC\Files\Cache\Wrapper\CacheWrapper","type":"->","args":["",{"mimetype":"httpd/unix-directory","mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"size":-1,"etag":"5d497ff3f3d47","storage_mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"permissions":23,"scan_permissions":23,"checksum":""}]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Scanner.php","line":292,"function":"put","class":"OC\Files\Cache\Wrapper\CacheWrapper","type":"->","args":["",{"mimetype":"httpd/unix-directory","mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"size":-1,"etag":"5d497ff3f3d47","storage_mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"permissions":23,"scan_permissions":23,"checksum":""}]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Scanner.php","line":221,"function":"addToCache","class":"OC\Files\Cache\Scanner","type":"->","args":["",{"mimetype":"httpd/unix-directory","mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"size":-1,"etag":"5d497ff3f3d47","storage_mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"permissions":23,"scan_permissions":23,"checksum":""},-1]},{"file":"/mnt/nextcloud/lib/private/Files/View.php","line":1482,"function":"scanFile","class":"OC\Files\Cache\Scanner","type":"->","args":[""]},{"file":"/mnt/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php","line":265,"function":"getDirectoryContent","class":"OC\Files\View","type":"->","args":["/"]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php","line":195,"function":"getChildren","class":"OCA\DAV\Connector\Sabre\Directory","type":"->","args":[]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":899,"function":"getChildren","class":"Sabre\DAV\Tree","type":"->","args":[""]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":978,"function":"generatePathNodes","class":"Sabre\DAV\Server","type":"->","args":[{"class":"Sabre\DAV\PropFind"},[{"class":"Sabre\DAV\PropFind"},{"class":"OCA\DAV\Connector\Sabre\Directory"}]]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1666,"function":"getPropertiesIteratorForPath","class":"Sabre\DAV\Server","type":"->","args":["",["{DAV:}resourcetype"],1]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":355,"function":"generateMultiStatus","class":"Sabre\DAV\Server","type":"->","args":[{"class":"Generator"},false]},{"function":"httpPropFind","class":"Sabre\DAV\CorePlugin","type":"->","args":[{"absoluteUrl":"https://npxnb.55555.io/remote.php/webdav","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/mnt/nextcloud/3rdparty/sabre/event/lib/EventEmitterTrait.php","line":105,"function":"call_user_func_array","args":[[{"__class__":"Sabre\\DAV\\CorePlugin"},"httpPropFind"],[{"absoluteUrl":"https://npxnb.55555.io/remote.php/webdav","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":479,"function":"emit","class":"Sabre\\Event\\EventEmitter","type":"->","args":["method:PROPFIND",[{"absoluteUrl":"https://npxnb.55555.io/remote.php/webdav","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":254,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[{"absoluteUrl":"https://npxnb.55555.io/remote.php/webdav","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/mnt/nextcloud/apps/dav/appinfo/v1/webdav.php","line":80,"function":"exec","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"/mnt/nextcloud/remote.php","line":163,"args":["/mnt/nextcloud/apps/dav/appinfo/v1/webdav.php"],"function":"require_once"}],"File":"/mnt/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":143,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'Array' for column nextcloud_db.oc_filecache.mtime at row 1","Code":"22007","Trace":[{"file":"/mnt/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","line":141,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/mnt/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1079,"function":"execute","class":"Doctrine\DBAL\Driver\PDOStatement","type":"->","args":[]},{"file":"/mnt/nextcloud/lib/private/DB/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\DBAL\Connection","type":"->","args":["INSERT INTO oc_filecache (mimepart, mimetype, mtime, size, etag, storage_mtime, permissions, checksum, path_hash, path, parent, name, storage) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",["1","2",{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},-1,"5d497ff3f3d47",{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},23,"","d41d8cd98f00b204e9800998ecf8427e","",-1,"",25],[2,2,2,2,2,2,2,2,2,2,2,2,2]]},{"file":"/mnt/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":222,"function":"executeUpdate","class":"OC\DB\Connection","type":"->","args":["INSERT INTO oc_filecache (mimepart, mimetype, mtime, size, etag, storage_mtime, permissions, checksum, path_hash, path, parent, name, storage) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10, :dcValue11, :dcValue12, :dcValue13)",{"dcValue1":"1","dcValue2":"2","dcValue3":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"dcValue4":-1,"dcValue5":"5d497ff3f3d47","dcValue6":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"dcValue7":23,"dcValue8":"","dcValue9":"d41d8cd98f00b204e9800998ecf8427e","dcValue10":"","dcValue11":-1,"dcValue12":"","dcValue13":25},{"dcValue1":2,"dcValue2":2,"dcValue3":2,"dcValue4":2,"dcValue5":2,"dcValue6":2,"dcValue7":2,"dcValue8":2,"dcValue9":2,"dcValue10":2,"dcValue11":2,"dcValue12":2,"dcValue13":2}]},{"file":"/mnt/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Cache.php","line":291,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":128,"function":"insert","class":"OC\Files\Cache\Cache","type":"->","args":["",{"mimetype":"httpd/unix-directory","mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"size":-1,"etag":"5d497ff3f3d47","storage_mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"permissions":23,"scan_permissions":23,"checksum":"","path":"","parent":-1,"name":""}]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":128,"function":"insert","class":"OC\Files\Cache\Wrapper\CacheWrapper","type":"->","args":["",{"mimetype":"httpd/unix-directory","mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"size":-1,"etag":"5d497ff3f3d47","storage_mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"permissions":23,"scan_permissions":23,"checksum":""}]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":114,"function":"insert","class":"OC\Files\Cache\Wrapper\CacheWrapper","type":"->","args":["",{"mimetype":"httpd/unix-directory","mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"size":-1,"etag":"5d497ff3f3d47","storage_mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"permissions":23,"scan_permissions":23,"checksum":""}]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Scanner.php","line":292,"function":"put","class":"OC\Files\Cache\Wrapper\CacheWrapper","type":"->","args":["",{"mimetype":"httpd/unix-directory","mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"size":-1,"etag":"5d497ff3f3d47","storage_mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"permissions":23,"scan_permissions":23,"checksum":""}]},{"file":"/mnt/nextcloud/lib/private/Files/Cache/Scanner.php","line":221,"function":"addToCache","class":"OC\Files\Cache\Scanner","type":"->","args":["",{"mimetype":"httpd/unix-directory","mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"size":-1,"etag":"5d497ff3f3d47","storage_mtime":{"path":"hildren/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null},"permissions":23,"scan_permissions":23,"checksum":""},-1]},{"file":"/mnt/nextcloud/lib/private/Files/View.php","line":1482,"function":"scanFile","class":"OC\Files\Cache\Scanner","type":"->","args":[""]},{"file":"/mnt/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php","line":265,"function":"getDirectoryContent","class":"OC\Files\View","type":"->","args":["/"]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php","line":195,"function":"getChildren","class":"OCA\DAV\Connector\Sabre\Directory","type":"->","args":[]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":899,"function":"getChildren","class":"Sabre\DAV\Tree","type":"->","args":[""]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":978,"function":"generatePathNodes","class":"Sabre\DAV\Server","type":"->","args":[{"class":"Sabre\DAV\PropFind"},[{"class":"Sabre\DAV\PropFind"},{"class":"OCA\DAV\Connector\Sabre\Directory"}]]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1666,"function":"getPropertiesIteratorForPath","class":"Sabre\DAV\Server","type":"->","args":["",["{DAV:}resourcetype"],1]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":355,"function":"generateMultiStatus","class":"Sabre\DAV\Server","type":"->","args":[{"class":"Generator"},false]},{"function":"httpPropFind","class":"Sabre\DAV\CorePlugin","type":"->","args":[{"absoluteUrl":"https://npxnb.55555.io/remote.php/webdav","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/mnt/nextcloud/3rdparty/sabre/event/lib/EventEmitterTrait.php","line":105,"function":"call_user_func_array","args":[[{"__class__":"Sabre\\DAV\\CorePlugin"},"httpPropFind"],[{"absoluteUrl":"https://npxnb.55555.io/remote.php/webdav","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":479,"function":"emit","class":"Sabre\\Event\\EventEmitter","type":"->","args":["method:PROPFIND",[{"absoluteUrl":"https://npxnb.55555.io/remote.php/webdav","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"/mnt/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":254,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[{"absoluteUrl":"https://npxnb.55555.io/remote.php/webdav","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/mnt/nextcloud/apps/dav/appinfo/v1/webdav.php","line":80,"function":"exec","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"/mnt/nextcloud/remote.php","line":163,"args":["/mnt/nextcloud/apps/dav/appinfo/v1/webdav.php"],"function":"require_once"}],"File":"/mnt/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":141}},"CustomMessage":"Exception while scanning storage \"onedrive::28670622-5b5e-4244-962d-653547ec3737::5d497c19b33ea4.31278631\""},"userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.142 Safari/537.36","version":"16.0.3.0","id":"5d49801bb79d9"}

hevelius commented 5 years ago

Version of files_external_onedrive? Have you set all permissions on portal.azure.com correctly? Is NC behind a proxy? I have OneDrive installed on my NC 16.0.3 without issues.

enljm115 commented 5 years ago

The files_external_onedrive version is 1.0.3. Installed from the NC App Store. No use proxy. I uploaded a screenshot. Maybe the permissions for portal.azure.com are incorrect. Help me judge WX20190807-083419

WX20190807-084215

enljm115 commented 5 years ago

It will become like this after a while. . . .

WX20190807-083700

hevelius commented 5 years ago

Latest release is 1.0.4 I can't reproduce this.

You can try with this steps:

enljm115 commented 5 years ago

Is a problem with my local environment Thank you

enljm115 commented 5 years ago

After the addition is successful, it can be used normally, but it will become like this after a while, about 30 minutes.

WX20190808-223311

hevelius commented 5 years ago

@enljm115 you add external storage as admin for "all users". Have you the same issue mounting onedrive as normal user? Did you check NC logs? Is there something of interesting?

enljm115 commented 5 years ago

The onedrive client has not been installed and is not mounted elsewhere. I found that there was a problem with the MariaDB database and I could not mount onedrive successfully. But with sqlite can be mounted, but the above problems will occur, and can not be used after a while, After submitting this question, I found that many small partners have this problem (because they receive an email inquiry) Can you explain how to use or how to set up portal.Azure.Com for a detailed description?

enljm115 commented 5 years ago

WX20190810-025019

ghost commented 5 years ago

I have the exact same issue. Maybe a language thing? I have an german setting. Version: 16.0.4, MariaDB

kshimohata commented 5 years ago

I have the exact same issue, too.

Nextcloud Settings

hevelius commented 5 years ago

I have the exact same issue, too.

Nextcloud Settings

  • Nextcloud 16.0.4
  • External Storage: OneDrive 1.0.4
  • Japanese setting
  • Nginx 1.16.0
  • PHP 7.3.7
  • MariaDB 10.4.6
  • Redis 5.0.5
  • Built on AWS EC2 (CentOS 7.6)

With MariaDB > 5.7 there are some issues I hope to fix them as soon as possibile

ghost commented 5 years ago

Thanks for your hard work. My Version is: MySQL-Version 10.3.15-MariaDB

enljm115 commented 5 years ago

I have the exact same issue, too.

Nextcloud Settings

  • Nextcloud 16.0.4
  • External Storage: OneDrive 1.0.4
  • Japanese setting
  • Nginx 1.16.0
  • PHP 7.3.7
  • MariaDB 10.4.6
  • Redis 5.0.5
  • Built on AWS EC2 (CentOS 7.6)

My environment is the same as you, But the language I use is Chinese.

kshimohata commented 5 years ago

Thank you for your fixing. I'm looking forward to them.

solracsf commented 5 years ago

Same issue here with MariaDB 10.4.7

I've configured a storage as explained at https://github.com/hevelius/files_external_onedrive#configuring-oauth2 and connection is OK.

When accessing that external storage, it says it is unavailable and in the logs i have this:

[lib] Error: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO `oc_filecache` (`mimepart`, `mimetype`, `mtime`, `size`, `etag`, `storage_mtime`, `permissions`, `checksum`, `path_hash`, `path`, `parent`, `name`, `storage`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["1", "3", {"path":"hildren\/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null}, -1, "5d6d1a95aa6fe", {"path":"hildren\/","timestamp":false,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null}, 23, "", "d41d8cd98f00b204e9800998ecf8427e", "", -1, "", 5]:

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'Array' for column `nextcloud_nextcloud`.`oc_filecache`.`mtime` at row 1 at <<closure>>

 0. /home/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 184
    Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exception oc ... 1", Doctrine\DBAL\Dr ... ]})
 1. /home/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 158
    Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "An exception oc ... 1")
 2. /home/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 1088
    Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "INSERT INTO `oc ... )", {1: "1",2: "3",3 ... 5})
 3. /home/nextcloud/lib/private/DB/Connection.php line 216
    Doctrine\DBAL\Connection->executeUpdate("INSERT INTO `oc ... )", ["1","3",{path:  ... 5], [2,2,2,2,2,2,2,2,2,2,2,2,2])
 4. /home/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 222
    OC\DB\Connection->executeUpdate("INSERT INTO `oc ... )", {dcValue1: "1",d ... 5}, {dcValue1: 2,dcV ... 2})
 5. /home/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 214
    Doctrine\DBAL\Query\QueryBuilder->execute()
 6. /home/nextcloud/lib/private/Files/Cache/Cache.php line 291
    OC\DB\QueryBuilder\QueryBuilder->execute()
 7. /home/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php line 128
    OC\Files\Cache\Cache->insert("", {mimetype: "http ... "})
 8. /home/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php line 114
    OC\Files\Cache\Wrapper\CacheWrapper->insert("", {mimetype: "http ... "})
 9. /home/nextcloud/lib/private/Files/Cache/Scanner.php line 292
    OC\Files\Cache\Wrapper\CacheWrapper->put("", {mimetype: "http ... "})
10. /home/nextcloud/lib/private/Files/Cache/Scanner.php line 221
    OC\Files\Cache\Scanner->addToCache("", {mimetype: "http ... "}, -1)
11. /home/nextcloud/lib/private/Files/View.php line 1482
    OC\Files\Cache\Scanner->scanFile("")
12. /home/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php line 265
    OC\Files\View->getDirectoryContent("/")
13. /home/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php line 195
    OCA\DAV\Connector\Sabre\Directory->getChildren()
14. /home/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 899
    Sabre\DAV\Tree->getChildren("")
15. /home/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 978
    Sabre\DAV\Server->generatePathNodes(Sabre\DAV\PropFind {}, [Sabre\DAV\PropF ... }])
16. /home/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 1666
    Sabre\DAV\Server->getPropertiesIteratorForPath("", ["{DAV:}resourcetype"], 1)
17. /home/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 355
    Sabre\DAV\Server->generateMultiStatus(Generator {}, false)
18. <<closure>>
    Sabre\DAV\CorePlugin->httpPropFind(Sabre\HTTP\Reque ... "}, Sabre\HTTP\Response {})
19. /home/nextcloud/3rdparty/sabre/event/lib/EventEmitterTrait.php line 105
    undefinedundefinedcall_user_func_array([Sabre\DAV\CorePlugin {},"httpPropFind"], [Sabre\HTTP\Requ ... }])
20. /home/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 479
    Sabre\Event\EventEmitter->emit("method:PROPFIND", [Sabre\HTTP\Requ ... }])
21. /home/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 254
    Sabre\DAV\Server->invokeMethod(Sabre\HTTP\Reque ... "}, Sabre\HTTP\Response {})
22. /home/nextcloud/apps/dav/appinfo/v1/webdav.php line 80
    Sabre\DAV\Server->exec()
23. /home/nextcloud/remote.php line 163
    undefinedundefinedrequire_once("/home/nextcloud/w ... p")
[PHP] Error: Array to string conversion at /home/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#101
[PHP] Error: Undefined index: name at /home/nextcloud/apps/files_external_onedrive/vendor/hevelius/flysystem-onedrive/src/OneDriveAdapter.php#381
[PHP] Error: Undefined index: lastModifiedDateTime at /home/nextcloud/apps/files_external_onedrive/vendor/hevelius/flysystem-onedrive/src/OneDriveAdapter.php#382
[PHP] Error: Undefined index: size at /home/nextcloud/apps/files_external_onedrive/vendor/hevelius/flysystem-onedrive/src/OneDriveAdapter.php#383
[PHP] Error: Undefined index: size at /home/nextcloud/apps/files_external_onedrive/vendor/hevelius/flysystem-onedrive/src/OneDriveAdapter.php#384
ghost commented 5 years ago

Version 1.0.5 solved it for me. A big smile and a huge thanks!!

hevelius commented 5 years ago

Glad to ear this! I consider the issue solved @enljm115. Thanks for reporting.

kshimohata commented 4 years ago

Version 1.0.5 solved it for me. A big smile and a huge thanks!!

I can access it by updating the app to version 1.0.5, too. You've been a great help!

rightsaidfred99 commented 2 years ago

Hello, this bug is back Screenshot 2022-01-09 124521

Screenshot 2022-01-09 124629