Skip to content

404 when accessing a poll as logged on unser #4877

Closed
Bug
#4968
Closed
404 when accessing a poll as logged on unser#4877
Bug
#4968
Milestone
9.2.0

Description

@christianwicke
christianwicke
opened on Jul 22, 2026

⚠️ This issue respects the following points: ⚠️

  • This is a bug, not a question or a configuration/webserver/proxy issue.
  • This issue is not already reported on Github (I've searched it).
  • I agree to follow Nextcloud's Code of Conduct.

What went wrong, what did you observe?

I created a public poll with one nextcloud user. I logged in with a second nextcloud user.
Then I clicked on the public poll link.
I got redirected to to internal poll URL (https://{site}/index.php/apps/polls/vote/{pollid}).
I could access the poll without typing in my name (it used my nextcloud name).

But this only worked for the first time!
Whenever I click on the public poll link again, I get redirected to https://{site}/index.php/apps/polls/not-found . The same happens if I try to use the internal link.

There is another strange thing: When I click on Polls->Openly accessible polls, the poll appears twice. Maybe it has to do with this bug.

What did you expect, how polls should behave instead?

I expect to be able to use the public poll URL as often as I want to

What steps does it need to replay this bug?

  1. create poll with user 1
  2. create public link
  3. log off with user 1, log in with user 2
  4. click on public link
  5. navigate to some other web site
  6. click on the public link again

Affected polls version

9.1.4

Installation method

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

Installation type

First time installation

Can you rule out that any extension you use is involved in the issue?

  • I have checked all browser extension

Which browser did you use, when experiencing the bug?

  • Firefox
  • Chrome
  • Chromium/Chromium based (i.e. Edge)
  • Safari
  • Other/Don't know

Other browser

No response

Add your browser log here

[ERROR] polls: Could not load context  Object { app: "polls", uid: "christian", level: 0, error: AxiosError } index-BkSMASYT.chunk.mjs:67:807
[DEBUG] polls: Loading session Object { app: "polls", uid: "christian", level: 0 } index-BkSMASYT.chunk.mjs:67:603
[DEBUG] polls: Session loaded Object { app: "polls", uid: "christian", level: 0 } index-BkSMASYT.chunk.mjs:67:603
[INFO] polls: Context loaded Object { app: "polls", uid: "christian", level: 0 } index-BkSMASYT.chunk.mjs:67:672

Additional client environment information

No response

NC version

Other/Don't know

Other Nextcloud version

Nextcloud 34 (26 Spring)

PHP engine version

PHP 8.5

Other PHP version

No response

Database engine

PostgreSQL

Database Engine version or other Database

Postgres 18

Which user-backends are you using?

  • Default user-backend (database)
  • LDAP/ Active Directory
  • SSO - SAML
  • Other/Don't know

Add your nextcloud server log here

{"reqId":"91lTOuCqBYKNgV2e0iWu","level":1,"time":"2026-07-22T09:42:47+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/christian/","scriptName":"/remote.php","message":"The app config key dav/enableCalendarFederation is not defined in the config lexicon","userAgent":"Mozilla/5.0 (Linux) mirall/3.16.7-1~deb13u1 (Debian built) (Nextcloud, debian-6.16.0 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"34.0.1.2","clientReqId":"35391f1f-34cd-4d77-bb53-8d4db1680831","data":[]}
{"reqId":"91lTOuCqBYKNgV2e0iWu","level":1,"time":"2026-07-22T09:42:47+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/christian/","scriptName":"/remote.php","message":"The app config key dav/sendInvitations is not defined in the config lexicon","userAgent":"Mozilla/5.0 (Linux) mirall/3.16.7-1~deb13u1 (Debian built) (Nextcloud, debian-6.16.0 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"34.0.1.2","clientReqId":"35391f1f-34cd-4d77-bb53-8d4db1680831","data":[]}
{"reqId":"axa0MgOoun6MAQMY4jqB","level":1,"time":"2026-07-22T09:42:54+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/christian/","scriptName":"/remote.php","message":"The app config key dav/enableCalendarFederation is not defined in the config lexicon","userAgent":"Mozilla/5.0 (Linux) mirall/3.16.7-1~deb13u1 (Debian built) (Nextcloud, debian-6.16.0 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"34.0.1.2","clientReqId":"ed010a1a-d938-4e49-818c-068a6dbeb673","data":[]}
{"reqId":"axa0MgOoun6MAQMY4jqB","level":1,"time":"2026-07-22T09:42:54+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/christian/","scriptName":"/remote.php","message":"The app config key dav/sendInvitations is not defined in the config lexicon","userAgent":"Mozilla/5.0 (Linux) mirall/3.16.7-1~deb13u1 (Debian built) (Nextcloud, debian-6.16.0 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"34.0.1.2","clientReqId":"ed010a1a-d938-4e49-818c-068a6dbeb673","data":[]}
{"reqId":"MAULvV1Z8bZDiTo3hAm6","level":1,"time":"2026-07-22T09:42:56+00:00","remoteAddr":"79.223.165.65","user":"--","app":"no app in context","method":"GET","url":"/index.php/login","scriptName":"/index.php","message":"The app config key dav/hide_absence_settings is not defined in the config lexicon","userAgent":"Uptime-Kuma/2.4.0","version":"34.0.1.2","data":[]}
{"reqId":"cYI3weAKA7uJv5MJiRU4","level":1,"time":"2026-07-22T09:42:57+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/christian/","scriptName":"/remote.php","message":"The app config key dav/enableCalendarFederation is not defined in the config lexicon","userAgent":"Mozilla/5.0 (Linux) mirall/3.16.7-1~deb13u1 (Debian built) (Nextcloud, debian-6.16.0 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"34.0.1.2","clientReqId":"d364ae9c-6b13-4ca4-b802-38ddf17708ac","data":[]}
{"reqId":"cYI3weAKA7uJv5MJiRU4","level":1,"time":"2026-07-22T09:42:57+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/christian/","scriptName":"/remote.php","message":"The app config key dav/sendInvitations is not defined in the config lexicon","userAgent":"Mozilla/5.0 (Linux) mirall/3.16.7-1~deb13u1 (Debian built) (Nextcloud, debian-6.16.0 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"34.0.1.2","clientReqId":"d364ae9c-6b13-4ca4-b802-38ddf17708ac","data":[]}
{"reqId":"LpG27MZIteg2vn8JwHi5","level":0,"time":"2026-07-22T09:42:59+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"dav","method":"PUT","url":"/ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json","scriptName":"/ocs/v2.php","message":"No calendar events found for status check","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"dav","user":"christian"}}
{"reqId":"bw4ImVmUktS1MpvlF6I0","level":1,"time":"2026-07-22T09:43:01+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/christian/","scriptName":"/remote.php","message":"The app config key dav/enableCalendarFederation is not defined in the config lexicon","userAgent":"Mozilla/5.0 (Linux) mirall/3.16.7-1~deb13u1 (Debian built) (Nextcloud, debian-6.16.0 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"34.0.1.2","clientReqId":"d31c5112-a6bf-4859-b46e-2681b823d588","data":[]}
{"reqId":"bw4ImVmUktS1MpvlF6I0","level":1,"time":"2026-07-22T09:43:01+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/christian/","scriptName":"/remote.php","message":"The app config key dav/sendInvitations is not defined in the config lexicon","userAgent":"Mozilla/5.0 (Linux) mirall/3.16.7-1~deb13u1 (Debian built) (Nextcloud, debian-6.16.0 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"34.0.1.2","clientReqId":"d31c5112-a6bf-4859-b46e-2681b823d588","data":[]}
{"reqId":"dr2Q1OcCkoz52xQwQcbM","level":0,"time":"2026-07-22T09:43:09+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"no app in context","method":"POST","url":"/index.php/apps/text/session/117269/sync","scriptName":"/index.php","message":"dirty table reads: SELECT `id`, `color`, `document_id`, `last_awareness_message`, `last_contact`, `user_id`, `guest_name` FROM `*PREFIX*text_sessions` WHERE `document_id` = :dcValue1","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id`, `color`, `document_id`, `last_awareness_message`, `last_contact`, `user_id`, `guest_name` FROM `*PREFIX*text_sessions` WHERE `document_id` = :dcValue1","Code":0,"Trace":[{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":57,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `id`, `color`, `document_id`, `last_awareness_message`, `last_contact`, `user_id`, `guest_name` FROM `*PREFIX*text_sessions` WHERE `document_id` = :dcValue1",{"dcValue1":117269},{"dcValue1":2}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":261,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["SELECT `id`, `color`, `document_id`, `last_awareness_message`, `last_contact`, `user_id`, `guest_name` FROM `*PREFIX*text_sessions` WHERE `document_id` = :dcValue1",{"dcValue1":117269},{"dcValue1":2}]},{"file":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","line":336,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/text/lib/Db/SessionMapper.php","line":69,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/var/www/html/apps/text/lib/Service/SessionService.php","line":98,"function":"findAll","class":"OCA\\Text\\Db\\SessionMapper","type":"->","args":[117269]},{"file":"/var/www/html/apps/text/lib/Service/ApiService.php","line":213,"function":"getAllSessions","class":"OCA\\Text\\Service\\SessionService","type":"->","args":[117269]},{"file":"/var/www/html/apps/text/lib/Controller/SessionController.php","line":75,"function":"sync","class":"OCA\\Text\\Service\\ApiService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":165,"function":"sync","class":"OCA\\Text\\Controller\\SessionController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":78,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Text\\Controller\\SessionController"},"sync"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":137,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Text\\Controller\\SessionController"},"sync"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":324,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Text\\Controller\\SessionController","sync",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"documentId":"117269","_route":"text.session.sync"}]},{"file":"/var/www/html/lib/base.php","line":1159,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/text/session/117269/sync"]},{"file":"/var/www/html/index.php","line":25,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":407,"message":"dirty table reads: SELECT `id`, `color`, `document_id`, `last_awareness_message`, `last_contact`, `user_id`, `guest_name` FROM `*PREFIX*text_sessions` WHERE `document_id` = :dcValue1","tables":"[\"oc_text_sessions\"]","reads":"[\"oc_text_sessions\"]","exception":"{\"class\":\"Exception\",\"message\":\"dirty table reads: SELECT `id`, `color`, `document_id`, `last_awareness_message`, `last_contact`, `user_id`, `guest_name` FROM `*PREFIX*text_sessions` WHERE `document_id` = :dcValue1\",\"code\":0,\"file\":\"/var/www/html/lib/private/DB/Connection.php:407\",\"trace\":\"#0 /var/www/html/lib/private/DB/ConnectionAdapter.php(57): OC\\DB\\Connection->executeQuery('SELECT `id`, `c...', Array, Array)\\n#1 /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php(261): OC\\DB\\ConnectionAdapter->executeQuery('SELECT `id`, `c...', Array, Array)\\n#2 /var/www/html/lib/public/AppFramework/Db/QBMapper.php(336): OC\\DB\\QueryBuilder\\QueryBuilder->executeQuery()\\n#3 /var/www/html/apps/text/lib/Db/SessionMapper.php(69): OCP\\AppFramework\\Db\\QBMapper->findEntities(Object(OC\\DB\\QueryBuilder\\QueryBuilder))\\n#4 /var/www/html/apps/text/lib/Service/SessionService.php(98): OCA\\Text\\Db\\SessionMapper->findAll(117269)\\n#5 /var/www/html/apps/text/lib/Service/ApiService.php(213): OCA\\Text\\Service\\SessionService->getAllSessions(117269)\\n#6 /var/www/html/apps/text/lib/Controller/SessionController.php(75): OCA\\Text\\Service\\ApiService->sync(Object(OCA\\Text\\Db\\Session), Object(OCA\\Text\\Db\\Document), 58)\\n#7 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(165): OCA\\Text\\Controller\\SessionController->sync(58)\\n#8 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(78): OC\\AppFramework\\Http\\Dispatcher->executeController(Object(OCA\\Text\\Controller\\SessionController), 'sync')\\n#9 /var/www/html/lib/private/AppFramework/App.php(137): OC\\AppFramework\\Http\\Dispatcher->dispatch(Object(OCA\\Text\\Controller\\SessionController), 'sync')\\n#10 /var/www/html/lib/private/Route/Router.php(324): OC\\AppFramework\\App::main('OCA\\\\Text\\\\Contro...', 'sync', Object(OC\\AppFramework\\DependencyInjection\\DIContainer), Array)\\n#11 /var/www/html/lib/base.php(1159): OC\\Route\\Router->match('/apps/text/sess...')\\n#12 /var/www/html/index.php(25): OC::handleRequest()\\n#13 {main}\"}","CustomMessage":"dirty table reads: SELECT `id`, `color`, `document_id`, `last_awareness_message`, `last_contact`, `user_id`, `guest_name` FROM `*PREFIX*text_sessions` WHERE `document_id` = :dcValue1"}}
{"reqId":"8Q3VSNsKyWZSxv90JzcE","level":1,"time":"2026-07-22T09:43:11+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"no app in context","method":"GET","url":"/index.php/apps/polls/s/byS8Hnqx","scriptName":"/index.php","message":"The app config key dav/hide_absence_settings is not defined in the config lexicon","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":[]}
{"reqId":"qDFXZzOmJ8c5Cm4pQETN","level":3,"time":"2026-07-22T09:43:12+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"index","method":"GET","url":"/index.php/apps/polls/s/byS8Hnqx/session?time=1784713392530","scriptName":"/index.php","message":"Did not expect more than one result when executing: query \"SELECT `polls_polls`.*, (SELECT MAX(`options`.`timestamp`) FROM `*PREFIX*polls_options` `options` WHERE (`options`.`poll_id` = `polls_polls`.`id`) AND (`options`.`deleted` = '0')) AS `max_date`, coalesce(user_shares.type, '') AS user_role, `user_shares`.`locked` AS `is_current_user_locked`, coalesce(user_shares.token, '') AS share_token, string_agg(distinct group_shares.user_id::varchar, ',') AS group_shares, string_agg(distinct poll_groups.group_id::varchar, ',') AS poll_groups, string_agg(distinct poll_group_shares.type::varchar, ',') AS poll_group_user_shares, COUNT(DISTINCT(participants.user_id)) AS `participants_count`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1)) AS `current_user_votes`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1) AND (`votes`.`vote_answer` = :dcValue2)) AS `current_user_votes_yes`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1) AND (`votes`.`vote_answer` = :dcValue3)) AS `current_user_votes_no`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1) AND (`votes`.`vote_answer` = :dcValue4)) AS `current_user_votes_maybe`, (SELECT COUNT(`v`.`id`) FROM `*PREFIX*polls_votes` `v` LEFT JOIN `*PREFIX*polls_options` `o` ON (`o`.`poll_id` = `v`.`poll_id`) AND (`o`.`poll_option_hash` = `v`.`vote_option_hash`) AND (`o`.`deleted` = '0') WHERE (`v`.`poll_id` = `polls_polls`.`id`) AND (`v`.`user_id` = :dcValue1) AND (`o`.`id` IS NULL)) AS `current_user_orphaned_votes` FROM `*PREFIX*polls_polls` `polls_polls` LEFT JOIN `*PREFIX*polls_share` `user_shares` ON (`user_shares`.`poll_id` = `polls_polls`.`id`) AND (`user_shares`.`user_id` = :dcValue1) AND (`user_shares`.`deleted` = '0') LEFT JOIN `*PREFIX*polls_share` `group_shares` ON (`group_shares`.`poll_id` = `polls_polls`.`id`) AND (`group_shares`.`type` = 'group') AND (`group_shares`.`deleted` = '0') LEFT JOIN `*PREFIX*polls_groups_polls` `poll_groups` ON `polls_polls`.`id` = `poll_groups`.`poll_id` LEFT JOIN `*PREFIX*polls_votes` `participants` ON `participants`.`poll_id` = `polls_polls`.`id` LEFT JOIN `*PREFIX*polls_share` `poll_group_shares` ON (`poll_group_shares`.`group_id` = `poll_groups`.`group_id`) AND (`poll_group_shares`.`deleted` = '0') AND (`poll_group_shares`.`user_id` = :dcValue1) WHERE `polls_polls`.`id` = :dcValue5 GROUP BY `polls_polls`.`id`, `user_shares`.`type`, `user_shares`.`locked`, `user_shares`.`token`\"; ","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","exception":{"Exception":"OCP\\AppFramework\\Db\\MultipleObjectsReturnedException","Message":"Did not expect more than one result when executing: query \"SELECT `polls_polls`.*, (SELECT MAX(`options`.`timestamp`) FROM `*PREFIX*polls_options` `options` WHERE (`options`.`poll_id` = `polls_polls`.`id`) AND (`options`.`deleted` = '0')) AS `max_date`, coalesce(user_shares.type, '') AS user_role, `user_shares`.`locked` AS `is_current_user_locked`, coalesce(user_shares.token, '') AS share_token, string_agg(distinct group_shares.user_id::varchar, ',') AS group_shares, string_agg(distinct poll_groups.group_id::varchar, ',') AS poll_groups, string_agg(distinct poll_group_shares.type::varchar, ',') AS poll_group_user_shares, COUNT(DISTINCT(participants.user_id)) AS `participants_count`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1)) AS `current_user_votes`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1) AND (`votes`.`vote_answer` = :dcValue2)) AS `current_user_votes_yes`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1) AND (`votes`.`vote_answer` = :dcValue3)) AS `current_user_votes_no`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1) AND (`votes`.`vote_answer` = :dcValue4)) AS `current_user_votes_maybe`, (SELECT COUNT(`v`.`id`) FROM `*PREFIX*polls_votes` `v` LEFT JOIN `*PREFIX*polls_options` `o` ON (`o`.`poll_id` = `v`.`poll_id`) AND (`o`.`poll_option_hash` = `v`.`vote_option_hash`) AND (`o`.`deleted` = '0') WHERE (`v`.`poll_id` = `polls_polls`.`id`) AND (`v`.`user_id` = :dcValue1) AND (`o`.`id` IS NULL)) AS `current_user_orphaned_votes` FROM `*PREFIX*polls_polls` `polls_polls` LEFT JOIN `*PREFIX*polls_share` `user_shares` ON (`user_shares`.`poll_id` = `polls_polls`.`id`) AND (`user_shares`.`user_id` = :dcValue1) AND (`user_shares`.`deleted` = '0') LEFT JOIN `*PREFIX*polls_share` `group_shares` ON (`group_shares`.`poll_id` = `polls_polls`.`id`) AND (`group_shares`.`type` = 'group') AND (`group_shares`.`deleted` = '0') LEFT JOIN `*PREFIX*polls_groups_polls` `poll_groups` ON `polls_polls`.`id` = `poll_groups`.`poll_id` LEFT JOIN `*PREFIX*polls_votes` `participants` ON `participants`.`poll_id` = `polls_polls`.`id` LEFT JOIN `*PREFIX*polls_share` `poll_group_shares` ON (`poll_group_shares`.`group_id` = `poll_groups`.`group_id`) AND (`poll_group_shares`.`deleted` = '0') AND (`poll_group_shares`.`user_id` = :dcValue1) WHERE `polls_polls`.`id` = :dcValue5 GROUP BY `polls_polls`.`id`, `user_shares`.`type`, `user_shares`.`locked`, `user_shares`.`token`\"; ","Code":0,"Trace":[{"file":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","line":382,"function":"findOneQuery","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/var/www/html/apps/polls/lib/Db/PollMapper.php","line":44,"function":"findEntity","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/var/www/html/apps/polls/lib/Service/ShareService.php","line":137,"function":"get","class":"OCA\\Polls\\Db\\PollMapper","type":"->","args":[35]},{"file":"/var/www/html/apps/polls/lib/Controller/PublicController.php","line":113,"function":"getEffectiveShare","class":"OCA\\Polls\\Service\\ShareService","type":"->","args":[]},{"file":"/var/www/html/apps/polls/lib/Controller/BaseController.php","line":42,"function":"{closure:OCA\\Polls\\Controller\\PublicController::getSession():112}","class":"OCA\\Polls\\Controller\\PublicController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/polls/lib/Controller/PublicController.php","line":112,"function":"response","class":"OCA\\Polls\\Controller\\BaseController","type":"->","args":[{"__class__":"Closure"}]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":165,"function":"getSession","class":"OCA\\Polls\\Controller\\PublicController","type":"->","args":[]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":78,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Polls\\Controller\\PublicController"},"getSession"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":137,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Polls\\Controller\\PublicController"},"getSession"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":324,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Polls\\Controller\\PublicController","getSession",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"token":"byS8Hnqx","_route":"polls.public.getsession"}]},{"file":"/var/www/html/lib/base.php","line":1159,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/polls/s/byS8Hnqx/session"]},{"file":"/var/www/html/index.php","line":25,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","Line":293,"message":"Did not expect more than one result when executing: query \"SELECT `polls_polls`.*, (SELECT MAX(`options`.`timestamp`) FROM `*PREFIX*polls_options` `options` WHERE (`options`.`poll_id` = `polls_polls`.`id`) AND (`options`.`deleted` = '0')) AS `max_date`, coalesce(user_shares.type, '') AS user_role, `user_shares`.`locked` AS `is_current_user_locked`, coalesce(user_shares.token, '') AS share_token, string_agg(distinct group_shares.user_id::varchar, ',') AS group_shares, string_agg(distinct poll_groups.group_id::varchar, ',') AS poll_groups, string_agg(distinct poll_group_shares.type::varchar, ',') AS poll_group_user_shares, COUNT(DISTINCT(participants.user_id)) AS `participants_count`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1)) AS `current_user_votes`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1) AND (`votes`.`vote_answer` = :dcValue2)) AS `current_user_votes_yes`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1) AND (`votes`.`vote_answer` = :dcValue3)) AS `current_user_votes_no`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1) AND (`votes`.`vote_answer` = :dcValue4)) AS `current_user_votes_maybe`, (SELECT COUNT(`v`.`id`) FROM `*PREFIX*polls_votes` `v` LEFT JOIN `*PREFIX*polls_options` `o` ON (`o`.`poll_id` = `v`.`poll_id`) AND (`o`.`poll_option_hash` = `v`.`vote_option_hash`) AND (`o`.`deleted` = '0') WHERE (`v`.`poll_id` = `polls_polls`.`id`) AND (`v`.`user_id` = :dcValue1) AND (`o`.`id` IS NULL)) AS `current_user_orphaned_votes` FROM `*PREFIX*polls_polls` `polls_polls` LEFT JOIN `*PREFIX*polls_share` `user_shares` ON (`user_shares`.`poll_id` = `polls_polls`.`id`) AND (`user_shares`.`user_id` = :dcValue1) AND (`user_shares`.`deleted` = '0') LEFT JOIN `*PREFIX*polls_share` `group_shares` ON (`group_shares`.`poll_id` = `polls_polls`.`id`) AND (`group_shares`.`type` = 'group') AND (`group_shares`.`deleted` = '0') LEFT JOIN `*PREFIX*polls_groups_polls` `poll_groups` ON `polls_polls`.`id` = `poll_groups`.`poll_id` LEFT JOIN `*PREFIX*polls_votes` `participants` ON `participants`.`poll_id` = `polls_polls`.`id` LEFT JOIN `*PREFIX*polls_share` `poll_group_shares` ON (`poll_group_shares`.`group_id` = `poll_groups`.`group_id`) AND (`poll_group_shares`.`deleted` = '0') AND (`poll_group_shares`.`user_id` = :dcValue1) WHERE `polls_polls`.`id` = :dcValue5 GROUP BY `polls_polls`.`id`, `user_shares`.`type`, `user_shares`.`locked`, `user_shares`.`token`\"; ","exception":"{\"class\":\"OCP\\AppFramework\\Db\\MultipleObjectsReturnedException\",\"message\":\"Did not expect more than one result when executing: query \\\"SELECT `polls_polls`.*, (SELECT MAX(`options`.`timestamp`) FROM `*PREFIX*polls_options` `options` WHERE (`options`.`poll_id` = `polls_polls`.`id`) AND (`options`.`deleted` = '0')) AS `max_date`, coalesce(user_shares.type, '') AS user_role, `user_shares`.`locked` AS `is_current_user_locked`, coalesce(user_shares.token, '') AS share_token, string_agg(distinct group_shares.user_id::varchar, ',') AS group_shares, string_agg(distinct poll_groups.group_id::varchar, ',') AS poll_groups, string_agg(distinct poll_group_shares.type::varchar, ',') AS poll_group_user_shares, COUNT(DISTINCT(participants.user_id)) AS `participants_count`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1)) AS `current_user_votes`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1) AND (`votes`.`vote_answer` = :dcValue2)) AS `current_user_votes_yes`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1) AND (`votes`.`vote_answer` = :dcValue3)) AS `current_user_votes_no`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1) AND (`votes`.`vote_answer` = :dcValue4)) AS `current_user_votes_maybe`, (SELECT COUNT(`v`.`id`) FROM `*PREFIX*polls_votes` `v` LEFT JOIN `*PREFIX*polls_options` `o` ON (`o`.`poll_id` = `v`.`poll_id`) AND (`o`.`poll_option_hash` = `v`.`vote_option_hash`) AND (`o`.`deleted` = '0') WHERE (`v`.`poll_id` = `polls_polls`.`id`) AND (`v`.`user_id` = :dcValue1) AND (`o`.`id` IS NULL)) AS `current_user_orphaned_votes` FROM `*PREFIX*polls_polls` `polls_polls` LEFT JOIN `*PREFIX*polls_share` `user_shares` ON (`user_shares`.`poll_id` = `polls_polls`.`id`) AND (`user_shares`.`user_id` = :dcValue1) AND (`user_shares`.`deleted` = '0') LEFT JOIN `*PREFIX*polls_share` `group_shares` ON (`group_shares`.`poll_id` = `polls_polls`.`id`) AND (`group_shares`.`type` = 'group') AND (`group_shares`.`deleted` = '0') LEFT JOIN `*PREFIX*polls_groups_polls` `poll_groups` ON `polls_polls`.`id` = `poll_groups`.`poll_id` LEFT JOIN `*PREFIX*polls_votes` `participants` ON `participants`.`poll_id` = `polls_polls`.`id` LEFT JOIN `*PREFIX*polls_share` `poll_group_shares` ON (`poll_group_shares`.`group_id` = `poll_groups`.`group_id`) AND (`poll_group_shares`.`deleted` = '0') AND (`poll_group_shares`.`user_id` = :dcValue1) WHERE `polls_polls`.`id` = :dcValue5 GROUP BY `polls_polls`.`id`, `user_shares`.`type`, `user_shares`.`locked`, `user_shares`.`token`\\\"; \",\"code\":0,\"file\":\"/var/www/html/lib/public/AppFramework/Db/QBMapper.php:293\",\"trace\":\"#0 /var/www/html/lib/public/AppFramework/Db/QBMapper.php(382): OCP\\AppFramework\\Db\\QBMapper->findOneQuery(Object(OC\\DB\\QueryBuilder\\QueryBuilder))\\n#1 /var/www/html/apps/polls/lib/Db/PollMapper.php(44): OCP\\AppFramework\\Db\\QBMapper->findEntity(Object(OC\\DB\\QueryBuilder\\QueryBuilder))\\n#2 /var/www/html/apps/polls/lib/Service/ShareService.php(137): OCA\\Polls\\Db\\PollMapper->get(35)\\n#3 /var/www/html/apps/polls/lib/Controller/PublicController.php(113): OCA\\Polls\\Service\\ShareService->getEffectiveShare()\\n#4 /var/www/html/apps/polls/lib/Controller/BaseController.php(42): OCA\\Polls\\Controller\\PublicController->{closure:OCA\\Polls\\Controller\\PublicController::getSession():112}()\\n#5 /var/www/html/apps/polls/lib/Controller/PublicController.php(112): OCA\\Polls\\Controller\\BaseController->response(Object(Closure))\\n#6 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(165): OCA\\Polls\\Controller\\PublicController->getSession()\\n#7 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(78): OC\\AppFramework\\Http\\Dispatcher->executeController(Object(OCA\\Polls\\Controller\\PublicController), 'getSession')\\n#8 /var/www/html/lib/private/AppFramework/App.php(137): OC\\AppFramework\\Http\\Dispatcher->dispatch(Object(OCA\\Polls\\Controller\\PublicController), 'getSession')\\n#9 /var/www/html/lib/private/Route/Router.php(324): OC\\AppFramework\\App::main('OCA\\\\Polls\\\\Contr...', 'getSession', Object(OC\\AppFramework\\DependencyInjection\\DIContainer), Array)\\n#10 /var/www/html/lib/base.php(1159): OC\\Route\\Router->match('/apps/polls/s/b...')\\n#11 /var/www/html/index.php(25): OC::handleRequest()\\n#12 {main}\"}","CustomMessage":"Did not expect more than one result when executing: query \"SELECT `polls_polls`.*, (SELECT MAX(`options`.`timestamp`) FROM `*PREFIX*polls_options` `options` WHERE (`options`.`poll_id` = `polls_polls`.`id`) AND (`options`.`deleted` = '0')) AS `max_date`, coalesce(user_shares.type, '') AS user_role, `user_shares`.`locked` AS `is_current_user_locked`, coalesce(user_shares.token, '') AS share_token, string_agg(distinct group_shares.user_id::varchar, ',') AS group_shares, string_agg(distinct poll_groups.group_id::varchar, ',') AS poll_groups, string_agg(distinct poll_group_shares.type::varchar, ',') AS poll_group_user_shares, COUNT(DISTINCT(participants.user_id)) AS `participants_count`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1)) AS `current_user_votes`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1) AND (`votes`.`vote_answer` = :dcValue2)) AS `current_user_votes_yes`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1) AND (`votes`.`vote_answer` = :dcValue3)) AS `current_user_votes_no`, (SELECT COUNT(`votes`.`id`) FROM `*PREFIX*polls_votes` `votes` WHERE (`votes`.`poll_id` = `polls_polls`.`id`) AND (`votes`.`user_id` = :dcValue1) AND (`votes`.`vote_answer` = :dcValue4)) AS `current_user_votes_maybe`, (SELECT COUNT(`v`.`id`) FROM `*PREFIX*polls_votes` `v` LEFT JOIN `*PREFIX*polls_options` `o` ON (`o`.`poll_id` = `v`.`poll_id`) AND (`o`.`poll_option_hash` = `v`.`vote_option_hash`) AND (`o`.`deleted` = '0') WHERE (`v`.`poll_id` = `polls_polls`.`id`) AND (`v`.`user_id` = :dcValue1) AND (`o`.`id` IS NULL)) AS `current_user_orphaned_votes` FROM `*PREFIX*polls_polls` `polls_polls` LEFT JOIN `*PREFIX*polls_share` `user_shares` ON (`user_shares`.`poll_id` = `polls_polls`.`id`) AND (`user_shares`.`user_id` = :dcValue1) AND (`user_shares`.`deleted` = '0') LEFT JOIN `*PREFIX*polls_share` `group_shares` ON (`group_shares`.`poll_id` = `polls_polls`.`id`) AND (`group_shares`.`type` = 'group') AND (`group_shares`.`deleted` = '0') LEFT JOIN `*PREFIX*polls_groups_polls` `poll_groups` ON `polls_polls`.`id` = `poll_groups`.`poll_id` LEFT JOIN `*PREFIX*polls_votes` `participants` ON `participants`.`poll_id` = `polls_polls`.`id` LEFT JOIN `*PREFIX*polls_share` `poll_group_shares` ON (`poll_group_shares`.`group_id` = `poll_groups`.`group_id`) AND (`poll_group_shares`.`deleted` = '0') AND (`poll_group_shares`.`user_id` = :dcValue1) WHERE `polls_polls`.`id` = :dcValue5 GROUP BY `polls_polls`.`id`, `user_shares`.`type`, `user_shares`.`locked`, `user_shares`.`token`\"; "}}
{"reqId":"eSGDV1IwqXilIcmpJS8J","level":0,"time":"2026-07-22T09:43:12+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"dav","method":"PUT","url":"/ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json","scriptName":"/ocs/v2.php","message":"No calendar events found for status check","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"dav","user":"christian"}}
{"reqId":"isp7bnnfkD9zfGkAmvn2","level":0,"time":"2026-07-22T09:43:12+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"dav","method":"GET","url":"/ocs/v2.php/apps/user_status/api/v1/user_status","scriptName":"/ocs/v2.php","message":"No calendar events found for status check","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"dav","user":"christian"}}
{"reqId":"OI9YuxCoUFdBBdptjfUs","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"core","method":"GET","url":"/index.php/contactsmenu/teams","scriptName":"/index.php","message":"OC\\Core\\Controller\\ContactsMenuController::getTeams returned raw data. Please wrap it in a Response or one of it's inheritors.","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"core"}}
{"reqId":"Cj5PLuInemRhDwquiOtR","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/session?time=1784713393266","scriptName":"/index.php","message":"The loading of lazy AppConfig values have been triggered by app \"polls\"","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","exception":{"Exception":"RuntimeException","Message":"The loading of lazy AppConfig values have been triggered by app \"polls\"","Code":0,"Trace":[{"file":"/var/www/html/lib/private/AppConfig.php","line":597,"function":"loadConfig","class":"OC\\AppConfig","type":"->","args":["polls",true]},{"file":"/var/www/html/apps/polls/lib/Model/Settings/AppSettings.php","line":138,"function":"getValueType","class":"OC\\AppConfig","type":"->","args":["polls","allowAllAccess"]},{"file":"/var/www/html/apps/polls/lib/Model/Settings/AppSettings.php","line":170,"function":"checkSettingType","class":"OCA\\Polls\\Model\\Settings\\AppSettings","type":"->","args":["allowAllAccess",32,"polls"]},{"file":"/var/www/html/apps/polls/lib/Model/Settings/AppSettings.php","line":274,"function":"getBooleanSetting","class":"OCA\\Polls\\Model\\Settings\\AppSettings","type":"->","args":["allowAllAccess","allAccessGroups"]},{"file":"/var/www/html/apps/polls/lib/Model/Settings/AppSettings.php","line":83,"function":"getAllAccessAllowed","class":"OCA\\Polls\\Model\\Settings\\AppSettings","type":"->","args":[]},{"file":"/var/www/html/apps/polls/lib/Controller/UserController.php","line":67,"function":"getPermissionsArray","class":"OCA\\Polls\\Model\\Settings\\AppSettings","type":"->","args":[]},{"file":"/var/www/html/apps/polls/lib/Controller/BaseController.php","line":42,"function":"{closure:OCA\\Polls\\Controller\\UserController::getSession():64}","class":"OCA\\Polls\\Controller\\UserController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/polls/lib/Controller/UserController.php","line":64,"function":"response","class":"OCA\\Polls\\Controller\\BaseController","type":"->","args":[{"__class__":"Closure"}]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":165,"function":"getSession","class":"OCA\\Polls\\Controller\\UserController","type":"->","args":[]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":78,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Polls\\Controller\\UserController"},"getSession"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":137,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Polls\\Controller\\UserController"},"getSession"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":324,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Polls\\Controller\\UserController","getSession",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"polls.user.getsession"}]},{"file":"/var/www/html/lib/base.php","line":1159,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/polls/session"]},{"file":"/var/www/html/index.php","line":25,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/AppConfig.php","Line":1378,"message":"The loading of lazy AppConfig values have been triggered by app \"polls\"","exception":"{\"class\":\"RuntimeException\",\"message\":\"The loading of lazy AppConfig values have been triggered by app \\\"polls\\\"\",\"code\":0,\"file\":\"/var/www/html/lib/private/AppConfig.php:1378\",\"trace\":\"#0 /var/www/html/lib/private/AppConfig.php(597): OC\\AppConfig->loadConfig('polls', true)\\n#1 /var/www/html/apps/polls/lib/Model/Settings/AppSettings.php(138): OC\\AppConfig->getValueType('polls', 'allowAllAccess')\\n#2 /var/www/html/apps/polls/lib/Model/Settings/AppSettings.php(170): OCA\\Polls\\Model\\Settings\\AppSettings->checkSettingType('allowAllAccess', 32, 'polls')\\n#3 /var/www/html/apps/polls/lib/Model/Settings/AppSettings.php(274): OCA\\Polls\\Model\\Settings\\AppSettings->getBooleanSetting('allowAllAccess', 'allAccessGroups')\\n#4 /var/www/html/apps/polls/lib/Model/Settings/AppSettings.php(83): OCA\\Polls\\Model\\Settings\\AppSettings->getAllAccessAllowed()\\n#5 /var/www/html/apps/polls/lib/Controller/UserController.php(67): OCA\\Polls\\Model\\Settings\\AppSettings->getPermissionsArray()\\n#6 /var/www/html/apps/polls/lib/Controller/BaseController.php(42): OCA\\Polls\\Controller\\UserController->{closure:OCA\\Polls\\Controller\\UserController::getSession():64}()\\n#7 /var/www/html/apps/polls/lib/Controller/UserController.php(64): OCA\\Polls\\Controller\\BaseController->response(Object(Closure))\\n#8 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(165): OCA\\Polls\\Controller\\UserController->getSession()\\n#9 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(78): OC\\AppFramework\\Http\\Dispatcher->executeController(Object(OCA\\Polls\\Controller\\UserController), 'getSession')\\n#10 /var/www/html/lib/private/AppFramework/App.php(137): OC\\AppFramework\\Http\\Dispatcher->dispatch(Object(OCA\\Polls\\Controller\\UserController), 'getSession')\\n#11 /var/www/html/lib/private/Route/Router.php(324): OC\\AppFramework\\App::main('OCA\\\\Polls\\\\Contr...', 'getSession', Object(OC\\AppFramework\\DependencyInjection\\DIContainer), Array)\\n#12 /var/www/html/lib/base.php(1159): OC\\Route\\Router->match('/apps/polls/ses...')\\n#13 /var/www/html/index.php(25): OC::handleRequest()\\n#14 {main}\"}","CustomMessage":"The loading of lazy AppConfig values have been triggered by app \"polls\""}}
{"reqId":"Cj5PLuInemRhDwquiOtR","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/session?time=1784713393266","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"allowAllAccess","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"Cj5PLuInemRhDwquiOtR","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/session?time=1784713393266","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"unrestrictedOwner","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"Cj5PLuInemRhDwquiOtR","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/session?time=1784713393266","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"allowCombo","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"Cj5PLuInemRhDwquiOtR","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/session?time=1784713393266","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"unrestrictedOwner","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"Cj5PLuInemRhDwquiOtR","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/session?time=1784713393266","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"allowPollCreation","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"Cj5PLuInemRhDwquiOtR","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/session?time=1784713393266","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"allowPollDownload","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"Cj5PLuInemRhDwquiOtR","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/session?time=1784713393266","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"allowPublicShares","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"Cj5PLuInemRhDwquiOtR","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/session?time=1784713393266","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"showMailAddresses","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"Cj5PLuInemRhDwquiOtR","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/session?time=1784713393266","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"unrestrictedOwner","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"Cj5PLuInemRhDwquiOtR","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/session?time=1784713393266","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"useActivity","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"Cj5PLuInemRhDwquiOtR","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/session?time=1784713393266","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"navigationPollsInList","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"Cj5PLuInemRhDwquiOtR","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/session?time=1784713393266","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"unrestrictedOwner","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"j82AXiFDYtWxRgx3mZl3","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/polls?time=1784713393790","scriptName":"/index.php","message":"The loading of lazy AppConfig values have been triggered by app \"polls\"","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","exception":{"Exception":"RuntimeException","Message":"The loading of lazy AppConfig values have been triggered by app \"polls\"","Code":0,"Trace":[{"file":"/var/www/html/lib/private/AppConfig.php","line":597,"function":"loadConfig","class":"OC\\AppConfig","type":"->","args":["polls",true]},{"file":"/var/www/html/apps/polls/lib/Model/Settings/AppSettings.php","line":138,"function":"getValueType","class":"OC\\AppConfig","type":"->","args":["polls","allowPollCreation"]},{"file":"/var/www/html/apps/polls/lib/Model/Settings/AppSettings.php","line":170,"function":"checkSettingType","class":"OCA\\Polls\\Model\\Settings\\AppSettings","type":"->","args":["allowPollCreation",32,"polls"]},{"file":"/var/www/html/apps/polls/lib/Model/Settings/AppSettings.php","line":246,"function":"getBooleanSetting","class":"OCA\\Polls\\Model\\Settings\\AppSettings","type":"->","args":["allowPollCreation","pollCreationGroups"]},{"file":"/var/www/html/apps/polls/lib/Controller/PollController.php","line":68,"function":"getPollCreationAllowed","class":"OCA\\Polls\\Model\\Settings\\AppSettings","type":"->","args":[]},{"file":"/var/www/html/apps/polls/lib/Controller/BaseController.php","line":42,"function":"{closure:OCA\\Polls\\Controller\\PollController::listPolls():63}","class":"OCA\\Polls\\Controller\\PollController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/polls/lib/Controller/PollController.php","line":63,"function":"response","class":"OCA\\Polls\\Controller\\BaseController","type":"->","args":[{"__class__":"Closure"}]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":165,"function":"listPolls","class":"OCA\\Polls\\Controller\\PollController","type":"->","args":[]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":78,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Polls\\Controller\\PollController"},"listPolls"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":137,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Polls\\Controller\\PollController"},"listPolls"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":324,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Polls\\Controller\\PollController","listPolls",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"polls.poll.listpolls"}]},{"file":"/var/www/html/lib/base.php","line":1159,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/polls/polls"]},{"file":"/var/www/html/index.php","line":25,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/AppConfig.php","Line":1378,"message":"The loading of lazy AppConfig values have been triggered by app \"polls\"","exception":"{\"class\":\"RuntimeException\",\"message\":\"The loading of lazy AppConfig values have been triggered by app \\\"polls\\\"\",\"code\":0,\"file\":\"/var/www/html/lib/private/AppConfig.php:1378\",\"trace\":\"#0 /var/www/html/lib/private/AppConfig.php(597): OC\\AppConfig->loadConfig('polls', true)\\n#1 /var/www/html/apps/polls/lib/Model/Settings/AppSettings.php(138): OC\\AppConfig->getValueType('polls', 'allowPollCreati...')\\n#2 /var/www/html/apps/polls/lib/Model/Settings/AppSettings.php(170): OCA\\Polls\\Model\\Settings\\AppSettings->checkSettingType('allowPollCreati...', 32, 'polls')\\n#3 /var/www/html/apps/polls/lib/Model/Settings/AppSettings.php(246): OCA\\Polls\\Model\\Settings\\AppSettings->getBooleanSetting('allowPollCreati...', 'pollCreationGro...')\\n#4 /var/www/html/apps/polls/lib/Controller/PollController.php(68): OCA\\Polls\\Model\\Settings\\AppSettings->getPollCreationAllowed()\\n#5 /var/www/html/apps/polls/lib/Controller/BaseController.php(42): OCA\\Polls\\Controller\\PollController->{closure:OCA\\Polls\\Controller\\PollController::listPolls():63}()\\n#6 /var/www/html/apps/polls/lib/Controller/PollController.php(63): OCA\\Polls\\Controller\\BaseController->response(Object(Closure))\\n#7 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(165): OCA\\Polls\\Controller\\PollController->listPolls()\\n#8 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(78): OC\\AppFramework\\Http\\Dispatcher->executeController(Object(OCA\\Polls\\Controller\\PollController), 'listPolls')\\n#9 /var/www/html/lib/private/AppFramework/App.php(137): OC\\AppFramework\\Http\\Dispatcher->dispatch(Object(OCA\\Polls\\Controller\\PollController), 'listPolls')\\n#10 /var/www/html/lib/private/Route/Router.php(324): OC\\AppFramework\\App::main('OCA\\\\Polls\\\\Contr...', 'listPolls', Object(OC\\AppFramework\\DependencyInjection\\DIContainer), Array)\\n#11 /var/www/html/lib/base.php(1159): OC\\Route\\Router->match('/apps/polls/pol...')\\n#12 /var/www/html/index.php(25): OC::handleRequest()\\n#13 {main}\"}","CustomMessage":"The loading of lazy AppConfig values have been triggered by app \"polls\""}}
{"reqId":"j82AXiFDYtWxRgx3mZl3","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/polls?time=1784713393790","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"allowPollCreation","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"j82AXiFDYtWxRgx3mZl3","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/polls?time=1784713393790","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"allowCombo","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"j82AXiFDYtWxRgx3mZl3","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/polls?time=1784713393790","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"unrestrictedOwner","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"j82AXiFDYtWxRgx3mZl3","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/polls?time=1784713393790","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"unrestrictedOwner","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"j82AXiFDYtWxRgx3mZl3","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/polls?time=1784713393790","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"unrestrictedOwner","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"j82AXiFDYtWxRgx3mZl3","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/polls?time=1784713393790","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"allowPollDownload","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
{"reqId":"j82AXiFDYtWxRgx3mZl3","level":0,"time":"2026-07-22T09:43:13+00:00","remoteAddr":"79.223.165.65","user":"christian","app":"polls","method":"GET","url":"/index.php/apps/polls/polls?time=1784713393790","scriptName":"/index.php","message":"Could not get setting type","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"34.0.1.2","data":{"app":"polls","key":"showMailAddresses","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}
...

Additional environment informations

No response

Configuration report

www-data@701ce01299e4:~/html$ php occ config:list system
{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "v2",
            "v9.nimkannon.de",
            "cloud.fg9.eu",
            "v2.sxvq2ajjq5adzs08.myfritz.net",
            "v2.fritz.box",
            "192.168.178.43",
            "[::]"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "pgsql",
        "version": "34.0.1.2",
        "appstoreenabled": true,
        "installed": true,
        "theme": "",
        "maintenance": false,
        "secret": "***REMOVED SENSITIVE VALUE***",
        "loglevel": 0,
        "trashbin_retention_obligation": "auto",
        "appstore.experimental.enabled": false,
        "updater.release.channel": "stable",
        "overwritehost": "cloud.fg9.eu",
        "overwriteprotocol": "https",
        "overwrite.cli.url": "https:\/\/cloud.fg9.eu\/",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "log_rotate_size": 104857600,
        "mail_smtpmode": "smtp",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "mail_sendmailmode": "smtp"
    }
}

List of activated Apps

www-data@701ce01299e4:~/html$ php occ app:list          
Enabled:
  - activity: 7.0.0
  - admin_audit: 1.24.0
  - app_api: 34.0.0
  - appstore: 1.0.0
  - calendar: 6.5.0
  - circles: 34.0.0
  - cloud_federation_api: 1.18.0
  - comments: 1.24.0
  - contacts: 8.7.2
  - contactsinteraction: 1.15.0
  - dashboard: 7.14.0
  - dav: 1.39.0
  - federatedfilesharing: 1.24.0
  - federation: 1.24.0
  - files: 2.6.0
  - files_downloadlimit: 5.2.0-dev.0
  - files_lock: 34.0.0
  - files_pdfviewer: 7.0.0-dev.0
  - files_reminders: 1.7.0
  - files_sharing: 1.26.0
  - files_trashbin: 1.24.0
  - files_versions: 1.27.0
  - firstrunwizard: 7.0.0-dev.0
  - logreader: 7.0.0
  - lookup_server_connector: 1.22.0
  - nextcloud_announcements: 6.0.0
  - notes: 6.0.1
  - notifications: 7.0.0-dev.1
  - oauth2: 1.22.0
  - office: 1.0.0
  - password_policy: 6.0.0-dev.0
  - photos: 7.0.0
  - polls: 9.1.4
  - privacy: 6.0.0-dev.1
  - profile: 1.3.0
  - provisioning_api: 1.24.0
  - recommendations: 7.0.0
  - related_resources: 5.0.0-dev.0
  - serverinfo: 6.0.0
  - settings: 1.17.0
  - sharebymail: 1.24.0
  - support: 6.0.0
  - survey_client: 6.0.0-dev.0
  - systemtags: 1.24.0
  - text: 8.0.0
  - theming: 2.9.0
  - twofactor_backupcodes: 1.23.0
  - twofactor_totp: 16.0.0
  - updatenotification: 1.24.0
  - user_status: 1.14.0
  - viewer: 7.0.0-dev.0
  - weather_status: 1.14.0
  - webhook_listeners: 1.6.0
  - workflowengine: 2.16.0
Disabled:
  - bruteforcesettings: 7.0.0 (installed 1.0.3)
  - encryption: 2.22.0
  - files_external: 1.26.0
  - suspicious_login: 12.0.0-dev.0
  - twofactor_nextcloud_notification: 8.0.0
  - user_ldap: 1.25.0

Nextcloud Signing status

No errors have been found.

Additional Information

I read #4496 and #4561, but these bugs have been fixed with version 9.0.0. I use version 9.1.4, so I guess, it is a new bug. I also read #4835 , but I didn't restrict the app to groups, so this doesn't apply here.

Pinned by dartcafe
@dartcafedartcafeon Aug 22, 2026

I think I have the complete picture:

  • In 9.0.0 this issue should have been fixed, but there was a gap left over
  • The database definition with group_id null=false could not be applied, if records with group_id=null were present — the DB rejects ALTER TABLE ... NOT NULL as long as NULL rows still exist in that column
  • Nullish values could not be set to 0 because they produced duplicates
  • The duplication tidy did not recognize duplicates where both records werde set to group_id=null or one of the was set to the default value (learning: UNIQUE indices never enforce uniqueness across NULL values — two rows with NULL in an indexed column always count as distinct, on Postgres, MySQL/MariaDB and SQL…

View full comment

Activity

  1. christianwicke
    added the
    Bug
    issue type on Jul 22, 2026
  2. christianwicke
    added
    needs approval
    on Jul 22, 2026

  3. dartcafe commented on Jul 22, 2026

    @dartcafe
    dartcafe
    on Jul 22, 2026
    Collaborator

    It looks like the app settings can't get loaded. Try to enter the admin settings of polls and change any setting as a workaround for now. I will investigate further.

    Very good information collection, btw. I just stripped out unrelated console messages.

  4. christianwicke commented on Jul 22, 2026

    @christianwicke
    christianwicke
    on Jul 22, 2026
    Author

    Thanks for fast response and for your efforts! I changed some settings in the poll (Allow comments, Collapse long description, Hide results until poll is closed).
    Then I changed global poll settings as user 1: Date polls default to list view and Use modal 'Add poll' dialog instead of embedded dialog in Navigation bar. I repeated that as user 2.
    Unfortunately, none of this helped as a workaround. (As a workaround I voted under another name in an private tab.)

  5. dartcafe commented on Jul 23, 2026

    @dartcafe
    dartcafe
    on Jul 23, 2026
    Collaborator

    I was talking about the admin settings: /settings/admin/polls

    This tells me, there is something wrong with the global app settings:

    "message":"Could not get setting type",
"data":{"app":"polls","key":"allowAllAccess","expectedType":"32","actualType":"[unknown(NULL)]","exception":"unknown config key"}}

  6. christianwicke commented on Jul 23, 2026

    @christianwicke
    christianwicke
    on Jul 23, 2026
    Author

    I disabled "Enable the spreadsheet download of polls globally" as admin. But this didn't fix it. I also changed some setting in /settings/user/polls both as user 1 and user 2. But this didn't help either. If you need any logs of these, just let me know.

  7. dartcafe commented on Aug 4, 2026

    @dartcafe
    dartcafe
    on Aug 4, 2026
    Collaborator

    Sorry. I was busy the last weeks. I just tried to force this error, but I can't.

    Check your settings keys in oc_appsettings where appid = 'polls'. For example allowAllAccess. The type has to be some numeric value.

  8. christianwicke commented on Aug 4, 2026

    @christianwicke
    christianwicke
    on Aug 4, 2026
    Author

    I don't have any table oc_appsettings. But there is a oc_appconfig. Here are my values:

    nextcloud_db=# select * from oc_appconfig where appid='polls';
 appid |        configkey        | configvalue | type | lazy 
-------+-------------------------+-------------+------+------
 polls | allAccessGroups         | []          |   64 |    0
 polls | allowAllAccess          | 1           |   32 |    0
 polls | allowCombo              | 1           |   32 |    0
 polls | allowPollCreation       | 1           |   32 |    0
 polls | allowPollDownload       | 0           |   32 |    0
 polls | allowPublicShares       | 1           |   32 |    0
 polls | autoArchive             | 0           |   32 |    0
 polls | autoArchiveOffset       | 30          |    8 |    0
 polls | autoDelete              | 0           |   32 |    0
 polls | autoDeleteOffset        | 30          |    8 |    0
 polls | comboGroups             | []          |   64 |    0
 polls | disclaimer              |             |    4 |    0
 polls | enabled                 | yes         |    2 |    0
 polls | imprintUrl              |             |    4 |    0
 polls | installed_version       | 9.1.4       |    2 |    0
 polls | legalTermsInEmail       | 1           |   32 |    0
 polls | navigationPollsInList   | 1           |   32 |    0
 polls | pollCreationGroups      | []          |   64 |    0
 polls | pollDownloadGroups      | []          |   64 |    0
 polls | privacyUrl              |             |    4 |    0
 polls | publicSharesGroups      | []          |   64 |    0
 polls | showLogin               | 1           |   32 |    0
 polls | showMailAddresses       | 1           |   32 |    0
 polls | showMailAddressesGroups | []          |   64 |    0
 polls | types                   |             |    2 |    0
 polls | unrestrictedOwner       | 1           |   32 |    0
 polls | unrestrictedOwnerGroups | []          |   64 |    0
 polls | updateType              | noPolling   |    4 |    0
 polls | useActivity             | 1           |   32 |    0
 polls | useSiteLegalTerms       | 1           |   32 |    0
(30 rows)

    Shall I change anything?

  9. cm-schl commented on Aug 17, 2026

    @cm-schl
    cm-schl
    on Aug 17, 2026

    I'm not completely sure if my problem is connected to this issue, but it seams very similar:

    I created a poll for many Nextcloud users and used a list of mail addresses to invite them. In fact the mail addresses are the same every individual user has connected to his own Nextcloud account. Unfortunately when a already logged in user tries to open the poll with his personal link received by mail Nextcloud Forms shows a error 404. If a user opens a private tab and pastes the url / logs off before trying to open the link the user sees the Form.

    In my opinion a user that is logged in should always be able to open these types personal links (if the user is in possession of this "secret" this should be enough to grant him access to the form).

  10. dartcafe commented on Aug 19, 2026

    @dartcafe
    dartcafe
    on Aug 19, 2026
    Collaborator

    @christianwicke I was on the wrong track.

    The cause seems to be found here:
    "message": "Did not expect more than one result when executing: query \"SELECTpolls_polls.*, (SELECT MAX(options.timestamp) FROM PREFIXpolls_options [...]\"; ",

    The full select:

    SELECT
  `polls_polls`.*,
  (
  SELECT
    MAX(`options`.`timestamp`)
  FROM `*PREFIX*polls_options` `options`
  WHERE (`options`.`poll_id` = `polls_polls`.`id`)
    AND (`options`.`deleted` = '0')
) AS `max_date`,
  coalesce(user_shares.type, '') AS user_role,
  `user_shares`.`locked` AS `is_current_user_locked`,
  coalesce(user_shares.token, '') AS share_token,
  string_agg(DISTINCT group_shares.user_id :: varchar, ',') AS group_shares,
  string_agg(DISTINCT poll_groups.group_id :: varchar, ',') AS poll_groups,
  string_agg(DISTINCT poll_group_shares.type :: varchar, ',') AS poll_group_user_shares,
  COUNT(DISTINCT (participants.user_id)) AS `participants_count`,
  (
  SELECT
    COUNT(`votes`.`id`)
  FROM `*PREFIX*polls_votes` `votes`
  WHERE (`votes`.`poll_id` = `polls_polls`.`id`)
    AND (`votes`.`user_id` = : dcValue1)
) AS `current_user_votes`,
  (
  SELECT
    COUNT(`votes`.`id`)
  FROM `*PREFIX*polls_votes` `votes`
  WHERE (`votes`.`poll_id` = `polls_polls`.`id`)
    AND (`votes`.`user_id` = : dcValue1)
    AND (`votes`.`vote_answer` = : dcValue2)
) AS `current_user_votes_yes`,
  (
  SELECT
    COUNT(`votes`.`id`)
  FROM `*PREFIX*polls_votes` `votes`
  WHERE (`votes`.`poll_id` = `polls_polls`.`id`)
    AND (`votes`.`user_id` = : dcValue1)
    AND (`votes`.`vote_answer` = : dcValue3)
) AS `current_user_votes_no`,
  (
  SELECT
    COUNT(`votes`.`id`)
  FROM `*PREFIX*polls_votes` `votes`
  WHERE (`votes`.`poll_id` = `polls_polls`.`id`)
    AND (`votes`.`user_id` = : dcValue1)
    AND (`votes`.`vote_answer` = : dcValue4)
) AS `current_user_votes_maybe`,
  (
  SELECT
    COUNT(`v`.`id`)
  FROM `*PREFIX*polls_votes` `v`
  LEFT JOIN `*PREFIX*polls_options` `o`
  ON (`o`.`poll_id` = `v`.`poll_id`)
    AND (`o`.`poll_option_hash` = `v`.`vote_option_hash`)
    AND (`o`.`deleted` = '0')
  WHERE (`v`.`poll_id` = `polls_polls`.`id`)
    AND (`v`.`user_id` = : dcValue1)
    AND (`o`.`id` IS NULL)
) AS `current_user_orphaned_votes`
FROM `*PREFIX*polls_polls` `polls_polls`
LEFT JOIN `*PREFIX*polls_share` `user_shares`
ON (`user_shares`.`poll_id` = `polls_polls`.`id`)
  AND (`user_shares`.`user_id` = : dcValue1)
  AND (`user_shares`.`deleted` = '0')
LEFT JOIN `*PREFIX*polls_share` `group_shares`
ON (`group_shares`.`poll_id` = `polls_polls`.`id`)
  AND (`group_shares`.`type` = 'group')
  AND (`group_shares`.`deleted` = '0')
LEFT JOIN `*PREFIX*polls_groups_polls` `poll_groups`
ON `polls_polls`.`id` = `poll_groups`.`poll_id`
LEFT JOIN `*PREFIX*polls_votes` `participants`
ON `participants`.`poll_id` = `polls_polls`.`id`
LEFT JOIN `*PREFIX*polls_share` `poll_group_shares`
ON (`poll_group_shares`.`group_id` = `poll_groups`.`group_id`)
  AND (`poll_group_shares`.`deleted` = '0')
  AND (`poll_group_shares`.`user_id` = : dcValue1)
WHERE `polls_polls`.`id` = : dcValue5
GROUP BY `polls_polls`.`id`,
  `user_shares`.`type`,
  `user_shares`.`locked`,
  `user_shares`.`token`

    I have to inspect further.

  11. dartcafe commented on Aug 22, 2026

    @dartcafe
    dartcafe
    on Aug 22, 2026
    Collaborator

    This makes me crazy.
    Could you post your table definitions for oc_polls_share and the records affecting this user?
    The issue should have been fixed in #4496, but it seems some inconsistency inside the code was left over.

    Have you ever executed occ polls:db:rebuild?

  12. dartcafe commented on Aug 22, 2026

    @dartcafe
    dartcafe
    on Aug 22, 2026
    Collaborator

    I think the cause of your problem - and the fact I could not reproduce this error - was a missing call to the repair function inside the repair steps.

    My guess: Before you call occ polls:db:rebuild the db definition of oc_polls_share.group_id has null=true, what allows duplicate entries if the group_id is null.

    You may notice duplicate db records for the affected user with the same pollId but different share tokens.

    This gets fixed with occ polls:db:rebuild but the repair step after an update does not fix this.

  13. dartcafe
    removed
    needs approval
    on Aug 22, 2026
  14. dartcafe
    added this to the 9.2.0 milestone on Aug 22, 2026
  15. dartcafe
    linked a pull request that will close this issuefix share duplication #4968on Aug 22, 2026

  16. dartcafe commented on Aug 22, 2026

    @dartcafe
    dartcafe
    on Aug 22, 2026 · Pinned by dartcafe
    Collaborator

    I think I have the complete picture:

    • In 9.0.0 this issue should have been fixed, but there was a gap left over
    • The database definition with group_id null=false could not be applied, if records with group_id=null were present — the DB rejects ALTER TABLE ... NOT NULL as long as NULL rows still exist in that column
    • Nullish values could not be set to 0 because they produced duplicates
    • The duplication tidy did not recognize duplicates where both records werde set to group_id=null or one of the was set to the default value (learning: UNIQUE indices never enforce uniqueness across NULL values — two rows with NULL in an indexed column always count as distinct, on Postgres, MySQL/MariaDB and SQLite alike)
    • the result was an unattended failed fix and the situation stayed the same as before, if these circumstances were met
    • additionally, the app itself actively wrote null instead of 0 for the unused side (ShareService::createNewShare()), so even a fully repaired database would have been corrupted again by the next share creation

    Fix now is a hardened migration to the next version which correctly handles 'unset' values, removes the duplicates and ensures, the database definition can be set — plus the app-side fix so it stops writing null in the first place.

    Why does occ polls:db:rebuild fix that?
    The rebuild goes another way by

    • removing all unique indices first.
    • Because of this nullish values for group_id could be set set to 0 and
    • the following duplicate tidy removed the oldest sibling and
    • added the unique index back on.
  17. dartcafe
    pinned a comment on Aug 22, 2026
  18. dartcafe
    closed this as completedin #4968on Aug 22, 2026

  19. christianwicke commented on Aug 22, 2026

    @christianwicke
    christianwicke
    on Aug 22, 2026
    Author

    Hello @dartcafe , I ran php ./occ polls:db:rebuild and afterwards the problem was gone.
    (One remark: I didn't see any records in oc_polls_share with group_id=null before. Maybe I didn't look sharp enough, but as long as the problem is gone, it doesn't matter to me.)

    Thank you very much for your help!!!

  20. dartcafe
    marked Users that are already logged in can not access polls recieved by mail #4975 as a duplicate of this issue on Aug 25, 2026

  21. github-actions commented on Sep 23, 2026

    @github-actions
    github-actionsbot
    on Sep 23, 2026 – with GitHub Actions

    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.

  22. github-actions
    locked as resolved and limited conversation to collaborators on Sep 23, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    Bug

    Projects

    No projects

      Milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions