Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Search/Create Contacts/Address Book not possible #556

Closed
EricThi opened this issue May 16, 2018 · 8 comments
Closed

Search/Create Contacts/Address Book not possible #556

EricThi opened this issue May 16, 2018 · 8 comments
Labels
needs info Not enough information provided

Comments

@EricThi
Copy link

EricThi commented May 16, 2018 •
edited by jospoortvliet
Loading

Steps to reproduce

  1. go to Contacts
  2. New contact => There is no address book available to create a contact.
    2a. Check Address Book :
    https://dl.plik.eric.ovh/file/pEcDBt237bFNL0IM/HMD1a3km91Afe5hr/2018-05-16-100050_1913x974_scrot.png
  3. Search contacts :
    https://dl.plik.eric.ovh/file/pEcDBt237bFNL0IM/ggCElA45qMoKC60d/2018-05-16-101024_1912x969_scrot.png

Expected behaviour

I check right on server (chmod/chwon) check log

Actual behaviour

Cannot search/create contact/address book on instance

Server configuration detail

Operating system: Linux 4.16.8-1-ARCH #1 SMP PREEMPT Wed May 9 11:25:02 UTC 2018 x86_64

Webserver: nginx/1.14.0 (fpm-fcgi)

Database: mysql 10.1.33

PHP version: 7.2.5
Modules loaded: Core, date, libxml, openssl, pcre, zlib, ctype, dom, fileinfo, filter, hash, json, mbstring, pcntl, SPL, PDO, bz2, posix, readline, Reflection, session, SimpleXML, standard, tokenizer, xml, xmlreader, xmlwriter, mysqlnd, cgi-fcgi, Phar, curl, gd, iconv, intl, pdo_mysql, xmlrpc, zip

Nextcloud version: 13.0.2 - 13.0.2.1

Updated from an older Nextcloud/ownCloud or fresh install: fresh install

Where did you install Nextcloud from: /usr/share/nginx/html/nextcloud

Signing status

Array

List of activated apps 
Enabled:
 - activity: 2.6.1
 - admin_audit: 1.3.0
 - admin_notifications: 1.0.1
 - calendar: 1.6.1
 - caniupdate: 0.1.2
 - circles: 0.13.6
 - contacts: 2.1.3
 - dav: 1
 - federatedfilesharing: 1
 - federation: 1.3.0
 - files: 1
 - files_downloadactivity: 1.2.0
 - files_external: 1.4.1
 - files_pdfviewer: 1.2.1
 - files_retention: 1.2.0
 - files_sharing: 1.5.0
 - files_trashbin: 1.3.0
 - files_versions: 1.6.0
 - gallery: 18.0.0
 - issuetemplate: 0.3.0
 - logreader: 2.0.0
 - lookup_server_connector: 1
 - mail: 0.8.1
 - nextcloud_announcements: 1.2.0
 - notifications: 2.1.2
 - oauth2: 1
 - password_policy: 1.3.0
 - provisioning_api: 1
 - quota_warning: 1.2.0
 - rainloop: 5.0.6
 - serverinfo: 1.3.0
 - sharebymail: 1.3.0
 - spreed: 3.2.1
 - systemtags: 1.3.0
 - twofactor_backupcodes: 1
 - updatenotification: 1.3.0
 - workflowengine: 1
Disabled:
 - comments
 - encryption
 - files_snapshots
 - files_texteditor
 - files_videoplayer
 - firstrunwizard
 - survey_client
 - theming
 - user_external
 - user_ldap
Configuration (config/config.php) 
{
    "instanceid": "***REMOVED SENSITIVE VALUE***",
    "passwordsalt": "***REMOVED SENSITIVE VALUE***",
    "secret": "***REMOVED SENSITIVE VALUE***",
    "trusted_domains": [
        "nextcloud.eric.ovh"
    ],
    "datadirectory": "***REMOVED SENSITIVE VALUE***",
    "overwrite.cli.url": "https:\/\/nextcloud.eric.ovh",
    "dbtype": "mysql",
    "version": "13.0.2.1",
    "dbname": "***REMOVED SENSITIVE VALUE***",
    "dbhost": "***REMOVED SENSITIVE VALUE***",
    "dbport": "",
    "dbtableprefix": "oc_",
    "dbuser": "***REMOVED SENSITIVE VALUE***",
    "dbpassword": "***REMOVED SENSITIVE VALUE***",
    "installed": true,
    "mail_smtpmode": "php",
    "mail_smtpauthtype": "LOGIN"
}

Are you using external storage, if yes which one: no

Are you using encryption: no

Are you using an external user-backend, if yes which one: no

Client configuration

Browser: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:60.0) Gecko/20100101 Firefox/60.0

Operating system: Linux desk 4.13.0-32-generic #35~16.04.1-Ubuntu SMP Thu Jan 25 10:13:43 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

Logs

Browser log 
2018/05/16 10:13:20 [info] 18718#18718: *5442 epoll_wait() reported that client prematurely closed connection, so upstream connection is closed too while sending request to upstream, client: 5.5.5.101, server: nextcloud.eric.ovh, request: "GET /apps/logreader/poll?lastReqId=dViWRHLlLvZJvPd7J8s1 HTTP/1.0", upstream: "fastcgi://unix:/run/php-fpm/php-fpm.sock:", host: "nextcloud.eric.ovh"
Nextcloud log 
Insert your Nextcloud log here

Error | index | Doctrine\DBAL\Exception\TableNotFoundException: An  exception occurred while executing 'SELECT `id`, `uri`, `displayname`,  `principaluri`, `description`, `synctoken` FROM `oc_addressbooks` WHERE  `principaluri` = ?' with params ["principals\/users\/admin"]:  SQLSTATE[42S02]: Base table or view not found: 1146 Table  'nextcloud.oc_addressbooks' doesn't exist/usr/share/nginx/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128:  Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))/usr/share/nginx/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 855:   Doctrine\DBAL\DBALException   driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver),  Object(Doctrine\DBAL\Driver\PDOException), 'SELECT `id`, `u...', Array)/usr/share/nginx/html/nextcloud/lib/private/DB/Connection.php - line 195:  Doctrine\DBAL\Connection->executeQuery('SELECT `id`, `u...', Array, Array, NULL)/usr/share/nginx/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 206:  OC\DB\Connection->executeQuery('SELECT `id`, `u...', Array, Array)/usr/share/nginx/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 214:  Doctrine\DBAL\Query\QueryBuilder->execute()/usr/share/nginx/html/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php - line 155:  OC\DB\QueryBuilder\QueryBuilder->execute()/usr/share/nginx/html/nextcloud/apps/dav/lib/CardDAV/ContactsManager.php - line 56:  OCA\DAV\CardDAV\CardDavBackend->getAddressBooksForUser('principals/user...')/usr/share/nginx/html/nextcloud/apps/dav/lib/AppInfo/Application.php - line 75:  OCA\DAV\CardDAV\ContactsManager->setupContactsProvider(Object(OC\ContactsManager), 'admin', Object(OC\URLGenerator))/usr/share/nginx/html/nextcloud/apps/dav/appinfo/app.php - line 55:  OCA\DAV\AppInfo\Application->setupContactsProvider(Object(OC\ContactsManager), 'admin')/usr/share/nginx/html/nextcloud/lib/private/ContactsManager.php - line 185:  OC_App  {closure}(*** sensitive parameters replaced ***)/usr/share/nginx/html/nextcloud/lib/private/ContactsManager.php - line 42:  OC\ContactsManager->loadAddressBooks()/usr/share/nginx/html/nextcloud/lib/private/Contacts/ContactsMenu/ContactsStore.php - line 77:  OC\ContactsManager->search('', Array)/usr/share/nginx/html/nextcloud/lib/private/Contacts/ContactsMenu/Manager.php - line 59:  OC\Contacts\ContactsMenu\ContactsStore->getContacts(Object(OC\User\User), NULL)/usr/share/nginx/html/nextcloud/core/Controller/ContactsMenuController.php - line 61:  OC\Contacts\ContactsMenu\Manager->getEntries(Object(OC\User\User), NULL)[internal function] OC\Core\Controller\ContactsMenuController->index(NULL)/usr/share/nginx/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 161:  call_user_func_array(Array, Array)/usr/share/nginx/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 91:  OC\AppFramework\Http\Dispatcher->executeController(Object(OC\Core\Controller\ContactsMenuController), 'index')/usr/share/nginx/html/nextcloud/lib/private/AppFramework/App.php - line 115:  OC\AppFramework\Http\Dispatcher->dispatch(Object(OC\Core\Controller\ContactsMenuController), 'index')/usr/share/nginx/html/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php - line 47:  OC\AppFramework\App  main('OC\\Core\\Control...', 'index', Object(OC\AppFramework\DependencyInjection\DIContainer), Array)[internal function] OC\AppFramework\Routing\RouteActionHandler->__invoke(Array)/usr/share/nginx/html/nextcloud/lib/private/Route/Router.php - line 297:  call_user_func(Object(OC\AppFramework\Routing\RouteActionHandler), Array)/usr/share/nginx/html/nextcloud/lib/base.php - line 999:  OC\Route\Router->match('/contactsmenu/c...')/usr/share/nginx/html/nextcloud/index.php - line 37:  OC  handleRequest(){main} | 2018-05-16T10:10:01+0200
-- | -- | -- | --
Fatal | webdav | Doctrine\DBAL\Exception\TableNotFoundException: An  exception occurred while executing 'SELECT `id`, `uri`, `displayname`,  `principaluri`, `description`, `synctoken` FROM `oc_addressbooks` WHERE  `principaluri` = ?' with params ["principals\/users\/admin"]:  SQLSTATE[42S02]: Base table or view not found: 1146 Table  'nextcloud.oc_addressbooks' doesn't exist/usr/share/nginx/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128:  Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))/usr/share/nginx/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 855:   Doctrine\DBAL\DBALException   driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver),  Object(Doctrine\DBAL\Driver\PDOException), 'SELECT `id`, `u...', Array)/usr/share/nginx/html/nextcloud/lib/private/DB/Connection.php - line 195:  Doctrine\DBAL\Connection->executeQuery('SELECT `id`, `u...', Array, Array, NULL)/usr/share/nginx/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 206:  OC\DB\Connection->executeQuery('SELECT `id`, `u...', Array, Array)/usr/share/nginx/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 214:  Doctrine\DBAL\Query\QueryBuilder->execute()/usr/share/nginx/html/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php - line 155:  OC\DB\QueryBuilder\QueryBuilder->execute()/usr/share/nginx/html/nextcloud/apps/dav/lib/CardDAV/UserAddressBooks.php - line 42:  OCA\DAV\CardDAV\CardDavBackend->getAddressBooksForUser('principals/user...')/usr/share/nginx/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php - line 195:  OCA\DAV\CardDAV\UserAddressBooks->getChildren()/usr/share/nginx/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 899:  Sabre\DAV\Tree->getChildren('addressbooks/us...')/usr/share/nginx/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 978:  Sabre\DAV\Server->generatePathNodes(Object(Sabre\DAV\PropFind), Array)/usr/share/nginx/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 1666:  Sabre\DAV\Server->getPropertiesIteratorForPath('addressbooks/us...', Array, 1)/usr/share/nginx/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php - line 355:  Sabre\DAV\Server->generateMultiStatus(Object(Generator), false)[internal function] Sabre\DAV\CorePlugin->httpPropFind(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))/usr/share/nginx/html/nextcloud/3rdparty/sabre/event/lib/EventEmitterTrait.php - line 105:  call_user_func_array(Array, Array)/usr/share/nginx/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 479:  Sabre\Event\EventEmitter->emit('method PROPFIND', Array)/usr/share/nginx/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 254:  Sabre\DAV\Server->invokeMethod(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))/usr/share/nginx/html/nextcloud/apps/dav/lib/Server.php - line 283:  Sabre\DAV\Server->exec()/usr/share/nginx/html/nextcloud/apps/dav/appinfo/v2/remote.php - line 35:  OCA\DAV\Server->exec()/usr/share/nginx/html/nextcloud/remote.php - line 164:  require_once('/usr/share/ngin...'){main}
Browser log

Insert your browser log here, this could for example include:
On Contacts :
Error: Bad status: 500
dav.js:3746:27
detail =>
{
key: 'send',
value: function send(data) {
debug('Sending request data: ' + data);
if (this.sandbox) this.sandbox.add(this);
var request = this.request;
request.send(data);
return new Promise(function (resolve, reject) {
request.onreadystatechange = function () {
if (request.readyState !== 4 /* done */) {
return;
}

      if (request.status < 200 || request.status >= 400) {
        return reject(new Error('Bad status: ' + request.status)); => report here
      }

      return resolve(request.responseText);
    };

    request.ontimeout = function () {
      reject(new Error('Request timed out after ' + request.timeout + ' ms'));
    };
  });
}

during check log and co, i found this changement :
https://dl.plik.eric.ovh/file/pEcDBt237bFNL0IM/7d5CKhO8MdeMMpHN/2018-05-16-101642_1909x925_scrot.png

https://dl.plik.eric.ovh/file/pEcDBt237bFNL0IM/7LALG4AeINEkAJj0/2018-05-16-102023_1906x976_scrot.png
https://dl.plik.eric.ovh/file/pEcDBt237bFNL0IM/3kjD2gGN7lnpADao/2018-05-16-101807_1911x974_scrot.png

detail error :

This application requires JavaScript for correct operation. Please enable JavaScript and reload the page.
Nextcloud
Internal Server Error

The server was unable to complete your request.

If this happens again, please send the technical details below to the server administrator.

More details can be found in the server log.
Technical details

Remote Address: 5.5.5.101
Request ID: ngggXZdbaO1E8xAzExtH

Nextcloud – a safe home for all your data

Javascript is neable on my browser... Oo

Thank you, Eric
@skjnldsv
Copy link
Member

Hello Eric :)
There is indeed something very wrong here. But it's not related to the contacts app.
The table is missing somehow. I don't know why, maybe a timeout during the installation?

Do you have access to your database?

@EricThi
Copy link
Author

EricThi commented May 16, 2018 •
edited
Loading

Hum, i hesitate to post directly on server... :/
Sorry,

I didn't relaunch create table ? Any timeout during the installation (via woozard, i deploy via tar.bz2) don't use autoinstall.

Yes, I have access, only table nextcloud :

| def           | nextcloud          | oc_accounts                                        | BASE TABLE  | InnoDB             |      10 | Compact    |          3 |           5461 |       16384 |                  0 |            0 |         0 |           NULL | 2018-05-14 15:01:10 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_activity                                        | BASE TABLE  | InnoDB             |      10 | Compact    |          2 |           8192 |       16384 |                  0 |        81920 |         0 |              4 | 2018-05-16 09:40:41 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_activity_mq                                     | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        49152 |         0 |              1 | 2018-05-16 09:40:42 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_admin_sections                                  | BASE TABLE  | InnoDB             |      10 | Compact    |          5 |           3276 |       16384 |                  0 |        16384 |         0 |           NULL | 2018-05-14 15:01:10 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_admin_settings                                  | BASE TABLE  | InnoDB             |      10 | Compact    |         17 |            963 |       16384 |                  0 |        32768 |         0 |             23 | 2018-05-14 15:01:11 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_appconfig                                       | BASE TABLE  | InnoDB             |      10 | Compact    |        151 |            108 |       16384 |                  0 |        32768 |         0 |           NULL | 2018-05-14 15:01:09 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_authtoken                                       | BASE TABLE  | InnoDB             |      10 | Compact    |          7 |           2340 |       16384 |                  0 |        32768 |         0 |              9 | 2018-05-14 15:01:11 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_bruteforce_attempts                             | BASE TABLE  | InnoDB             |      10 | Compact    |         19 |            862 |       16384 |                  0 |        32768 |         0 |             20 | 2018-05-14 15:01:11 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_circles_circles                                 | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              2 | 2018-05-16 09:17:48 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_circles_clouds                                  | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |           NULL | 2018-05-16 09:17:48 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_circles_groups                                  | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |           NULL | 2018-05-16 09:17:48 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_circles_links                                   | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-16 09:17:49 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_circles_members                                 | BASE TABLE  | InnoDB             |      10 | Compact    |          2 |           8192 |       16384 |                  0 |            0 |         0 |           NULL | 2018-05-16 09:17:48 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_circles_shares                                  | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-16 09:17:48 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_comments                                        | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        65536 |         0 |              1 | 2018-05-14 15:01:11 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_comments_read_markers                           | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        16384 |         0 |           NULL | 2018-05-14 15:01:10 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_credentials                                     | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        16384 |         0 |           NULL | 2018-05-14 15:01:10 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_dashboard_announcements                         | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:26:44 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_dashboard_files                                 | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:26:44 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_dashboard_settings                              | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:26:45 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_external_applicable                             | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        49152 |         0 |              1 | 2018-05-15 13:34:18 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_external_config                                 | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        32768 |         0 |              1 | 2018-05-15 13:34:18 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_external_mounts                                 | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:34:18 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_external_options                                | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        32768 |         0 |              1 | 2018-05-15 13:34:18 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_file_locks                                      | BASE TABLE  | InnoDB             |      10 | Compact    |         27 |            606 |       16384 |                  0 |        32768 |         0 |             28 | 2018-05-14 15:01:13 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_filecache                                       | BASE TABLE  | InnoDB             |      10 | Compact    |        212 |            386 |       81920 |                  0 |        81920 |         0 |            213 | 2018-05-14 15:01:09 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_files_trash                                     | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        49152 |         0 |              1 | 2018-05-15 13:34:08 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_group_admin                                     | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        16384 |         0 |           NULL | 2018-05-14 15:01:09 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_group_user                                      | BASE TABLE  | InnoDB             |      10 | Compact    |          4 |           4096 |       16384 |                  0 |        16384 |         0 |           NULL | 2018-05-14 15:01:09 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_groups                                          | BASE TABLE  | InnoDB             |      10 | Compact    |          2 |           8192 |       16384 |                  0 |            0 |         0 |           NULL | 2018-05-14 15:01:09 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_jobs                                            | BASE TABLE  | InnoDB             |      10 | Compact    |         16 |           1024 |       16384 |                  0 |        16384 |         0 |             22 | 2018-05-14 15:01:13 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_mail_accounts                                   | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        16384 |         0 |              1 | 2018-05-15 13:25:13 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_mail_aliases                                    | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:25:13 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_mail_attachments                                | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        16384 |         0 |              1 | 2018-05-15 13:25:13 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_mail_collected_addresses                        | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        32768 |         0 |              1 | 2018-05-15 13:25:13 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_migrations                                      | BASE TABLE  | InnoDB             |      10 | Compact    |         19 |            862 |       16384 |                  0 |            0 |         0 |           NULL | 2018-05-14 15:01:09 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_mimetypes                                       | BASE TABLE  | InnoDB             |      10 | Compact    |         18 |            910 |       16384 |                  0 |        16384 |         0 |             19 | 2018-05-14 15:01:09 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_mounts                                          | BASE TABLE  | InnoDB             |      10 | Compact    |          2 |           8192 |       16384 |                  0 |        81920 |         0 |              3 | 2018-05-14 15:01:13 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_notifications                                   | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        65536 |         0 |              1 | 2018-05-16 09:40:22 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_notifications_pushtokens                        | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |           NULL | 2018-05-16 09:40:22 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_passman_credentials                             | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        49152 |         0 |              1 | 2018-05-15 13:28:39 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_passman_delete_vault_request                    | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:28:39 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_passman_files                                   | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        32768 |         0 |              1 | 2018-05-15 13:28:39 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_passman_revisions                               | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        49152 |         0 |              1 | 2018-05-15 13:28:39 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_passman_share_request                           | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:28:39 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_passman_sharing_acl                             | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:28:39 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_passman_vaults                                  | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        65536 |         0 |              1 | 2018-05-15 13:28:39 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_passwords_entity_folder                         | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:28:14 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_passwords_entity_folder_revision                | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:28:14 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_passwords_entity_password                       | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:28:13 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_passwords_entity_password_revision              | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:28:14 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_passwords_entity_share                          | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:28:14 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_passwords_entity_tag                            | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:28:14 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_passwords_entity_tag_revision                   | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:28:14 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_passwords_relation_password_tag                 | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |              1 | 2018-05-15 13:28:14 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_personal_sections                               | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        16384 |         0 |           NULL | 2018-05-14 15:01:09 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_personal_settings                               | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        32768 |         0 |              3 | 2018-05-14 15:01:13 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_preferences                                     | BASE TABLE  | InnoDB             |      10 | Compact    |         54 |            303 |       16384 |                  0 |            0 |         0 |           NULL | 2018-05-14 15:01:10 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_properties                                      | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        16384 |         0 |              1 | 2018-05-14 15:01:13 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_retention                                       | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        16384 |         0 |              1 | 2018-05-15 13:28:51 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_share                                           | BASE TABLE  | InnoDB             |      10 | Compact    |          1 |          16384 |       16384 |                  0 |        65536 |         0 |              3 | 2018-05-14 15:01:13 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_share_external                                  | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        32768 |         0 |              1 | 2018-05-15 13:34:15 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_storages                                        | BASE TABLE  | InnoDB             |      10 | Compact    |          2 |           8192 |       16384 |                  0 |        16384 |         0 |              4 | 2018-05-14 15:01:09 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_systemtag                                       | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        16384 |         0 |              2 | 2018-05-14 15:01:13 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_systemtag_group                                 | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |           NULL | 2018-05-14 15:01:14 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_systemtag_object_mapping                        | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |           NULL | 2018-05-14 15:01:14 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_talk_guests                                     | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        16384 |         0 |           NULL | 2018-05-16 09:29:21 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_talk_participants                               | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |            0 |         0 |           NULL | 2018-05-16 09:29:21 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_talk_rooms                                      | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        16384 |         0 |              1 | 2018-05-16 09:29:21 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_talk_signaling                                  | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        16384 |         0 |           NULL | 2018-05-16 09:29:20 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_trusted_servers                                 | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        16384 |         0 |              1 | 2018-05-16 09:40:32 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_users                                           | BASE TABLE  | InnoDB             |      10 | Compact    |          3 |           5461 |       16384 |                  0 |            0 |         0 |           NULL | 2018-05-14 15:01:10 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_vcategory                                       | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        49152 |         0 |              1 | 2018-05-14 15:01:14 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |
| def           | nextcloud          | oc_vcategory_to_object                             | BASE TABLE  | InnoDB             |      10 | Compact    |          0 |              0 |       16384 |                  0 |        16384 |         0 |           NULL | 2018-05-14 15:01:14 | NULL                | NULL                | utf8_bin          |     NULL |                    |                                                   |


edit : more with insert code :D

@skjnldsv
Copy link
Member

You indeed have some table missing.
I would suggest a clean install if it's not too late. If not possible, here is the structure of my addressbook table:

CREATE TABLE `oc_addressbooks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `principaluri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `displayname` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `uri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `synctoken` int(10) UNSIGNED NOT NULL DEFAULT '1'
)

@EricThi
Copy link
Author

EricThi commented May 16, 2018

Thank you,

don't soluce for my case, i go redeploy and check tables after first deploy :

MariaDB [nextcloud]> SHOW TABLES
    -> ;
+---------------------------------------+
| Tables_in_nextcloud                   |
+---------------------------------------+
| oc_accounts                           |
| oc_activity                           |
| oc_activity_mq                        |
| oc_admin_sections                     |
| oc_admin_settings                     |
| oc_appconfig                          |
| oc_authtoken                          |
| oc_bruteforce_attempts                |
| oc_circles_circles                    |
| oc_circles_clouds                     |
| oc_circles_groups                     |
| oc_circles_links                      |
| oc_circles_members                    |
| oc_circles_shares                     |
| oc_comments                           |
| oc_comments_read_markers              |
| oc_credentials                        |
| oc_dashboard_announcements            |
| oc_dashboard_files                    |
| oc_dashboard_settings                 |
| oc_external_applicable                |
| oc_external_config                    |
| oc_external_mounts                    |
| oc_external_options                   |
| oc_file_locks                         |
| oc_filecache                          |
| oc_files_trash                        |
| oc_group_admin                        |
| oc_group_user                         |
| oc_groups                             |
| oc_jobs                               |
| oc_mail_accounts                      |
| oc_mail_aliases                       |
| oc_mail_attachments                   |
| oc_mail_collected_addresses           |
| oc_migrations                         |
| oc_mimetypes                          |
| oc_mounts                             |
| oc_notifications                      |
| oc_notifications_pushtokens           |
| oc_passman_credentials                |
| oc_passman_delete_vault_request       |
| oc_passman_files                      |
| oc_passman_revisions                  |
| oc_passman_share_request              |
| oc_passman_sharing_acl                |
| oc_passman_vaults                     |
| oc_passwords_entity_folder            |
| oc_passwords_entity_folder_revision   |
| oc_passwords_entity_password          |
| oc_passwords_entity_password_revision |
| oc_passwords_entity_share             |
| oc_passwords_entity_tag               |
| oc_passwords_entity_tag_revision      |
| oc_passwords_relation_password_tag    |
| oc_personal_sections                  |
| oc_personal_settings                  |
| oc_preferences                        |
| oc_properties                         |
| oc_retention                          |
| oc_share                              |
| oc_share_external                     |
| oc_storages                           |
| oc_systemtag                          |
| oc_systemtag_group                    |
| oc_systemtag_object_mapping           |
| oc_talk_guests                        |
| oc_talk_participants                  |
| oc_talk_rooms                         |
| oc_talk_signaling                     |
| oc_trusted_servers                    |
| oc_users                              |
| oc_vcategory                          |
| oc_vcategory_to_object                |
+---------------------------------------+
74 rows in set (0.00 sec)

MariaDB [nextcloud]> CREATE TABLE `oc_addressbooks` (
    ->   `id` bigint(20) UNSIGNED NOT NULL,
    ->   `principaluri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
    ->   `displayname` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
    ->   `uri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
    ->   `description` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
    ->   `synctoken` int(10) UNSIGNED NOT NULL DEFAULT '1'
    -> );
Query OK, 0 rows affected (0.07 sec)

MariaDB [nextcloud]> SHOW TABLES
    -> ;
+---------------------------------------+
| Tables_in_nextcloud                   |
+---------------------------------------+
| oc_accounts                           |
| oc_activity                           |
| oc_activity_mq                        |
| oc_addressbooks                       |
| oc_admin_sections                     |
| oc_admin_settings                     |
| oc_appconfig                          |
| oc_authtoken                          |
| oc_bruteforce_attempts                |
| oc_circles_circles                    |
| oc_circles_clouds                     |
| oc_circles_groups                     |
| oc_circles_links                      |
| oc_circles_members                    |
| oc_circles_shares                     |
| oc_comments                           |
| oc_comments_read_markers              |
| oc_credentials                        |
| oc_dashboard_announcements            |
| oc_dashboard_files                    |
| oc_dashboard_settings                 |
| oc_external_applicable                |
| oc_external_config                    |
| oc_external_mounts                    |
| oc_external_options                   |
| oc_file_locks                         |
| oc_filecache                          |
| oc_files_trash                        |
| oc_group_admin                        |
| oc_group_user                         |
| oc_groups                             |
| oc_jobs                               |
| oc_mail_accounts                      |
| oc_mail_aliases                       |
| oc_mail_attachments                   |
| oc_mail_collected_addresses           |
| oc_migrations                         |
| oc_mimetypes                          |
| oc_mounts                             |
| oc_notifications                      |
| oc_notifications_pushtokens           |
| oc_passman_credentials                |
| oc_passman_delete_vault_request       |
| oc_passman_files                      |
| oc_passman_revisions                  |
| oc_passman_share_request              |
| oc_passman_sharing_acl                |
| oc_passman_vaults                     |
| oc_passwords_entity_folder            |
| oc_passwords_entity_folder_revision   |
| oc_passwords_entity_password          |
| oc_passwords_entity_password_revision |
| oc_passwords_entity_share             |
| oc_passwords_entity_tag               |
| oc_passwords_entity_tag_revision      |
| oc_passwords_relation_password_tag    |
| oc_personal_sections                  |
| oc_personal_settings                  |
| oc_preferences                        |
| oc_properties                         |
| oc_retention                          |
| oc_share                              |
| oc_share_external                     |
| oc_storages                           |
| oc_systemtag                          |
| oc_systemtag_group                    |
| oc_systemtag_object_mapping           |
| oc_talk_guests                        |
| oc_talk_participants                  |
| oc_talk_rooms                         |
| oc_talk_signaling                     |
| oc_trusted_servers                    |
| oc_users                              |
| oc_vcategory                          |
| oc_vcategory_to_object                |
+---------------------------------------+
75 rows in set (0.00 sec)

@skjnldsv skjnldsv added the needs info Not enough information provided label May 16, 2018
@skjnldsv
Copy link
Member

So, did it work?

@EricThi
Copy link
Author

EricThi commented May 16, 2018

No didn't... i go reinstall it

thank you for your time.

I check to repair DB with occ :

sudo -u http php occ maintenance:repair

  • Repair MySQL collation
    • Change row format for oc_addressbooks ...
    • Change collation for oc_addressbooks ...
  • Repair mime types
  • Clean tags and favorites
    • 0 tags of deleted users have been removed.
    • 0 tags for delete files have been removed.
    • 0 tag entries for deleted tags have been removed.
    • 0 tags with no entries have been removed.
  • Repair invalid shares
  • Remove shares of a users root folder
  • Move .step file of updater to backup location
  • Add move avatar background job
    • Add background job
  • Add preview cleanup background jobs
  • Fix potential broken mount points
    • No mounts updated
  • Repair language codes
  • Install new core bundle components
  • Repair invalid paths in file cache
  • Rename folder with user specific keys
  • Add log rotate job
  • Clear frontend caches
    • Image cache cleared
    • SCSS cache cleared
    • JS cache cleared
  • Fix the shares to use timestamp instead of datetime
    • Update timestamp of shares
      0 [>---------------------------]
  • Fix the share type of guest shares when migrating from ownCloud
  • Generate unique id on created circle
    • Generate unique id on circles
      0 [>---------------------------]
  • Using shorten unique id instead of circle id
  • Fix component of birthday calendars

[Doctrine\DBAL\Exception\TableNotFoundException]
An exception occurred while executing 'UPDATE oc_calendars SET components = ? WHERE uri = ?' with params ["VEVENT", "contact_birthdays"]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_calendars' doesn't exist

[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_calendars' doesn't exist

[PDOException]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_calendars' doesn't exist

maintenance:repair [--include-expensive]

root /usr/share/nginx/html/nextcloud # sudo -u http php occ maintenance:repair --include-expensive
Nextcloud is in maintenance mode - no apps have been loaded

Failed to load repair step for circles: Repair step 'OCA\Circles\Migration\UpdateShareTimeToTimestamp' is unknown
Failed to load repair step for circles: Repair step 'OCA\Circles\Migration\ImportOwncloudCustomGroups' is unknown
Failed to load repair step for circles: Repair step 'OCA\Circles\Migration\GenerateUniqueIdOnCreatedCircle' is unknown
Failed to load repair step for circles: Repair step 'OCA\Circles\Migration\UsingShortenUniqueIdInsteadOfCircleId' is unknown
Failed to load repair step for dav: Repair step 'OCA\DAV\Migration\FixBirthdayCalendarComponent' is unknown
Failed to load repair step for dav: Repair step 'OCA\DAV\Migration\CalDAVRemoveEmptyValue' is unknown
Failed to load repair step for dav: Repair step 'OCA\DAV\Migration\BuildCalendarSearchIndex' is unknown
Failed to load repair step for files_sharing: Repair step 'OCA\Files_Sharing\Migration\OwncloudGuestShareType' is unknown
Failed to load repair step for files_sharing: Repair step 'OCA\Files_Sharing\Migration\SetPasswordColumn' is unknown
Failed to load repair step for mail: Repair step 'OCA\Mail\Migration\FixCollectedAddresses' is unknown

  • Repair MySQL collation
    • All tables already have the correct collation -> nothing to do
  • Repair mime types
  • Clean tags and favorites
    • 0 tags of deleted users have been removed.
    • 0 tags for delete files have been removed.
    • 0 tag entries for deleted tags have been removed.
    • 0 tags with no entries have been removed.
  • Repair invalid shares
  • Remove shares of a users root folder
  • Move .step file of updater to backup location
  • Add move avatar background job
    • Repair step already executed
  • Add preview cleanup background jobs
  • Fix potential broken mount points
    • No mounts updated
  • Repair language codes
  • Install new core bundle components
  • Repair invalid paths in file cache
  • Rename folder with user specific keys
  • Add log rotate job
  • Clear frontend caches
    • Image cache cleared
    • SCSS cache cleared
    • JS cache cleared
  • Remove shares of old group memberships

Don't fix...

@skjnldsv
Copy link
Member

Yeah, you're apparently missing more than just the addressbook table :/
Is reinstalling out of question?

@EricThi
Copy link
Author

EricThi commented May 16, 2018

Redeploy VM and new fresh install ;)

I deploy yesterday this instance ;) no data loss :)

@EricThi EricThi closed this as completed May 16, 2018
@nextcloud-bot nextcloud-bot mentioned this issue Aug 10, 2018
Closed
@nextcloud-bot nextcloud-bot mentioned this issue Nov 3, 2018
Closed
1 task
@nextcloud-bot nextcloud-bot mentioned this issue Dec 17, 2018
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
needs info Not enough information provided
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@EricThi @skjnldsv