03/01/2019 11:48:39Une erreur est survenue lors de l'ouverture d'un dossier : Error transferring http://server's ip/remote.php/dav/files/username - server replied: Internal Server Error

docker
webdav_issue

#1

Hi ,
Sorry for my English ;
I’m new between you, hope you help me find out a solution for my issue, I installed owncloud in docker, all is well, but I just had this error when I wanted to synchronize from owncloud Desktop,

server
Web server: Apache 2.4
Database: MySql
PHP version: 7.2
ownCloud version: 10.0.10

Client version: 2.5.0
Operating system: Windows 10
Desktop version 2.5.1


#2

Could you look in your server log and post the error here?


#3

thank your for your answer ,

{“reqId”:“3456aa64-23cf-46b8-b239-f7bf2fe785b5”,“level”:0,“time”:“2019-01-03T15:05:25+00:00”,“remoteAddr”:“192.168.2.198”,“user”:“Pointage”,“app”:“OC\Authentication\Token\DefaultTokenProvider::getToken”,“method”:“PROPFIND”,“url”:"/remote.php/dav/files/Pointage/",“message”:“token 8b2a4e26edbbb1cfde01358c81ab7540cebc127f80746201b1f706ee5181972b46a7d1f6c96b0f939fdc5f2cf44703fae8e81be3ba3b9508fe8d728755f0dee7 does not exist”}
{“reqId”:“GkWKiW9RYTdHFeRdhnuW”,“level”:0,“time”:“2019-01-03T15:05:35+00:00”,“remoteAddr”:“192.168.2.198”,“user”:“adminowncloud”,“app”:“OC\User\Session::validateToken”,“method”:“GET”,“url”:"/ocs/v2.php/apps/notifications/api/v1/notifications?format=json",“message”:“token 355b673d3de695cb49b44020b1ce2a225cb8448a10137f90d7dd64e28915a4d409c4dd420c0cc37f35a92c4403df825f1ac5c698b5648d935ef4f9f8348dbcde with token id 72 found, validating”}
{“reqId”:“GkWKiW9RYTdHFeRdhnuW”,“level”:0,“time”:“2019-01-03T15:05:35+00:00”,“remoteAddr”:“192.168.2.198”,“user”:“adminowncloud”,“app”:“OC\User\Session::validateToken”,“method”:“GET”,“url”:"/ocs/v2.php/apps/notifications/api/v1/notifications?format=json",“message”:“token 355b673d3de695cb49b44020b1ce2a225cb8448a10137f90d7dd64e28915a4d409c4dd420c0cc37f35a92c4403df825f1ac5c698b5648d935ef4f9f8348dbcde with token id 72 found, validating”}
{“reqId”:“41584743-d882-411c-aade-0d5bf0d9856b”,“level”:0,“time”:“2019-01-03T15:05:36+00:00”,“remoteAddr”:“192.168.2.198”,“user”:“Pointage”,“app”:“OC\Authentication\Token\DefaultTokenProvider::updateToken”,“method”:“PROPFIND”,“url”:"/remote.php/dav/files/Pointage/",“message”:“updating token 73, last check is now 1546425728”}
{“reqId”:“41584743-d882-411c-aade-0d5bf0d9856b”,“level”:0,“time”:“2019-01-03T15:05:36+00:00”,“remoteAddr”:“192.168.2.198”,“user”:“Pointage”,“app”:“OC\Authentication\Token\DefaultTokenProvider::getToken”,“method”:“PROPFIND”,“url”:"/remote.php/dav/files/Pointage/",“message”:“token 8b2a4e26edbbb1cfde01358c81ab7540cebc127f80746201b1f706ee5181972b46a7d1f6c96b0f939fdc5f2cf44703fae8e81be3ba3b9508fe8d728755f0dee7 does not exist”}
{“reqId”:“w9QgXV6FhEpUvDacpj7Y”,“level”:0,“time”:“2019-01-03T15:05:51+00:00”,“remoteAddr”:“192.168.2.198”,“user”:“adminowncloud”,“app”:“OC\User\Session::validateToken”,“method”:“GET”,“url”:"/ocs/v2.php/apps/notifications/api/v1/notifications?format=json",“message”:“token 355b673d3de695cb49b44020b1ce2a225cb8448a10137f90d7dd64e28915a4d409c4dd420c0cc37f35a92c4403df825f1ac5c698b5648d935ef4f9f8348dbcde with token id 72 found, validating”}
{“reqId”:“w9QgXV6FhEpUvDacpj7Y”,“level”:0,“time”:“2019-01-03T15:05:51+00:00”,“remoteAddr”:“192.168.2.198”,“user”:“adminowncloud”,“app”:“OC\Authentication\Token\DefaultTokenProvider::updateTokenActivity”,“method”:“GET”,“url”:"/ocs/v2.php/apps/notifications/api/v1/notifications?format=json",“message”:“updating activity of token 72 to 1546527951”}


#4

Hey,

maybe you can set a more / better fitting debug level (e.g. the default of 2) in your config/config.php:

https://doc.owncloud.org/server/administration_manual/configuration/server/logging_configuration.html

and then try again to not have too much unrelated logging (like currently) in the owncloud.log.


#5

Hey tom42 ,
i did as you asked me ,
here what i found .
{“reqId”:“4a18c0c5-25c9-4562-b661-2a7858bb87cf”,“level”:4,“time”:“2019-01-04T10:33:26+00:00”,“remoteAddr”:“192.168.2.198”,“user”:“Pointage”,“app”:“webdav”,“method”:“PROPFIND”,“url”:"/remote.php/dav/files/Pointage/",“message”:“Exception: An exception occurred while executing 'SELECT * FROM oc_properties WHERE fileid IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND propertyname in (?) ORDER BY propertyname’ with params [“255857”, “390875”, “390874”, “67904”, “67905”, “390927”, “390891”, “390886”, “390916”, “390892”, “390894”, “390930”, “{http:\/\/owncloud.org\/ns}checksums”]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘fileid’ in ‘where clause’: {“Exception”:“Doctrine\\DBAL\\Exception\\InvalidFieldNameException”,“Message”:“An exception occurred while executing 'SELECT * FROM oc_properties WHERE fileid IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND propertyname in (?) ORDER BY propertyname’ with params [\“255857\”, \“390875\”, \“390874\”, \“67904\”, \“67905\”, \“390927\”, \“390891\”, \“390886\”, \“390916\”, \“390892\”, \“390894\”, \“390930\”, \”{http:\\\/\\\/owncloud.org\\\/ns}checksums\”]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘fileid’ in ‘where clause’",“Code”:0,“Trace”:"#0 \/var\/www\/html\/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\/html\/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\\\/html\\\/lib\\\/private\\\/DB\\\/Connection.php(187): Doctrine\\\\DBAL\\\\Connection->executeQuery('SELECT * FROM…’, Array, Array, NULL)\n#3 \/var\/www\/html\/apps\/dav\/lib\/DAV\/FileCustomPropertiesBackend.php(244): OC\\DB\\Connection->executeQuery(‘SELECT * FROM `…’, Array, Array)\n#4 \/var\/www\/html\/apps\/dav\/lib\/DAV\/AbstractCustomPropertiesBackend.php(182): OCA\\DAV\\DAV\\FileCustomPropertiesBackend->loadChildrenProperties(Object(OCA\\DAV\\Connector\\Sabre\\Directory), Array)\n#5 \/var\/www\/html\/lib\/composer\/sabre\/dav\/lib\/DAV\/PropertyStorage\/Plugin.php(91): OCA\\DAV\\DAV\\AbstractCustomPropertiesBackend->propFind(‘files\/Pointage’, 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\/html\/lib\/composer\/sabre\/event\/lib\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\n#8 \/var\/www\/html\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(1058): Sabre\\Event\\EventEmitter->emit(‘propFind’, Array)\n#9 \/var\/www\/html\/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\/html\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(1665): Sabre\\DAV\\Server->getPropertiesIteratorForPath(‘files\/Pointage’, Array, 1)\n#11 \/var\/www\/html\/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\/html\/lib\/composer\/sabre\/event\/lib\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\n#14 \/var\/www\/html\/lib\/composer\/sabre\/dav\/lib\/DAV\/Server.php(479): Sabre\\Event\\EventEmitter->emit(‘method:PROPFIND’, Array)\n#15 \/var\/www\/html\/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\/html\/apps\/dav\/lib\/Server.php(298): Sabre\\DAV\\Server->exec()\n#17 \/var\/www\/html\/apps\/dav\/appinfo\/v2\/remote.php(31): OCA\\DAV\\Server->exec()\n#18 \/var\/www\/html\/remote.php(165): require_once(’\/var\/www\/html\/a…’)\n#19 {main}",“File”:"\/var\/www\/html\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php",“Line”:71}"}


#6

Hey,

it seems this indeed has now lead to the info where the issue is coming from:

This has been discussed in the past in the following thread below where various possible solutions / workarounds have been provided by several users:


#7

Thank you tom42 ,
I fixed it by adding fileid in oc_properties