[Bug]: Unable to update background execution mode: `conflict between new type (mixed) and old type (string)`

theyoungstone commented 6 months ago

⚠️ This issue respects the following points: ⚠️

[X] This is a bug, not a question or a configuration/webserver/proxy issue.
[X] This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
[X] Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
[X] I agree to follow Nextcloud's Code of Conduct.

Bug description

When I want to change the background task execution mode, I have the message "Impossible de mettre à jour le mode d'exécution des tâches d'arrière-plan" (Unable to update background task execution mode)

Steps to reproduce

Go to "Administration parameters"
Go to "Basic settings"
Try to change background task execution mode from "Cron" to another

Expected behavior

Change accepted

Installation method

Community Manual Installation with Archive

Nextcloud Server version

29

Operating system

Debian

PHP engine version

8.3

Web server

Apache

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

Update from 28.0.5 to 29.0.0

Are you using the Nextcloud Server Encryption module?

No

What user-backends are you using?

[X] Default user-backend (database)
[ ] LDAP/ Active Directory
[ ] SSO - SAML
[ ] Other

Configuration report

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "nextcloud.lejeune.pl"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "29.0.0.19",
        "overwrite.cli.url": "https:\/\/nextcloud.lejeune.pl",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.distributed": "\\OC\\Memcache\\Memcached",
        "memcache.locking": "\\OC\\Memcache\\Memcached",
        "memcached_servers": [
            [
                "localhost",
                11211
            ]
        ],
        "maintenance": false,
        "mail_smtpmode": "smtp",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpsecure": "ssl",
        "has_rebuilt_cache": true,
        "twofactor_enforced": "true",
        "twofactor_enforced_groups": [
            "DoubleAuth"
        ],
        "twofactor_enforced_excluded_groups": [
            "SimpleAuth"
        ],
        "theme": "",
        "loglevel": 2,
        "updater.release.channel": "stable",
        "app_install_overwrite": [
            "calendar",
            "ransomware_detection",
            "gpxedit",
            "gpxpod",
            "phonetrack",
            "quota_warning",
            "ransomware_protection"
        ],
        "default_phone_region": "FR",
        "maintenance_window_start": "1",
        "trashbin_retention_obligation": "auto",
        "updater.secret": "***REMOVED SENSITIVE VALUE***"
    },
    "apps": {
        "activity": {
            "enable_email": "no",
            "enabled": "yes",
            "installed_version": "2.21.1",
            "notify_email_calendar": "0",
            "notify_email_calendar_event": "0",
            "notify_email_calendar_todo": "0",
            "notify_email_comments": "0",
            "notify_email_deck": "0",
            "notify_email_deck_card_description": "0",
            "notify_email_deck_comment": "0",
            "notify_email_favorite": "0",
            "notify_email_file_changed": "0",
            "notify_email_file_created": "0",
            "notify_email_file_deleted": "0",
            "notify_email_file_favorite_changed": "0",
            "notify_email_file_restored": "0",
            "notify_email_phonetrack": "0",
            "notify_email_phonetrack_geofence_event": "0",
            "notify_email_phonetrack_proximity_event": "0",
            "notify_email_public_links": "1",
            "notify_email_remote_share": "0",
            "notify_email_shared": "0",
            "notify_email_systemtags": "0",
            "notify_notification_calendar": "0",
            "notify_notification_calendar_event": "0",
            "notify_notification_calendar_todo": "0",
            "notify_notification_comments": "0",
            "notify_notification_deck": "0",
            "notify_notification_deck_card_description": "0",
            "notify_notification_deck_comment": "0",
            "notify_notification_favorite": "0",
            "notify_notification_file_changed": "0",
            "notify_notification_file_favorite_changed": "1",
            "notify_notification_group_settings": "1",
            "notify_notification_personal_settings": "0",
            "notify_notification_phonetrack": "0",
            "notify_notification_phonetrack_geofence_event": "0",
            "notify_notification_phonetrack_proximity_event": "0",
            "notify_notification_public_links": "0",
            "notify_notification_remote_share": "0",
            "notify_notification_security": "1",
            "notify_notification_shared": "1",
            "notify_notification_systemtags": "0",
            "notify_notification_twofactor_totp": "1",
            "notify_setting_batchtime": "3600",
            "notify_setting_self": "0",
            "notify_setting_selfemail": "0",
            "notify_stream_calendar": "1",
            "notify_stream_calendar_event": "1",
            "notify_stream_calendar_todo": "1",
            "notify_stream_comments": "1",
            "notify_stream_deck": "1",
            "notify_stream_deck_card_description": "1",
            "notify_stream_favorite": "1",
            "notify_stream_file_changed": "1",
            "notify_stream_file_created": "1",
            "notify_stream_file_deleted": "1",
            "notify_stream_file_favorite": "0",
            "notify_stream_file_restored": "1",
            "notify_stream_phonetrack": "1",
            "notify_stream_phonetrack_geofence_event": "1",
            "notify_stream_phonetrack_proximity_event": "1",
            "notify_stream_public_links": "1",
            "notify_stream_remote_share": "1",
            "notify_stream_shared": "1",
            "notify_stream_systemtags": "1",
            "types": "filesystem"
        },
        "backgroundjob": {
            "lastjob": "19086"
        },
        "bruteForce": {
            "whitelist_2": "82.64.57.215\/32"
        },
        "bruteforcesettings": {
            "enabled": "yes",
            "installed_version": "2.9.0",
            "types": ""
        },
        "calendar": {
            "enabled": "yes",
            "installed_version": "4.7.1",
            "types": ""
        },
        "carnet": {
            "enabled": "no",
            "installed_version": "0.20.0",
            "types": "filesystem"
        },
        "circles": {
            "enabled": "yes",
            "installed_version": "29.0.0-dev",
            "loopback_tmp_scheme": "https",
            "maintenance_run": "0",
            "maintenance_update": "{\"maximum\":3,\"3\":1714238102,\"2\":1714239003,\"1\":1714239003,\"4\":1652320802,\"5\":1651892403}",
            "migration_22": "1",
            "migration_22_1": "1",
            "migration_run": "0",
            "types": "filesystem,dav"
        },
        "cloud_federation_api": {
            "enabled": "yes",
            "installed_version": "1.12.0",
            "types": "filesystem"
        },
        "comments": {
            "enabled": "yes",
            "installed_version": "1.19.0",
            "types": "logging"
        },
        "contacts": {
            "enabled": "yes",
            "installed_version": "6.0.0",
            "types": "dav"
        },
        "contactsinteraction": {
            "enabled": "yes",
            "installed_version": "1.10.0",
            "types": "dav"
        },
        "core": {
            "backgroundjobs_mode": "cron",
            "enterpriseLogoChecked": "yes",
            "files_metadata": "{\"photos-original_date_time\":{\"value\":null,\"type\":\"int\",\"indexed\":true,\"editPermission\":0},\"photos-exif\":{\"value\":null,\"type\":\"array\",\"indexed\":false,\"editPermission\":0},\"photos-ifd0\":{\"value\":null,\"type\":\"array\",\"indexed\":false,\"editPermission\":0},\"photos-size\":{\"value\":null,\"type\":\"array\",\"indexed\":false,\"editPermission\":0},\"photos-gps\":{\"value\":null,\"type\":\"array\",\"indexed\":false,\"editPermission\":0},\"photos-place\":{\"value\":null,\"type\":\"string\",\"indexed\":true,\"editPermission\":0},\"files-live-photo\":{\"value\":null,\"type\":\"string\",\"indexed\":false,\"editPermission\":1}}",
            "files_metadata_installed": "1",
            "installed.bundles": "[\"CoreBundle\"]",
            "installedat": "1584987245.804",
            "lastcron": "1714283220",
            "lastupdateResult": "[]",
            "lastupdatedat": "1714283141",
            "moveavatarsdone": "yes",
            "previewsCleanedUp": "1",
            "public_files": "files_sharing\/public.php",
            "public_webdav": "dav\/appinfo\/v1\/publicwebdav.php",
            "theming.variables": "3380c74585402bc749599a676554ab7b",
            "updater.secret.created": "1714238927",
            "vendor": "nextcloud",
            "oc.integritycheck.checker": "[]"
        },
        "cospend": {
            "enabled": "no",
            "installed_version": "1.3.7",
            "types": ""
        },
        "dashboard": {
            "enabled": "no",
            "installed_version": "7.1.0",
            "types": ""
        },
        "dav": {
            "buildCalendarReminderIndex": "yes",
            "buildCalendarSearchIndex": "yes",
            "builtSocialSearchIndex": "yes",
            "chunks_migrated": "1",
            "enabled": "yes",
            "installed_version": "1.30.1",
            "regeneratedBirthdayCalendarsForYearFix": "yes",
            "types": "filesystem"
        },
        "deck": {
            "enabled": "no",
            "installed_version": "1.3.2",
            "types": "dav"
        },
        "duplicatefinder": {
            "enabled": "no",
            "installed_version": "0.0.15",
            "types": ""
        },
        "federatedfilesharing": {
            "enabled": "yes",
            "installed_version": "1.19.0",
            "types": ""
        },
        "federation": {
            "enabled": "yes",
            "installed_version": "1.19.0",
            "types": "authentication"
        },
        "files": {
            "cronjob_scan_files": "500",
            "default_quota": "1 GB",
            "enabled": "yes",
            "installed_version": "2.1.0",
            "types": "filesystem"
        },
        "files_antivirus": {
            "av_path": "\/usr\/bin\/clamscan",
            "enabled": "no",
            "installed_version": "3.0.0",
            "types": "filesystem,dav"
        },
        "files_downloadlimit": {
            "enabled": "yes",
            "installed_version": "2.0.0",
            "types": ""
        },
        "files_pdfviewer": {
            "enabled": "yes",
            "installed_version": "2.10.0",
            "types": ""
        },
        "files_reminders": {
            "enabled": "yes",
            "installed_version": "1.2.0",
            "types": ""
        },
        "files_retention": {
            "enabled": "no",
            "installed_version": "1.10.0",
            "types": "filesystem"
        },
        "files_rightclick": {
            "enabled": "no",
            "installed_version": "1.6.0",
            "types": ""
        },
        "files_sharing": {
            "enabled": "yes",
            "installed_version": "1.21.0",
            "types": "filesystem"
        },
        "files_trashbin": {
            "enabled": "yes",
            "installed_version": "1.19.0",
            "types": "filesystem,dav"
        },
        "files_versions": {
            "enabled": "yes",
            "installed_version": "1.22.0",
            "types": "filesystem,dav"
        },
        "firstrunwizard": {
            "enabled": "yes",
            "installed_version": "2.18.0",
            "types": "logging"
        },
        "gpxedit": {
            "enabled": "no",
            "installed_version": "0.0.14",
            "types": ""
        },
        "gpxmotion": {
            "enabled": "no",
            "installed_version": "0.1.0",
            "types": ""
        },
        "gpxpod": {
            "enabled": "yes",
            "installed_version": "5.0.18",
            "reset304": "1",
            "resetPics404": "1",
            "types": ""
        },
        "groupfolders": {
            "enabled": "no",
            "installed_version": "16.0.6",
            "types": "filesystem,dav"
        },
        "logreader": {
            "enabled": "yes",
            "installed_version": "2.14.0",
            "levels": "00111",
            "shownLevels": "[2,3,4]",
            "types": "logging"
        },
        "lookup_server_connector": {
            "enabled": "yes",
            "installed_version": "1.17.0",
            "types": "authentication"
        },
        "mail": {
            "enabled": "yes",
            "installed_version": "3.6.0",
            "types": ""
        },
        "maps": {
            "enabled": "no",
            "installed_version": "0.1.6",
            "lastAddressLookup": "1585295213",
            "types": "filesystem"
        },
        "nextcloud_announcements": {
            "enabled": "yes",
            "installed_version": "1.18.0",
            "pub_date": "Thu, 24 Oct 2019 00:00:00 +0200",
            "types": "logging"
        },
        "notes": {
            "enabled": "yes",
            "installed_version": "4.10.0",
            "types": ""
        },
        "notifications": {
            "enabled": "yes",
            "installed_version": "2.17.0",
            "types": "logging"
        },
        "oauth2": {
            "enabled": "yes",
            "installed_version": "1.17.0",
            "types": "authentication"
        },
        "password_policy": {
            "enabled": "yes",
            "enforceHaveIBeenPwned": "1",
            "enforceNumericCharacters": "1",
            "enforceSpecialCharacters": "1",
            "enforceUpperLowerCase": "1",
            "installed_version": "1.19.0",
            "types": "authentication"
        },
        "phonetrack": {
            "enabled": "yes",
            "installed_version": "0.7.7",
            "pointQuota": "20000",
            "types": ""
        },
        "photos": {
            "enabled": "yes",
            "installed_version": "2.5.0",
            "lastPlaceMappedUser": "pierre",
            "lastPlaceMappingDone": "true",
            "types": "dav,authentication"
        },
        "privacy": {
            "enabled": "yes",
            "installed_version": "1.13.0",
            "readableLocation": "fr",
            "types": ""
        },
        "provisioning_api": {
            "enabled": "yes",
            "installed_version": "1.19.0",
            "types": "prevent_group_restriction"
        },
        "quota_warning": {
            "alert_email": "yes",
            "enabled": "yes",
            "info_email": "yes",
            "installed_version": "1.19.0",
            "types": "filesystem",
            "warning_email": "yes"
        },
        "ransomware_detection": {
            "debug": "0",
            "enabled": "no",
            "installed_version": "0.10.0",
            "types": ""
        },
        "ransomware_protection": {
            "enabled": "no",
            "installed_version": "1.14.0",
            "types": "logging"
        },
        "recommendations": {
            "enabled": "yes",
            "installed_version": "2.1.0",
            "types": ""
        },
        "related_resources": {
            "enabled": "yes",
            "installed_version": "1.4.0",
            "types": ""
        },
        "serverinfo": {
            "cached_count_filecache": "59169",
            "cached_count_storages": "6",
            "enabled": "yes",
            "installed_version": "1.19.0",
            "types": ""
        },
        "settings": {
            "enabled": "yes",
            "installed_version": "1.12.0",
            "types": ""
        },
        "sharebymail": {
            "enabled": "yes",
            "installed_version": "1.19.0",
            "types": "filesystem"
        },
        "side_menu": {
            "add-logo-link": "0",
            "always-displayed": "0",
            "background-color": "#333333",
            "background-color-opacity": "100",
            "background-color-to": "#333333",
            "big-menu": "0",
            "big-menu-hidden-apps": "[]",
            "cache": "11",
            "cache-categories": <Comment to long for bug formular>,
            "categories-order": "[\"other\",\"office\",\"external_links\",\"files\",\"workflow\",\"integration\",\"games\",\"multimedia\",\"organization\",\"tools\",\"customization\",\"search\",\"social\",\"monitoring\",\"security\",\"dashboard\"]",
            "categories-order-type": "default",
            "current-app-background-color": "#444444",
            "dark-mode-background-color": "#333333",
            "dark-mode-background-color-opacity": "100",
            "dark-mode-background-color-to": "#333333",
            "dark-mode-current-app-background-color": "#444444",
            "dark-mode-icon-invert-filter": "0",
            "dark-mode-icon-opacity": "100",
            "dark-mode-loader-color": "#cccccc",
            "dark-mode-opener": "side-menu-opener",
            "dark-mode-text-color": "#ffffff",
            "default-enabled": "1",
            "display-logo": "1",
            "enabled": "no",
            "external-sites-in-top-menu": "0",
            "force": "0",
            "force-light-icon": "0",
            "hide-when-no-apps": "1",
            "icon-invert-filter": "0",
            "icon-opacity": "0",
            "installed_version": "2.0.1",
            "loader-color": "#0e75ac",
            "loader-enabled": "1",
            "opener": "side-menu-opener",
            "opener-hover": "0",
            "opener-only": "0",
            "opener-position": "before",
            "show-settings": "0",
            "side-with-categories": "0",
            "size-icon": "small",
            "size-text": "normal",
            "target-blank-apps": "[]",
            "text-color": "#ffffff",
            "top-menu-apps": "[]",
            "types": "",
            "undefined": "",
            "use-avatar": "0"
        },
        "support": {
            "SwitchUpdaterServerHasRun": "yes",
            "enabled": "yes",
            "installed_version": "1.12.0",
            "types": "session"
        },
        "survey_client": {
            "enabled": "yes",
            "installed_version": "1.17.0",
            "last_report": "{\"id\":\"ocfdzy5tv71g\",\"items\":[[\"server\",\"version\",\"28.0.4.1\"],[\"server\",\"code\",\"other\"],[\"server\",\"enable_avatars\",\"yes\"],[\"server\",\"enable_previews\",\"yes\"],[\"server\",\"memcache.local\",\"\\\\OC\\\\Memcache\\\\APCu\"],[\"server\",\"memcache.distributed\",\"\\\\OC\\\\Memcache\\\\Memcached\"],[\"server\",\"asset-pipeline.enabled\",\"no\"],[\"server\",\"filelocking.enabled\",\"yes\"],[\"server\",\"memcache.locking\",\"\\\\OC\\\\Memcache\\\\Memcached\"],[\"server\",\"debug\",\"no\"],[\"server\",\"cron\",\"cron\"],[\"php\",\"version\",\"8.3.6\"],[\"php\",\"memory_limit\",-1],[\"php\",\"max_execution_time\",0],[\"php\",\"upload_max_filesize\",2097152],[\"database\",\"type\",\"mysql\"],[\"database\",\"version\",\"10.3.39\"],[\"database\",\"size\",99917824],[\"apps\",\"activity\",\"2.20.0\"],[\"apps\",\"bruteforcesettings\",\"2.8.0\"],[\"apps\",\"calendar\",\"4.6.7\"],[\"apps\",\"carnet\",\"disabled\"],[\"apps\",\"circles\",\"28.0.0\"],[\"apps\",\"cloud_federation_api\",\"1.11.0\"],[\"apps\",\"comments\",\"1.18.0\"],[\"apps\",\"contacts\",\"5.5.3\"],[\"apps\",\"contactsinteraction\",\"1.9.0\"],[\"apps\",\"cospend\",\"disabled\"],[\"apps\",\"dashboard\",\"disabled\"],[\"apps\",\"dav\",\"1.29.1\"],[\"apps\",\"deck\",\"disabled\"],[\"apps\",\"duplicatefinder\",\"disabled\"],[\"apps\",\"federatedfilesharing\",\"1.18.0\"],[\"apps\",\"federation\",\"1.18.0\"],[\"apps\",\"files\",\"2.0.0\"],[\"apps\",\"files_antivirus\",\"disabled\"],[\"apps\",\"files_pdfviewer\",\"2.9.0\"],[\"apps\",\"files_reminders\",\"1.1.0\"],[\"apps\",\"files_retention\",\"disabled\"],[\"apps\",\"files_rightclick\",\"disabled\"],[\"apps\",\"files_sharing\",\"1.20.0\"],[\"apps\",\"files_trashbin\",\"1.18.0\"],[\"apps\",\"files_versions\",\"1.21.0\"],[\"apps\",\"firstrunwizard\",\"2.17.0\"],[\"apps\",\"gpxedit\",\"disabled\"],[\"apps\",\"gpxmotion\",\"disabled\"],[\"apps\",\"gpxpod\",\"5.0.18\"],[\"apps\",\"groupfolders\",\"16.0.6\"],[\"apps\",\"logreader\",\"2.13.0\"],[\"apps\",\"lookup_server_connector\",\"1.16.0\"],[\"apps\",\"mail\",\"3.5.7\"],[\"apps\",\"maps\",\"disabled\"],[\"apps\",\"nextcloud_announcements\",\"1.17.0\"],[\"apps\",\"notes\",\"4.9.4\"],[\"apps\",\"notifications\",\"2.16.0\"],[\"apps\",\"oauth2\",\"1.16.3\"],[\"apps\",\"password_policy\",\"1.18.0\"],[\"apps\",\"phonetrack\",\"0.7.7\"],[\"apps\",\"photos\",\"2.4.0\"],[\"apps\",\"privacy\",\"1.12.0\"],[\"apps\",\"provisioning_api\",\"1.18.0\"],[\"apps\",\"quota_warning\",\"1.19.0\"],[\"apps\",\"ransomware_detection\",\"disabled\"],[\"apps\",\"ransomware_protection\",\"disabled\"],[\"apps\",\"recommendations\",\"2.0.0\"],[\"apps\",\"related_resources\",\"1.3.0\"],[\"apps\",\"serverinfo\",\"1.18.0\"],[\"apps\",\"settings\",\"1.10.1\"],[\"apps\",\"sharebymail\",\"1.18.0\"],[\"apps\",\"side_menu\",\"disabled\"],[\"apps\",\"support\",\"1.11.1\"],[\"apps\",\"survey_client\",\"1.16.0\"],[\"apps\",\"systemtags\",\"1.18.0\"],[\"apps\",\"tasks\",\"disabled\"],[\"apps\",\"text\",\"3.9.1\"],[\"apps\",\"theming\",\"2.3.0\"],[\"apps\",\"twofactor_backupcodes\",\"1.17.0\"],[\"apps\",\"twofactor_totp\",\"10.0.0-beta.2\"],[\"apps\",\"updatenotification\",\"1.18.0\"],[\"apps\",\"user_status\",\"1.8.1\"],[\"apps\",\"viewer\",\"2.2.0\"],[\"apps\",\"weather_status\",\"1.8.0\"],[\"apps\",\"workflowengine\",\"2.10.0\"],[\"stats\",\"num_files\",58271],[\"stats\",\"num_users\",4],[\"stats\",\"num_storages\",6],[\"stats\",\"num_storages_local\",2],[\"stats\",\"num_storages_home\",4],[\"stats\",\"num_storages_other\",0],[\"stats\",\"num_comments\",0],[\"stats\",\"num_comment_markers\",0],[\"stats\",\"num_systemtags\",0],[\"stats\",\"num_systemtags_mappings\",0],[\"files_sharing\",\"num_shares\",5],[\"files_sharing\",\"num_shares_user\",3],[\"files_sharing\",\"num_shares_groups\",0],[\"files_sharing\",\"num_shares_link\",2],[\"files_sharing\",\"num_shares_link_no_password\",2],[\"files_sharing\",\"num_fed_shares_sent\",0],[\"files_sharing\",\"num_fed_shares_received\",0],[\"files_sharing\",\"permissions_3_17\",2],[\"files_sharing\",\"permissions_0_31\",3],[\"encryption\",\"enabled\",\"no\"],[\"encryption\",\"default_module\",\"no\"]]}",
            "last_sent": "1713354903",
            "server": "yes",
            "types": ""
        },
        "systemtags": {
            "enabled": "yes",
            "installed_version": "1.19.0",
            "types": "logging"
        },
        "tasks": {
            "enabled": "no",
            "installed_version": "0.13.6",
            "types": ""
        },
        "text": {
            "enabled": "yes",
            "installed_version": "3.10.0",
            "types": "dav"
        },
        "theming": {
            "cachebuster": "1",
            "enabled": "yes",
            "installed_version": "2.4.0",
            "types": "logging"
        },
        "twofactor_backupcodes": {
            "enabled": "yes",
            "installed_version": "1.18.0",
            "types": ""
        },
        "twofactor_totp": {
            "enabled": "yes",
            "installed_version": "11.0.0-dev",
            "types": ""
        },
        "updatenotification": {
            "bruteforcesettings": "2.0.1",
            "calendar": "4.6.4",
            "contacts": "5.5.2",
            "core": "28.0.3.2",
            "deck": "1.2.6",
            "enabled": "yes",
            "gpxedit": "0.0.14",
            "gpxpod": "5.0.15",
            "groupfolders": "16.0.4",
            "installed_version": "1.19.1",
            "mail": "3.5.7",
            "notes": "4.9.2",
            "notify_groups": "[\"admin\"]",
            "phonetrack": "0.7.7",
            "quota_warning": "1.18.0",
            "ransomware_detection": "0.10.0",
            "ransomware_protection": "1.13.0",
            "related_resources": "1.0.4",
            "side_menu": "2.0.1",
            "twofactor_totp": "6.4.1",
            "types": "",
            "update_check_errors": "0"
        },
        "user_status": {
            "enabled": "yes",
            "installed_version": "1.9.0",
            "types": ""
        },
        "viewer": {
            "enabled": "yes",
            "installed_version": "2.3.0",
            "types": ""
        },
        "weather_status": {
            "enabled": "yes",
            "installed_version": "1.9.0",
            "types": ""
        },
        "workflowengine": {
            "enabled": "yes",
            "installed_version": "2.11.0",
            "types": "filesystem"
        }
    }
}

List of activated Apps

Enabled:
  - activity: 2.21.1
  - bruteforcesettings: 2.9.0
  - calendar: 4.7.1
  - circles: 29.0.0-dev
  - cloud_federation_api: 1.12.0
  - comments: 1.19.0
  - contacts: 6.0.0
  - contactsinteraction: 1.10.0
  - dav: 1.30.1
  - federatedfilesharing: 1.19.0
  - federation: 1.19.0
  - files: 2.1.0
  - files_downloadlimit: 2.0.0
  - files_pdfviewer: 2.10.0
  - files_reminders: 1.2.0
  - files_sharing: 1.21.0
  - files_trashbin: 1.19.0
  - files_versions: 1.22.0
  - firstrunwizard: 2.18.0
  - gpxpod: 5.0.18
  - logreader: 2.14.0
  - lookup_server_connector: 1.17.0
  - mail: 3.6.0
  - nextcloud_announcements: 1.18.0
  - notes: 4.10.0
  - notifications: 2.17.0
  - oauth2: 1.17.0
  - password_policy: 1.19.0
  - phonetrack: 0.7.7
  - photos: 2.5.0
  - privacy: 1.13.0
  - provisioning_api: 1.19.0
  - quota_warning: 1.19.0
  - recommendations: 2.1.0
  - related_resources: 1.4.0
  - serverinfo: 1.19.0
  - settings: 1.12.0
  - sharebymail: 1.19.0
  - support: 1.12.0
  - survey_client: 1.17.0
  - systemtags: 1.19.0
  - text: 3.10.0
  - theming: 2.4.0
  - twofactor_backupcodes: 1.18.0
  - twofactor_totp: 11.0.0-dev
  - updatenotification: 1.19.1
  - user_status: 1.9.0
  - viewer: 2.3.0
  - weather_status: 1.9.0
  - workflowengine: 2.11.0
Disabled:
  - admin_audit: 1.19.0
  - dashboard: 7.9.0 (installed 7.1.0)
  - encryption: 2.17.0
  - files_external: 1.21.0
  - suspicious_login: 7.0.0
  - user_ldap: 1.20.0

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

{"reqId":"JTeLBOKxg5fEafinsMxV","level":3,"time":"2024-04-28T05:55:49+00:00","remoteAddr":"92.184.99.151","user":"pierre","app":"no app in context","method":"POST","url":"/ocs/v2.php/apps/provisioning_api/api/v1/config/apps/core/backgroundjobs_mode","message":"conflict between new type (mixed) and old type (string)","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:125.0) Gecko/20100101 Firefox/125.0","version":"29.0.0.19","exception":{"Exception":"OCP\\Exceptions\\AppConfigTypeConflictException","Message":"conflict between new type (mixed) and old type (string)","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/AppConfig.php","line":556,"function":"setTypedValue","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/html/nextcloud/apps/provisioning_api/lib/Controller/AppConfigController.php","line":147,"function":"setValueMixed","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"setValue","class":"OCA\\Provisioning_API\\Controller\\AppConfigController","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/html/nextcloud/ocs/v1.php","line":66,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/html/nextcloud/ocs/v2.php","line":23,"args":["/var/www/html/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/AppConfig.php","Line":821,"message":"conflict between new type (mixed) and old type (string)","exception":[],"CustomMessage":"conflict between new type (mixed) and old type (string)"},"id":"662de84237d0c"}

Additional info

No response

SDuesterhaupt commented 6 months ago

If I toggle the background job type on my test system (Nextcloud 29, updated over years including beta and RC versions) using the CLI

sudo -u apache php /var/www/public_html/nextcloud.domain.tld/occ background:ajax

then this error occurs:

In AppConfig.php line 821:

  conflict between new type (mixed) and old type (string)

This error does not occur in a productive system (version 29, updated over years excluding beta and RC versions, no fresh install). I assume that a database entry may be out of date.

wagnbeu0 commented 5 months ago

Can confirm the same issue here on my NC29.0.1 instance:

root@vm1:~# sudo -u www-data php /var/www/occ background:webcron
In AppConfig.php line 821:
  conflict between new type (mixed) and old type (string)
background:webcron

root@vm1:~# sudo -u www-data php /var/www/occ background:ajax
In AppConfig.php line 821:
  conflict between new type (mixed) and old type (string)
background:ajax

root@vm1:~# sudo -u www-data php /var/www/occ background:cron
Set mode for background jobs to 'cron'
root@vm1:~#

joshtrichards commented 5 months ago

Thanks for reporting.

Looks possibly related to changes made in PR #41755 that typed the values.

Not a PR or area of code I'm at all familiar with, but some clues in case someone feels like taking a closer look.

Allesanddro commented 5 months ago

Same issue here

tobykurien commented 5 months ago

Same here too. Additional info: if I run ./occ background:webcron to change it, I get:

In AppConfig.php line 821:

  conflict between new type (mixed) and old type (string)  

background:webcron

HammyHavoc commented 5 months ago

Seeing this too.

jarrodjay commented 5 months ago

Same here.

HammyHavoc commented 5 months ago

Same here.

I updated to the latest version of Nextcloud yesterday and it seemed to solve my problem with cron not working and also not being able to switch cron types.

theyoungstone commented 5 months ago

Same here.

I updated to the latest version of Nextcloud yesterday and it seemed to solve my problem with cron not working and also not being able to switch cron types.

Nextcloud up to date (stable version : Nextcloud Hub 8 (29.0.2)) and not solved.

johnczer commented 5 months ago

Ditto on above

CNeutron commented 5 months ago

Same issue here: php occ background:ajax results in

In AppConfig.php line 821:

  conflict between new type (mixed) and old type (string)  

background:ajax

just updated from 28.0.5 --> 29.0.2

johnczer commented 4 months ago

And still happening on 29.0.3:(

joshtrichards commented 4 months ago

Rather than posting "me too" comments, upvote :+1: the initial report above, unless you have some new information to add.

It just spams everybody and wastes developer time needed to fix bugs. Thanks!

P.S. This is a known issue (reproduced). That's why I labeled it 1. to develop last week. :)

joshtrichards commented 4 months ago

As a workaround, for the time being to toggle the background mode, you should be able to change the value directly:

occ config:app:set --value cron --type string core backgroundjobs_mode

Where cron is one of { cron, webcron, ajax }.

It's also possible to force it to be mixed, but I'm hesitant to suggest changing that since I'm not sure what's actually going on here and I still have yet to wrap my head around #41755, the migration path, what the expected behavior was here (other than obviously not breaking the ability to set the background mode).

kesselb commented 4 months ago

https://github.com/nextcloud/server/blob/00aa8f543841c6bfd853a3ac5cb4ff3ab0a058ae/cron.php#L109-L111

We are using the new IAppConfig api in cron.php. That means if cron.php was called once, and the backgroundjobs_mode was not already set to cron, it's then changed to cron AND type is set from 2 (mixed) to 4 (string).

When the value was typed once, it's not possible to set a new value without giving a type. Unfortunatly , the commands and provisioning_api are using the old IAppConfig api which uses type mixed.

Pull request for the commands: https://github.com/nextcloud/server/pull/46185

The provisioning_api also needs an update to use the types.

Needs some input from @ArtificialOwl.

kesselb commented 4 months ago

The provisioning_api also needs an update to use the types.

The final version should support all types, but the patch below made it work again.

Index: apps/provisioning_api/lib/Controller/AppConfigController.php
IDEA additional info:
Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP
<+>UTF-8
===================================================================
diff --git a/apps/provisioning_api/lib/Controller/AppConfigController.php b/apps/provisioning_api/lib/Controller/AppConfigController.php
--- a/apps/provisioning_api/lib/Controller/AppConfigController.php  (revision f6e95d3aec5eb3482891b7ebcd64d6676947d448)
+++ b/apps/provisioning_api/lib/Controller/AppConfigController.php  (date 1719519354804)
@@ -107,7 +107,7 @@
     * 200: Value updated successfully
     * 403: App or key is not allowed
     */
-   public function setValue(string $app, string $key, string $value): DataResponse {
+   public function setValue(string $app, string $key, string $value, int $type = IAppConfig::VALUE_MIXED): DataResponse {
        $user = $this->userSession->getUser();
        if ($user === null) {
            throw new \Exception("User is not logged in."); // Should not happen, since method is guarded by middleware
@@ -124,8 +124,13 @@
            return new DataResponse(['data' => ['message' => $e->getMessage()]], Http::STATUS_FORBIDDEN);
        }

-       /** @psalm-suppress InternalMethod */
-       $this->appConfig->setValueMixed($app, $key, $value);
+       if ($type === IAppConfig::VALUE_STRING) {
+           $this->appConfig->setValueString($app, $key, $value);
+       } else {
+           /** @psalm-suppress InternalMethod */
+           $this->appConfig->setValueMixed($app, $key, $value);
+       }
+
        return new DataResponse();
    }

Index: apps/settings/src/components/BasicSettings/BackgroundJob.vue
IDEA additional info:
Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP
<+>UTF-8
===================================================================
diff --git a/apps/settings/src/components/BasicSettings/BackgroundJob.vue b/apps/settings/src/components/BasicSettings/BackgroundJob.vue
--- a/apps/settings/src/components/BasicSettings/BackgroundJob.vue  (revision f6e95d3aec5eb3482891b7ebcd64d6676947d448)
+++ b/apps/settings/src/components/BasicSettings/BackgroundJob.vue  (date 1719519482717)
@@ -125,7 +125,7 @@
    },
    methods: {
        async onBackgroundJobModeChanged(backgroundJobsMode) {
-           const url = generateOcsUrl('/apps/provisioning_api/api/v1/config/apps/{appId}/{key}', {
+           const url = generateOcsUrl('/apps/provisioning_api/api/v1/config/apps/{appId}/{key}?type=4', {
                appId: 'core',
                key: 'backgroundjobs_mode',
            })

aronmgv commented 3 months ago

Hello,

I am using crazy-max's nextcloud image and was upgrading from 28.0.1 to 29.0.3 and am facing this database problem after performing the upgrade. Is it related please?

nextcloud.postgres  |
nextcloud.postgres  | PostgreSQL Database directory appears to contain a database; Skipping initialization
nextcloud.postgres  |
nextcloud.postgres  | 2024-07-27 20:31:25.050 UTC [1] LOG:  starting PostgreSQL 12.19 (Debian 12.19-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
nextcloud.postgres  | 2024-07-27 20:31:25.060 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
nextcloud.postgres  | 2024-07-27 20:31:25.060 UTC [1] LOG:  listening on IPv6 address "::", port 5432
nextcloud.postgres  | 2024-07-27 20:31:25.063 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
nextcloud.postgres  | 2024-07-27 20:31:25.070 UTC [26] LOG:  database system was shut down at 2024-07-27 11:14:09 UTC
nextcloud.postgres  | 2024-07-27 20:31:25.079 UTC [1] LOG:  database system is ready to accept connections
nextcloud.postgres  | 2024-07-27 20:31:25.983 UTC [34] ERROR:  column "type" does not exist at character 45
nextcloud.postgres  | 2024-07-27 20:31:25.983 UTC [34] STATEMENT:  SELECT "appid", "configkey", "configvalue", "type" FROM "appconfig" WHERE "lazy" = $1
nextcloud.postgres  | 2024-07-27 20:31:26.323 UTC [38] ERROR:  column "type" does not exist at character 45
nextcloud.postgres  | 2024-07-27 20:31:26.323 UTC [38] STATEMENT:  SELECT "appid", "configkey", "configvalue", "type" FROM "appconfig" WHERE "lazy" = $1
nextcloud.postgres  | 2024-07-27 20:31:26.332 UTC [39] ERROR:  column "type" does not exist at character 45
nextcloud.postgres  | 2024-07-27 20:31:26.332 UTC [39] STATEMENT:  SELECT "appid", "configkey", "configvalue", "type" FROM "appconfig" WHERE "lazy" = $1

If so how to use your workaround from above?

I tried and it did not work:

root@caradhras:[/docker/nextcloud]: docker-compose exec --user nextcloud nextcloud php occ config:app:set --value cron --type string core backgroundjobs_mode
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
You are about to set config value core/backgroundjobs_mode as STRING

This might break thing, affect performance on your instance or its security!
Confirm this action by typing 'yes': yes
done

In DbalException.php line 71:

  An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "type" of relation "appconfig" does not exist
  LINE 1: UPDATE "appconfig" SET "type" = $1 WHERE ("appid" = $2) AND ...
                                 ^

In ExceptionConverter.php line 68:

  An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "type" of relation "appconfig" does not exist
  LINE 1: UPDATE "appconfig" SET "type" = $1 WHERE ("appid" = $2) AND ...
                                 ^

In Exception.php line 28:

  SQLSTATE[42703]: Undefined column: 7 ERROR:  column "type" of relation "appconfig" does not exist
  LINE 1: UPDATE "appconfig" SET "type" = $1 WHERE ("appid" = $2) AND ...
                                 ^

In Statement.php line 130:

  SQLSTATE[42703]: Undefined column: 7 ERROR:  column "type" of relation "appconfig" does not exist
  LINE 1: UPDATE "appconfig" SET "type" = $1 WHERE ("appid" = $2) AND ...
                                 ^

config:app:set [--output [OUTPUT]] [--value VALUE] [--type TYPE] [--lazy|--no-lazy] [--sensitive|--no-sensitive] [--update-only] [--] <app> <name>

root@caradhras:[/docker/nextcloud]:

Thanks a lot!

kesselb commented 3 months ago

Is it related please?

Unrelated.

aronmgv commented 3 months ago

Is it related please?

Unrelated.

Should I create new issue then?

kesselb commented 3 months ago

Should I create new issue then?

Yes please

ariep commented 3 months ago

We're blocked by this from upgrading our fleet from 28 to 29: we have a provisioning script which does a php occ config:import ..., and the json file contains among many other settings

[...]
        "apps":{                                                                                                                                                                              
            "core":{                                                                                                                                                                          
                "backgroundjobs_mode": "webcron"
[...]

so this bug makes the provisioning fail.

Will this bug be fixed in the 29 series? I see that the MR has milestone set to 31, but as you can't skip major versions that would be unfortunate.

kesselb commented 3 months ago

@ariep

I don't think the pull request will address the problem with the config import command. Please leave a comment on the pull request, maybe that can be considered. Don't forget to also open a support ticket with Nextcloud if you have a support contract.

mkleger commented 2 months ago

I have the same problem when setting the background image via OCC and also via the WebUI with Nextcloud 30.0.0

EDIT: Tracking in #48436

kesselb commented 1 month ago

I'm pleasantly surprised to see the 18 people used the thumbs up reaction, thank you :pray:

It's definitely annoying that changing the background image is broken, sorry about that :disappointed:

Could some please log a fresh issue for the problem? It's a different component that needs a different fix than the background mode. It's perfectly fine to omit most of the issue template (e.g. we don't need the configuration report, logs, etc). Just the basic steps to reproduce, your Nextcloud version and a screenshot would be nice.

Thanks everyone :+1:

EDIT: Tracking in https://github.com/nextcloud/server/issues/48436

MajorTomDE commented 1 month ago

Same issue here

nextcloud / server