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

[cheerios2006]

Just setup following guide and am unable to open onedrive folder with error "This directory is unavailable. please check the logs or contact the administrator". external storage connected successfully after granting permissions. Logs as follows: Error	lib	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", "2", {"path":"children\/","name":null,"timestamp":null,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null}, -1, "5dc9a120cb183", {"path":"children\/","name":null,"timestamp":null,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null}, 23, "", "d41d8cd98f00b204e9800998ecf8427e", "", -1, "", 11]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'Array' for column nextcloud.oc_filecache.mtime at row 1		2019-11-11T08:57:52-0900

Error | PHP | Array to string conversion at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#77 |   | 2019-11-11T08:57:52-0900

Error | PHP | Array to string conversion at /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#77 |   | 2019-11-11T08:57:52-0900

Error | PHP | Undefined index: name at /config/www/nextcloud/apps/files_external_onedrive/vendor/hevelius/flysystem-onedrive/src/OneDriveAdapter.php#394 |   | 2019-11-11T08:57:52-0900

[acherstyx]

I meet the same problem.

Logs: [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", "2", {"path":"children\/","name":null,"timestamp":null,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null}, -1, "5df48104260fb", {"path":"children\/","name":null,"timestamp":null,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null}, 23, "", "d41d8cd98f00b204e9800998ecf8427e", "", -1, "", 12]:

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

0. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169 Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exception oc ... 1", Doctrine\DBAL\Dr ... ]})
1. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 145 Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "An exception oc ... 1")
2. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 1063 Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "INSERT INTO `oc ... )", {1: "1",2: "2",3 ... 2})
3. /var/www/html/lib/private/DB/Connection.php line 216 Doctrine\DBAL\Connection->executeUpdate("INSERT INTO `oc ... )", ["1","2",{path: ... 2], [2,2,2,2,2,2,2,2,2,2,2,2,2])
4. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 203 OC\DB\Connection->executeUpdate("INSERT INTO `oc ... )", {dcValue1: "1",d ... 2}, {dcValue1: 2,dcV ... 2})
5. /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 214 Doctrine\DBAL\Query\QueryBuilder->execute()
6. /var/www/html/lib/private/Files/Cache/Cache.php line 291 OC\DB\QueryBuilder\QueryBuilder->execute()
7. /var/www/html/lib/private/Files/Cache/Wrapper/CacheWrapper.php line 128 OC\Files\Cache\Cache->insert("", {mimetype: "http ... "})
8. /var/www/html/lib/private/Files/Cache/Wrapper/CacheWrapper.php line 128 OC\Files\Cache\Wrapper\CacheWrapper->insert("", {mimetype: "http ... "})
9. /var/www/html/lib/private/Files/Cache/Wrapper/CacheWrapper.php line 114 OC\Files\Cache\Wrapper\CacheWrapper->insert("", {mimetype: "http ... "})
   10. /var/www/html/lib/private/Files/Cache/Scanner.php line 292 OC\Files\Cache\Wrapper\CacheWrapper->put("", {mimetype: "http ... "})
   11. /var/www/html/lib/private/Files/Cache/Scanner.php line 221 OC\Files\Cache\Scanner->addToCache("", {mimetype: "http ... "}, -1)
   12. /var/www/html/lib/private/Files/View.php line 1482 OC\Files\Cache\Scanner->scanFile("")
   13. /var/www/html/apps/dav/lib/Connector/Sabre/Directory.php line 265 OC\Files\View->getDirectoryContent("/")
   14. /var/www/html/3rdparty/sabre/dav/lib/DAV/Tree.php line 195 OCA\DAV\Connector\Sabre\Directory->getChildren()
   15. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 899 Sabre\DAV\Tree->getChildren("")
   16. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 978 Sabre\DAV\Server->generatePathNodes(Sabre\DAV\PropFind {}, [Sabre\DAV\PropF ... }])
   17. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 1666 Sabre\DAV\Server->getPropertiesIteratorForPath("", ["{DAV:}resourcetype"], 1)
   18. /var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 355 Sabre\DAV\Server->generateMultiStatus(Generator {}, false)
   19. <> Sabre\DAV\CorePlugin->httpPropFind(Sabre\HTTP\Reque ... "}, Sabre\HTTP\Response {})
   20. /var/www/html/3rdparty/sabre/event/lib/EventEmitterTrait.php line 105 undefinedundefinedcall_user_func_array([Sabre\DAV\CorePlugin {},"httpPropFind"], [Sabre\HTTP\Requ ... }])
   21. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 479 Sabre\Event\EventEmitter->emit("method:PROPFIND", [Sabre\HTTP\Requ ... }])
   22. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 254 Sabre\DAV\Server->invokeMethod(Sabre\HTTP\Reque ... "}, Sabre\HTTP\Response {})
   23. /var/www/html/apps/dav/appinfo/v1/webdav.php line 80 Sabre\DAV\Server->exec()
   24. /var/www/html/remote.php line 163 undefinedundefinedrequire_once("/var/www/html/a ... p")

[NCShadown]

I have the same problem:

[lib] Error: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTOoc_filecache(mimepart,mimetype,mtime,size,etag,storage_mtime,permissions,checksum,path_hash,path,parent,name,storage`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["1", "2", {"path":"children\/","name":null,"timestamp":null,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null}, -1, "5e03cf38061a7", {"path":"children\/","name":null,"timestamp":null,"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.oc_filecache.mtime at row 1 at <>

0. /media/sda/Webserver/home.shadown.de/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169 Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exception oc ... 1", Doctrine\DBAL\Dr ... ]})
1. /media/sda/Webserver/home.shadown.de/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 145 Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "An exception oc ... 1")
2. /media/sda/Webserver/home.shadown.de/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 1063 Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "INSERT INTO `oc ... )", {1: "1",2: "2",3 ... 5})
3. /media/sda/Webserver/home.shadown.de/lib/private/DB/Connection.php line 216 Doctrine\DBAL\Connection->executeUpdate("INSERT INTO `oc ... )", ["1","2",{path: ... 5], [2,2,2,2,2,2,2,2,2,2,2,2,2])
4. /media/sda/Webserver/home.shadown.de/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 203 OC\DB\Connection->executeUpdate("INSERT INTO `oc ... )", {dcValue1: "1",d ... 5}, {dcValue1: 2,dcV ... 2})
5. /media/sda/Webserver/home.shadown.de/lib/private/DB/QueryBuilder/QueryBuilder.php line 214 Doctrine\DBAL\Query\QueryBuilder->execute()
6. /media/sda/Webserver/home.shadown.de/lib/private/Files/Cache/Cache.php line 291 OC\DB\QueryBuilder\QueryBuilder->execute()
7. /media/sda/Webserver/home.shadown.de/lib/private/Files/Cache/Wrapper/CacheWrapper.php line 128 OC\Files\Cache\Cache->insert("", {mimetype: "http ... "})
8. /media/sda/Webserver/home.shadown.de/lib/private/Files/Cache/Wrapper/CacheWrapper.php line 114 OC\Files\Cache\Wrapper\CacheWrapper->insert("", {mimetype: "http ... "})
9. /media/sda/Webserver/home.shadown.de/lib/private/Files/Cache/Scanner.php line 292 OC\Files\Cache\Wrapper\CacheWrapper->put("", {mimetype: "http ... "})
   10. /media/sda/Webserver/home.shadown.de/lib/private/Files/Cache/Scanner.php line 221 OC\Files\Cache\Scanner->addToCache("", {mimetype: "http ... "}, -1)
   11. /media/sda/Webserver/home.shadown.de/lib/private/Files/View.php line 1482 OC\Files\Cache\Scanner->scanFile("")
   12. /media/sda/Webserver/home.shadown.de/apps/dav/lib/Connector/Sabre/Directory.php line 265 OC\Files\View->getDirectoryContent("/")
   13. /media/sda/Webserver/home.shadown.de/apps/dav/lib/Connector/Sabre/TagsPlugin.php line 224 OCA\DAV\Connector\Sabre\Directory->getChildren()
   14. <> OCA\DAV\Connector\Sabre\TagsPlugin->handleGetProperties(Sabre\DAV\PropFind {}, OCA\DAV\Files\FilesHome {})
   15. /media/sda/Webserver/home.shadown.de/3rdparty/sabre/event/lib/EventEmitterTrait.php line 105 undefinedundefinedcall_user_func_array([OCA\DAV\Connect ... "], [Sabre\DAV\PropF ... }])
   16. /media/sda/Webserver/home.shadown.de/3rdparty/sabre/dav/lib/DAV/Server.php line 1059 Sabre\Event\EventEmitter->emit("propFind", [Sabre\DAV\PropF ... }])
   17. /media/sda/Webserver/home.shadown.de/3rdparty/sabre/dav/lib/DAV/Server.php line 981 Sabre\DAV\Server->getPropertiesByNode(Sabre\DAV\PropFind {}, OCA\DAV\Files\FilesHome {})
   18. /media/sda/Webserver/home.shadown.de/3rdparty/sabre/dav/lib/DAV/Server.php line 1666 Sabre\DAV\Server->getPropertiesIteratorForPath("files/Maric", ["{DAV:}getlastm ... "], 1)
   19. /media/sda/Webserver/home.shadown.de/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 355 Sabre\DAV\Server->generateMultiStatus(Generator {}, false)
   20. <> Sabre\DAV\CorePlugin->httpPropFind(Sabre\HTTP\Reque ... "}, Sabre\HTTP\Response {})
   21. /media/sda/Webserver/home.shadown.de/3rdparty/sabre/event/lib/EventEmitterTrait.php line 105 undefinedundefinedcall_user_func_array([Sabre\DAV\CorePlugin {},"httpPropFind"], [Sabre\HTTP\Requ ... }])
   22. /media/sda/Webserver/home.shadown.de/3rdparty/sabre/dav/lib/DAV/Server.php line 479 Sabre\Event\EventEmitter->emit("method:PROPFIND", [Sabre\HTTP\Requ ... }])
   23. /media/sda/Webserver/home.shadown.de/3rdparty/sabre/dav/lib/DAV/Server.php line 254 Sabre\DAV\Server->invokeMethod(Sabre\HTTP\Reque ... "}, Sabre\HTTP\Response {})
   24. /media/sda/Webserver/home.shadown.de/apps/dav/lib/Server.php line 317 Sabre\DAV\Server->exec()
   25. /media/sda/Webserver/home.shadown.de/apps/dav/appinfo/v2/remote.php line 35 OCA\DAV\Server->exec()
   26. /media/sda/Webserver/home.shadown.de/remote.php line 163 undefinedundefinedrequire_once("/media/sda/Webs ... p")

PROPFIND /remote.php/dav/files/Maric/ from XX.XXX.XX.XXX by Maric at 2019-12-25T21:06:00+00:00`

[jameswagar]

I am having this same problem on 1.0.7, using NextCloudPi 1.20.1 and NextCloud 17.0.2.1.

I am not sure where to find the logs but will try to figure that out and post them here.

[filoor]

I have the smae issue

`[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, 2, {"path":"children\/","name":null,"timestamp":null,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null}, -1, "5e1c968acf53b", {"path":"children\/","name":null,"timestamp":null,"size":null,"bytes":null,"type":"dir","mimetype":null,"link":null}, 23, "", "d41d8cd98f00b204e9800998ecf8427e", "", -1, "", 11]:

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "Array" at <>

0. /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169 Doctrine\DBAL\Driver\AbstractPostgreSQLDriver->convertException("An exception oc ... "", Doctrine\DBAL\Dr ... ]})
1. /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 145 Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOPgSql\Driver {}, Doctrine\DBAL\Dr ... ]}, "An exception oc ... "")
2. /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 1063 Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOPgSql\Driver {}, Doctrine\DBAL\Dr ... ]}, "INSERT INTO \"o ... )", {1: 1,2: 2,3: {p ... 1})
3. /config/www/nextcloud/lib/private/DB/Connection.php line 216 Doctrine\DBAL\Connection->executeUpdate("INSERT INTO \"o ... )", [1,2,{path: "chi ... 1], [2,2,2,2,2,2,2,2,2,2,2,2,2])
4. /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 203 OC\DB\Connection->executeUpdate("INSERT INTO \"o ... )", {dcValue1: 1,dcV ... 1}, {dcValue1: 2,dcV ... 2})
5. /config/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 214 Doctrine\DBAL\Query\QueryBuilder->execute()
6. /config/www/nextcloud/lib/private/Files/Cache/Cache.php line 291 OC\DB\QueryBuilder\QueryBuilder->execute()
7. /config/www/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php line 128 OC\Files\Cache\Cache->insert("", {mimetype: "http ... "})
8. /config/www/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php line 114 OC\Files\Cache\Wrapper\CacheWrapper->insert("", {mimetype: "http ... "})
9. /config/www/nextcloud/lib/private/Files/Cache/Scanner.php line 292 OC\Files\Cache\Wrapper\CacheWrapper->put("", {mimetype: "http ... "})
   10. /config/www/nextcloud/lib/private/Files/Cache/Scanner.php line 221 OC\Files\Cache\Scanner->addToCache("", {mimetype: "http ... "}, -1)
   11. /config/www/nextcloud/lib/private/Files/View.php line 1482 OC\Files\Cache\Scanner->scanFile("")
   12. /config/www/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php line 265 OC\Files\View->getDirectoryContent("/")
   13. /config/www/nextcloud/apps/dav/lib/Connector/Sabre/TagsPlugin.php line 224 OCA\DAV\Connector\Sabre\Directory->getChildren()
   14. <> OCA\DAV\Connector\Sabre\TagsPlugin->handleGetProperties(Sabre\DAV\PropFind {}, OCA\DAV\Files\FilesHome {})
   15. /config/www/nextcloud/3rdparty/sabre/event/lib/EventEmitterTrait.php line 105 undefinedundefinedcall_user_func_array([OCA\DAV\Connect ... "], [Sabre\DAV\PropF ... }])
   16. /config/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 1059 Sabre\Event\EventEmitter->emit("propFind", [Sabre\DAV\PropF ... }])
   17. /config/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 981 Sabre\DAV\Server->getPropertiesByNode(Sabre\DAV\PropFind {}, OCA\DAV\Files\FilesHome {})
   18. /config/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 1666 Sabre\DAV\Server->getPropertiesIteratorForPath("files/Tarik", ["{DAV:}getlastm ... "], 1)
   19. /config/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 355 Sabre\DAV\Server->generateMultiStatus(Generator {}, false)
   20. <> Sabre\DAV\CorePlugin->httpPropFind(Sabre\HTTP\Reque ... "}, Sabre\HTTP\Response {})
   21. /config/www/nextcloud/3rdparty/sabre/event/lib/EventEmitterTrait.php line 105 undefinedundefinedcall_user_func_array([Sabre\DAV\CorePlugin {},"httpPropFind"], [Sabre\HTTP\Requ ... }])
   22. /config/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 479 Sabre\Event\EventEmitter->emit("method:PROPFIND", [Sabre\HTTP\Requ ... }])
   23. /config/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 254 Sabre\DAV\Server->invokeMethod(Sabre\HTTP\Reque ... "}, Sabre\HTTP\Response {})
   24. /config/www/nextcloud/apps/dav/lib/Server.php line 317 Sabre\DAV\Server->exec()
   25. /config/www/nextcloud/apps/dav/appinfo/v2/remote.php line 35 OCA\DAV\Server->exec()
   26. /config/www/nextcloud/remote.php line 163 undefinedundefinedrequire_once("/config/www/nex ... p")

PROPFIND /remote.php/dav/files/Tarik/ from 192.168.0.9 by Tarik at 2020-01-13T16:10:50+00:00`

[hifihedgehog]

Same issue. If the author has officially abandoned this project, he needs to speak up and say so. That way, someone else who is responsible enough can take over and maintain it.

[sirNugg3ts]

has author abandoned this project? I'm having the same problem...

[thekarinka]

I have got this problem also (Nextcloud 18.0.3)

[davidtkaye]

I am also having the same issue (Nextcloud 18.0.3) hoping for a fix!

[dawid-woitaschek]

Yup, @hevelius doesn't care anymore.