# Nextcloud
## Update to 16.0.2
Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing 'ALTER TABLE `oc_migrations` ROW_FORMAT=COMPRESSED;': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_migrations' doesn't exist
Detailed logs
Preparing update
Set log level to debug
Turned on maintenance mode
Repair step: Repair MySQL collation
Repair info: Change row format for oc_activity ...
Repair info: Change collation for oc_activity ...
Repair info: Change row format for oc_addressbooks ...
Repair info: Change collation for oc_addressbooks ...
Repair info: Change row format for oc_authtoken ...
Repair info: Change collation for oc_authtoken ...
Repair info: Change row format for oc_bruteforce_attempts ...
Repair info: Change collation for oc_bruteforce_attempts ...
Repair info: Change row format for oc_calendar_resources ...
Repair info: Change collation for oc_calendar_resources ...
Repair info: Change row format for oc_calendar_rooms ...
Repair info: Change collation for oc_calendar_rooms ...
Repair info: Change row format for oc_calendarobjects ...
Repair info: Change collation for oc_calendarobjects ...
Repair info: Change row format for oc_calendarobjects_props ...
Repair info: Change collation for oc_calendarobjects_props ...
Repair info: Change row format for oc_calendars ...
Repair info: Change collation for oc_calendars ...
Repair info: Change row format for oc_calendarsubscriptions ...
Repair info: Change collation for oc_calendarsubscriptions ...
Repair info: Change row format for oc_cards_properties ...
Repair info: Change collation for oc_cards_properties ...
Repair info: Change row format for oc_dav_shares ...
Repair info: Change collation for oc_dav_shares ...
Repair info: Change row format for oc_filecache ...
Repair info: Change collation for oc_filecache ...
Repair info: Change row format for oc_files_trash ...
Repair info: Change collation for oc_files_trash ...
Repair info: Change row format for oc_jobs ...
Repair info: Change collation for oc_jobs ...
Repair info: Change row format for oc_ldap_group_mapping ...
Repair info: Change collation for oc_ldap_group_mapping ...
Repair info: Change row format for oc_ldap_group_members ...
Repair info: Change collation for oc_ldap_group_members ...
Repair info: Change row format for oc_ldap_user_mapping ...
Repair info: Change collation for oc_ldap_user_mapping ...
Repair info: Change row format for oc_login_flow_v2 ...
Repair info: Change collation for oc_login_flow_v2 ...
Repair info: Change row format for oc_migrations ...
Repair info: Change collation for oc_migrations ...
Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing 'ALTER TABLE `oc_migrations` ROW_FORMAT=COMPRESSED;': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_migrations' doesn't exist
The update was unsuccessful. Please report this issue to the [Nextcloud community](https://github.com/nextcloud/server/issues).
su -m www -c "php ./occ status"
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
- installed: true
- version: 16.0.2.1
- versionstring: 16.0.2
- edition:
mysql> show tables
reveals that there is an oc_migrations table…
| oc_migrations |
mysql> select * from oc_migrations;
ERROR 1146 (42S02): Table 'nextcloud.oc_migrations' doesn't exist
I don’t see how to recreate it, no schema that I can find.