Hey!
I updated my nextcloud, driven on an Raspberry Pi 4 / 8GB in docker.
After this update i need to “finish” the update in my Browser.
There I got an non-saying error. so i tried to upgrade it with:
www-data@db8f80d24476:~/html$ php occ maintenance:repair
first, the
Change row format for oc_activity …
took a very long time. sometimes the browser-update breakes here.
than the second time the update need much time right here:
Change row format for oc_filecache …
this will be the other point where the browser updater breaks
but after all I get thise wired error and I don’t get any clue from the world wide web.
ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘argument_hash’ in ‘where clause’
I cant find ANYTHING about the ‘argument_hash’ so I dont know where I should create this column
I hope someone could help me!
If you need any further logs, please let me know.
extcloud 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
- Repair MySQL collation
- Change row format for oc_known_users ...
- Change collation for oc_known_users ...
- Change row format for oc_webauthn ...
- Change collation for oc_webauthn ...
- Change row format for oc_systemtag_group ...
- Change collation for oc_systemtag_group ...
- Change row format for oc_dav_cal_proxy ...
- Change collation for oc_dav_cal_proxy ...
- Change row format for oc_talk_rooms ...
- Change collation for oc_talk_rooms ...
- Change row format for oc_directlink ...
- Change collation for oc_directlink ...
- Change row format for oc_share ...
- Change collation for oc_share ...
- Change row format for oc_flow_operations_scope ...
- Change collation for oc_flow_operations_scope ...
- Change row format for oc_recent_contact ...
- Change collation for oc_recent_contact ...
- Change row format for oc_privacy_admins ...
- Change collation for oc_privacy_admins ...
- Change row format for oc_authorized_groups ...
- Change collation for oc_authorized_groups ...
- Change row format for oc_comments ...
- Change collation for oc_comments ...
- Change row format for oc_text_sessions ...
- Change collation for oc_text_sessions ...
- Change row format for oc_oauth2_clients ...
- Change collation for oc_oauth2_clients ...
- Change row format for oc_preferences ...
- Change collation for oc_preferences ...
- Change row format for oc_addressbookchanges ...
- Change collation for oc_addressbookchanges ...
- Change row format for oc_jobs ...
- Change collation for oc_jobs ...
- Change row format for oc_notifications_pushhash ...
- Change collation for oc_notifications_pushhash ...
- Change row format for oc_flow_operations ...
- Change collation for oc_flow_operations ...
- Change row format for oc_talk_signaling ...
- Change collation for oc_talk_signaling ...
- Change row format for oc_circles_circle ...
- Change collation for oc_circles_circle ...
- Change row format for oc_calendar_appt_bookings ...
- Change collation for oc_calendar_appt_bookings ...
- Change row format for oc_activity ...
- Change collation for oc_activity ...
- Change row format for oc_mail_accounts ...
- Change collation for oc_mail_accounts ...
- Change row format for oc_authtoken ...
- Change collation for oc_authtoken ...
- Change row format for oc_circles_share_lock ...
- Change collation for oc_circles_share_lock ...
- Change row format for oc_federated_reshares ...
- Change collation for oc_federated_reshares ...
- Change row format for oc_files_trash ...
- Change collation for oc_files_trash ...
- Change row format for oc_user_transfer_owner ...
- Change collation for oc_user_transfer_owner ...
- Change row format for oc_mail_mailboxes ...
- Change collation for oc_mail_mailboxes ...
- Change row format for oc_vcategory ...
- Change collation for oc_vcategory ...
- Change row format for oc_cards ...
- Change collation for oc_cards ...
- Change row format for oc_calendars ...
- Change collation for oc_calendars ...
- Change row format for oc_comments_read_markers ...
- Change collation for oc_comments_read_markers ...
- Change row format for oc_systemtag ...
- Change collation for oc_systemtag ...
- Change row format for oc_circles_mountpoint ...
- Change collation for oc_circles_mountpoint ...
- Change row format for oc_twofactor_backupcodes ...
- Change collation for oc_twofactor_backupcodes ...
- Change row format for oc_file_locks ...
- Change collation for oc_file_locks ...
- Change row format for oc_documentserver_changes ...
- Change collation for oc_documentserver_changes ...
- Change row format for oc_notifications ...
- Change collation for oc_notifications ...
- Change row format for oc_mimetypes ...
- Change collation for oc_mimetypes ...
- Change row format for oc_accounts_data ...
- Change collation for oc_accounts_data ...
- Change row format for oc_documentserver_ipc ...
- Change collation for oc_documentserver_ipc ...
- Change row format for oc_mail_coll_addresses ...
- Change collation for oc_mail_coll_addresses ...
- Change row format for oc_documentserver_locks ...
- Change collation for oc_documentserver_locks ...
- Change row format for oc_documentserver_sess ...
- Change collation for oc_documentserver_sess ...
- Change row format for oc_circles_member ...
- Change collation for oc_circles_member ...
- Change row format for oc_group_admin ...
- Change collation for oc_group_admin ...
- Change row format for oc_calendarchanges ...
- Change collation for oc_calendarchanges ...
- Change row format for oc_notifications_settings ...
- Change collation for oc_notifications_settings ...
- Change row format for oc_login_flow_v2 ...
- Change collation for oc_login_flow_v2 ...
- Change row format for oc_whats_new ...
- Change collation for oc_whats_new ...
- Change row format for oc_circles_token ...
- Change collation for oc_circles_token ...
- Change row format for oc_dav_shares ...
- Change collation for oc_dav_shares ...
- Change row format for oc_share_external ...
- Change collation for oc_share_external ...
- Change row format for oc_notes_meta ...
- Change collation for oc_notes_meta ...
- Change row format for oc_collres_collections ...
- Change collation for oc_collres_collections ...
- Change row format for oc_calendar_resources ...
- Change collation for oc_calendar_resources ...
- Change row format for oc_circles_membership ...
- Change collation for oc_circles_membership ...
- Change row format for oc_storages ...
- Change collation for oc_storages ...
- Change row format for oc_users ...
- Change collation for oc_users ...
- Change row format for oc_circles_event ...
- Change collation for oc_circles_event ...
- Change row format for oc_text_steps ...
- Change collation for oc_text_steps ...
- Change row format for oc_migrations ...
- Change collation for oc_migrations ...
- Change row format for oc_calendar_rooms ...
- Change collation for oc_calendar_rooms ...
- Change row format for oc_richdocuments_assets ...
- Change collation for oc_richdocuments_assets ...
- Change row format for oc_trusted_servers ...
- Change collation for oc_trusted_servers ...
- Change row format for oc_mounts ...
- Change collation for oc_mounts ...
- Change row format for oc_mail_aliases ...
- Change collation for oc_mail_aliases ...
- Change row format for oc_mail_attachments ...
- Change collation for oc_mail_attachments ...
- Change row format for oc_properties ...
- Change collation for oc_properties ...
- Change row format for oc_cards_properties ...
- Change collation for oc_cards_properties ...
- Change row format for oc_collres_accesscache ...
- Change collation for oc_collres_accesscache ...
- Change row format for oc_vcategory_to_object ...
- Change collation for oc_vcategory_to_object ...
- Change row format for oc_calendar_invitations ...
- Change collation for oc_calendar_invitations ...
- Change row format for oc_calendar_reminders ...
- Change collation for oc_calendar_reminders ...
- Change row format for oc_direct_edit ...
- Change collation for oc_direct_edit ...
- Change row format for oc_user_status ...
- Change collation for oc_user_status ...
- Change row format for oc_appconfig ...
- Change collation for oc_appconfig ...
- Change row format for oc_twofactor_providers ...
- Change collation for oc_twofactor_providers ...
- Change row format for oc_flow_checks ...
- Change collation for oc_flow_checks ...
- Change row format for oc_talk_commands ...
- Change collation for oc_talk_commands ...
- Change row format for oc_mail_recipients ...
- Change collation for oc_mail_recipients ...
- Change row format for oc_group_user ...
- Change collation for oc_group_user ...
- Change row format for oc_accounts ...
- Change collation for oc_accounts ...
- Change row format for oc_calendarobjects_props ...
- Change collation for oc_calendarobjects_props ...
- Change row format for oc_calendarsubscriptions ...
- Change collation for oc_calendarsubscriptions ...
- Change row format for oc_filecache ...
- Change collation for oc_filecache ...
- Change row format for oc_schedulingobjects ...
- Change collation for oc_schedulingobjects ...
- Change row format for oc_collres_resources ...
- Change collation for oc_collres_resources ...
- Change row format for oc_talk_guests ...
- Change collation for oc_talk_guests ...
- Change row format for oc_calendarobjects ...
- Change collation for oc_calendarobjects ...
- Change row format for oc_calendar_rooms_md ...
- Change collation for oc_calendar_rooms_md ...
- Change row format for oc_profile_config ...
- Change collation for oc_profile_config ...
- Change row format for oc_text_documents ...
- Change collation for oc_text_documents ...
- Change row format for oc_groups ...
- Change collation for oc_groups ...
- Change row format for oc_systemtag_object_mapping ...
- Change collation for oc_systemtag_object_mapping ...
- Change row format for oc_richdocuments_wopi ...
- Change collation for oc_richdocuments_wopi ...
- Change row format for oc_richdocuments_direct ...
- Change collation for oc_richdocuments_direct ...
- Change row format for oc_circles_mount ...
- Change collation for oc_circles_mount ...
- Change row format for oc_filecache_extended ...
- Change collation for oc_filecache_extended ...
- Change row format for oc_oauth2_access_tokens ...
- Change collation for oc_oauth2_access_tokens ...
- Change row format for oc_addressbooks ...
- Change collation for oc_addressbooks ...
- Change row format for oc_onlyoffice_filekey ...
- Change collation for oc_onlyoffice_filekey ...
- Change row format for oc_calendar_resources_md ...
- Change collation for oc_calendar_resources_md ...
- Change row format for oc_mail_messages ...
- Change collation for oc_mail_messages ...
- Change row format for oc_calendar_appt_configs ...
- Change collation for oc_calendar_appt_configs ...
- Change row format for oc_bruteforce_attempts ...
- Change collation for oc_bruteforce_attempts ...
- Change row format for oc_talk_participants ...
- Change collation for oc_talk_participants ...
- Change row format for oc_activity_mq ...
- Change collation for oc_activity_mq ...
- Change row format for oc_circles_remote ...
- Change collation for oc_circles_remote ...
- Change row format for oc_ratelimit_entries ...
- Change collation for oc_ratelimit_entries ...
- Change row format for oc_storages_credentials ...
- Change collation for oc_storages_credentials ...
- Change row format for oc_retention ...
- Change collation for oc_retention ...
- 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
- 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
- Add log rotate job
- ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause'
- Clear frontend caches
- Image cache cleared
- SCSS cache cleared
- JS cache cleared
- Clear every generated avatar on major updates
- Add preview background cleanup job
- ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause'
- Queue a one-time job to cleanup old backups of the updater
- ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause'
- Cleanup invalid photocache files for carddav
- Add background job to cleanup login flow v2 tokens
- ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause'
- Remove potentially over exposing share links
- No need to remove link shares.
- Clear access cache of projects
- Reset generated avatar flag
- Keep legacy encryption enabled
- Check encryption key format
- Remove old dashboard app config data
- Add job to cleanup the bruteforce entries
- ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause'
- Queue a one-time job to check for user uploaded certificates
- Repair DAV shares
- Add background job to set the lookup server share state for users
- ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause'
- Update name of the stored view
- Upgrading Circles App
- Fix component of birthday calendars
- 6 birthday calendars updated.
- Regenerating birthday calendars to use new icons and fix old birthday events without year
- Repair step already executed
- Fix broken values of calendar objects
0 [->--------------------------]
- Registering building of calendar search index as background job
- Repair step already executed
- Register building of social profile search index as background job
- Registering background jobs to update cache for webcal calendars
- Added 0 background jobs to update webcal calendars
- Registering building of calendar reminder index as background job
- Repair step already executed
- Clean up orphan event and contact data
- 0 events without a calendar have been cleaned up
- 0 properties without an events have been cleaned up
- 0 changes without a calendar have been cleaned up
- 0 cached events without a calendar subscription have been cleaned up
- 0 changes without a calendar subscription have been cleaned up
- 0 contacts without an addressbook have been cleaned up
- 0 properties without a contact have been cleaned up
- 0 changes without an addressbook have been cleaned up
- Remove activity entries of private events
- Removed 0 activity entries
- Clean up old calendar subscriptions from deleted users that were not cleaned-up
0 [----->----------------------]
- 0 calendar subscriptions without an user have been cleaned up
- Fix the share type of guest shares when migrating from ownCloud
- Copy the share password into the dedicated column
- Set existing shares as accepted
- Clean up meta table
- Update OAuth token expiration times
- Switches from default updater server to the customer one if a valid subscription is available
- Repair step already executed
- Send an admin notification if monthly report is disabled
- ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause'
- Add background job to check for backup codes
- ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause'
- Populating added database structures for workflows