Polls do not load after upgrade to 7.0.0 #3393
Comments
|
The changes below fix the issue for me. |
|
#!/bin/bash Define file pathsPOLL_MAPPER_FILE="./PollMapper.php" Create backupscp "$POLL_MAPPER_FILE" "${POLL_MAPPER_FILE}.bak" cp "$PREFERENCES_FILE" "${PREFERENCES_FILE}.bak" Apply changes to PollMapper.phpsed -i '/$qb->groupBy(self::TABLE . \x27.id\x27);/a \ $qb->addGroupBy(\x27shares.type\x27);\n $qb->addGroupBy(\x27shares.locked\x27);' "$POLL_MAPPER_FILE" Apply changes to Preferences.phpsed -i "s/return json_decode($this->getPreferences());/return json_decode($this->getPreferences() ?: '');/" "$PREFERENCES_FILE" echo "Script execution completed." you can try this script to implement the bugfix |
|
Ah. Don't care. I noticed a simple unit test was missing for recognizing this error in the CI process. |
|
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. |
What went wrong, what did you observe?
After upgrading the polls app, polls do not load.
What did you expect, how polls should behave instead?
The polls should load
What steps does it need to replay this bug?
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
7.0.0
Which browser did you use, when experiencing the bug?
Other browser
No response
Add your browser log here
No response
Additional client environment information
No response
NC version
Nextcloud 28
Other Nextcloud version
No response
PHP engine version
PHP 8.2
Other PHP version
No response
Database engine
PostgreSQL
Database Engine version or other Database
No response
Which user-backends are you using?
Add your nextcloud server log here
{ "reqId": "r2Knd5NPYRCnGXkqtt14", "level": 3, "time": "March 27, 2024 21:20:03", "remoteAddr": "", "user": "--", "app": "core", "method": "", "url": "--", "message":"Error while running bac kground job (class: OCA\\Polls\\Cron\\AutoReminderCron, arguments: )","userAgent":"--","version":"28.0.3.2","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Mes sage":"An exception occurred while executing a query: SQLSTATE[ 42601 ]: Syntax error: 7 ERROR: zero-length delimited identifier at or near \"\"\"\"\nLINE 1: ...\") AS \"curr ent_user_votes\", coalesce(shares.type, \"\") AS use...\n ^", "Code": 7, "Trace": [ { "file":"/var/www/obzorje/lib/priv ate/DB/QueryBuilder/QueryBuilder.php","line":295,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":": : "},{"file":"/var/www/obzorje/lib/public/AppFramework /Db/QBMapper.php","line":335,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/obzorje/apps/polls/lib/Db/PollMapper.php","line": 72, "function": "findEntities", "class": "OCP\\AppFramework\\Db\\QBMapper", "type": "->" }, { "file": "/var/www/obzorje/apps/polls/lib/Service/MailService.php", "line": 224,"func tion":"findAutoReminderPolls","class":"OCA\\Polls\\Db\\PollMapper","type":"->"},{"file":"/var/www/obzorje/apps/polls/lib/Cron/AutoReminderCron.php","line":49,"function":"sen dAutoReminder","class":"OCA\\Polls\\Service\\MailService","type":"->"},{"file":"/var/www/obzorje/lib/public/BackgroundJob/Job.php","line":81,"function":"run","class":"OCA\\P olls\\Cron\\AutoReminderCron","type":"->"},{"file":"/var/www/obzorje/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\\BackgroundJob\\Job"," type":"->"},{"file":"/var/www/obzorje/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/w ww/obzorje/cron.php","line":152,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/obzorje/lib/private/DB/Exceptions/DbalException.ph p","Line":71,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\SyntaxErrorException","Message":"An exception occurred while executing a query: SQLSTATE[ 42601 ]: Syntax erro r: 7 ERROR: zero-length delimited identifier at or near \"\"\"\"\nLINE 1: ...\") AS \"current_user_votes\", coalesce(shares.type, \"\") AS use...\n ^","Code":7,"Trace":[{"file":"/var/www/obzorje/3rdparty/doctrine/dbal/src/Connection.php","line":1938,"function":"convert","class":"Doctr ine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter","type":"->"},{"file":"/var/www/obzorje/3rdparty/doctrine/dbal/src/Connection.php","line":1880,"function":"handleDrive rException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/obzorje/3rdparty/doctrine/dbal/src/Connection.php","line":1105,"function":"convertExceptionDu ringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/obzorje/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\ \DBAL\\Connection","type":"->"},{"file":"/var/www/obzorje/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":337,"function":"executeQuery","class":"OC\\DB\\Connection ","type":"->"},{"file":"/var/www/obzorje/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":377,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder ","type":"->"},{"file":"/var/www/obzorje/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":" ->"},{"file":"/var/www/obzorje/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file ":"/var/www/obzorje/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www /obzorje/apps/polls/lib/Db/PollMapper.php","line":72,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/obzorje/apps/polls/li b/Service/MailService.php","line":224,"function":"findAutoReminderPolls","class":"OCA\\Polls\\Db\\PollMapper","type":"->"},{"file":"/var/www/obzorje/apps/polls/lib/Cron/Auto ReminderCron.php","line":49,"function":"sendAutoReminder","class":"OCA\\Polls\\Service\\MailService","type":"->"},{"file":"/var/www/obzorje/lib/public/BackgroundJob/Job.php", "line": 81, "function": "run", "class": "OCA\\Polls\\Cron\\AutoReminderCron", "type": "->" }, { "file": "/var/www/obzorje/lib/public/BackgroundJob/TimedJob.php", "line": 102, "function": "start", "class": "OCP\\BackgroundJob\\Job", "type": "->" }, { "file": "/var/www/obzorje/lib/public/BackgroundJob/TimedJob.php", "line": 92, "function": "start", "class":"OCP\\Background Job\\TimedJob","type":"->"},{"file":"/var/www/obzorje/cron.php","line":152,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/obzorje /apps/polls/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php","Line":62,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLS TATE[ 42601 ]: Syntax error: 7 ERROR: zero-length delimited identifier at or near \"\"\"\"\nLINE 1: ...\") AS \"current_user_votes\", coalesce(shares.type, \"\") AS use...\n ^","Code":7,"Trace":[{"file":"/var/www/obzorje/apps/polls/vendor/doctrine/dbal/src/Driver/PDO/Statement.php","lin e":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":": : "},{"file":"/var/www/obzorje/3rdparty/doctrine/dbal/src/Connection.php","line":1098,"funct ion":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/obzorje/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/obzorje/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":337,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/obzorje/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":377,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/obzorje/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/obzorje/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/obzorje/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/obzorje/apps/polls/lib/Db/PollMapper.php","line":72,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/obzorje/apps/polls/lib/Service/MailService.php","line":224,"function":"findAutoReminderPolls","class":"OCA\\Polls\\Db\\PollMapper","type":"->"},{"file":"/var/www/obzorje/apps/polls/lib/Cron/AutoReminderCron.php","line":49,"function":"sendAutoReminder","class":"OCA\\Polls\\Service\\MailService","type":"->"},{"file":"/var/www/obzorje/lib/public/BackgroundJob/Job.php","line":81,"function":"run","class":"OCA\\Polls\\Cron\\AutoReminderCron","type":"->"},{"file":"/var/www/obzorje/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/obzorje/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/obzorje/cron.php","line":152,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/obzorje/apps/polls/vendor/doctrine/dbal/src/Driver/PDO/Exception.php","Line":28,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[ 42601 ]: Syntax error: 7 ERROR: zero-length delimited identifier at or near \"\"\"\"\nLINE 1: ...\") AS \"current_user_votes\", coalesce(shares.type, \"\") AS use...\n ^", "Code": "42601", "Trace": [ { "file": "/var/www/obzorje/apps/polls/vendor/doctrine/dbal/src/Driver/PDO/Statement.php", "line": 130, "function": "execute", "class": "PDOStatement", "type": "->" }, { "file": "/var/www/obzorje/3rdparty/doctrine/dbal/src/Connection.php", "line": 1098, "function": "execute", "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement", "type": "->" }, { "file": "/var/www/obzorje/lib/private/DB/Connection.php", "line": 261, "function": "executeQuery", "class": "Doctrine\\DBAL\\Connection", "type": "->" }, { "file": "/var/www/obzorje/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php", "line": 337, "function": "executeQuery", "class": "OC\\DB\\Connection", "type": "->" }, { "file": "/var/www/obzorje/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php", "line": 377, "function": "executeQuery", "class": "Doctrine\\DBAL\\Query\\QueryBuilder", "type": "->" }, { "file": "/var/www/obzorje/lib/private/DB/QueryBuilder/QueryBuilder.php", "line": 280, "function": "execute", "class": "Doctrine\\DBAL\\Query\\QueryBuilder", "type": "->" }, { "file": "/var/www/obzorje/lib/private/DB/QueryBuilder/QueryBuilder.php", "line": 293, "function": "execute", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->" }, { "file": "/var/www/obzorje/lib/public/AppFramework/Db/QBMapper.php", "line": 335, "function": "executeQuery", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->" }, { "file": "/var/www/obzorje/apps/polls/lib/Db/PollMapper.php", "line": 72, "function": "findEntities", "class": "OCP\\AppFramework\\Db\\QBMapper", "type": "->" }, { "file": "/var/www/obzorje/apps/polls/lib/Service/MailService.php", "line": 224, "function": "findAutoReminderPolls", "class": "OCA\\Polls\\Db\\PollMapper", "type": "->" }, { "file": "/var/www/obzorje/apps/polls/lib/Cron/AutoReminderCron.php", "line": 49, "function": "sendAutoReminder", "class": "OCA\\Polls\\Service\\MailService", "type": "->" }, { "file": "/var/www/obzorje/lib/public/BackgroundJob/Job.php", "line": 81, "function": "run", "class": "OCA\\Polls\\Cron\\AutoReminderCron", "type": "->" }, { "file": "/var/www/obzorje/lib/public/BackgroundJob/TimedJob.php", "line": 102, "function": "start", "class": "OCP\\BackgroundJob\\Job", "type": "->" }, { "file": "/var/www/obzorje/lib/public/BackgroundJob/TimedJob.php", "line": 92, "function": "start", "class": "OCP\\BackgroundJob\\TimedJob", "type": "->" }, { "file": "/var/www/obzorje/cron.php", "line": 152, "function": "execute", "class": "OCP\\BackgroundJob\\TimedJob", "type": "->" } ], "File": "/var/www/obzorje/apps/polls/vendor/doctrine/dbal/src/Driver/PDO/Statement.php", "Line": 130 } } }, "message": "Error while running background job (class: OCA\\Polls\\Cron\\AutoReminderCron, arguments: )", "exception": {}, "CustomMessage": "Error while running background job (class: OCA\\Polls\\Cron\\AutoReminderCron, arguments: )" } }Additional environment informations
No response
Configuration report
{ "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "obzorje.kompot.si", "oo.kompot.si" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "pgsql", "version": "28.0.3.2", "overwrite.cli.url": "https:\/\/obzorje.kompot.si", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "mysql.utf8mb4": true, "ldapIgnoreNamingRules": false, "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory", "maintenance": false, "memcache.local": "\\OC\\Memcache\\APCu", "memcache.distributed": "\\OC\\Memcache\\Redis", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "timeout": 0, "dbindex": 0 }, "loglevel": 2, "log_type": "file", "logfile": "\/var\/log\/nextcloud\/nextcloud.log", "logfilemode": 416, "logdateformat": "F d, Y H:i:s", "onlyoffice": { "verify_peer_off": true, "jwt_secret": "***REMOVED SENSITIVE VALUE***", "jwt_header": "AuthorizationJwt" }, "allow_local_remote_servers": true, "lookup_server": "", "theme": "", "default_phone_region": "SI", "trusted_proxies": "***REMOVED SENSITIVE VALUE***", "app_install_overwrite": [ "files_texteditor", "onlyoffice", "files_markdown" ], "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "smtp", "mail_sendmailmode": "smtp", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "maintenance_window_start": 1 } }List of activated Apps
Nextcloud Signing status
Additional Information
No response
The text was updated successfully, but these errors were encountered: