Support intro
Sorry to hear you’re facing problems
help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.
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:
example
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' => '13.0.1.1',
'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' => '',
);