Sync/Webdav issues after upgrade to 10.0.7 (solved)

hosting

#1

Steps to reproduce

  1. mount -tdavfs https://cloud.csa-gmbh.com/remote.php/webdav /d3/ownCloud -orw
  2. using desktopClient Linux version2.4.1 (build 9083)
  3. using android client version 2.6.0

Expected behaviour

using mount: cloudfolders should be visible
using desktop client: Files should be synced
using adroid client: Files should be synced

Actual behaviour

case mount: username password are not accepted
case DesktopClient: server replied "Internal Server Error
case Android Client: no sync without error messages

Server configuration

Ubuntu Linux 10.04.4 LTE

Web server:
Apache2 2.2.14

Database:
mysql version 5.5.32

PHP version:
5.6.10

ownCloud version: (see ownCloud admin page)
Systemstatus
installed 1
maintenance
needsDbUpgrade
version 10.0.7.2
versionstring 10.0.7
edition Community
productname ownCloud
hostname guliver

Updated from an older ownCloud or fresh install:
tried both ways but configuration.php was copied from former version and database was exported and imported from former versions

Where did you install ownCloud from:
/d3/software/owncloud-10.0.7.tar.bz2

Signing status (ownCloud 9.0 and above):
??

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.
Technical information
=====================
The following list covers which files have failed the integrity check. Please read
the previous linked documentation to learn more about the errors and how to fix
them.

Results
=======
- core
	- FILE_MISSING
		- CHANGELOG.md
		- COPYING
	- EXTRA_FILE
		- robots.txt

Raw output
==========
Array
(
    [core] => Array
        (
            [FILE_MISSING] => Array
                (
                    [CHANGELOG.md] => Array
                        (
                            [expected] => 4e02ead8cbae969f9b2231ee54bb7b3c2572dcc01343bbe2d46b399526d9bba379bd5425f57e9da002e105bfdd3d16fdb946c3c1b814a371ed6611fd565819e2
                            [current] => 
                        )

                    [COPYING] => Array
                        (
                            [expected] => 3a02a6ec14e9d076b79aea8301eab31053c6600b68dcfa6261e10edaa7296a87c8767e35f2411d234b90111fcaf6b4a55c49aa2790a1a0d015213218bb7549fc
                            [current] => 
                        )

                )

            [EXTRA_FILE] => Array
                (
                    [robots.txt] => Array
                        (
                            [expected] => 
                            [current] => 63a36e950e134b5217e33c763e88840c10a07d80e6057d92b9ac97508de7fb1fa6f0e9b7531e169657165ea764e8963399cb6d921ffe6078425aaafe54c04563
                        )

                )

        )

)
**The content of config/config.php:**
{
    "system": {
        "instanceid": "51af48c30db99",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "datadirectory": "\/d2\/csa-cloud\/data",
        "dbtype": "mysql",
        "version": "10.0.7.2",
        "dbname": "csa_cloud",
        "dbhost": "127.0.0.1",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "forcessl": true,
        "theme": "",
        "maintenance": false,
        "loglevel": 3,
        "trusted_domains": [
            "cloud.csa-gmbh.com"
        ],
        "secret": "***REMOVED SENSITIVE VALUE***",
        "share_folder": "\/Shared",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "appstore.experimental.enabled": true,
        "trashbin_retention_obligation": "auto",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "25",
        "integrity.excluded.files": [
            "robots.txt",
            "CHANGELOG.md",
            "COPYING"
        ]
    }
}

**List of activated apps:**
Enabled:
  - calendar: 1.5.5
  - comments: 0.3.0
  - configreport: 0.1.1
  - contacts: 1.5.3
  - dav: 0.3.2
  - external: true
  - federatedfilesharing: 0.3.1
  - federation: 0.1.0
  - files: 1.5.1
  - files_external: 0.7.1
  - files_sharing: 0.10.1
  - files_trashbin: 0.9.1
  - files_versions: 1.3.0
  - files_videoplayer: 0.9.8
  - market: 0.2.3
  - notifications: 0.3.2
  - provisioning_api: 0.5.0
  - systemtags: 0.3.0
  - templateeditor: 0.2
  - updatenotification: 0.2.1
Disabled:
  - encryption
  - firstrunwizard
  - theme-example
  - user_external


**Are you using external storage, if yes which one:** local/smb/sftp/...
no

**Are you using encryption:** yes/no
no

**Are you using an external user-backend, if yes which one:** LDAP/ActiveDirectory/Webdav/...
no



### Client configuration
Chrome

**Operating system:**
Ubuntu Linux 16.04.4 LTE

### Logs
#### Web server error log
no entries related to access cloud

Insert your webserver log here
217.5.156.60 - rb [11/Mar/2018:13:54:59 +0100] "GET /status.php HTTP/1.1" 200 132 "-" "Mozilla/5.0 (Linux) mirall/2.1.1"
217.5.156.60 - rb [11/Mar/2018:13:55:00 +0100] "PROPFIND /remote.php/webdav/ HTTP/1.1" 403 220 "-" "Mozilla/5.0 (Linux) mirall/2.1.1"
217.5.156.60 - brb [11/Mar/2018:13:55:14 +0100] "PROPFIND /remote.php/dav/files/brb/ HTTP/1.1" 207 511 "-" "Mozilla/5.0 (Linux) mirall/2.4.1 (build 9083)"
217.5.156.60 - brb [11/Mar/2018:13:55:22 +0100] "PROPFIND /remote.php/dav/files/brb/ HTTP/1.1" 207 475 "-" "Mozilla/5.0 (Linux) mirall/2.4.1 (build 9083)"

#### ownCloud log (data/owncloud.log)
{"reqId":"f63bb26b-9bf0-4287-b2df-98d38e682eb2","level":3,"time":"2018-03-11T11:55:09+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"f63bb26b-9bf0-4287-b2df-98d38e682eb2","level":3,"time":"2018-03-11T11:55:09+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"f63bb26b-9bf0-4287-b2df-98d38e682eb2","level":3,"time":"2018-03-11T11:55:09+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"f63bb26b-9bf0-4287-b2df-98d38e682eb2","level":3,"time":"2018-03-11T11:55:09+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"f63bb26b-9bf0-4287-b2df-98d38e682eb2","level":3,"time":"2018-03-11T11:55:09+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"f63bb26b-9bf0-4287-b2df-98d38e682eb2","level":3,"time":"2018-03-11T11:55:09+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"f63bb26b-9bf0-4287-b2df-98d38e682eb2","level":3,"time":"2018-03-11T11:55:09+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"0aff5aed-f6b9-48cc-b7be-bb1f6feedb65","level":3,"time":"2018-03-11T11:55:22+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"0aff5aed-f6b9-48cc-b7be-bb1f6feedb65","level":3,"time":"2018-03-11T11:55:22+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"0aff5aed-f6b9-48cc-b7be-bb1f6feedb65","level":3,"time":"2018-03-11T11:55:22+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"0aff5aed-f6b9-48cc-b7be-bb1f6feedb65","level":3,"time":"2018-03-11T11:55:22+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"0aff5aed-f6b9-48cc-b7be-bb1f6feedb65","level":3,"time":"2018-03-11T11:55:22+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"0aff5aed-f6b9-48cc-b7be-bb1f6feedb65","level":3,"time":"2018-03-11T11:55:22+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"0aff5aed-f6b9-48cc-b7be-bb1f6feedb65","level":3,"time":"2018-03-11T11:55:22+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"bc798d4b-4bf9-4817-8863-a55b5a14c99d","level":3,"time":"2018-03-11T11:55:39+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"bc798d4b-4bf9-4817-8863-a55b5a14c99d","level":3,"time":"2018-03-11T11:55:39+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"bc798d4b-4bf9-4817-8863-a55b5a14c99d","level":3,"time":"2018-03-11T11:55:39+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"bc798d4b-4bf9-4817-8863-a55b5a14c99d","level":3,"time":"2018-03-11T11:55:39+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"bc798d4b-4bf9-4817-8863-a55b5a14c99d","level":3,"time":"2018-03-11T11:55:39+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"bc798d4b-4bf9-4817-8863-a55b5a14c99d","level":3,"time":"2018-03-11T11:55:39+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"bc798d4b-4bf9-4817-8863-a55b5a14c99d","level":3,"time":"2018-03-11T11:55:39+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"489a09c7-2ee0-43f0-a24b-9000746d27dd","level":3,"time":"2018-03-11T11:55:52+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"489a09c7-2ee0-43f0-a24b-9000746d27dd","level":3,"time":"2018-03-11T11:55:52+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"489a09c7-2ee0-43f0-a24b-9000746d27dd","level":3,"time":"2018-03-11T11:55:52+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"489a09c7-2ee0-43f0-a24b-9000746d27dd","level":3,"time":"2018-03-11T11:55:52+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"489a09c7-2ee0-43f0-a24b-9000746d27dd","level":3,"time":"2018-03-11T11:55:52+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"489a09c7-2ee0-43f0-a24b-9000746d27dd","level":3,"time":"2018-03-11T11:55:52+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}
{"reqId":"489a09c7-2ee0-43f0-a24b-9000746d27dd","level":3,"time":"2018-03-11T11:55:52+00:00","remoteAddr":"217.5.156.60","user":"brb","app":"PHP","method":"PROPFIND","url":"\/remote.php\/dav\/files\/brb\/","message":"Undefined index: share_name at \/d2\/httpd\/csa-cloud\/lib\/private\/Share20\/DefaultShareProvider.php#1002"}

Browser log

./. - no issues with browser

additional Info

access to files and directory in browser without any issues
access to calandar and contacts with android and linux thunderbird without issues


#2

It was a little tricky, but I read the error messages in the owncloud.log file and found out, that two tables had missing colums:

oc-properties: there was a field fileid integer missing
i just added the field by mysql command

oc-share: there was a field share_name varchar(64) missing
I added the field by running sudo -u apacheuser php occ migrations:execute core 20170320173955 from the command line

After those modification client sync works again as expected.