Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: Cannot enable any app from appstore #50252

Closed
5 of 8 tasks
sonnatager opened this issue Jan 18, 2025 · 2 comments
Closed
5 of 8 tasks

[Bug]: Cannot enable any app from appstore #50252

sonnatager opened this issue Jan 18, 2025 · 2 comments
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap bug

Comments

@sonnatager
Copy link

sonnatager commented Jan 18, 2025

⚠️ This issue respects the following points: ⚠️

Bug description

Whenever i try to download and enable any app from the app store i get an InvalidArgumentException:
Foreign key name "device_id" for table "oc_uppush_applications" collides with the constraint on table "oc_uppush_applications".

It seems to have to do with the UnifiedPush App. I have already tried to disable and remove the app and did a
occ maintenance:repair
but its still the same.

Expected behavior

Apps can be downloaded and enabled

Nextcloud Server version

30

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.2

Web server

Nginx

Database engine version

MySQL

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

Updated from a MINOR version (ex. 28.0.1 to 28.0.2)

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

  • Default user-backend (database)
  • LDAP/ Active Directory
  • SSO - SAML
  • Other

Configuration report

{
    "system": {
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": {
            "0": "localhost",
            "2": "***REMOVED SENSITIVE VALUE***"
        },
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "30.0.5.1",
        "hashingThreads": 6,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "filelocking.enabled": true,
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0
        },
        "overwrite.cli.url": "***REMOVED SENSITIVE VALUE***",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_smtpsecure": "ssl",
        "mail_sendmailmode": "smtp",
        "mail_smtpauthtype": "PLAIN",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "maintenance": false,
        "loglevel": 1,
        "theme": "",
        "default_phone_region": "***REMOVED SENSITIVE VALUE***",
        "maintenance_window_start": 1,
        "allow_local_remote_servers": true,
        "defaultapp": ""
    }
}

List of activated Apps

Enabled:
  - app_api: 4.0.5
  - bruteforcesettings: 3.0.0
  - calendar: 5.0.9
  - cfg_share_links: 6.1.1
  - cloud_federation_api: 1.13.0
  - contacts: 6.1.3
  - cospend: 3.0.8
  - dashboard: 7.10.0
  - dav: 1.31.1
  - federatedfilesharing: 1.20.0
  - files: 2.2.0
  - files_downloadlimit: 3.0.0
  - files_pdfviewer: 3.0.0
  - files_reminders: 1.3.0
  - files_sharing: 1.22.0
  - files_trashbin: 1.20.1
  - files_versions: 1.23.0
  - groupfolders: 18.0.8
  - logreader: 3.0.0
  - lookup_server_connector: 1.18.0
  - notifications: 3.0.0
  - oauth2: 1.18.1
  - polls: 7.2.9
  - privacy: 2.0.0
  - provisioning_api: 1.20.0
  - related_resources: 1.5.0
  - serverinfo: 2.0.0
  - settings: 1.13.0
  - text: 4.1.0
  - theming: 2.5.0
  - theming_customcss: 1.18.0
  - twofactor_backupcodes: 1.19.0
  - twofactor_totp: 12.0.0-dev
  - updatenotification: 1.20.0
  - uppush: 2.1.2
  - viewer: 3.0.0
  - webhook_listeners: 1.1.0-dev
  - workflowengine: 2.12.0
Disabled:
  - activity: 3.0.0 (installed 2.21.1)
  - admin_audit: 1.20.0
  - circles: 30.0.0 (installed 29.0.0-dev)
  - comments: 1.20.1 (installed 1.19.0)
  - contactsinteraction: 1.11.0 (installed 1.10.0)
  - cookbook: 0.11.2
  - encryption: 2.18.0
  - federation: 1.20.0 (installed 1.19.0)
  - files_external: 1.22.0
  - firstrunwizard: 3.0.0 (installed 3.0.0)
  - nextcloud_announcements: 2.0.0 (installed 1.18.0)
  - password_policy: 2.0.0 (installed 1.19.0)
  - photos: 3.0.2 (installed 3.0.2)
  - recommendations: 3.0.0 (installed 2.1.0)
  - secrets: 2.1.2
  - sharebymail: 1.20.0 (installed 1.19.0)
  - support: 2.0.0 (installed 1.12.0)
  - survey_client: 2.0.0 (installed 1.17.0)
  - suspicious_login: 8.0.0
  - systemtags: 1.20.0 (installed 1.19.0)
  - twofactor_nextcloud_notification: 4.0.0
  - user_ldap: 1.21.0
  - user_status: 1.10.0 (installed 1.9.0)
  - weather_status: 1.10.0 (installed 1.9.0)

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

{"reqId":"2PjvepPb6hl4lkIHksXR","level":3,"time":"2025-01-18T08:13:54+00:00","remoteAddr":"***REMOVED SENSITIVE VALUE***","user":"admin","app":"settings","method":"POST","url":"/settings/apps/enable","message":"could not enable apps","userAgent":"Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36","version":"30.0.5.1","exception":{"Exception":"InvalidArgumentException","Message":"Foreign key name \"device_id\" for table \"oc_uppush_applications\" collides with the constraint on table \"oc_uppush_applications\".","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/private/DB/MigrationService.php","line":429,"function":"ensureUniqueNamesConstraints","class":"OC\\DB\\MigrationService","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/MigrationService.php","line":387,"function":"migrateSchemaOnly","class":"OC\\DB\\MigrationService","type":"->"},{"file":"/var/www/nextcloud/lib/private/Installer.php","line":105,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->"},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php","line":528,"function":"installApp","class":"OC\\Installer","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":208,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1003,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":24,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/lib/private/DB/MigrationService.php","Line":687,"message":"could not enable apps","exception":[],"CustomMessage":"could not enable apps"},"id":"678b6d962f976"}

Additional info

No response

@sonnatager sonnatager added 0. Needs triage Pending check for reproducibility or if it fits our roadmap bug labels Jan 18, 2025
@solracsf
Copy link
Member

Seems related to Uppush app; You must report this to https://codeberg.org/NextPush/uppush/issues

@joshtrichards
Copy link
Member

Indeed. Looks like they have a couple open related issues over in their repo they're actively working on (including a merged PR that appears related but isn't yet released in a new version of their app). @sonnatager I suggest you read through their other recent open Issues to find a solution. Nothing we can do here.

@joshtrichards joshtrichards closed this as not planned Won't fix, can't repro, duplicate, stale Jan 18, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap bug
Projects
None yet
Development

No branches or pull requests

3 participants