Support intro
Sorry to hear you’re facing problems
help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.
In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:
example
Or for longer, use three backticks above and below the code snippet:
longer
example
here
Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can
Nextcloud version : 26.0.1
Operating system and version : Debian Bullseye
Apache or nginx version : Apache/2.4.56 (Debian) - built: 2023-04-02T03:06:01
PHP version : 8.1.19
The issue you are facing:
Attempting to create and modify POLL I get an error message (pop up says: error writing the POLL, error saving the POLL)
The POLL app was working fine on version 24, we then upgraded to 25 and 26 in sequence (we did not use 25) now testing the POLL for the first time after the upgrade is showing the error described below.
Steps to replicate it:
- create ane poll
- modify it by adding a date
- modify by adding a comment
The output of your Nextcloud log in Admin > Logging:
pop up says: error writing the POLL, error saving the POLL
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'htaccess.RewriteBase' => '/',
'memcache.local' => '\\OC\\Memcache\\APCu',
'apps_paths' =>
array (
0 =>
array (
'path' => '/var/www/html/apps',
'url' => '/apps',
'writable' => false,
),
1 =>
array (
'path' => '/var/www/html/custom_apps',
'url' => '/custom_apps',
'writable' => true,
),
),
'instanceid' => '',
'passwordsalt' => '',
'secret' => '',
'trusted_domains' =>
array (
0 => '',
1 => '',
2 => '',
3 => '',
),
'trusted_proxies' =>
array (
0 => 'localhost',
1 => '',
),
'datadirectory' => '/var/www/html/data',
'dbtype' => 'mysql',
'version' => '26.0.1.1',
'overwrite.cli.url' => '',
'dbname' => 'nextcloud',
'dbhost' => 'nextcloud_db:3306',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => '',
'dbpassword' => '',
'installed' => true,
'allow_local_remote_servers' => 'true',
'maintenance' => false,
'allow_user_to_change_display_name' => false,
'lost_password_link' => 'disabled',
'overwriteprotocol' => 'https',
'oidc_login_provider_url' => '',
'oidc_login_client_id' => '',
'oidc_login_client_secret' => '',
'oidc_login_auto_redirect' => true,
'oidc_login_logout_url' => '',
'oidc_login_end_session_redirect' => false,
'oidc_login_redir_fallback' => true,
'oidc_login_attributes' =>
array (
'id' => 'preferred_username',
'mail' => 'email',
),
'oidc_login_default_quota' => '1000000000',
'oidc_login_button_text' => 'Log in with OpenID',
'oidc_login_hide_password_form' => false,
'oidc_login_use_id_token' => false,
'oidc_login_default_group' => 'oidc',
'oidc_login_use_external_storage' => false,
'oidc_login_scope' => 'openid profile',
'oidc_login_proxy_ldap' => false,
'oidc_login_disable_registration' => true,
'oidc_login_alt_login_page' => 'assets/login.php',
'oidc_login_tls_verify' => true,
'oidc_create_groups' => false,
'oidc_login_webdav_enabled' => false,
'oidc_login_password_authentication' => false,
'oidc_login_public_key_caching_time' => 86400,
'oidc_login_min_time_between_jwks_requests' => 10,
'oidc_login_well_known_caching_time' => 86400,
'oidc_login_update_avatar' => false,
'oidc_login_skip_proxy' => false,
'mail_smtpmode' => 'smtp',
'mail_smtpsecure' => 'ssl',
'mail_sendmailmode' => 'smtp',
'mail_from_address' => 'adc-support',
'mail_domain' => 'met.no',
'mail_smtpauthtype' => 'PLAIN',
'mail_smtpauth' => 1,
'mail_smtphost' => '',
'mail_smtpport' => '',
'mail_smtpname' => '',
'mail_smtppassword' => '',
'memcache.locking' => '\\OC\\Memcache\\Redis',
'memcache.distributed' => '\\OC\\Memcache\\Redis',
'redis' =>
array (
'host' => 'redis',
'port' => 6379,
'dbindex' => 0,
'password' => '',
'timeout' => 1.5,
),
'loglevel' => 0,
'app_install_overwrite' =>
array (
0 => 'files_accesscontrol',
),
'updater.secret' => '',
);
Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.
OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'poll_option_hash' in 'field list'```
extended log:
[index] Error: 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/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 328
OC\DB\Exceptions\DbalException::wrap(["Doctrine\\DBAL ... "])
1. /var/www/html/lib/public/AppFramework/Db/QBMapper.php line 138
OC\DB\QueryBuilder\QueryBuilder->executeStatement()
2. /var/www/html/custom_apps/polls/lib/Service/WatchService.php line 92
OCP\AppFramework\Db\QBMapper->insert(["OCA\\Polls\\Db\\Watch",null])
3. /var/www/html/custom_apps/polls/lib/Listener/BaseListener.php line 160
OCA\Polls\Service\WatchService->writeUpdate(7, "comments")
4. /var/www/html/custom_apps/polls/lib/Listener/BaseListener.php line 92
OCA\Polls\Listener\BaseListener->writeWatch()
5. /var/www/html/lib/private/EventDispatcher/ServiceEventListener.php line 86
OCA\Polls\Listener\BaseListener->handle(["OCA\\Polls\\Event\\CommentAddEvent"])
6. /var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
OC\EventDispatcher\ServiceEventListener->__invoke(["OCA\\Polls\\Event\\CommentAddEvent"], "OCA\\Polls\\Event\\CommentAddEvent", ["Symfony\\Compo ... "])
7. /var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
Symfony\Component\EventDispatcher\EventDispatcher->callListeners([["Closure"]], "OCA\\Polls\\Event\\CommentAddEvent", ["OCA\\Polls\\Event\\CommentAddEvent"])
8. /var/www/html/lib/private/EventDispatcher/EventDispatcher.php line 87
Symfony\Component\EventDispatcher\EventDispatcher->dispatch(["OCA\\Polls\\Event\\CommentAddEvent"], "OCA\\Polls\\Event\\CommentAddEvent")
9. /var/www/html/lib/private/EventDispatcher/EventDispatcher.php line 99
OC\EventDispatcher\EventDispatcher->dispatch("OCA\\Polls\\Event\\CommentAddEvent", ["OCA\\Polls\\Event\\CommentAddEvent"])
10. /var/www/html/custom_apps/polls/lib/Service/CommentService.php line 110
OC\EventDispatcher\EventDispatcher->dispatchTyped(["OCA\\Polls\\Event\\CommentAddEvent"])
11. /var/www/html/custom_apps/polls/lib/Controller/CommentController.php line 59
OCA\Polls\Service\CommentService->add("new comment", ["OCA\\Polls\\Model\\Acl"])
12. /var/www/html/custom_apps/polls/lib/Controller/BaseController.php line 55
OCA\Polls\Controller\CommentController->OCA\Polls\Controller\{closure}("*** sensitive parameters replaced ***")
13. /var/www/html/custom_apps/polls/lib/Controller/CommentController.php line 60
OCA\Polls\Controller\BaseController->response(["Closure"])
14. /var/www/html/lib/private/AppFramework/Http/Dispatcher.php line 230
OCA\Polls\Controller\CommentController->add(7, "new comment")
15. /var/www/html/lib/private/AppFramework/Http/Dispatcher.php line 137
OC\AppFramework\Http\Dispatcher->executeController(["OCA\\Polls\\Co ... "], "add")
16. /var/www/html/lib/private/AppFramework/App.php line 183
OC\AppFramework\Http\Dispatcher->dispatch(["OCA\\Polls\\Co ... "], "add")
17. /var/www/html/lib/private/Route/Router.php line 315
OC\AppFramework\App::main("OCA\\Polls\\Con ... r", "add", ["OC\\AppFramewo ... "], ["7","polls.comment.add"])
18. /var/www/html/lib/base.php line 1056
OC\Route\Router->match("/apps/polls/poll/7/comment")
19. /var/www/html/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/html/3rdparty/doctrine/dbal/src/Connection.php line 1814
Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(["Doctrine\\DBAL ... "], ["Doctrine\\DBAL\\Query"])
1. /var/www/html/3rdparty/doctrine/dbal/src/Connection.php line 1749
Doctrine\DBAL\Connection->handleDriverException(["Doctrine\\DBAL ... "], ["Doctrine\\DBAL\\Query"])
2. /var/www/html/3rdparty/doctrine/dbal/src/Connection.php line 1163
Doctrine\DBAL\Connection->convertExceptionDuringQuery(["Doctrine\\DBAL ... "], "INSERT INTO `oc ... )", [7,"comments","f ... "], [1,2,2])
3. /var/www/html/lib/private/DB/Connection.php line 297
Doctrine\DBAL\Connection->executeStatement("INSERT INTO `oc ... )", [7,"comments","f ... "], [1,2,2])
4. /var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
OC\DB\Connection->executeStatement("INSERT INTO `oc ... )", [7,"comments","f ... "], [1,2,2])
5. /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
Doctrine\DBAL\Query\QueryBuilder->execute()
6. /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
OC\DB\QueryBuilder\QueryBuilder->execute()
7. /var/www/html/lib/public/AppFramework/Db/QBMapper.php line 138
OC\DB\QueryBuilder\QueryBuilder->executeStatement()
8. /var/www/html/custom_apps/polls/lib/Service/WatchService.php line 92
OCP\AppFramework\Db\QBMapper->insert(["OCA\\Polls\\Db\\Watch",null])
9. /var/www/html/custom_apps/polls/lib/Listener/BaseListener.php line 160
OCA\Polls\Service\WatchService->writeUpdate(7, "comments")
10. /var/www/html/custom_apps/polls/lib/Listener/BaseListener.php line 92
OCA\Polls\Listener\BaseListener->writeWatch()
11. /var/www/html/lib/private/EventDispatcher/ServiceEventListener.php line 86
OCA\Polls\Listener\BaseListener->handle(["OCA\\Polls\\Event\\CommentAddEvent"])
12. /var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
OC\EventDispatcher\ServiceEventListener->__invoke(["OCA\\Polls\\Event\\CommentAddEvent"], "OCA\\Polls\\Event\\CommentAddEvent", ["Symfony\\Compo ... "])
13. /var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
Symfony\Component\EventDispatcher\EventDispatcher->callListeners([["Closure"]], "OCA\\Polls\\Event\\CommentAddEvent", ["OCA\\Polls\\Event\\CommentAddEvent"])
14. /var/www/html/lib/private/EventDispatcher/EventDispatcher.php line 87
Symfony\Component\EventDispatcher\EventDispatcher->dispatch(["OCA\\Polls\\Event\\CommentAddEvent"], "OCA\\Polls\\Event\\CommentAddEvent")
15. /var/www/html/lib/private/EventDispatcher/EventDispatcher.php line 99
OC\EventDispatcher\EventDispatcher->dispatch("OCA\\Polls\\Event\\CommentAddEvent", ["OCA\\Polls\\Event\\CommentAddEvent"])
16. /var/www/html/custom_apps/polls/lib/Service/CommentService.php line 110
OC\EventDispatcher\EventDispatcher->dispatchTyped(["OCA\\Polls\\Event\\CommentAddEvent"])
17. /var/www/html/custom_apps/polls/lib/Controller/CommentController.php line 59
OCA\Polls\Service\CommentService->add("new comment", ["OCA\\Polls\\Model\\Acl"])
18. /var/www/html/custom_apps/polls/lib/Controller/BaseController.php line 55
OCA\Polls\Controller\CommentController->OCA\Polls\Controller\{closure}("*** sensitive parameters replaced ***")
19. /var/www/html/custom_apps/polls/lib/Controller/CommentController.php line 60
OCA\Polls\Controller\BaseController->response(["Closure"])
20. /var/www/html/lib/private/AppFramework/Http/Dispatcher.php line 230
OCA\Polls\Controller\CommentController->add(7, "new comment")
21. /var/www/html/lib/private/AppFramework/Http/Dispatcher.php line 137
OC\AppFramework\Http\Dispatcher->executeController(["OCA\\Polls\\Co ... "], "add")
22. /var/www/html/lib/private/AppFramework/App.php line 183
OC\AppFramework\Http\Dispatcher->dispatch(["OCA\\Polls\\Co ... "], "add")
23. /var/www/html/lib/private/Route/Router.php line 315
OC\AppFramework\App::main("OCA\\Polls\\Con ... r", "add", ["OC\\AppFramewo ... "], ["7","polls.comment.add"])
24. /var/www/html/lib/base.php line 1056
OC\Route\Router->match("/apps/polls/poll/7/comment")
25. /var/www/html/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/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 103
Doctrine\DBAL\Driver\PDO\Exception::new(["PDOException", ... ]])
1. /var/www/html/3rdparty/doctrine/dbal/src/Connection.php line 1153
Doctrine\DBAL\Driver\PDO\Statement->execute()
2. /var/www/html/lib/private/DB/Connection.php line 297
Doctrine\DBAL\Connection->executeStatement("INSERT INTO `oc ... )", [7,"comments","f ... "], [1,2,2])
3. /var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
OC\DB\Connection->executeStatement("INSERT INTO `oc ... )", [7,"comments","f ... "], [1,2,2])
4. /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
Doctrine\DBAL\Query\QueryBuilder->execute()
5. /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
OC\DB\QueryBuilder\QueryBuilder->execute()
6. /var/www/html/lib/public/AppFramework/Db/QBMapper.php line 138
OC\DB\QueryBuilder\QueryBuilder->executeStatement()
7. /var/www/html/custom_apps/polls/lib/Service/WatchService.php line 92
OCP\AppFramework\Db\QBMapper->insert(["OCA\\Polls\\Db\\Watch",null])
8. /var/www/html/custom_apps/polls/lib/Listener/BaseListener.php line 160
OCA\Polls\Service\WatchService->writeUpdate(7, "comments")
9. /var/www/html/custom_apps/polls/lib/Listener/BaseListener.php line 92
OCA\Polls\Listener\BaseListener->writeWatch()
10. /var/www/html/lib/private/EventDispatcher/ServiceEventListener.php line 86
OCA\Polls\Listener\BaseListener->handle(["OCA\\Polls\\Event\\CommentAddEvent"])
11. /var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
OC\EventDispatcher\ServiceEventListener->__invoke(["OCA\\Polls\\Event\\CommentAddEvent"], "OCA\\Polls\\Event\\CommentAddEvent", ["Symfony\\Compo ... "])
12. /var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
Symfony\Component\EventDispatcher\EventDispatcher->callListeners([["Closure"]], "OCA\\Polls\\Event\\CommentAddEvent", ["OCA\\Polls\\Event\\CommentAddEvent"])
13. /var/www/html/lib/private/EventDispatcher/EventDispatcher.php line 87
Symfony\Component\EventDispatcher\EventDispatcher->dispatch(["OCA\\Polls\\Event\\CommentAddEvent"], "OCA\\Polls\\Event\\CommentAddEvent")
14. /var/www/html/lib/private/EventDispatcher/EventDispatcher.php line 99
OC\EventDispatcher\EventDispatcher->dispatch("OCA\\Polls\\Event\\CommentAddEvent", ["OCA\\Polls\\Event\\CommentAddEvent"])
15. /var/www/html/custom_apps/polls/lib/Service/CommentService.php line 110
OC\EventDispatcher\EventDispatcher->dispatchTyped(["OCA\\Polls\\Event\\CommentAddEvent"])
16. /var/www/html/custom_apps/polls/lib/Controller/CommentController.php line 59
OCA\Polls\Service\CommentService->add("new comment", ["OCA\\Polls\\Model\\Acl"])
17. /var/www/html/custom_apps/polls/lib/Controller/BaseController.php line 55
OCA\Polls\Controller\CommentController->OCA\Polls\Controller\{closure}("*** sensitive parameters replaced ***")
18. /var/www/html/custom_apps/polls/lib/Controller/CommentController.php line 60
OCA\Polls\Controller\BaseController->response(["Closure"])
19. /var/www/html/lib/private/AppFramework/Http/Dispatcher.php line 230
OCA\Polls\Controller\CommentController->add(7, "new comment")
20. /var/www/html/lib/private/AppFramework/Http/Dispatcher.php line 137
OC\AppFramework\Http\Dispatcher->executeController(["OCA\\Polls\\Co ... "], "add")
21. /var/www/html/lib/private/AppFramework/App.php line 183
OC\AppFramework\Http\Dispatcher->dispatch(["OCA\\Polls\\Co ... "], "add")
22. /var/www/html/lib/private/Route/Router.php line 315
OC\AppFramework\App::main("OCA\\Polls\\Con ... r", "add", ["OC\\AppFramewo ... "], ["7","polls.comment.add"])
23. /var/www/html/lib/base.php line 1056
OC\Route\Router->match("/apps/polls/poll/7/comment")
24. /var/www/html/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/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 101
PDOStatement->execute(null)
1. /var/www/html/3rdparty/doctrine/dbal/src/Connection.php line 1153
Doctrine\DBAL\Driver\PDO\Statement->execute()
2. /var/www/html/lib/private/DB/Connection.php line 297
Doctrine\DBAL\Connection->executeStatement("INSERT INTO `oc ... )", [7,"comments","f ... "], [1,2,2])
3. /var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
OC\DB\Connection->executeStatement("INSERT INTO `oc ... )", [7,"comments","f ... "], [1,2,2])
4. /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
Doctrine\DBAL\Query\QueryBuilder->execute()
5. /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
OC\DB\QueryBuilder\QueryBuilder->execute()
6. /var/www/html/lib/public/AppFramework/Db/QBMapper.php line 138
OC\DB\QueryBuilder\QueryBuilder->executeStatement()
7. /var/www/html/custom_apps/polls/lib/Service/WatchService.php line 92
OCP\AppFramework\Db\QBMapper->insert(["OCA\\Polls\\Db\\Watch",null])
8. /var/www/html/custom_apps/polls/lib/Listener/BaseListener.php line 160
OCA\Polls\Service\WatchService->writeUpdate(7, "comments")
9. /var/www/html/custom_apps/polls/lib/Listener/BaseListener.php line 92
OCA\Polls\Listener\BaseListener->writeWatch()
10. /var/www/html/lib/private/EventDispatcher/ServiceEventListener.php line 86
OCA\Polls\Listener\BaseListener->handle(["OCA\\Polls\\Event\\CommentAddEvent"])
11. /var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
OC\EventDispatcher\ServiceEventListener->__invoke(["OCA\\Polls\\Event\\CommentAddEvent"], "OCA\\Polls\\Event\\CommentAddEvent", ["Symfony\\Compo ... "])
12. /var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
Symfony\Component\EventDispatcher\EventDispatcher->callListeners([["Closure"]], "OCA\\Polls\\Event\\CommentAddEvent", ["OCA\\Polls\\Event\\CommentAddEvent"])
13. /var/www/html/lib/private/EventDispatcher/EventDispatcher.php line 87
Symfony\Component\EventDispatcher\EventDispatcher->dispatch(["OCA\\Polls\\Event\\CommentAddEvent"], "OCA\\Polls\\Event\\CommentAddEvent")
14. /var/www/html/lib/private/EventDispatcher/EventDispatcher.php line 99
OC\EventDispatcher\EventDispatcher->dispatch("OCA\\Polls\\Event\\CommentAddEvent", ["OCA\\Polls\\Event\\CommentAddEvent"])
15. /var/www/html/custom_apps/polls/lib/Service/CommentService.php line 110
OC\EventDispatcher\EventDispatcher->dispatchTyped(["OCA\\Polls\\Event\\CommentAddEvent"])
16. /var/www/html/custom_apps/polls/lib/Controller/CommentController.php line 59
OCA\Polls\Service\CommentService->add("new comment", ["OCA\\Polls\\Model\\Acl"])
17. /var/www/html/custom_apps/polls/lib/Controller/BaseController.php line 55
OCA\Polls\Controller\CommentController->OCA\Polls\Controller\{closure}("*** sensitive parameters replaced ***")
18. /var/www/html/custom_apps/polls/lib/Controller/CommentController.php line 60
OCA\Polls\Controller\BaseController->response(["Closure"])
19. /var/www/html/lib/private/AppFramework/Http/Dispatcher.php line 230
OCA\Polls\Controller\CommentController->add(7, "new comment")
20. /var/www/html/lib/private/AppFramework/Http/Dispatcher.php line 137
OC\AppFramework\Http\Dispatcher->executeController(["OCA\\Polls\\Co ... "], "add")
21. /var/www/html/lib/private/AppFramework/App.php line 183
OC\AppFramework\Http\Dispatcher->dispatch(["OCA\\Polls\\Co ... "], "add")
22. /var/www/html/lib/private/Route/Router.php line 315
OC\AppFramework\App::main("OCA\\Polls\\Con ... r", "add", ["OC\\AppFramewo ... "], ["7","polls.comment.add"])
23. /var/www/html/lib/base.php line 1056
OC\Route\Router->match("/apps/polls/poll/7/comment")
24. /var/www/html/index.php line 36
OC::handleRequest()
POST /apps/polls/poll/7/comment?time=1686121635339
from 84.215.129.204 by massimods at 2023-06-07T07:07:15+00:00```