Sorry to hear you’re facing problems
In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:
Or for longer, use three backticks above and below the code snippet:
longer example here
Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can
Nextcloud version 13.06:
Operating system and version FreeBSD 12.0-RELEASE-p3:
Apache or nginx version : Apache/2.4.38
PHP version 7.1:
The issue you are facing:
I have been happily running 13.0.0 for some time. That was my original installation. Then I realized I’d gotten a bit behind in updating so I attempted to update via the FreeBSD ports system. Although my goal was to get to version 15, I read and learned I should do only one major version at a time. I also learned some things had changed between 13.0.0 and 13.0.1 so I upgraded to it first instead of straight to version 14. I did not receive any errors when I ran the occ upgrade as my web user. However, after the upgrade, I noticed I received errors when attempting to access the settings menu. I failed to capture the error but it was a SQL error about being unable to access a table.
I thought well I’ll upgrade to 13.0.6 and maybe that will solve it. But this time when trying to run occ upgrade, I get an error about a missing table. This is the output from the CLI:
# su -m www -c "php ./occ upgrade" Nextcloud 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 Updating database schema Updated database Updating <oauth2> ... Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing 'SELECT `class` FROM `oc_admin_settings` WHERE `class` = ? LIMIT 1' with params ["OCA\\OAuth2\\Settings\\Admin"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_admin_settings' doesn't exist Update failed Maintenance mode is kept active Reset log level
So I check my database and sure enough, I do not have this table. These are my tables:
root@localhost [nextcloud]> show tables; +--------------------------------+ | Tables_in_nextcloud | +--------------------------------+ | oc_accounts | | oc_activity | | oc_activity_mq | | oc_addressbookchanges | | oc_addressbooks | | oc_appconfig | | oc_audioplayer_albums | | oc_audioplayer_artists | | oc_audioplayer_genre | | oc_audioplayer_playlist_tracks | | oc_audioplayer_playlists | | oc_audioplayer_stats | | oc_audioplayer_streams | | oc_audioplayer_tracks | | oc_authtoken | | oc_bruteforce_attempts | | oc_calendarchanges | | oc_calendarobjects | | oc_calendarobjects_props | | oc_calendars | | oc_calendarsubscriptions | | oc_cards | | oc_cards_properties | | oc_comments | | oc_comments_read_markers | | oc_credentials | | oc_dav_shares | | oc_federated_reshares | | oc_file_locks | | oc_filecache | | oc_files_trash | | oc_flow_checks | | oc_flow_operations | | oc_group_admin | | oc_group_user | | oc_groups | | oc_jobs | | oc_migrations | | oc_mimetypes | | oc_mounts | | oc_notifications | | oc_notifications_pushtokens | | oc_oauth2_access_tokens | | oc_oauth2_clients | | oc_preferences | | oc_privatedata | | oc_properties | | oc_schedulingobjects | | oc_share | | oc_share_external | | oc_storages | | oc_systemtag | | oc_systemtag_group | | oc_systemtag_object_mapping | | oc_trusted_servers | | oc_twofactor_backupcodes | | oc_twofactor_providers | | oc_users | | oc_vcategory | | oc_vcategory_to_object | | oc_whats_new | +--------------------------------+ 61 rows in set (0.00 sec)
So how can I fix this? I’d really appreciate your assistance as my Googling hasn’t turned up any answers that seem to apply to me.
Is this the first time you’ve seen this error? Y:
The output of your Nextcloud log in Admin > Logging:
I can't access Nextcloud. Is there a log I can paste from the CLI that would be helpful?
The output of your config.php file in
/path/to/nextcloud (make sure you remove any identifiable information!):
# cat config.php <?php $CONFIG = array ( 'debug' => 'true', 'instanceid' => 'removed', 'passwordsalt' => 'removed', 'secret' => 'removed', 'trusted_domains' => array ( 0 => 'removed.com', ), 'datadirectory' => '/usr/local/www/nextcloud/data', 'overwrite.cli.url' => 'http://removed.com', 'dbtype' => 'mysql', 'version' => '126.96.36.199', 'dbname' => 'nextcloud', 'dbhost' => 'localhost:3306', 'dbport' => '', 'dbtableprefix' => 'oc_', 'mysql.utf8mb4' => true, 'dbuser' => 'removed', 'dbpassword' => 'removed', 'installed' => true, 'mail_from_address' => 'removed', 'mail_smtpmode' => 'php', 'mail_smtpauthtype' => 'LOGIN', 'mail_domain' => 'removed', 'appstoreenabled' => false, 'loglevel' => 0, 'logtimezone' => 'America/Los_Angeles', 'maintenance' => true, 'memcache.local' => '\\OC\\Memcache\\APCu', 'updater.secret' => 'removed', 'apps_paths' => array ( 0 => array ( 'path' => '/usr/local/www/nextcloud/apps', 'url' => '/apps', 'writable' => true, ), 1 => array ( 'path' => '/usr/local/www/nextcloud/apps-pkg', 'url' => '/apps-pkg', 'writable' => false, ), ), 'theme' => '', );