Polls not working on NC 26.0.1

Joon · June 21, 2023, 9:23pm

Hi Community,

while my cloud instance now on 26.0.1) is still facing external storage issues I realized now that also polls is not working. Last year there was also a bug. How is the situation now? Is it a bug again?

I´m quite fed up in the moment, sorry to say. Not one update works out of the box. But this time is “advanced”. There is a quite long list of things which are not working. Only to start: external storage (SMB), collabora server running, but does not connect, which means: no Collabora on Android-Client in my case. And now also polls…

[index] Fehler: OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'session_id' in 'field list' at <<closure>>

 0. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 328
    OC\DB\Exceptions\DbalException::wrap()
 1. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 138
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 2. /var/www/nextcloud/apps/polls/lib/Service/WatchService.php line 92
    OCP\AppFramework\Db\QBMapper->insert()
 3. /var/www/nextcloud/apps/polls/lib/Listener/BaseListener.php line 160
    OCA\Polls\Service\WatchService->writeUpdate()
 4. /var/www/nextcloud/apps/polls/lib/Listener/BaseListener.php line 92
    OCA\Polls\Listener\BaseListener->writeWatch()
 5. /var/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\Polls\Listener\BaseListener->handle()
 6. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
 7. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
 8. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 87
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
 9. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 99
    OC\EventDispatcher\EventDispatcher->dispatch()
10. /var/www/nextcloud/apps/polls/lib/Service/PollService.php line 285
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
11. /var/www/nextcloud/apps/polls/lib/Controller/PollController.php line 113
    OCA\Polls\Service\PollService->toggleArchive()
12. /var/www/nextcloud/apps/polls/lib/Controller/BaseController.php line 55
    OCA\Polls\Controller\PollController->OCA\Polls\Controller\{closure}("*** sensitive parameters replaced ***")
13. /var/www/nextcloud/apps/polls/lib/Controller/PollController.php line 113
    OCA\Polls\Controller\BaseController->response()
14. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Polls\Controller\PollController->toggleArchive()
15. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController()
16. /var/www/nextcloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch()
17. /var/www/nextcloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
18. /var/www/nextcloud/lib/base.php line 1056
    OC\Route\Router->match()
19. /var/www/nextcloud/index.php line 36
    OC::handleRequest()

Caused by:

Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'session_id' in 'field list' at <<closure>>

 0. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1814
    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
 1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1749
    Doctrine\DBAL\Connection->handleDriverException()
 2. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1163
    Doctrine\DBAL\Connection->convertExceptionDuringQuery()
 3. /var/www/nextcloud/lib/private/DB/Connection.php line 297
    Doctrine\DBAL\Connection->executeStatement()
 4. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 6. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
 7. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 138
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 8. /var/www/nextcloud/apps/polls/lib/Service/WatchService.php line 92
    OCP\AppFramework\Db\QBMapper->insert()
 9. /var/www/nextcloud/apps/polls/lib/Listener/BaseListener.php line 160
    OCA\Polls\Service\WatchService->writeUpdate()
10. /var/www/nextcloud/apps/polls/lib/Listener/BaseListener.php line 92
    OCA\Polls\Listener\BaseListener->writeWatch()
11. /var/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\Polls\Listener\BaseListener->handle()
12. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
13. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
14. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 87
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
15. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 99
    OC\EventDispatcher\EventDispatcher->dispatch()
16. /var/www/nextcloud/apps/polls/lib/Service/PollService.php line 285
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
17. /var/www/nextcloud/apps/polls/lib/Controller/PollController.php line 113
    OCA\Polls\Service\PollService->toggleArchive()
18. /var/www/nextcloud/apps/polls/lib/Controller/BaseController.php line 55
    OCA\Polls\Controller\PollController->OCA\Polls\Controller\{closure}("*** sensitive parameters replaced ***")
19. /var/www/nextcloud/apps/polls/lib/Controller/PollController.php line 113
    OCA\Polls\Controller\BaseController->response()
20. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Polls\Controller\PollController->toggleArchive()
21. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController()
22. /var/www/nextcloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch()
23. /var/www/nextcloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
24. /var/www/nextcloud/lib/base.php line 1056
    OC\Route\Router->match()
25. /var/www/nextcloud/index.php line 36
    OC::handleRequest()

Caused by:

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'session_id' in 'field list' at <<closure>>

 0. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 103
    Doctrine\DBAL\Driver\PDO\Exception::new()
 1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1153
    Doctrine\DBAL\Driver\PDO\Statement->execute()
 2. /var/www/nextcloud/lib/private/DB/Connection.php line 297
    Doctrine\DBAL\Connection->executeStatement()
 3. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 4. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
 6. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 138
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 7. /var/www/nextcloud/apps/polls/lib/Service/WatchService.php line 92
    OCP\AppFramework\Db\QBMapper->insert()
 8. /var/www/nextcloud/apps/polls/lib/Listener/BaseListener.php line 160
    OCA\Polls\Service\WatchService->writeUpdate()
 9. /var/www/nextcloud/apps/polls/lib/Listener/BaseListener.php line 92
    OCA\Polls\Listener\BaseListener->writeWatch()
10. /var/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\Polls\Listener\BaseListener->handle()
11. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
12. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
13. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 87
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
14. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 99
    OC\EventDispatcher\EventDispatcher->dispatch()
15. /var/www/nextcloud/apps/polls/lib/Service/PollService.php line 285
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
16. /var/www/nextcloud/apps/polls/lib/Controller/PollController.php line 113
    OCA\Polls\Service\PollService->toggleArchive()
17. /var/www/nextcloud/apps/polls/lib/Controller/BaseController.php line 55
    OCA\Polls\Controller\PollController->OCA\Polls\Controller\{closure}("*** sensitive parameters replaced ***")
18. /var/www/nextcloud/apps/polls/lib/Controller/PollController.php line 113
    OCA\Polls\Controller\BaseController->response()
19. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Polls\Controller\PollController->toggleArchive()
20. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController()
21. /var/www/nextcloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch()
22. /var/www/nextcloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
23. /var/www/nextcloud/lib/base.php line 1056
    OC\Route\Router->match()
24. /var/www/nextcloud/index.php line 36
    OC::handleRequest()

Caused by:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'session_id' in 'field list' at <<closure>>

 0. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 101
    PDOStatement->execute()
 1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1153
    Doctrine\DBAL\Driver\PDO\Statement->execute()
 2. /var/www/nextcloud/lib/private/DB/Connection.php line 297
    Doctrine\DBAL\Connection->executeStatement()
 3. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 4. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
 6. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 138
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 7. /var/www/nextcloud/apps/polls/lib/Service/WatchService.php line 92
    OCP\AppFramework\Db\QBMapper->insert()
 8. /var/www/nextcloud/apps/polls/lib/Listener/BaseListener.php line 160
    OCA\Polls\Service\WatchService->writeUpdate()
 9. /var/www/nextcloud/apps/polls/lib/Listener/BaseListener.php line 92
    OCA\Polls\Listener\BaseListener->writeWatch()
10. /var/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\Polls\Listener\BaseListener->handle()
11. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
12. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
13. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 87
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
14. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 99
    OC\EventDispatcher\EventDispatcher->dispatch()
15. /var/www/nextcloud/apps/polls/lib/Service/PollService.php line 285
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
16. /var/www/nextcloud/apps/polls/lib/Controller/PollController.php line 113
    OCA\Polls\Service\PollService->toggleArchive()
17. /var/www/nextcloud/apps/polls/lib/Controller/BaseController.php line 55
    OCA\Polls\Controller\PollController->OCA\Polls\Controller\{closure}("*** sensitive parameters replaced ***")
18. /var/www/nextcloud/apps/polls/lib/Controller/PollController.php line 113
    OCA\Polls\Controller\BaseController->response()
19. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Polls\Controller\PollController->toggleArchive()
20. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController()
21. /var/www/nextcloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch()
22. /var/www/nextcloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
23. /var/www/nextcloud/lib/base.php line 1056
    OC\Route\Router->match()
24. /var/www/nextcloud/index.php line 36
    OC::handleRequest()

PUT /apps/polls/poll/107/toggleArchive

Nextcloud version (eg, 20.0.5): 26.0.1
Operating system and version (eg, Ubuntu 20.04): 22.04 LTS
nginx version (eg, Apache 2.4.25): 1.18.0
PHP version (eg, 7.4): 8.2.7

The issue you are facing:
Polls doesn´t create dates

Is this the first time you’ve seen this error? (Y/N): yes, since I worked the first time with it since update

Anyone, any idea?

Best Joon

tflidd · June 23, 2023, 10:49am

Someone is reporting a similar error message:

github.com/nextcloud/polls

Unable to add date options in NC26

opened 08:55AM - 02 Jun 23 UTC

ttenroK

needs info

### ⚠️ This issue respects the following points: ⚠️ - [X] This is a **bug**, …not a question or a configuration/webserver/proxy issue. - [X] This issue is **not** already reported on Github _(I've searched it)_. - [X] I agree to follow Nextcloud's [Code of Conduct](https://nextcloud.com/contribute/code-of-conduct/). ### What went wrong, what did you observe? After the upgrade to NC26 it isn't possible to add new date options to a poll. After trying to add a date, an error appears at the right top, e.g. "Fehler beim Hinzufügen von 5. Juni 2023"/"Error when adding 5 June 2023". ### What did you expect, how polls should behave instead? Instead, the date option should be added to the poll. ### What steps does it need to replay this bug? 1. Upgrade to NC26 2. Create a new poll 3. Try to add a new date as option ### 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.5 ### Which browser did you use, when experiencing the bug? - [X] Firefox - [ ] Chrome - [X] Chromium/Chromium based (i.e. Edge) - [ ] Safari - [ ] Other/Don't know ### Other browser _No response_ ### Which System did you use, when experiencing the bug? - [ ] Windows - [X] Linux - [ ] MacOs - [ ] iOS - [ ] Android - [ ] Other/Don't know ### Other OS _No response_ ### Add your browser log here ```shell JQMIGRATE: Migrate is installed, version 3.4.0 jquery-migrate.min.js:2:698 session heartbeat polling started session-heartbeat.js:103:9 Registering notifications container as a menu NotificationsApp.vue:219 Notifications permissions granted NotificationsApp.vue:453 Has notify_push enabled, slowing polling to 15 minutes NotificationsApp.vue:231 Polling interval updated to 900000 NotificationsApp.vue:413 Started background fetcher as session_keepalive is enabled NotificationsApp.vue:275 Got notification data NotificationsApp.vue:376 Polling interval updated to 900000 NotificationsApp.vue:413 XHRPOST https://<mydomain>/apps/polls/option [HTTP/2 500 Internal Server Error 551ms] Error adding option: <!DOCTYPE html> <html> <head> <title>Internal Server Error - Storage Share - Hetzner Online GmbH</title> <meta charset="UTF-8"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0" name="viewport"> <link rel="apple-touch-icon" sizes="180x180" href="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAALQAAAC0CAMAAAAKE/YAAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAA9lBMVEXVDC3bMEzqiJjzucP1xc33ztX1xs7zusTri5vcNFDWFDTjX3XtlaTvo6/xrrnvpLHtmaflaH3YGzrndIf++/z//////f3oe43eQlz75ur98vPjWnHcM0///P3//v7dO1XWFTT76Ov+9/jaKUbqhpbskaDjXHLpfpDxr7rzu8XriprxrLf2ytHtmKbzvMX0vcb2zNPum6n0v8j2zdT3z9b30Nf30df42N3bLEnwqLT76u3unqv2ydDunKnsj57qhZbskJ/kZnrpgJHbL0v++vvcN1LXGjn87/HmcYThUGf99PXqhJXwqbXwqrbZI0HmcIPwpbLZJEIhxI7dAAAAAWJLR0QV5dj5owAAAAlwSFlzAAAFMQAABTEBt+0oUgAAAAd0SU1FB… Object { error: {…} } Object { payload: {…} } options.js:185:3 ``` ### Additional client environment information Nextcloud is hosted on Hetzner-servers ### NC version Nextcloud 26 (Nextcloud Hub 4) ### Other Nextcloud version _No response_ ### PHP engine version Other/Don't know ### Other PHP version 8.2 ### Database engine MySQL ### Database Engine version or other Database 10.5 ### Which user-backends are you using? - [X] Default user-backend _(database)_ - [ ] LDAP/ Active Directory - [ ] SSO - SAML - [ ] Other/Don't know ### Add your nextcloud server log here ```shell - ``` ### Additional environment informations _No response_ ### Configuration report _No response_ ### List of activated Apps ```shell Enabled: - activity: 2.18.0 - appointments: 1.15.1 - audioplayer: 3.3.1 - bruteforcesettings: 2.6.0 - cadviewer: 8.70.4 - calendar: 4.3.4 - calendar_news: 1.1.7 - calendar_resource_management: 0.5.0 - circles: 26.0.0 - cloud_federation_api: 1.9.0 - collectives: 2.5.0 - comments: 1.16.0 - contacts: 5.2.0 - contactsinteraction: 1.7.0 - dashboard: 7.6.0 - dav: 1.25.0 - documentserver_community: 0.1.13 - external: 5.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_pdfviewer: 2.7.0 - files_rightclick: 1.5.0 - files_sharing: 1.18.0 - files_trashbin: 1.16.0 - files_versions: 1.19.1 - files_zip: 1.4.0 - firstrunwizard: 2.15.0 - forms: 3.3.0 - fulltextsearch_elasticsearch: 26.0.0 - groupfolders: 14.0.2 - logreader: 2.11.0 - lookup_server_connector: 1.14.0 - memories: 5.1.0 - nextcloud_announcements: 1.15.0 - notifications: 2.14.0 - notify_push: 0.6.3 - oauth2: 1.14.0 - onlyoffice: 7.8.0 - password_policy: 1.16.0 - photos: 2.2.0 - polls: 5.0.5 - previewgenerator: 5.3.0 - privacy: 1.10.0 - provisioning_api: 1.16.0 - recommendations: 1.5.0 - registration: 2.1.0 - related_resources: 1.1.0-alpha1 - serverinfo_hetzner: 1.18.0 - settings: 1.8.0 - sharebymail: 1.16.0 - spreed: 16.0.4 - support: 1.9.0 - survey_client: 1.14.0 - suspicious_login: 4.4.0 - systemtags: 1.16.0 - tables: 0.5.0 - talk_matterbridge: 1.26.0 - text: 3.7.2 - theming: 2.1.1 - twofactor_backupcodes: 1.15.0 - twofactor_totp: 8.0.0 - updatenotification: 1.16.0 - user_status: 1.6.0 - viewer: 1.10.0 - weather_status: 1.6.0 - workflowengine: 2.8.0 Disabled: - admin_audit: 1.16.0 - encryption: 2.14.0 - end_to_end_encryption: 1.12.5 (installed 1.12.5) - files_external: 1.18.0 - mail: 3.1.1 (installed 3.1.1) - ownpad: 0.7.1 (installed 0.7.1) - pandoc: 0.5.0 (installed 0.5.0) - richdocuments: 8.0.2 (installed 8.0.2) - theming_customcss: 1.14.0 (installed 1.14.0) - user_ldap: 1.16.0 - wopi: 3.5.11 (installed 3.5.11) ``` ### Nextcloud Signing status ```shell No errors have been found. ``` ### Additional Information _No response_

I am not sure if all the descriptions in this bug report are valid in your case. Either add some information of your setup (if you think it is the same), if it is too different, then perhaps open a new one. There is also a command further down to recreate the database for the polls. I don’t know if that is an option for you (check first if data might be lost or not, I’m not the developer).

Joon · June 23, 2023, 6:13pm

Hi tflidd,
thanks for the tipp. it resolved the problem.
Best Joon

dartcafe · June 29, 2023, 8:43am

Since I cannot identify any problem: How did you sove it in your case?

@tflidd The error trace seems to describe exact the same problem.

dartcafe · June 29, 2023, 1:08pm

Obviously a server restart fixes the problem. There seems to be some object caching issue.