Several issues known from OC

aronovgj · June 14, 2016, 2:09pm

Wasn’t sure if this is worth posting on GitHub.

I try to upgrade from OC 8.2.5 to Nextcloud 9.

Problem:
Calendar and contacts don’t work properly after running into some bugs known from Owncloud.

I’m looking for a way to work around them.

nginx 1.4.6 (in test environment but 1.11.1 in productive environment. No difference)
PHP 5.5.9
MySQL 5.5.49

/var/www/nextcloud/config/config.php

 "system": {
        "instanceid": "ocro13eb0f5c",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost"
        ],
        "datadirectory": "\/home\/me\/owncloud\/data",
        "overwrite.cli.url": "http:\/\/xxx.xxx.xxx.xxx",
        "overwriteprotocol": "",
        "dbtype": "mysql",
        "version": "9.0.50.0",
        "dbname": "owncloud",
        "dbhost": "localhost",
        "filelocking.enabled": "true",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "logtimezone": "CEST",
        "installed": true,
        "maintenance": false,
        "asset-pipeline.enabled": false,
        "theme": "",
        "loglevel": 1,
        "logfile": "\/var\/log\/owncloud.log",
        "log_rotate_size": 10485760,
        "trashbin_retention_obligation": "auto",
        "mail_from_address": "me",
        "mail_smtpmode": "smtp",
        "mail_domain": "me.net",
        "mail_smtpsecure": "ssl",
        "mail_smtpport": "465",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpauth": 1,
        "mail_smtphost": "mail.me.net",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "ldapIgnoreNamingRules": false
    },

/etc/nginx/conf.d/default.conf

upstream php-handler {
 # server 127.0.0.1:9000;
  server unix:/var/run/php5-fpm.sock;
}

server {
  listen 80;
  server_name localhost;
  # enforce https
  return 301 https://$server_name$request_uri;
}


server {
  listen 443 ssl;
  server_name localhost;


  ssl_certificate /etc/apache2/ssl/apache.crt;
  ssl_certificate_key /etc/apache2/ssl/apache.key;

      # Add headers to serve security related headers
    # Before enabling Strict-Transport-Security headers please read into this
    # topic first.
    # add_header Strict-Transport-Security "max-age=15768000;
    # includeSubDomains; preload;";
    add_header X-Content-Type-Options nosniff;
    add_header X-Frame-Options "SAMEORIGIN";
    add_header X-XSS-Protection "1; mode=block";
    add_header X-Robots-Tag none;
    add_header X-Download-Options noopen;
    add_header X-Permitted-Cross-Domain-Policies none;

    # Path to the root of your installation
    root /var/www/nextcloud/;

    location = /robots.txt {
        allow all;
        log_not_found off;
        access_log off;
    }

    # The following 2 rules are only needed for the user_webfinger app.
    # Uncomment it if you're planning to use this app.
    #rewrite ^/.well-known/host-meta /public.php?service=host-meta last;
    #rewrite ^/.well-known/host-meta.json /public.php?service=host-meta-json
    # last;

    location = /.well-known/carddav { return 301
     $scheme://$host/remote.php/dav; }
    location = /.well-known/caldav { return 301
     $scheme://$host/remote.php/dav; }

    location /.well-known/acme-challenge { }

    # set max upload size
    client_max_body_size 512M;
    fastcgi_buffers 64 4K;

    # Disable gzip to avoid the removal of the ETag header
    gzip off;

    # Uncomment if your server is build with the ngx_pagespeed module
    # This module is currently not supported.
    #pagespeed off;

    error_page 403 /core/templates/403.php;
    error_page 404 /core/templates/404.php;

    location / {
        rewrite ^ /index.php$uri;
    }

    location ~ ^/(?:build|tests|config|lib|3rdparty|templates|data)/ {
        deny all;
    }
    location ~ ^/(?:\.|autotest|occ|issue|indie|db_|console) {
        deny all;
    }

    location ~
    ^/(?:index|remote|public|cron|core/ajax/update|status|ocs/v[12]|updater/.+|ocs-provider/.+|core/templates/40[34])\.php(?:$|/) {
        include fastcgi_params;
        fastcgi_split_path_info ^(.+\.php)(/.+)$;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        fastcgi_param PATH_INFO $fastcgi_path_info;
        fastcgi_param HTTPS on;
        #Avoid sending the security headers twice
        fastcgi_param modHeadersAvailable true;
        fastcgi_param front_controller_active true;
        fastcgi_pass php-handler;
        fastcgi_intercept_errors on;
        #fastcgi_request_buffering off;
    }

    location ~ ^/(?:updater|ocs-provider)(?:$|/) {
        try_files $uri/ =404;
        index index.php;
    }

    # Adding the cache control header for js and css files
    # Make sure it is BELOW the PHP block
    location ~* \.(?:css|js)$ {
        try_files $uri /index.php$uri$is_args$args;
        add_header Cache-Control "public, max-age=7200";
        # Add headers to serve security related headers (It is intended to
        # have those duplicated to the ones above)
        # Before enabling Strict-Transport-Security headers please read into
        # this topic first.
        # add_header Strict-Transport-Security "max-age=15768000;
        #  includeSubDomains; preload;";
        add_header X-Content-Type-Options nosniff;
        add_header X-Frame-Options "SAMEORIGIN";
        add_header X-XSS-Protection "1; mode=block";
        add_header X-Robots-Tag none;
        add_header X-Download-Options noopen;
        add_header X-Permitted-Cross-Domain-Policies none;
        # Optional: Don't log access to assets
        access_log off;
    }

    location ~* \.(?:svg|gif|png|html|ttf|woff|ico|jpg|jpeg)$ {
        try_files $uri /index.php$uri$is_args$args;
        # Optional: Don't log access to other assets
        access_log off;
    }
}

Backup owncloud folder
Remove owncloud folder
Unzip Nextcloud
Fix permissions
Restore config.php
Change nginx root to match Nextcloud

when doing
sudo -u www-data php /var/www/nextcloud/occ upgrade
I get errors looking much like here:

github.com/owncloud/core

Upgrade from 8.2.3 to 9.0.1 result in some errors (table already exist)

opened 03:09PM - 08 Apr 16 UTC

closed 02:03PM - 13 Dec 17 UTC

rpelissi

needs info feature:update

### Steps to reproduce 1. Install owncloud on centos 7.2 and mariodb on another server, php 5.5.34 and ldap 2. Try to upgrade from 8.2.3 to 9.0.1 3. ### Expected behaviour Upgrade should works (at least the installer should detect that the tables already exist and update them instead of trying to create them) ### Actual behaviour Upgrade fail because of some mysql error messages ### Server configuration **Operating system**: Centos 7.2 **Web server:** Apache **Database:** mariadb 10.10.22 **PHP version:** 5.5.34 **ownCloud version:** (see ownCloud admin page) 8.2.3 **Updated from an older ownCloud or fresh install:** yes **Where did you install ownCloud from:** **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 here. ``` **List of activated apps:** ``` If you have access to your command line run e.g.: sudo -u www-data php occ app:list from within your ownCloud installation folder ``` **The content of config/config.php:** ``` If you have access to your command line run e.g.: sudo -u www-data php occ config:list system from within your ownCloud installation folder or Insert your config.php content here (Without the database password, passwordsalt and secret) ``` **Are you using external storage, if yes which one:** local/smb/sftp/... **Are you using encryption:** yes/no **Are you using an external user-backend, if yes which one:** LDAP/ActiveDirectory/Webdav/... #### LDAP configuration (delete this part if not used) ``` With access to your command line run e.g.: sudo -u www-data php occ ldap:show-config from within your ownCloud installation folder Without access to your command line download the data/owncloud.db to your local computer or access your SQL server remotely and run the select query: SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap'; Eventually replace sensitive data as the name/IP-address of your LDAP server or groups. ``` ### Client configuration **Browser:** **Operating system:** ### Logs Here are the logs from the upgrade: ``` bash-4.2$ ./occ upgrade ownCloud or one of the apps require upgrade - only a limited number of commands are available You may use your browser or the occ upgrade command to do the upgrade Set log level to debug Turned on maintenance mode Checking whether the database schema can be updated (this can take a long time depending on the database size) Checked database schema update Checking updates of apps Checking whether the database schema for <activity> can be updated (this can take a long time depending on the database size) Checking whether the database schema for <files_sharing> can be updated (this can take a long time depending on the database size) Checking whether the database schema for <user_ldap> can be updated (this can take a long time depending on the database size) Checked database schema update for apps Updating database schema Updated database Updating <files_pdfviewer> ... Updated <files_pdfviewer> to 0.8 Updating <files_texteditor> ... Updated <files_texteditor> to 2.1 Updating <gallery> ... Updated <gallery> to 14.5.0 Updating <user_ldap> ... Updated <user_ldap> to 0.8.0 Updating <files> ... Updated <files> to 1.4.4 Updating <activity> ... Updated <activity> to 2.2.1 Updating <files_sharing> ... Updated <files_sharing> to 0.9.1 Updating <files_versions> ... Updated <files_versions> to 1.2.0 notifications: An exception occurred while executing 'CREATE TABLE `oc_notifications` (`notification_id` INT AUTO_INCREMENT NOT NULL, `app` VARCHAR(32) NOT NULL, `user` VARCHAR(64) NOT NULL, `timestamp` INT DEFAULT 0 NOT NULL, `object_type` VARCHAR(64) NOT NULL, `object_id` VARCHAR(64) NOT NULL, `subject` VARCHAR(64) NOT NULL, `subject_parameters` LONGTEXT DEFAULT NULL, `message` VARCHAR(64) DEFAULT NULL, `message_parameters` LONGTEXT DEFAULT NULL, `link` VARCHAR(4000) DEFAULT NULL, `actions` LONGTEXT DEFAULT NULL, INDEX oc_notifications_app (`app`), INDEX oc_notifications_user (`user`), INDEX oc_notifications_timestamp (`timestamp`), INDEX oc_notifications_object (`object_type`, `object_id`), PRIMARY KEY(`notification_id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_notifications' already exists federation: An exception occurred while executing 'CREATE TABLE `oc_trusted_servers` (`id` INT AUTO_INCREMENT NOT NULL, `url` VARCHAR(512) NOT NULL COMMENT 'Url of trusted server', `url_hash` VARCHAR(255) DEFAULT '' NOT NULL COMMENT 'sha1 hash of the url without the protocol', `token` VARCHAR(128) DEFAULT NULL COMMENT 'token used to exchange the shared secret', `shared_secret` VARCHAR(256) DEFAULT NULL COMMENT 'shared secret used to authenticate', `status` INT DEFAULT 2 NOT NULL COMMENT 'current status of the connection', `sync_token` VARCHAR(512) DEFAULT NULL COMMENT 'cardDav sync token', UNIQUE INDEX url_hash (`url_hash`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_trusted_servers' already exists files_trashbin: An exception occurred while executing 'CREATE TABLE `oc_files_trash` (`auto_id` INT AUTO_INCREMENT NOT NULL, `id` VARCHAR(250) DEFAULT '' NOT NULL, `user` VARCHAR(64) DEFAULT '' NOT NULL, `timestamp` VARCHAR(12) DEFAULT '' NOT NULL, `location` VARCHAR(512) DEFAULT '' NOT NULL, `type` VARCHAR(4) DEFAULT NULL, `mime` VARCHAR(255) DEFAULT NULL, INDEX id_index (`id`), INDEX timestamp_index (`timestamp`), INDEX user_index (`user`), PRIMARY KEY(`auto_id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_files_trash' already exists dav: An exception occurred while executing 'CREATE TABLE `oc_addressbooks` (`id` BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, `principaluri` VARCHAR(255) DEFAULT NULL, `displayname` VARCHAR(255) DEFAULT NULL, `uri` VARCHAR(255) DEFAULT NULL, `description` VARCHAR(255) DEFAULT NULL, `synctoken` INT UNSIGNED DEFAULT 1 NOT NULL, UNIQUE INDEX addressbook_index (`principaluri`, `uri`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_addressbooks' already exists Starting code integrity check... Finished code integrity check Update successful Turned off maintenance mode Reset log level bash-4.2$ ```

PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php5/20121212/apcu.so' - /usr/lib/php5/20121212/apcu.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php5/20121212/imagick.so' - /usr/lib/php5/20121212/imagick.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php5/20121212/memcached.so' - /usr/lib/php5/20121212/memcached.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php5/20121212/redis.so' - /usr/lib/php5/20121212/redis.so: cannot open shared object file: No such file or directory in Unknown on line 0
ownCloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Set log level to debug
Turned on maintenance mode
{"reqId":"q34bGPnLwEoynKZcDODk","remoteAddr":"","app":"core","message":"starting upgrade from 8.2.5.2 to 9.0.50.0","level":0,"time":"2016-06-14T15:09:29+02:00","method":"--","url":"--","user":"--"}
Checking whether the database schema can be updated (this can take a long time depending on the database size)
Checked database schema update
Checking updates of apps
Checked database schema update for apps
Updating database schema
Updated database
Disabled 3rd-party app: calendar
Disabled 3rd-party app: contacts
Disabled 3rd-party app: direct_menu
Disabled 3rd-party app: documents
Disabled 3rd-party app: galleryplus
Disabled 3rd-party app: logreader
Disabled 3rd-party app: updater
Updating <files_pdfviewer> ...
Updated <files_pdfviewer> to 0.8.1
Update 3rd-party app: calendar
Update 3rd-party app: contacts
Update 3rd-party app: direct_menu
Update 3rd-party app: documents
Update 3rd-party app: galleryplus
Update 3rd-party app: logreader
{"reqId":"q34bGPnLwEoynKZcDODk","remoteAddr":"","app":"federation","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\TableExistsException\",\"Message\":\"An exception occurred while executing 'CREATE TABLE `oc_trusted_servers` (`id` INT AUTO_INCREMENT NOT NULL, `url` VARCHAR(512) NOT NULL COMMENT 'Url of trusted server', `url_hash` VARCHAR(255) DEFAULT '' NOT NULL COMMENT 'sha1 hash of the url without the protocol', `token` VARCHAR(128) DEFAULT NULL COMMENT 'token used to exchange the shared secret', `shared_secret` VARCHAR(256) DEFAULT NULL COMMENT 'shared secret used to authenticate', `status` INT DEFAULT 2 NOT NULL COMMENT 'current status of the connection', `sync_token` VARCHAR(512) DEFAULT NULL COMMENT 'cardDav sync token', UNIQUE INDEX url_hash (`url_hash`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB':\\n\\nSQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_trusted_servers' already exists\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(116): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(945): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'CREATE TABLE `o...')\\n#2 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/db\\\/mdb2schemamanager.php(167): Doctrine\\\\DBAL\\\\Connection->query('CREATE TABLE `o...')\\n#3 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/db\\\/mdb2schemamanager.php(70): OC\\\\DB\\\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\\\DBAL\\\\Schema\\\\Schema))\\n#4 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/db.php(172): OC\\\\DB\\\\MDB2SchemaManager->createDbFromStructure('\\\/var\\\/www\\\/nextcl...')\\n#5 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/installer.php(586): OC_DB::createDbFromStructure('\\\/var\\\/www\\\/nextcl...')\\n#6 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/installer.php(556): OC_Installer::installShippedApp('federation')\\n#7 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/updater.php(334): OC_Installer::installShippedApps(true)\\n#8 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/updater.php(212): OC\\\\Updater->doUpgrade('9.0.50.0', '8.2.5.2')\\n#9 \\\/var\\\/www\\\/nextcloud\\\/core\\\/command\\\/upgrade.php(246): OC\\\\Updater->upgrade()\\n#10 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Command\\\/Command.php(259): OC\\\\Core\\\\Command\\\\Upgrade->execute(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#11 \\\/var\\\/www\\\/nextcloud\\\/core\\\/command\\\/base.php(158): Symfony\\\\Component\\\\Console\\\\Command\\\\Command->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#12 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(840): OC\\\\Core\\\\Command\\\\Base->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#13 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(192): Symfony\\\\Component\\\\Console\\\\Application->doRunCommand(Object(OC\\\\Core\\\\Command\\\\Upgrade), Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#14 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(123): Symfony\\\\Component\\\\Console\\\\Application->doRun(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#15 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/console\\\/application.php(145): Symfony\\\\Component\\\\Console\\\\Application->run(NULL, NULL)\\n#16 \\\/var\\\/www\\\/nextcloud\\\/console.php(88): OC\\\\Console\\\\Application->run()\\n#17 \\\/var\\\/www\\\/nextcloud\\\/occ(11): require_once('\\\/var\\\/www\\\/nextcl...')\\n#18 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":49}","level":3,"time":"2016-06-14T15:10:39+02:00","method":"--","url":"--","user":"--"}
federation: An exception occurred while executing 'CREATE TABLE `oc_trusted_servers` (`id` INT AUTO_INCREMENT NOT NULL, `url` VARCHAR(512) NOT NULL COMMENT 'Url of trusted server', `url_hash` VARCHAR(255) DEFAULT '' NOT NULL COMMENT 'sha1 hash of the url without the protocol', `token` VARCHAR(128) DEFAULT NULL COMMENT 'token used to exchange the shared secret', `shared_secret` VARCHAR(256) DEFAULT NULL COMMENT 'shared secret used to authenticate', `status` INT DEFAULT 2 NOT NULL COMMENT 'current status of the connection', `sync_token` VARCHAR(512) DEFAULT NULL COMMENT 'cardDav sync token', UNIQUE INDEX url_hash (`url_hash`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB':

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_trusted_servers' already exists
{"reqId":"q34bGPnLwEoynKZcDODk","remoteAddr":"","app":"dav","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\TableExistsException\",\"Message\":\"An exception occurred while executing 'CREATE TABLE `oc_addressbooks` (`id` BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, `principaluri` VARCHAR(255) DEFAULT NULL, `displayname` VARCHAR(255) DEFAULT NULL, `uri` VARCHAR(255) DEFAULT NULL, `description` VARCHAR(255) DEFAULT NULL, `synctoken` INT UNSIGNED DEFAULT 1 NOT NULL, UNIQUE INDEX addressbook_index (`principaluri`, `uri`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB':\\n\\nSQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_addressbooks' already exists\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(116): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(945): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'CREATE TABLE `o...')\\n#2 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/db\\\/mdb2schemamanager.php(167): Doctrine\\\\DBAL\\\\Connection->query('CREATE TABLE `o...')\\n#3 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/db\\\/mdb2schemamanager.php(70): OC\\\\DB\\\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\\\DBAL\\\\Schema\\\\Schema))\\n#4 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/db.php(172): OC\\\\DB\\\\MDB2SchemaManager->createDbFromStructure('\\\/var\\\/www\\\/nextcl...')\\n#5 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/installer.php(586): OC_DB::createDbFromStructure('\\\/var\\\/www\\\/nextcl...')\\n#6 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/installer.php(556): OC_Installer::installShippedApp('dav')\\n#7 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/updater.php(334): OC_Installer::installShippedApps(true)\\n#8 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/updater.php(212): OC\\\\Updater->doUpgrade('9.0.50.0', '8.2.5.2')\\n#9 \\\/var\\\/www\\\/nextcloud\\\/core\\\/command\\\/upgrade.php(246): OC\\\\Updater->upgrade()\\n#10 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Command\\\/Command.php(259): OC\\\\Core\\\\Command\\\\Upgrade->execute(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#11 \\\/var\\\/www\\\/nextcloud\\\/core\\\/command\\\/base.php(158): Symfony\\\\Component\\\\Console\\\\Command\\\\Command->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#12 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(840): OC\\\\Core\\\\Command\\\\Base->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#13 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(192): Symfony\\\\Component\\\\Console\\\\Application->doRunCommand(Object(OC\\\\Core\\\\Command\\\\Upgrade), Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#14 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(123): Symfony\\\\Component\\\\Console\\\\Application->doRun(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#15 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/console\\\/application.php(145): Symfony\\\\Component\\\\Console\\\\Application->run(NULL, NULL)\\n#16 \\\/var\\\/www\\\/nextcloud\\\/console.php(88): OC\\\\Console\\\\Application->run()\\n#17 \\\/var\\\/www\\\/nextcloud\\\/occ(11): require_once('\\\/var\\\/www\\\/nextcl...')\\n#18 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":49}","level":3,"time":"2016-06-14T15:10:39+02:00","method":"--","url":"--","user":"--"}
dav: An exception occurred while executing 'CREATE TABLE `oc_addressbooks` (`id` BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, `principaluri` VARCHAR(255) DEFAULT NULL, `displayname` VARCHAR(255) DEFAULT NULL, `uri` VARCHAR(255) DEFAULT NULL, `description` VARCHAR(255) DEFAULT NULL, `synctoken` INT UNSIGNED DEFAULT 1 NOT NULL, UNIQUE INDEX addressbook_index (`principaluri`, `uri`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB':

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_addressbooks' already exists
Starting code integrity check...
Finished code integrity check
Update successful
Turned off maintenance mode
Reset log level
{"reqId":"q34bGPnLwEoynKZcDODk","remoteAddr":"","app":"PHP","message":"PHP Startup: Unable to load dynamic library '\/usr\/lib\/php5\/20121212\/redis.so' - \/usr\/lib\/php5\/20121212\/redis.so: cannot open shared object file: No such file or directory at Unknown#0","level":3,"time":"2016-06-14T15:10:44+02:00","method":"--","url":"--","user":"--"}

I tried to drop the tables that are mentioned in the exception but then it just throws the same exceptions on other tables.
I just ignore it as suggested on github.

Next thing is this:

github.com/owncloud/core

remote.php errors after upgrade

opened 11:01AM - 28 Mar 16 UTC

closed 09:35AM - 06 Apr 16 UTC

TheOtterslider

Type:Bug feature:update

**Steps to reproduce** 1. working 8.2.3 server 2. download and unzip 9.0.0 tar 3…. copy config/config.php 4. upgrade (running occ upgrade manually from the command. it finished with no errors) **Expected behaviour** It should work **Actual behaviour** When I login, I get a "this directory is unavailable, please check the logs or contact the administrator error message displayed (for all users) When I check the logs, they are full of this: ``` Error PHP require_once(): Failed opening required '/var/www/html/owncloud/apps/files/appinfo/remote.php' (include_path='/var/www/html/owncloud/3rdparty/pear/console_getopt:/var/www/html/owncloud/3rdparty/pear/pear_exception:/var/www/html/owncloud/3rdparty/pear/pear-core-minimal/src:/var/www/html/owncloud/3rdparty/pear/archive_tar:/var/www/html/owncloud/3rdparty/phpseclib/phpseclib/phpseclib:/var/www/html/owncloud/lib/private:/var/www/html/owncloud/config:/var/www/html/owncloud/3rdparty:/var/www/html/owncloud/apps:.:/usr/share/pear:/usr/share/php:/var/www/html/owncloud') at /var/www/html/owncloud/remote.php#138 2016-03-27T13:03:01+00:00 Error PHP require_once(/var/www/html/owncloud/apps/files/appinfo/remote.php): failed to open stream: No such file or directory at /var/www/html/owncloud/remote.php#138 2016-03-27T13:03:01+00:00 Error PHP require_once(): Failed opening required '/var/www/html/owncloud/apps/files/appinfo/remote.php' (include_path='/var/www/html/owncloud/3rdparty/pear/console_getopt:/var/www/html/owncloud/3rdparty/pear/pear_exception:/var/www/html/owncloud/3rdparty/pear/pear-core-minimal/src:/var/www/html/owncloud/3rdparty/pear/archive_tar:/var/www/html/owncloud/3rdparty/phpseclib/phpseclib/phpseclib:/var/www/html/owncloud/lib/private:/var/www/html/owncloud/config:/var/www/html/owncloud/3rdparty:/var/www/html/owncloud/apps:.:/usr/share/pear:/usr/share/php:/var/www/html/owncloud') at /var/www/html/owncloud/remote.php#138 ``` I check...that file doesn't exist (/var/www/html/owncloud/apps/files/appinfo/remote.php). This is weird because I just unzipped the owncloud directory directly from the tar. But, I try to copy it and I get other errors (so I deleted it from files/appinfo and leave it in the root). I decide I'll just get it from github....hmm, it doesn't exist there. If I go to https://MyHost/owncloud/remote.php/webdav I get a 500 error thrown If I go to https://MyHost/owncloud/remote.php/dav I get prompted to login and then see the standard "this is the webdav interface" message I **think** the root problem is something messed up with webdav. When I upgraded to 8.2.3, I had to run the upgrade twice because I had some similar problems. When I reenabled the contacts and calendar apps, then did the upgrade again everything started working (in 8.2.3). I can go in and enable apps,once I got to that point, I decided to upgrade to 9. Just to clarify, what happened in the 8.2.3 upgrade was I upgraded, logged in just fine, enabled the contacts app, then got kicked out to the "you need to upgrade" web screen. I reran the upgrade from the command line. Same with calendar...enabled it, got kicked out to the "you need to upgrade" screen, so I rerean it from the command line. By the time I was all finished, everything worked Some more information, calendar and contacts work great...it is only files that is messed up. RealRancor on the forums thought it was related to .htaccess issues. I went and manually got the htaccess from the 9.0.1 beta branch. it didn't appear to be different than the file I had, but I put it in anyway. No change. **Server configuration** `Operating system: centos 6.7 (final) Web server: apache 2.2.15 Database: mysql 5.1.73 PHP version: 5.6.18 ownCloud version (see ownCloud admin page): 9.0.0 Updated from an older ownCloud or fresh install: upgrade from 8.2.3` **ownCloud log (data/owncloud.log):** ``` {"reqId":"FDSfwgNB9ZBx4Wwm5KGf","remoteAddr":"xxxxxxxxxxxx","app":"PHP","message":"require_once(): Failed opening required '\/var\/www\/html\/owncloud\/apps\/files\/appinfo\/remote.php' (include_path='\/var\/www\/html\/owncloud\/3rdparty\/pear\/console_getopt:\/var\/www\/html\/owncloud\/3rdparty\/pear\/pear_exception:\/var\/www\/html\/owncloud\/3rdparty\/pear\/pear-core-minimal\/src:\/var\/www\/html\/owncloud\/3rdparty\/pear\/archive_tar:\/var\/www\/html\/owncloud\/3rdparty\/phpseclib\/phpseclib\/phpseclib:\/var\/www\/html\/owncloud\/lib\/private:\/var\/www\/html\/owncloud\/config:\/var\/www\/html\/owncloud\/3rdparty:\/var\/www\/html\/owncloud\/apps:.:\/usr\/share\/pear:\/usr\/share\/php:\/var\/www\/html\/owncloud') at \/var\/www\/html\/owncloud\/remote.php#138","level":3,"time":"2016-03-27T13:09:25+00:00","method":"PROPFIND","url":"\/owncloud\/remote.php\/webdav\/"} {"reqId":"MLsH7dvlieo3PEL\/pfuo","remoteAddr":"xxxxxxxxxxxx","app":"PHP","message":"require_once(\/var\/www\/html\/owncloud\/apps\/files\/appinfo\/remote.php): failed to open stream: No such file or directory at \/var\/www\/html\/owncloud\/remote.php#138","level":3,"time":"2016-03-27T13:09:57+00:00","method":"PROPFIND","url":"\/owncloud\/remote.php\/webdav\/"} {"reqId":"MLsH7dvlieo3PEL\/pfuo","remoteAddr":"xxxxxxxxxxxx","app":"PHP","message":"require_once(): Failed opening required '\/var\/www\/html\/owncloud\/apps\/files\/appinfo\/remote.php' (include_path='\/var\/www\/html\/owncloud\/3rdparty\/pear\/console_getopt:\/var\/www\/html\/owncloud\/3rdparty\/pear\/pear_exception:\/var\/www\/html\/owncloud\/3rdparty\/pear\/pear-core-minimal\/src:\/var\/www\/html\/owncloud\/3rdparty\/pear\/archive_tar:\/var\/www\/html\/owncloud\/3rdparty\/phpseclib\/phpseclib\/phpseclib:\/var\/www\/html\/owncloud\/lib\/private:\/var\/www\/html\/owncloud\/config:\/var\/www\/html\/owncloud\/3rdparty:\/var\/www\/html\/owncloud\/apps:.:\/usr\/share\/pear:\/usr\/share\/php:\/var\/www\/html\/owncloud') at \/var\/www\/html\/owncloud\/remote.php#138","level":3,"time":"2016-03-27T13:09:57+00:00","method":"PROPFIND","url":"\/owncloud\/remote.php\/webdav\/"} {"reqId":"HRlhElEdaXXobvB+vxaD","remoteAddr":"xxxxxxxxxxxx","app":"PHP","message":"require_once(\/var\/www\/html\/owncloud\/apps\/files\/appinfo\/remote.php): failed to open stream: No such file or directory at \/var\/www\/html\/owncloud\/remote.php#138","level":3,"time":"2016-03-27T13:10:29+00:00","method":"PROPFIND","url":"\/owncloud\/remote.php\/webdav\/"} {"reqId":"HRlhElEdaXXobvB+vxaD","remoteAddr":"xxxxxxxxxxxx","app":"PHP","message":"require_once(): Failed opening required '\/var\/www\/html\/owncloud\/apps\/files\/appinfo\/remote.php' (include_path='\/var\/www\/html\/owncloud\/3rdparty\/pear\/console_getopt:\/var\/www\/html\/owncloud\/3rdparty\/pear\/pear_exception:\/var\/www\/html\/owncloud\/3rdparty\/pear\/pear-core-minimal\/src:\/var\/www\/html\/owncloud\/3rdparty\/pear\/archive_tar:\/var\/www\/html\/owncloud\/3rdparty\/phpseclib\/phpseclib\/phpseclib:\/var\/www\/html\/owncloud\/lib\/private:\/var\/www\/html\/owncloud\/config:\/var\/www\/html\/owncloud\/3rdparty:\/var\/www\/html\/owncloud\/apps:.:\/usr\/share\/pear:\/usr\/share\/php:\/var\/www\/html\/owncloud') at \/var\/www\/html\/owncloud\/remote.php#138","level":3,"time":"2016-03-27T13:10:29+00:00","method":"PROPFIND","url":"\/owncloud\/remote.php\/webdav\/"} {"reqId":"iH+ZeaqCte8TFqg9CljO","remoteAddr":"xxxxxxxxxxxx","app":"PHP","message":"require_once(\/var\/www\/html\/owncloud\/apps\/files\/appinfo\/remote.php): failed to open stream: No such file or directory at \/var\/www\/html\/owncloud\/remote.php#138","level":3,"time":"2016-03-27T13:11:01+00:00","method":"PROPFIND","url":"\/owncloud\/remote.php\/webdav\/"} {"reqId":"iH+ZeaqCte8TFqg9CljO","remoteAddr":"xxxxxxxxxxxx","app":"PHP","message":"require_once(): Failed opening required '\/var\/www\/html\/owncloud\/apps\/files\/appinfo\/remote.php' (include_path='\/var\/www\/html\/owncloud\/3rdparty\/pear\/console_getopt:\/var\/www\/html\/owncloud\/3rdparty\/pear\/pear_exception:\/var\/www\/html\/owncloud\/3rdparty\/pear\/pear-core-minimal\/src:\/var\/www\/html\/owncloud\/3rdparty\/pear\/archive_tar:\/var\/www\/html\/owncloud\/3rdparty\/phpseclib\/phpseclib\/phpseclib:\/var\/www\/html\/owncloud\/lib\/private:\/var\/www\/html\/owncloud\/config:\/var\/www\/html\/owncloud\/3rdparty:\/var\/www\/html\/owncloud\/apps:.:\/usr\/share\/pear:\/usr\/share\/php:\/var\/www\/html\/owncloud') at \/var\/www\/html\/owncloud\/remote.php#138","level":3,"time":"2016-03-27T13:11:01+00:00","method":"PROPFIND","url":"\/owncloud\/remote.php\/webdav\/"} {"reqId":"VTOqfcIKmtFOWuxXahps","remoteAddr":"xxxxxxxxxxxx","app":"PHP","message":"require_once(\/var\/www\/html\/owncloud\/apps\/files\/appinfo\/remote.php): failed to open stream: No such file or directory at \/var\/www\/html\/owncloud\/remote.php#138","level":3,"time":"2016-03-27T13:11:36+00:00","method":"PROPFIND","url":"\/owncloud\/remote.php\/webdav\/"} {"reqId":"VTOqfcIKmtFOWuxXahps","remoteAddr":xxxxxxxxxxxx","app":"PHP","message":"require_once(): Failed opening required '\/var\/www\/html\/owncloud\/apps\/files\/appinfo\/remote.php' (include_path='\/var\/www\/html\/owncloud\/3rdparty\/pear\/console_getopt:\/var\/www\/html\/owncloud\/3rdparty\/pear\/pear_exception:\/var\/www\/html\/owncloud\/3rdparty\/pear\/pear-core-minimal\/src:\/var\/www\/html\/owncloud\/3rdparty\/pear\/archive_tar:\/var\/www\/html\/owncloud\/3rdparty\/phpseclib\/phpseclib\/phpseclib:\/var\/www\/html\/owncloud\/lib\/private:\/var\/www\/html\/owncloud\/config:\/var\/www\/html\/owncloud\/3rdparty:\/var\/www\/html\/owncloud\/apps:.:\/usr\/share\/pear:\/usr\/share\/php:\/var\/www\/html\/owncloud') at \/var\/www\/html\/owncloud\/remote.php#138","level":3,"time":"2016-03-27T13:11:36+00:00","method":"PROPFIND","url":"\/owncloud\/remote.php\/webdav\/"} ``` **Special configuration (external storage, external authentication, reverse proxy, server-side-encryption):** nothing special **Login as admin user into your ownCloud and access http://example.com/index.php/settings/integrity/failed paste the results here.** ``` No errors have been found. ``` List of activated apps: If you have access to your command line run e.g.: sudo -u www-data php occ app:list from within your ownCloud installation folder ``` Enabled: - activity: 2.2.1 - calendar: true - comments: 0.2 - contacts: true - dav: 0.1.5 - federatedfilesharing: 0.1.0 - federation: 0.0.4 - files: 1.4.4 - files_external: 0.5.2 - files_pdfviewer: 0.8 - files_sharing: 0.9.1 - files_texteditor: 2.1 - files_trashbin: 0.8.0 - files_versions: 1.2.0 - firstrunwizard: 1.1 - gallery: 14.5.0 - notifications: 0.2.3 - provisioning_api: 0.4.1 - templateeditor: 0.1 Disabled: - encryption - external - files_videoplayer - systemtags - updatenotification - user_external - user_ldap ``` **The content of config/config.php:** If you have access to your command line run e.g.: sudo -u www-data php occ c from within your ownCloud installation folder or Insert your config.php content here (Without the database password, passwordsalt and secret) ``` { "system": { "instanceid": "oc8e61b24903", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "MYDOMAIN" ], "datadirectory": "\/Path\/To\/DataDir\/", "overwrite.cli.url": "https:\/\/MYDOMAIN\/owncloud", "dbtype": "mysql", "version": "9.0.0.19", "dbname": "owncloud", "dbhost": "localhost", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "forcessl": true, "mail_from_address": "admin", "mail_smtpmode": "php", "mail_domain": "MYDOMAIN", "theme": "", "maintenance": false, "secret": "***REMOVED SENSITIVE VALUE***", "singleuser": false, "loglevel": 0 } } ``` **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 **Browser:** - Chrome **Operating system:** Mac OSx 10.11.3 ### Logs #### Web server error log ``` [Mon Mar 28 11:52:17 2016] [error] [client 74.195.15.177] PHP Fatal error: require_once(): Failed opening required '/var/www/html/owncloud/apps/files/appinfo/remote.php' (include_path='/var/www/html/owncloud/3rdparty/pear/console_getopt:/var/www/html/owncloud/3rdparty/pear/pear_exception:/var/www/html/owncloud/3rdparty/pear/pear-core-minimal/src:/var/www/html/owncloud/3rdparty/pear/archive_tar:/var/www/html/owncloud/3rdparty/phpseclib/phpseclib/phpseclib:/var/www/html/owncloud/lib/private:/var/www/html/owncloud/config:/var/www/html/owncloud/3rdparty:/var/www/html/owncloud/apps:.:/usr/share/pear:/usr/share/php:/var/www/html/owncloud') in /var/www/html/owncloud/remote.php on line 138 [Mon Mar 28 11:52:49 2016] [error] [client 74.195.15.177] PHP Fatal error: require_once(): Failed opening required '/var/www/html/owncloud/apps/files/appinfo/remote.php' (include_path='/var/www/html/owncloud/3rdparty/pear/console_getopt:/var/www/html/owncloud/3rdparty/pear/pear_exception:/var/www/html/owncloud/3rdparty/pear/pear-core-minimal/src:/var/www/html/owncloud/3rdparty/pear/archive_tar:/var/www/html/owncloud/3rdparty/phpseclib/phpseclib/phpseclib:/var/www/html/owncloud/lib/private:/var/www/html/owncloud/config:/var/www/html/owncloud/3rdparty:/var/www/html/owncloud/apps:.:/usr/share/pear:/usr/share/php:/var/www/html/owncloud') in /var/www/html/owncloud/remote.php on line 138 [Mon Mar 28 11:53:21 2016] [error] [client 74.195.15.177] PHP Fatal error: require_once(): Failed opening required '/var/www/html/owncloud/apps/files/appinfo/remote.php' (include_path='/var/www/html/owncloud/3rdparty/pear/console_getopt:/var/www/html/owncloud/3rdparty/pear/pear_exception:/var/www/html/owncloud/3rdparty/pear/pear-core-minimal/src:/var/www/html/owncloud/3rdparty/pear/archive_tar:/var/www/html/owncloud/3rdparty/phpseclib/phpseclib/phpseclib:/var/www/html/owncloud/lib/private:/var/www/html/owncloud/config:/var/www/html/owncloud/3rdparty:/var/www/html/owncloud/apps:.:/usr/share/pear:/usr/share/php:/var/www/html/owncloud') in /var/www/html/owncloud/remote.php on line 138 [Mon Mar 28 11:53:53 2016] [error] [client 74.195.15.177] PHP Fatal error: require_once(): Failed opening required '/var/www/html/owncloud/apps/files/appinfo/remote.php' (include_path='/var/www/html/owncloud/3rdparty/pear/console_getopt:/var/www/html/owncloud/3rdparty/pear/pear_exception:/var/www/html/owncloud/3rdparty/pear/pear-core-minimal/src:/var/www/html/owncloud/3rdparty/pear/archive_tar:/var/www/html/owncloud/3rdparty/phpseclib/phpseclib/phpseclib:/var/www/html/owncloud/lib/private:/var/www/html/owncloud/config:/var/www/html/owncloud/3rdparty:/var/www/html/owncloud/apps:.:/usr/share/pear:/usr/share/php:/var/www/html/owncloud') in /var/www/html/owncloud/remote.php on line 138 ``` Edit - formatting

After doing this I can access my files:

update oc_appconfig set configvalue = 'dav/appinfo/v1/caldav.php' where appid = 'core' and configkey = 'remote_caldav';
update oc_appconfig set configvalue = 'dav/appinfo/v1/caldav.php' where appid = 'core' and configkey = 'remote_calendar';
update oc_appconfig set configvalue = 'dav/appinfo/v1/carddav.php' where appid = 'core' and configkey = 'remote_carddav';
update oc_appconfig set configvalue = 'dav/appinfo/v1/carddav.php' where appid = 'core' and configkey = 'remote_contacts';
update oc_appconfig set configvalue = 'dav/appinfo/v1/webdav.php' where appid = 'core' and configkey = 'remote_files';
update oc_appconfig set configvalue = 'dav/appinfo/v1/webdav.php' where appid = 'core' and configkey = 'remote_webdav';
update oc_appconfig set configvalue = 'dav/appinfo/v2/remote.php' where appid = 'core' and configkey = 'remote_dav';
update oc_appconfig set configvalue = 'dav/appinfo/v1/publicwebdav.php' where appid = 'core' and configkey = 'public_webdav';
update oc_appconfig set configvalue = 'dav/appinfo/v2/remote.php' where appid = 'core' and configkey = 'remote_dav';

MySQL looks like this afterwards:
select * from oc_appconfig where configvalue like '%appinfo%';

+-------+-----------------+---------------------------------+
| appid | configkey       | configvalue                     |
+-------+-----------------+---------------------------------+
| core  | public_webdav   | dav/appinfo/v1/publicwebdav.php |
| core  | remote_caldav   | dav/appinfo/v1/caldav.php       |
| core  | remote_calendar | dav/appinfo/v1/caldav.php       |
| core  | remote_carddav  | dav/appinfo/v1/carddav.php      |
| core  | remote_contacts | dav/appinfo/v1/carddav.php      |
| core  | remote_files    | dav/appinfo/v1/webdav.php       |
| core  | remote_webdav   | dav/appinfo/v1/webdav.php       |
+-------+-----------------+---------------------------------+

After activating calendar app I get this when i try to access it:

2016/06/14 15:24:26 [error] 3383#0: *64 upstream sent invalid status “0” while reading response header from upstream, client: 127.0.0.1, server: localhost, request: “PROPFIND /remote.php/dav HTTP/1.1”, upstream: “fastcgi://unix:/var/run/php5-fpm.sock:”, host: “localhost”

Thats how it looks like:

the circle won’t stop spinning.

After activating contacts I get this when I try to access it:
2016/06/14 15:33:46 [error] 3391#0: *143 upstream sent invalid status “0” while reading response header from upstream, client: 127.0.0.1, server: localhost, request: “GET /remote.php/dav/addressbooks HTTP/1.1”, upstream: “fastcgi://unix:/var/run/php5-fpm.sock:”, host: “localhost”
2016/06/14 15:33:46 [error] 3391#0: *109 upstream sent invalid status “0” while reading response header from upstream, client: 127.0.0.1, server: localhost, request: “PROPFIND /remote.php/dav/addressbooks HTTP/1.1”, upstream: “fastcgi://unix:/var/run/php5-fpm.sock:”, host: “localhost”

Thats how it looks like:

The calendar/contacts issue looks similar to other issues but not quite the same. For example some can not see only one calendar. I can’t see any calendars at all.

aronovgj · June 14, 2016, 8:50pm

Should I repost this on github?

aronovgj · June 15, 2016, 7:12pm

Posted it here:

github.com/nextcloud/server

Several issues during upgrade from OC 8.2.5 to NC 9

opened 06:14PM - 15 Jun 16 UTC

closed 05:09AM - 17 Jun 16 UTC

aronovgj

bug 0. Needs triage

### Steps to reproduce - Backup owncloud folder - Remove owncloud folder - Unzip… Nextcloud - Fix permissions - Restore config.php - Change nginx root to match Nextcloud ### Expected behaviour Everything should work properly, especially files, calendar and contacts ### Actual behaviour I'm running into several issues that I already had upgrading to owncloud 9. The whole story chronologically further below. ### Server configuration **Operating system**: Mint 17.3 **Web server:** nginx 1.4.6 (in test environment but 1.11.1 in productive environment. No difference) **Database:** MySQL 5.5.49 **PHP version:** PHP 5.5.9 **Nextcloud version:** (see Nextcloud admin page) 9 **Updated from an older Nextcloud/ownCloud or fresh install:** Owncloud 8.2.5 **Where did you install Nextcloud from:** https://download.nextcloud.com/server/releases/nextcloud-9.0.50.zip **Signing status (Nextcloud 9.0 and above):** ``` No errors have been found. ``` **List of activated apps:** ``` Enabled: - activity: 2.2.1 - calendar: 0.8.2 - contacts: 0.5.0.0 - direct_menu: 0.8.0 - documents: 0.11.1 - files: 1.4.4 - files_external: 0.5.2 - files_pdfviewer: 0.8 - files_sharing: 0.9.1 - files_texteditor: 2.1 - files_trashbin: 0.8.0 - files_versions: 1.2.0 - firstrunwizard: 1.1 - galleryplus: 15.0.0 - logreader: 1.1.2 - notifications: 0.2.3 - provisioning_api: 0.4.1 - templateeditor: 0.1 - updater: 0.6 - user_external: 0.4 ``` **The content of config/config.php:** ``` "system": { "instanceid": "ocro13eb0f5c", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "localhost" ], "datadirectory": "\/home\/me\/owncloud\/data", "overwrite.cli.url": "http:\/\/xxx.xxx.xxx.xxx", "overwriteprotocol": "", "dbtype": "mysql", "version": "9.0.50.0", "dbname": "owncloud", "dbhost": "localhost", "filelocking.enabled": "true", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "logtimezone": "CEST", "installed": true, "maintenance": false, "asset-pipeline.enabled": false, "theme": "", "loglevel": 1, "logfile": "\/var\/log\/owncloud.log", "log_rotate_size": 10485760, "trashbin_retention_obligation": "auto", "mail_from_address": "me", "mail_smtpmode": "smtp", "mail_domain": "me.net", "mail_smtpsecure": "ssl", "mail_smtpport": "465", "mail_smtpauthtype": "LOGIN", "mail_smtpauth": 1, "mail_smtphost": "mail.me.net", "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "ldapIgnoreNamingRules": false }, ``` /etc/nginx/conf.d/default.conf ``` upstream php-handler { # server 127.0.0.1:9000; server unix:/var/run/php5-fpm.sock; } server { listen 80; server_name localhost; # enforce https return 301 https://$server_name$request_uri; } server { listen 443 ssl; server_name localhost; ssl_certificate /etc/apache2/ssl/apache.crt; ssl_certificate_key /etc/apache2/ssl/apache.key; ssl_protocols TLSv1 TLSv1.1 TLSv1.2; ssl_prefer_server_ciphers on; # ssl_ciphers 'EECDH+AESGCM:EDH+AESGCM:AES256+EECDH:AES256+EDH'; ssl_ciphers 'ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA:DHE-RSA-AES256-SHA:ECDHE-RSA-DES-CBC3-SHA:ECDHE-ECDSA-DES-CBC3-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:AES:CAMELLIA:DES-CBC3-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA'; ssl_stapling on; ssl_stapling_verify on; resolver 8.8.8.8 8.8.4.4 valid=300s; # Add headers to serve security related headers add_header Strict-Transport-Security "max-age=15768000; includeSubDomains; preload;"; add_header X-Content-Type-Options nosniff; add_header X-Frame-Options "SAMEORIGIN"; add_header X-XSS-Protection "1; mode=block"; add_header X-Robots-Tag none; # Path to the root of your installation root /var/www/nextcloud; # set max upload size client_max_body_size 10G; fastcgi_buffers 64 4K; # Disable gzip to avoid the removal of the ETag header gzip off; # Uncomment if your server is build with the ngx_pagespeed module # This module is currently not supported. #pagespeed off; index index.php; error_page 403 /core/templates/403.php; error_page 404 /core/templates/404.php; rewrite ^/.well-known/carddav /remote.php/carddav/ permanent; rewrite ^/.well-known/caldav /remote.php/caldav/ permanent; # The following 2 rules are only needed for the user_webfinger app. # Uncomment it if you're planning to use this app. #rewrite ^/.well-known/host-meta /public.php?service=host-meta last; #rewrite ^/.well-known/host-meta.json /public.php?service=host-meta-json last; location = /robots.txt { allow all; log_not_found off; access_log off; } location ~ ^/(build|tests|config|lib|3rdparty|templates|data)/ { deny all; } location ~ ^/(?:\.|autotest|occ|issue|indie|db_|console) { deny all; } location / { rewrite ^/remote/(.*) /remote.php last; rewrite ^(/core/doc/[^\/]+/)$ $1/index.html; try_files $uri $uri/ =404; } # cache_purge (with $http_cookies we have unique keys for the user) fastcgi_cache_key $http_cookie$request_method$host$request_uri; fastcgi_cache_use_stale error timeout invalid_header http_500; fastcgi_ignore_headers Cache-Control Expires Set-Cookie; location ~ \.php(?:$|/) { fastcgi_split_path_info ^(.+\.php)(/.+)$; include fastcgi_params; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; fastcgi_param PATH_INFO $fastcgi_path_info; fastcgi_param HTTPS on; fastcgi_param modHeadersAvailable true; #Avoid sending the security headers twice fastcgi_pass php-handler; fastcgi_intercept_errors on; fastcgi_read_timeout 300; if (!-f $document_root$fastcgi_script_name) { return 404; } } # Adding the cache control header for js and css files # Make sure it is BELOW the location ~ \.php(?:$|/) { block location ~* \.(?:css|js)$ { add_header Cache-Control "public, max-age=7200"; # Add headers to serve security related headers add_header Strict-Transport-Security "max-age=15768000; includeSubDomains; preload;"; add_header X-Content-Type-Options nosniff; add_header X-Frame-Options "SAMEORIGIN"; add_header X-XSS-Protection "1; mode=block"; add_header X-Robots-Tag none; # Optional: Don't log access to assets access_log off; } # Optional: Don't log access to other assets location ~* \.(?:jpg|jpeg|gif|bmp|ico|png|swf)$ { access_log off; } } ``` **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 ### The story After doing all the "steps to reproduce" stuff I do this: `sudo -u www-data php /var/www/nextcloud/occ upgrade` I get errors looking much like here: http://github.com/owncloud/core/issues/23867 ``` PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20121212/apcu.so' - /usr/lib/php5/20121212/apcu.so: cannot open shared object file: No such file or directory in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20121212/imagick.so' - /usr/lib/php5/20121212/imagick.so: cannot open shared object file: No such file or directory in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20121212/memcached.so' - /usr/lib/php5/20121212/memcached.so: cannot open shared object file: No such file or directory in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20121212/redis.so' - /usr/lib/php5/20121212/redis.so: cannot open shared object file: No such file or directory in Unknown on line 0 ownCloud or one of the apps require upgrade - only a limited number of commands are available You may use your browser or the occ upgrade command to do the upgrade Set log level to debug Turned on maintenance mode {"reqId":"q34bGPnLwEoynKZcDODk","remoteAddr":"","app":"core","message":"starting upgrade from 8.2.5.2 to 9.0.50.0","level":0,"time":"2016-06-14T15:09:29+02:00","method":"--","url":"--","user":"--"} Checking whether the database schema can be updated (this can take a long time depending on the database size) Checked database schema update Checking updates of apps Checked database schema update for apps Updating database schema Updated database Disabled 3rd-party app: calendar Disabled 3rd-party app: contacts Disabled 3rd-party app: direct_menu Disabled 3rd-party app: documents Disabled 3rd-party app: galleryplus Disabled 3rd-party app: logreader Disabled 3rd-party app: updater Updating <files_pdfviewer> ... Updated <files_pdfviewer> to 0.8.1 Update 3rd-party app: calendar Update 3rd-party app: contacts Update 3rd-party app: direct_menu Update 3rd-party app: documents Update 3rd-party app: galleryplus Update 3rd-party app: logreader {"reqId":"q34bGPnLwEoynKZcDODk","remoteAddr":"","app":"federation","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\TableExistsException\",\"Message\":\"An exception occurred while executing 'CREATE TABLE `oc_trusted_servers` (`id` INT AUTO_INCREMENT NOT NULL, `url` VARCHAR(512) NOT NULL COMMENT 'Url of trusted server', `url_hash` VARCHAR(255) DEFAULT '' NOT NULL COMMENT 'sha1 hash of the url without the protocol', `token` VARCHAR(128) DEFAULT NULL COMMENT 'token used to exchange the shared secret', `shared_secret` VARCHAR(256) DEFAULT NULL COMMENT 'shared secret used to authenticate', `status` INT DEFAULT 2 NOT NULL COMMENT 'current status of the connection', `sync_token` VARCHAR(512) DEFAULT NULL COMMENT 'cardDav sync token', UNIQUE INDEX url_hash (`url_hash`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB':\\n\\nSQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_trusted_servers' already exists\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(116): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(945): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'CREATE TABLE `o...')\\n#2 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/db\\\/mdb2schemamanager.php(167): Doctrine\\\\DBAL\\\\Connection->query('CREATE TABLE `o...')\\n#3 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/db\\\/mdb2schemamanager.php(70): OC\\\\DB\\\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\\\DBAL\\\\Schema\\\\Schema))\\n#4 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/db.php(172): OC\\\\DB\\\\MDB2SchemaManager->createDbFromStructure('\\\/var\\\/www\\\/nextcl...')\\n#5 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/installer.php(586): OC_DB::createDbFromStructure('\\\/var\\\/www\\\/nextcl...')\\n#6 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/installer.php(556): OC_Installer::installShippedApp('federation')\\n#7 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/updater.php(334): OC_Installer::installShippedApps(true)\\n#8 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/updater.php(212): OC\\\\Updater->doUpgrade('9.0.50.0', '8.2.5.2')\\n#9 \\\/var\\\/www\\\/nextcloud\\\/core\\\/command\\\/upgrade.php(246): OC\\\\Updater->upgrade()\\n#10 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Command\\\/Command.php(259): OC\\\\Core\\\\Command\\\\Upgrade->execute(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#11 \\\/var\\\/www\\\/nextcloud\\\/core\\\/command\\\/base.php(158): Symfony\\\\Component\\\\Console\\\\Command\\\\Command->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#12 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(840): OC\\\\Core\\\\Command\\\\Base->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#13 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(192): Symfony\\\\Component\\\\Console\\\\Application->doRunCommand(Object(OC\\\\Core\\\\Command\\\\Upgrade), Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#14 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(123): Symfony\\\\Component\\\\Console\\\\Application->doRun(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#15 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/console\\\/application.php(145): Symfony\\\\Component\\\\Console\\\\Application->run(NULL, NULL)\\n#16 \\\/var\\\/www\\\/nextcloud\\\/console.php(88): OC\\\\Console\\\\Application->run()\\n#17 \\\/var\\\/www\\\/nextcloud\\\/occ(11): require_once('\\\/var\\\/www\\\/nextcl...')\\n#18 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":49}","level":3,"time":"2016-06-14T15:10:39+02:00","method":"--","url":"--","user":"--"} federation: An exception occurred while executing 'CREATE TABLE `oc_trusted_servers` (`id` INT AUTO_INCREMENT NOT NULL, `url` VARCHAR(512) NOT NULL COMMENT 'Url of trusted server', `url_hash` VARCHAR(255) DEFAULT '' NOT NULL COMMENT 'sha1 hash of the url without the protocol', `token` VARCHAR(128) DEFAULT NULL COMMENT 'token used to exchange the shared secret', `shared_secret` VARCHAR(256) DEFAULT NULL COMMENT 'shared secret used to authenticate', `status` INT DEFAULT 2 NOT NULL COMMENT 'current status of the connection', `sync_token` VARCHAR(512) DEFAULT NULL COMMENT 'cardDav sync token', UNIQUE INDEX url_hash (`url_hash`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_trusted_servers' already exists {"reqId":"q34bGPnLwEoynKZcDODk","remoteAddr":"","app":"dav","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\TableExistsException\",\"Message\":\"An exception occurred while executing 'CREATE TABLE `oc_addressbooks` (`id` BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, `principaluri` VARCHAR(255) DEFAULT NULL, `displayname` VARCHAR(255) DEFAULT NULL, `uri` VARCHAR(255) DEFAULT NULL, `description` VARCHAR(255) DEFAULT NULL, `synctoken` INT UNSIGNED DEFAULT 1 NOT NULL, UNIQUE INDEX addressbook_index (`principaluri`, `uri`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB':\\n\\nSQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_addressbooks' already exists\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(116): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(945): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'CREATE TABLE `o...')\\n#2 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/db\\\/mdb2schemamanager.php(167): Doctrine\\\\DBAL\\\\Connection->query('CREATE TABLE `o...')\\n#3 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/db\\\/mdb2schemamanager.php(70): OC\\\\DB\\\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\\\DBAL\\\\Schema\\\\Schema))\\n#4 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/db.php(172): OC\\\\DB\\\\MDB2SchemaManager->createDbFromStructure('\\\/var\\\/www\\\/nextcl...')\\n#5 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/installer.php(586): OC_DB::createDbFromStructure('\\\/var\\\/www\\\/nextcl...')\\n#6 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/installer.php(556): OC_Installer::installShippedApp('dav')\\n#7 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/updater.php(334): OC_Installer::installShippedApps(true)\\n#8 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/updater.php(212): OC\\\\Updater->doUpgrade('9.0.50.0', '8.2.5.2')\\n#9 \\\/var\\\/www\\\/nextcloud\\\/core\\\/command\\\/upgrade.php(246): OC\\\\Updater->upgrade()\\n#10 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Command\\\/Command.php(259): OC\\\\Core\\\\Command\\\\Upgrade->execute(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#11 \\\/var\\\/www\\\/nextcloud\\\/core\\\/command\\\/base.php(158): Symfony\\\\Component\\\\Console\\\\Command\\\\Command->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#12 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(840): OC\\\\Core\\\\Command\\\\Base->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#13 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(192): Symfony\\\\Component\\\\Console\\\\Application->doRunCommand(Object(OC\\\\Core\\\\Command\\\\Upgrade), Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#14 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(123): Symfony\\\\Component\\\\Console\\\\Application->doRun(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#15 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/console\\\/application.php(145): Symfony\\\\Component\\\\Console\\\\Application->run(NULL, NULL)\\n#16 \\\/var\\\/www\\\/nextcloud\\\/console.php(88): OC\\\\Console\\\\Application->run()\\n#17 \\\/var\\\/www\\\/nextcloud\\\/occ(11): require_once('\\\/var\\\/www\\\/nextcl...')\\n#18 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":49}","level":3,"time":"2016-06-14T15:10:39+02:00","method":"--","url":"--","user":"--"} dav: An exception occurred while executing 'CREATE TABLE `oc_addressbooks` (`id` BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, `principaluri` VARCHAR(255) DEFAULT NULL, `displayname` VARCHAR(255) DEFAULT NULL, `uri` VARCHAR(255) DEFAULT NULL, `description` VARCHAR(255) DEFAULT NULL, `synctoken` INT UNSIGNED DEFAULT 1 NOT NULL, UNIQUE INDEX addressbook_index (`principaluri`, `uri`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_addressbooks' already exists Starting code integrity check... Finished code integrity check Update successful Turned off maintenance mode Reset log level {"reqId":"q34bGPnLwEoynKZcDODk","remoteAddr":"","app":"PHP","message":"PHP Startup: Unable to load dynamic library '\/usr\/lib\/php5\/20121212\/redis.so' - \/usr\/lib\/php5\/20121212\/redis.so: cannot open shared object file: No such file or directory at Unknown#0","level":3,"time":"2016-06-14T15:10:44+02:00","method":"--","url":"--","user":"--"} ``` I tried to drop the tables that are mentioned in the exception but then it just throws the same exceptions on other tables. I just ignore it as suggested on github. Next thing is this: http://github.com/owncloud/core/issues/23610 After doing this I can access my files: ``` update oc_appconfig set configvalue = 'dav/appinfo/v1/caldav.php' where appid = 'core' and configkey = 'remote_caldav'; update oc_appconfig set configvalue = 'dav/appinfo/v1/caldav.php' where appid = 'core' and configkey = 'remote_calendar'; update oc_appconfig set configvalue = 'dav/appinfo/v1/carddav.php' where appid = 'core' and configkey = 'remote_carddav'; update oc_appconfig set configvalue = 'dav/appinfo/v1/carddav.php' where appid = 'core' and configkey = 'remote_contacts'; update oc_appconfig set configvalue = 'dav/appinfo/v1/webdav.php' where appid = 'core' and configkey = 'remote_files'; update oc_appconfig set configvalue = 'dav/appinfo/v1/webdav.php' where appid = 'core' and configkey = 'remote_webdav'; update oc_appconfig set configvalue = 'dav/appinfo/v2/remote.php' where appid = 'core' and configkey = 'remote_dav'; update oc_appconfig set configvalue = 'dav/appinfo/v1/publicwebdav.php' where appid = 'core' and configkey = 'public_webdav'; update oc_appconfig set configvalue = 'dav/appinfo/v2/remote.php' where appid = 'core' and configkey = 'remote_dav'; ``` MySQL looks like this afterwards: `select * from oc_appconfig where configvalue like '%appinfo%';` ``` +-------+-----------------+---------------------------------+ | appid | configkey | configvalue | +-------+-----------------+---------------------------------+ | core | public_webdav | dav/appinfo/v1/publicwebdav.php | | core | remote_caldav | dav/appinfo/v1/caldav.php | | core | remote_calendar | dav/appinfo/v1/caldav.php | | core | remote_carddav | dav/appinfo/v1/carddav.php | | core | remote_contacts | dav/appinfo/v1/carddav.php | | core | remote_files | dav/appinfo/v1/webdav.php | | core | remote_webdav | dav/appinfo/v1/webdav.php | +-------+-----------------+---------------------------------+ ``` After activating calendar app I get this when i try to access it: ``` 2016/06/14 15:24:26 [error] 3383#0: *64 upstream sent invalid status "0" while reading response header from upstream, client: 127.0.0.1, server: localhost, request: "PROPFIND /remote.php/dav HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "localhost" ``` Thats how it looks like: http://www.pic-upload.de/view-30937703/2.png.html the circle won't stop spinning. After activating contacts I get this when I try to access it: ``` 2016/06/14 15:33:46 [error] 3391#0: *143 upstream sent invalid status "0" while reading response header from upstream, client: 127.0.0.1, server: localhost, request: "GET /remote.php/dav/addressbooks HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "localhost" 2016/06/14 15:33:46 [error] 3391#0: *109 upstream sent invalid status "0" while reading response header from upstream, client: 127.0.0.1, server: localhost, request: "PROPFIND /remote.php/dav/addressbooks HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "localhost" ``` Thats how it looks like: http://www.pic-upload.de/view-30937702/1.png.html The calendar/contacts issue looks similar to other issues but not quite the same. For example some can not see only one calendar. I can't see any calendars at all.

aronovgj · June 16, 2016, 9:07pm

I’d still appreciate help fixing calendar and contacts.

4oo4 · June 17, 2016, 3:49pm

I would also like some assistance on this, and added to the GitHub issue. I didn’t get the upgrade errors like you did (nor do I have any similar errors in my nginx logs), but having the exact same problem you’re seeing. Interestingly enough, it was working right after the upgrade (including upgrading the apps), but then started doing this when I logged in this morning.

@aronovgj, I was curious if you use any DAV clients with yours, and if so, if they still worked for you? For some reason those still work just fine, it’s just the web app that’s not working.

Also, you’re running yours with just Nginx + php-fpm? I’m running mine with nginx reverse proxying to apache (w/ mod_php), so it would make sense that it might be a database thing.

For you it’s Contact + Calendar that’s not working? For me, Contacts works perfectly, but it’s Calendar + Tasks that does this. There’s hopefully some common thread that would explain both our problems…

aronovgj · June 17, 2016, 5:40pm

Thank god, I’m not the only one.
I don’t know whether the DAV clients work. Currently I have Nextcloud running in a VM that I created just to troubleshoot the issue. My server however still runs OC 8.2.5.

Yes, Nginx+php-fpm. No apache.
Yes, Calendar and Contacts, as you can see in the pictures. I don’t use Tasks.

The only workaround I can come up with is to export contacts and calendar, sync all the data to my local PC for all accounts, completely reset MySQL, do a fresh install of NC, import calendars and contacts and sync all accounts to the server. I really, really don’t want to do that…

Henry78 · July 3, 2016, 9:51pm

I got a look-alike issue with contacts after migrating owncloud to nextcloud. I run apache with apcu.

No errors during the upgrade, but a eternal spinner and “No contacts found” (in German, though), if I select the contacts menu in nextcloud web UI. This happens with Chrome and Firefox. It seems DAV clients are working and the contacts database definitely still contains entries that look quite complete.