nextcloud / polls

🗳️ Polls app for Nextcloud
https://apps.nextcloud.com/apps/polls
GNU Affero General Public License v3.0
254 stars 73 forks source link

After update to NC 26: Opening poll details leads to 404 Poll not found #2833

Closed jacotec closed 1 year ago

jacotec commented 1 year ago

⚠️ This issue respects the following points: ⚠️

What went wrong, what did you observe?

I've updated my Nextcloud from 25.0.5 to 26.0.0, Polls was updates to 5.0.0-beta5 with the NC update. After the update I can't access any polls, the detail view of the poll is visible very shortly, but then the screen changes to "404 - Poll not found".

Browser console throws a 500 internal server error:

       GET https://mydomain.de/apps/polls/preferences?time=1679948422899 500 (Internal Server Error)
(anonym) @ xhr.js:220
e.exports @ xhr.js:16
e.exports @ dispatchRequest.js:56
d.request @ Axios.js:109
(anonym) @ bind.js:9
getUserSettings @ userSettings.js:27
(anonym) @ settings.js:125
d @ settings.js:2
(anonym) @ settings.js:2
(anonym) @ settings.js:2
u @ settings.js:2
o @ settings.js:2
(anonym) @ settings.js:2
(anonym) @ settings.js:2
get @ settings.js:123
(anonym) @ vuex.esm.js:851
h.dispatch @ vuex.esm.js:516
dispatch @ vuex.esm.js:406
created @ App.vue:101
bn @ vue.runtime.esm.js:3017
hr @ vue.runtime.esm.js:4031
e._init @ vue.runtime.esm.js:5693
o @ vue.runtime.esm.js:5826
(anonym) @ vue.runtime.esm.js:4544
init @ vue.runtime.esm.js:4406
(anonym) @ vue.runtime.esm.js:6567
f @ vue.runtime.esm.js:6521
$i.nodeOps @ vue.runtime.esm.js:7109
e._update @ vue.runtime.esm.js:3765
r @ vue.runtime.esm.js:3875
e.get @ vue.runtime.esm.js:3446
e @ vue.runtime.esm.js:3436
e @ vue.runtime.esm.js:3892
ia.$mount @ vue.runtime.esm.js:8772
e._init @ vue.runtime.esm.js:5701
ia @ vue.runtime.esm.js:5762
(anonym) @ main.js:59
(anonym) @ main.js:63
(anonym) @ main.js:63
vuex.esm.js:542 

       Uncaught (in promise) a {message: 'Request failed with status code 500', name: 'AxiosError', code: 'ERR_BAD_RESPONSE', config: {…}, request: XMLHttpRequest, …}
(anonym) @ vuex.esm.js:542
Promise.then (asynchron)
(anonym) @ vuex.esm.js:519
h.dispatch @ vuex.esm.js:518
dispatch @ vuex.esm.js:406
created @ App.vue:101
bn @ vue.runtime.esm.js:3017
hr @ vue.runtime.esm.js:4031
e._init @ vue.runtime.esm.js:5693
o @ vue.runtime.esm.js:5826
(anonym) @ vue.runtime.esm.js:4544
init @ vue.runtime.esm.js:4406
(anonym) @ vue.runtime.esm.js:6567
f @ vue.runtime.esm.js:6521
$i.nodeOps @ vue.runtime.esm.js:7109
e._update @ vue.runtime.esm.js:3765
r @ vue.runtime.esm.js:3875
e.get @ vue.runtime.esm.js:3446
e @ vue.runtime.esm.js:3436
e @ vue.runtime.esm.js:3892
ia.$mount @ vue.runtime.esm.js:8772
e._init @ vue.runtime.esm.js:5701
ia @ vue.runtime.esm.js:5762
(anonym) @ main.js:59
(anonym) @ main.js:63
(anonym) @ main.js:63
index.es.js:2337 

What did you expect, how polls should behave instead?

I should be able to view my poll.

What steps does it need to replay this bug?

  1. Updated NC to 26.0.0
  2. Open a poll
  3. See the issue

Installation method

Installed/updated from the appstore (Apps section of your site)

Installation type

Updated from previous major version (i.e. 3.x.x to 4.x.x)

Affected polls version

5.0.0-beta 5

Which browser did you use, when experiencing the bug?

Other browser

No response

Which System did you use, when experiencing the bug?

Other OS

No response

Add your browser log here

init-collections.js:42 

       OCA.Sharing.ShareSearch not ready
(anonym) @ init-collections.js:42
xhr.js:220 

       GET https://mydomain.de/apps/polls/preferences?time=1679948422899 500 (Internal Server Error)
(anonym) @ xhr.js:220
e.exports @ xhr.js:16
e.exports @ dispatchRequest.js:56
d.request @ Axios.js:109
(anonym) @ bind.js:9
getUserSettings @ userSettings.js:27
(anonym) @ settings.js:125
d @ settings.js:2
(anonym) @ settings.js:2
(anonym) @ settings.js:2
u @ settings.js:2
o @ settings.js:2
(anonym) @ settings.js:2
(anonym) @ settings.js:2
get @ settings.js:123
(anonym) @ vuex.esm.js:851
h.dispatch @ vuex.esm.js:516
dispatch @ vuex.esm.js:406
created @ App.vue:101
bn @ vue.runtime.esm.js:3017
hr @ vue.runtime.esm.js:4031
e._init @ vue.runtime.esm.js:5693
o @ vue.runtime.esm.js:5826
(anonym) @ vue.runtime.esm.js:4544
init @ vue.runtime.esm.js:4406
(anonym) @ vue.runtime.esm.js:6567
f @ vue.runtime.esm.js:6521
$i.nodeOps @ vue.runtime.esm.js:7109
e._update @ vue.runtime.esm.js:3765
r @ vue.runtime.esm.js:3875
e.get @ vue.runtime.esm.js:3446
e @ vue.runtime.esm.js:3436
e @ vue.runtime.esm.js:3892
ia.$mount @ vue.runtime.esm.js:8772
e._init @ vue.runtime.esm.js:5701
ia @ vue.runtime.esm.js:5762
(anonym) @ main.js:59
(anonym) @ main.js:63
(anonym) @ main.js:63
vuex.esm.js:542 

       Uncaught (in promise) a {message: 'Request failed with status code 500', name: 'AxiosError', code: 'ERR_BAD_RESPONSE', config: {…}, request: XMLHttpRequest, …}

Additional client environment information

No response

NC version

Nextcloud 26 (Nextcloud Hub 4)

Other Nextcloud version

No response

PHP engine version

PHP 8.0

Other PHP version

No response

Database engine

MariaDB

Database Engine version or other Database

10.6.12

Which user-backends are you using?

Add your nextcloud server log here

[index] Fehler: TypeError: Cannot assign null to property OCA\Polls\Db\Preferences::$preferences of type string at <<closure>>

 0. /var/www/nextcloud/lib/public/AppFramework/Db/Entity.php line 167
    OCP\AppFramework\Db\Entity->setter()
 1. /var/www/nextcloud/lib/public/AppFramework/Db/Entity.php line 75
    OCP\AppFramework\Db\Entity->__call()
 2. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 321
    OCP\AppFramework\Db\Entity::fromRow()
 3. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 361
    OCP\AppFramework\Db\QBMapper->mapRowToEntity()
 4. /var/www/nextcloud/apps/polls/lib/Db/PreferencesMapper.php line 57
    OCP\AppFramework\Db\QBMapper->findEntity()
 5. /var/www/nextcloud/apps/polls/lib/Service/PreferencesService.php line 47
    OCA\Polls\Db\PreferencesMapper->find()
 6. /var/www/nextcloud/apps/polls/lib/Service/PreferencesService.php line 42
    OCA\Polls\Service\PreferencesService->load()
 7. <<closure>>
    OCA\Polls\Service\PreferencesService->__construct()
 8. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 116
    ReflectionClass->newInstanceArgs()
 9. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 124
    OC\AppFramework\Utility\SimpleContainer->buildClass()
10. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 142
    OC\AppFramework\Utility\SimpleContainer->resolve()
11. /var/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php line 493
    OC\AppFramework\Utility\SimpleContainer->query()
12. /var/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php line 465
    OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback()
13. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 97
    OC\AppFramework\DependencyInjection\DIContainer->query()
14. <<closure>>
    OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}("*** sensitive parameters replaced ***")
15. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 116
    array_map()
16. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 124
    OC\AppFramework\Utility\SimpleContainer->buildClass()
17. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 142
    OC\AppFramework\Utility\SimpleContainer->resolve()
18. /var/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php line 493
    OC\AppFramework\Utility\SimpleContainer->query()
19. /var/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php line 465
    OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback()
20. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 97
    OC\AppFramework\DependencyInjection\DIContainer->query()
21. <<closure>>
    OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}("*** sensitive parameters replaced ***")
22. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 116
    array_map()
23. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 124
    OC\AppFramework\Utility\SimpleContainer->buildClass()
24. /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php line 142
    OC\AppFramework\Utility\SimpleContainer->resolve()
25. /var/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php line 493
    OC\AppFramework\Utility\SimpleContainer->query()
26. /var/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php line 465
    OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback()
27. /var/www/nextcloud/lib/private/AppFramework/App.php line 162
    OC\AppFramework\DependencyInjection\DIContainer->query()
28. /var/www/nextcloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
29. /var/www/nextcloud/lib/base.php line 1055
    OC\Route\Router->match()
30. /var/www/nextcloud/index.php line 36
    OC::handleRequest()

GET /apps/polls/poll/13/options?time=1679948760164
from 10.0.2.2 by marco at 2023-03-27T22:26:02+02:00

Additional environment informations

No response

Configuration report

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "10.0.1.6",
            "*****.de"
        ],
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "forwarded_for_headers": [
            "HTTP_X_FORWARDED_FOR",
            "HTTP_FORWARDED_FOR"
        ],
        "overwrite.cli.url": "https:\/\/*****.de",
        "overwriteprotocol": "https",
        "allow_local_remote_servers": true,
        "htaccess.RewriteBase": "\/",
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "26.0.0.11",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "maintenance": false,
        "enable_avatars": true,
        "filesystem_check_changes": 1,
        "theme": "",
        "default_language": "de",
        "default_locale": "de_DE",
        "default_phone_region": "DE",
        "defaultapp": "files",
        "skeletondirectory": "\/var\/www\/skeleton",
        "share_folder": "\/Shared",
        "log_type": "file",
        "logfile": "\/var\/log\/nextcloud\/nextcloud.log",
        "loglevel": 2,
        "mail_smtpmode": "smtp",
        "remember_login_cookie_lifetime": 2592000,
        "session_lifetime": 604800,
        "session_keepalive": true,
        "log_rotate_size": "10485760",
        "trashbin_retention_obligation": "30, 60",
        "versions_retention_obligation": "auto, 365",
        "check_for_working_webdav": true,
        "simpleSignUpLink.shown": false,
        "auth.webauthn.enabled": false,
        "music.lastfm_api_key": "2897d80221740bce55bd257a138705d1",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "filelocking.enabled": true,
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "timeout": 0.5,
            "dbindex": 0
        },
        "logtimezone": "Europe\/Berlin",
        "preview_libreoffice_path": "\/usr\/bin\/libreoffice",
        "enable_previews": true,
        "enabledPreviewProviders": [
            "OC\\Preview\\PNG",
            "OC\\Preview\\JPEG",
            "OC\\Preview\\GIF",
            "OC\\Preview\\BMP",
            "OC\\Preview\\MarkDown",
            "OC\\Preview\\MP3",
            "OC\\Preview\\TXT",
            "OC\\Preview\\Movie",
            "OC\\Preview\\Photoshop",
            "OC\\Preview\\SVG",
            "OC\\Preview\\TIFF",
            "OC\\Preview\\HEIC",
            "OC\\Preview\\MKV",
            "OC\\Preview\\MOV",
            "OC\\Preview\\MP4",
            "OC\\Preview\\AVI",
            "OC\\Preview\\PDF",
            "OC\\Preview\\OpenDocument",
            "OC\\Preview\\MSOffice2003",
            "OC\\Preview\\MSOffice2007",
            "OC\\Preview\\MSOfficeDoc",
            "OC\\Preview\\Image",
            "OC\\Preview\\PPT",
            "OC\\Preview\\PPTX"
        ],
        "preview_max_x": "2048",
        "preview_max_y": "2048",
        "jpeg_quality": "60",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_sendmailmode": "smtp",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "ldapIgnoreNamingRules": false,
        "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory",
        "ldapUserCleanupInterval": 51,
        "app_install_overwrite": [
            "files_external_dropbox",
            "bookmarks_fulltextsearch",
            "files_inotify",
            "files_fulltextsearch_tesseract",
            "previewgenerator",
            "quickaccesssorting",
            "bbb",
            "fulltextsearch",
            "fulltextsearch_elasticsearch",
            "files_fulltextsearch",
            "socialsharing_email",
            "extract",
            "drawio",
            "quicknotes",
            "video_converter",
            "oidc_login",
            "facerecognition",
            "files_linkeditor",
            "metadata",
            "cfg_share_links"
        ],
        "updater.release.channel": "stable",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpsecure": "tls",
        "mail_smtpauthtype": "LOGIN",
        "oidc_login_provider_url": "https:\/\/****.de\/realms\/cloud",
        "oidc_login_client_id": "*******",
        "oidc_login_client_secret": "wAHp73Wj5veVPHOGxwFBT17ek8EE2VhS",
        "oidc_login_end_session_redirect": true,
        "oidc_login_logout_url": "https:\/\/****.de\/apps\/oidc_login\/oidc",
        "oidc_login_auto_redirect": false,
        "oidc_login_hide_password_form": false,
        "oidc_login_attributes": {
            "id": "preferred_username",
            "name": "name",
            "mail": "email",
            "quota": "nextcloudquota",
            "groups": "groups"
        },
        "oidc_login_scope": "openid profile",
        "oidc_login_disable_registration": false,
        "oidc_login_redir_fallback": true,
        "oidc_login_password_authentication": true,
        "oidc_login_button_text": "Mit ***** Cloud anmelden",
        "memories.exiftool": "\/var\/www\/nextcloud\/apps\/memories\/lib\/..\/exiftool-bin\/exiftool-amd64-glibc",
        "memories.transcoder": "\/var\/www\/nextcloud\/apps\/memories\/exiftool-bin\/go-vod-amd64",
        "memories.no_transcode": false,
        "memories.qsv": false,
        "memories.ffmpeg_path": "\/usr\/bin\/ffmpeg",
        "memories.ffprobe_path": "\/usr\/bin\/ffprobe",
        "memories.tmp_path": "\/tmp\/memories_cache",
        "memories.gis_type": 1
    }
}

List of activated Apps

Enabled:
  - activity: 2.18.0
  - admin_audit: 1.16.0
  - appointments: 1.14.13
  - bbb: 2.4.0
  - bookmarks: 13.0.1
  - bruteforcesettings: 2.6.0
  - calendar: 4.3.1
  - camerarawpreviews: 0.8.1
  - cfg_share_links: 3.0.2
  - circles: 26.0.0
  - cloud_federation_api: 1.9.0
  - comments: 1.16.0
  - contacts: 5.2.0
  - contactsinteraction: 1.7.0
  - dashboard: 7.6.0
  - dav: 1.25.0
  - deck: 1.9.0
  - drawio: 2.1.0
  - extract: 1.3.5
  - federatedfilesharing: 1.16.0
  - federation: 1.16.0
  - files: 1.21.1
  - files_accesscontrol: 1.16.0
  - files_automatedtagging: 1.16.1
  - files_downloadactivity: 1.16.0
  - files_external: 1.18.0
  - files_fulltextsearch: 25.0.0
  - files_fulltextsearch_tesseract: 25.0.0
  - files_inotify: 0.1.14
  - files_linkeditor: 1.1.13
  - files_pdfviewer: 2.7.0
  - files_retention: 1.15.0
  - files_rightclick: 1.5.0
  - files_sharing: 1.18.0
  - files_trashbin: 1.16.0
  - files_versions: 1.19.1
  - firstrunwizard: 2.15.0
  - forms: 3.2.0
  - fulltextsearch: 25.0.0
  - fulltextsearch_elasticsearch: 25.0.0
  - groupfolders: 14.0.0
  - guests: 2.3.0
  - logreader: 2.11.0
  - lookup_server_connector: 1.14.0
  - maps: 1.0.2
  - memories: 4.12.5
  - metadata: 0.17.0
  - news: 21.2.0-beta1
  - nextcloud_announcements: 1.15.0
  - notes: 4.7.2
  - notifications: 2.14.0
  - notify_push: 0.6.0
  - oauth2: 1.14.0
  - oidc_login: 2.5.0
  - photos: 2.2.0
  - polls: 5.0.0-beta5
  - previewgenerator: 5.2.1
  - privacy: 1.10.0
  - provisioning_api: 1.16.0
  - qownnotesapi: 23.3.0
  - quickaccesssorting: 1.1.4
  - quicknotes: 0.8.5
  - quota_warning: 1.16.0
  - recommendations: 1.5.0
  - richdocuments: 8.0.0
  - serverinfo: 1.16.0
  - settings: 1.8.0
  - sharebymail: 1.16.0
  - side_menu: 3.7.2
  - socialsharing_email: 2.5.0
  - spreed: 16.0.1
  - support: 1.9.0
  - survey_client: 1.14.0
  - systemtags: 1.16.0
  - tasks: 0.14.5
  - text: 3.7.2
  - theming: 2.1.1
  - twofactor_backupcodes: 1.15.0
  - twofactor_totp: 8.0.0-alpha.0
  - updatenotification: 1.16.0
  - user_ldap: 1.16.0
  - user_status: 1.6.0
  - video_converter: 1.0.5
  - viewer: 1.10.0
  - weather_status: 1.6.0
  - workflow_pdf_converter: 1.11.0
  - workflowengine: 2.8.0
Disabled:
  - audioplayer: 3.3.1 (installed 3.3.1)
  - encryption: 2.14.0
  - facerecognition: 0.9.12 (installed 0.9.12)
  - music: 1.8.1 (installed 1.8.1)
  - ncdownloader: 1.0.2 (installed 1.0.2)
  - ocdownloader: 1.9.1 (installed 1.8.1)
  - password_policy: 1.16.0 (installed 1.15.0)
  - ransomware_protection: 1.14.0 (installed 1.14.0)
  - related_resources: 1.1.0-alpha1 (installed 1.1.0-alpha1)
  - suspicious_login: 4.4.0
  - talk_matterbridge: 1.26.0-0 (installed 1.26.0-0)
  - workflow_script: 1.11.1 (installed 1.11.1)

Nextcloud Signing status

No errors have been found.

Additional Information

Strangely my wife can access her polls. Not sure if this is related to admin role? Even a creation of a new poll immediately ends up in the 404 once the detail view should be shown.

dartcafe commented 1 year ago

Fixed in beta 6 and rc1. See #2819

github-actions[bot] commented 3 months ago

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.