iPad专业版上的owncloud客户端ver3.6.2无法连接到owncloud 10服务器。 “此时无法连接到服务器”

我有自己的云10.0.3 Ubuntu 17.04服务器。 我可以使用多个用户通过Web浏览器,并通过Windows 10上的自有云桌面客户端从多个桌面访问它。

我以前使用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进行的每一次login尝试,我都无法理解:

 {"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"} 

有关如何解决这个问题的任何想法?

您的安装可能已损坏。 数据库中有些东西不应该在那里。 我想你有两个select。 截断oc_properties表。 但是,由于其他重要信息,您可能会丢失数据。 或者您尝试迁移到在进程中清理数据库的Nextcloud。 至less这是对我所做的。 Nextcloud反正有更less的错误。 我希望这有帮助。