我有 owncloud 10.0.3 ubuntu 17.04 服务器。我可以通过 Web 浏览器和 Windows 10 上的 owncloud 桌面客户端,使用多个用户从多个桌面顺利访问它。
我之前使用过 iPad 客户端应用程序,没有任何问题,但在我最近从 OC9 升级到 owncloud 10,从 16.04 升级到 ubuntu 17.04 后,出现了这个错误:
"it is not possible to connect to the server at this time"
但是我已通过 Safari 连接并能够在那里查看文件。我检查了服务器上数据目录中的 owncloud.log,发现每次尝试从 ipad pro 登录时都会出现此错误,我无法理解:
{"reqId":"MmqeK5EOQJtmVTbNvSgj","level":4,"time":"2017-10-24T10:54:19-07:00","remoteAddr":"174.215.4.61","user":"fawzi","app":"webdav","method":"PROPFIND","url":"\/remote.php\/webdav\/","message":"Exception: {\"Message\":\"An exception occurred while executing 'SELECT * FROM `oc_properties` WHERE `fileid` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND `propertyname` in (?, ?) ORDER BY `propertyname`' with params [\\\"28343\\\", \\\"23\\\", \\\"28346\\\", \\\"47571\\\", \\\"565\\\", \\\"28345\\\", \\\"46900\\\", \\\"46852\\\", \\\"46875\\\", \\\"46991\\\", \\\"46924\\\", \\\"46988\\\", \\\"46997\\\", \\\"47055\\\", \\\"47065\\\", \\\"47075\\\", \\\"47097\\\", \\\"28323\\\", \\\"28320\\\", \\\"47202\\\", \\\"47206\\\", \\\"47207\\\", \\\"47147\\\", \\\"21\\\", \\\"31235\\\", \\\"25\\\", \\\"47597\\\", \\\"2123\\\", \\\"47573\\\", \\\"2126\\\", \\\"47643\\\", \\\"2125\\\", \\\"47168\\\", \\\"36885\\\", \\\"24\\\", \\\"28648\\\", \\\"648\\\", \\\"31236\\\", \\\"2448\\\", \\\"2449\\\", \\\"28291\\\", \\\"31230\\\", \\\"3179\\\", \\\"3180\\\", \\\"16\\\", \\\"2479\\\", \\\"47651\\\", \\\"47572\\\", \\\"3370\\\", \\\"36859\\\", \\\"28649\\\", 31202, \\\"{DAV:}creationdate\\\", \\\"{DAV:}displayname\\\"]:\\n\\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fileid' in 'where clause'\",\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\InvalidFieldNameException\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->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\\\\PDOMySql\\\\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\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/CustomPropertiesBackend.php(333): OC\\\\DB\\\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\\n#4 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/CustomPropertiesBackend.php(139): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\CustomPropertiesBackend->loadChildrenProperties(Object(OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory), Array)\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/PropertyStorage\\\/Plugin.php(91): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\CustomPropertiesBackend->propFind('', Object(Sabre\\\\DAV\\\\PropFind))\\n#6 [internal function]: Sabre\\\\DAV\\\\PropertyStorage\\\\Plugin->propFind(Object(Sabre\\\\DAV\\\\PropFind), Object(OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory))\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#8 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1058): Sabre\\\\Event\\\\EventEmitter->emit('propFind', Array)\\n#9 \\\/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#10 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1665): Sabre\\\\DAV\\\\Server->getPropertiesIteratorForPath('', Array, 1)\\n#11 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(355): Sabre\\\\DAV\\\\Server->generateMultiStatus(Object(Generator), false)\\n#12 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPropFind(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#13 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#14 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:PROPFIND', Array)\\n#15 \\\/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#16 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v1\\\/webdav.php(63): Sabre\\\\DAV\\\\Server->exec()\\n#17 \\\/var\\\/www\\\/owncloud\\\/remote.php(165): require_once('\\\/var\\\/www\\\/ownclo...')\\n#18 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":71,\"User\":\"fawzi\"}"}
{"reqId":"YAiD9Quchf9It7tENFbS","level":3,"time":"2017-10-24T10:57:35-07:00","remoteAddr":"192.168.1.254","user":"fawzi","app":"PHP","method":"GET","url":"\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","message":"Undefined index: icon at \/var\/www\/owncloud\/apps\/notifications\/lib\/Handler.php#288"}
{"reqId":"YAiD9Quchf9It7tENFbS","level":3,"time":"2017-10-24T10:57:35-07:00","remoteAddr":"192.168.1.254","user":"fawzi","app":"PHP","method":"GET","url":"\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","message":"Undefined index: icon at \/var\/www\/owncloud\/apps\/notifications\/lib\/Handler.php#288"}
{"reqId":"YAiD9Quchf9It7tENFbS","level":3,"time":"2017-10-24T10:57:35-07:00","remoteAddr":"192.168.1.254","user":"fawzi","app":"PHP","method":"GET","url":"\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","message":"Undefined index: icon at \/var\/www\/owncloud\/apps\/notifications\/lib\/Handler.php#288"}
{"reqId":"YAiD9Quchf9It7tENFbS","level":3,"time":"2017-10-24T10:57:35-07:00","remoteAddr":"192.168.1.254","user":"fawzi","app":"PHP","method":"GET","url":"\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","message":"Undefined index: icon at \/var\/www\/owncloud\/apps\/notifications\/lib\/Handler.php#288"}
{"reqId":"pcgFnEKh1pdDjIgy1ynV","level":3,"time":"2017-10-24T11:02:35-07:00","remoteAddr":"192.168.1.254","user":"fawzi","app":"PHP","method":"GET","url":"\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","message":"Undefined index: icon at \/var\/www\/owncloud\/apps\/notifications\/lib\/Handler.php#288"}
{"reqId":"pcgFnEKh1pdDjIgy1ynV","level":3,"time":"2017-10-24T11:02:35-07:00","remoteAddr":"192.168.1.254","user":"fawzi","app":"PHP","method":"GET","url":"\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","message":"Undefined index: icon at \/var\/www\/owncloud\/apps\/notifications\/lib\/Handler.php#288"}
{"reqId":"pcgFnEKh1pdDjIgy1ynV","level":3,"time":"2017-10-24T11:02:35-07:00","remoteAddr":"192.168.1.254","user":"fawzi","app":"PHP","method":"GET","url":"\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","message":"Undefined index: icon at \/var\/www\/owncloud\/apps\/notifications\/lib\/Handler.php#288"}
{"reqId":"pcgFnEKh1pdDjIgy1ynV","level":3,"time":"2017-10-24T11:02:35-07:00","remoteAddr":"192.168.1.254","user":"fawzi","app":"PHP","method":"GET","url":"\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","message":"Undefined index: icon at \/var\/www\/owncloud\/apps\/notifications\/lib\/Handler.php#288"}
有什么想法可以解决这个问题吗?
答案1
您的安装可能已损坏。您的数据库中有一些不应该存在的内容。我认为您有两个选择。截断 oc_properties 表。但您可能会丢失数据,因为其中还有其他重要信息。或者您尝试迁移到 Nextcloud,这会在此过程中清理数据库。至少这是它为我做的。无论如何,Nextcloud 的错误较少。我希望这能有所帮助。