Update 23.0.0.10 to 23.0.2 - 1054 Unknown column 'argument_hash'

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

I got it by my own.
I will leave this post as a mark for everyone searching.

I just updated with:

www-data@db8f80d24476:~/html$ ./occ upgrade

in the first time there was no reaction and I thought nothin will happen. but just waiting was the answer.

1 Like

I have this bug too and ./occ upgrade give me the error :

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

7 times : Unknown column ‘argument_hash’ in ‘where clause’

  • 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’

  • 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’
  • 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’
  • 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’

I found my problems was the version in the config.php that was not the right one.
I do use docker to do the update and in my case I did have to setup to the right version.

in the config.php :
‘version’ => ‘22.1.1.2’,
‘overwrite.cli.url’ => 'ht
but occ

$ ./occ status

  • installed: true
  • version: 23.0.3.2
  • versionstring: 23.0.3

the occ upgrade complains about the vesion, I did not remember that there is a version field in the config file.

1 Like