search

nextcloud / polls

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

'Add a new Poll' Button missing, CRON errors while executing SQL #3409

Closed JannikRosendahl closed 5 months ago

JannikRosendahl commented 5 months ago

⚠️ This issue respects the following points: ⚠️

What went wrong, what did you observe?

The 'Add new Poll' Button is missing. The logs show errors from multiple apps, including core, index. Also there is a JS console error.

What did you expect, how polls should behave instead?

Button shown, no SQL errors.

What steps does it need to replay this bug?

  1. uninstall Polls
  2. install Polls 7.0.0
  3. open Polls App

Installation method

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

Installation type

First time installation

Affected polls version

7.0.0

Which browser did you use, when experiencing the bug?

Other browser

No response

Add your browser log here

{
  "stack": "r@https://<<nextcloud-url>>/custom_apps/polls/js/polls-main.js?v=4ce4ab63-36:2:2933666\nr@https://<<nextcloud-url>>/custom_apps/polls/js/polls-main.js?v=4ce4ab63-36:2:2940499\nE@https://<<nextcloud-url>>/custom_apps/polls/js/polls-main.js?v=4ce4ab63-36:2:2927703\n",
  "message": "Request failed with status code 500",
  "name": "AxiosError",
  "code": "ERR_BAD_RESPONSE",
  "config": {
    "transitional": {
      "silentJSONParsing": true,
      "forcedJSONParsing": true,
      "clarifyTimeoutError": false
    },
    "adapter": [
      "xhr",
      "http"
    ],
    "transformRequest": [
      null
    ],
    "transformResponse": [
      null
    ],
    "timeout": 0,
    "xsrfCookieName": "XSRF-TOKEN",
    "xsrfHeaderName": "X-XSRF-TOKEN",
    "maxContentLength": -1,
    "maxBodyLength": -1,
    "env": {},
    "headers": {
      "Accept": "application/json",
      "Content-Type": null,
      "requesttoken": "kYcAow0nrRsvHm8hF9A8sYXymI9oZOHxvElr1O1LMF8=:39BMlWNmyH1WaD9ZWb1O2M66q/kuC7amxhghkZ0bRhc=",
      "Nc-Polls-Client-Id": "5u0c01biya9",
      "Nc-Polls-Client-Time-Zone": "Europe/Berlin"
    },
    "baseURL": "/apps/polls/",
    "method": "get",
    "url": "administration/polls",
    "params": {
      "time": 1712055988539
    },
    "cancelToken": {
      "promise": {},
      "_listeners": []
    }
  },
  "request": {},
  "response": {
    "data": "<!DOCTYPE html>\n<html class=\"ng-csp\" data-placeholder-focus=\"false\" lang=\"en\" data-locale=\"en\" translate=\"no\" >\n\t<head\n data-requesttoken=\"\">\n\t\t<meta charset=\"utf-8\">\n\t\t<title>\n\t\t\tNextcloud\t\t</title>\n\t\t<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0, minimum-scale=1.0\">\n\t\t\t\t<meta name=\"apple-itunes-app\" content=\"app-id=1125420102\">\n\t\t\t\t<meta name=\"theme-color\" content=\"#dc3c05\">\n\t\t<link rel=\"icon\" href=\"/apps/theming/favicon?v=fc074d50\">\n\t\t<link rel=\"apple-touch-icon\" href=\"/apps/theming/icon?v=fc074d50\">\n\t\t<link rel=\"mask-icon\" sizes=\"any\" href=\"/core/img/favicon-mask.svg\" color=\"#dc3c05\">\n\t\t<link rel=\"manifest\" href=\"/apps/theming/manifest?v=fc074d50\" crossorigin=\"use-credentials\">\n\t\t<link rel=\"stylesheet\" href=\"/custom_apps/side_menu/css/sideMenu.css?v=03fb8bb3-36\">\n<link rel=\"stylesheet\" href=\"/core/css/styles.css?v=4ce4ab63-36\">\n<link rel=\"stylesheet\" href=\"/core/css/header.css?v=4ce4ab63-36\">\n<link rel=\"stylesheet\" href=\"/apps/theming/css/default.css?v=70e2b24f-36\">\n<link rel=\"stylesheet\" href=\"/core/css/guest.css?v=4ce4ab63-36\">\n\t\t<script nonce=\"UTdyL0d2V1dZUjdXeXZrN2xobW43NVJSTWhZOW1HOUU0MWdWbTUwbndMUT06RGUyekxKdlhCSGl2dktsRDJIVFZodDhaQVdCNzl6Z1RtUWxmM3UxM3R2dz0=\" defer src=\"/custom_apps/side_menu/js/sideMenu.js?v=4ce4ab63-36\"></script>\n\t\t<link rel=\"stylesheet\" href=\"/apps/side_menu/css/stylesheet?v=11\"></link><script defer nonce=\"UTdyL0d2V1dZUjdXeXZrN2xobW43NVJSTWhZOW1HOUU0MWdWbTUwbndMUT06RGUyekxKdlhCSGl2dktsRDJIVFZodDhaQVdCNzl6Z1RtUWxmM3UxM3R2dz0=\" src=\"/apps/side_menu/js/script?v=11\"></script>\t</head>\n\t<body id=\"body-login\">\n\t\t<noscript>\n\t<div id=\"nojavascript\">\n\t\t<div>\n\t\t\tThis application requires JavaScript for correct operation. Please <a href=\"https://www.enable-javascript.com/\" target=\"_blank\" rel=\"noreferrer noopener\">enable JavaScript</a> and reload the page.\t\t</div>\n\t</div>\n</noscript>\n\t\t\t\t\t<input type=\"hidden\" id=\"initial-state-core-versionHash\" value=\"IjRjZTRhYjYzIg==\">\n\t\t\t\t\t<input type=\"hidden\" id=\"initial-state-comments-maxAutoCompleteResults\" value=\"MTA=\">\n\t\t\t\t<div class=\"wrapper\">\n\t\t\t<div class=\"v-align\">\n\t\t\t\t\t\t\t\t\t<header>\n\t\t\t\t\t\t<div id=\"header\">\n\t\t\t\t\t\t\t<div class=\"logo\"></div>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</header>\n\t\t\t\t\t\t\t\t<main>\n\t\t\t\t\t<h1 class=\"hidden-visually\">\n\t\t\t\t\t\tNextcloud\t\t\t\t\t</h1>\n\t\t\t\t\t<div class=\"guest-box wide\">\n\t<h2>Internal Server Error</h2>\n\t<p>The server was unable to complete your request.</p>\n\t<p>If this happens again, please send the technical details below to the server administrator.</p>\n\t<p>More details can be found in the server log.</p>\n\n\t<h3>Technical details</h3>\n\t<ul>\n\t\t<li>Remote Address: 172.18.0.1</li>\n\t\t<li>Request ID: o7n1fy2nPtg16fIm2Fl5</li>\n\t\t\t</ul>\n\n\t</div>\n\t\t\t\t</main>\n\t\t\t</div>\n\t\t</div>\n\t\t\t\t<footer class=\"guest-box \">\n\t\t\t<p class=\"info\">\n\t\t\t\t<a href=\"https://<<nextcloud-url>>\" target=\"_blank\" rel=\"noreferrer noopener\" class=\"entity-name\">Nextcloud</a> – <<Department XY>\t\t\t</p>\n\t\t</footer>\n\t</body>\n</html>\n",
    "status": 500,
    "statusText": "",
    "headers": {
      "cache-control": "no-store, no-cache, must-revalidate",
      "content-security-policy": "default-src 'self'; script-src 'self' 'nonce-UTdyL0d2V1dZUjdXeXZrN2xobW43NVJSTWhZOW1HOUU0MWdWbTUwbndMUT06RGUyekxKdlhCSGl2dktsRDJIVFZodDhaQVdCNzl6Z1RtUWxmM3UxM3R2dz0='; style-src 'self' 'unsafe-inline'; frame-src *; img-src * data: blob:; font-src 'self' data:; media-src *; connect-src *; object-src 'none'; base-uri 'self';",
      "content-type": "text/html; charset=UTF-8",
      "date": "Tue, 02 Apr 2024 11:05:08 GMT",
      "expires": "Thu, 19 Nov 1981 08:52:00 GMT",
      "pragma": "no-cache",
      "referrer-policy": "no-referrer",
      "server": "openresty",
      "strict-transport-security": "max-age=31536000;",
      "x-content-type-options": "nosniff",
      "x-firefox-spdy": "h2",
      "x-frame-options": "SAMEORIGIN",
      "x-permitted-cross-domain-policies": "none",
      "x-robots-tag": "noindex, nofollow",
      "x-xss-protection": "1; mode=block"
    },
    "config": {
      "transitional": {
        "silentJSONParsing": true,
        "forcedJSONParsing": true,
        "clarifyTimeoutError": false
      },
      "adapter": [
        "xhr",
        "http"
      ],
      "transformRequest": [
        null
      ],
      "transformResponse": [
        null
      ],
      "timeout": 0,
      "xsrfCookieName": "XSRF-TOKEN",
      "xsrfHeaderName": "X-XSRF-TOKEN",
      "maxContentLength": -1,
      "maxBodyLength": -1,
      "env": {},
      "headers": {
        "Accept": "application/json",
        "Content-Type": null,
        "requesttoken": "kYcAow0nrRsvHm8hF9A8sYXymI9oZOHxvElr1O1LMF8=:39BMlWNmyH1WaD9ZWb1O2M66q/kuC7amxhghkZ0bRhc=",
        "Nc-Polls-Client-Id": "5u0c01biya9",
        "Nc-Polls-Client-Time-Zone": "Europe/Berlin"
      },
      "baseURL": "/apps/polls/",
      "method": "get",
      "url": "administration/polls",
      "params": {
        "time": 1712055988539
      },
      "cancelToken": {
        "promise": {},
        "_listeners": []
      }
    },
    "request": {}
  }
}

Error loading polls 
Object { error: {…} }
polls.js:204:11
    list polls.js:204

Error loading polls 
Object { error: {…} }
pollsAdmin.js:53:11
    list pollsAdmin.js:53

Additional client environment information

No response

NC version

Nextcloud 28

Other Nextcloud version

Nextcloud AIO v8.0.0, Nextcloud Hub 7 (28.0.3)

PHP engine version

Other/Don't know

Other PHP version

PHP 8.2.16 (cli)

Database engine

PostgreSQL

Database Engine version or other Database

postgres (PostgreSQL) 15.6

Which user-backends are you using?

Add your nextcloud server log here

{"reqId":"DXiNfIXaLlLMOVUQlCkd","level":3,"time":"2024-04-01T09:15:35+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":"Error while running background job (class: OCA\\Polls\\Cron\\AutoReminderCron, arguments: )","userAgent":"--","version":"28.0.3.2","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: 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":7,"Trace":[{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":295,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::","args":[["Doctrine\\DBAL\\Exception\\SyntaxErrorException"]]},{"file":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/polls/lib/Db/PollMapper.php","line":72,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"]]},{"file":"/var/www/html/custom_apps/polls/lib/Service/MailService.php","line":224,"function":"findAutoReminderPolls","class":"OCA\\Polls\\Db\\PollMapper","type":"->","args":[]},{"file":"/var/www/html/custom_apps/polls/lib/Cron/AutoReminderCron.php","line":49,"function":"sendAutoReminder","class":"OCA\\Polls\\Service\\MailService","type":"->","args":[]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":81,"function":"run","class":"OCA\\Polls\\Cron\\AutoReminderCron","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/var/www/html/cron.php","line":152,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"],["OC\\Log"]]}],"File":"/var/www/html/lib/private/DB/Exceptions/DbalException.php","Line":71,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\SyntaxErrorException","Message":"An exception occurred while executing a query: 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":7,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1938,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1880,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1105,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],"SELECT \"polls_polls\".*, coalesce(MAX(options.timestamp), 0) AS max_date, coalesce(MIN(options.timestamp), 1711962935) AS min_date, COUNT(\"user_vote\".\"vote_answer\") AS \"current_user_votes\", coalesce(shares.type, \"\") AS user_role, \"shares\".\"locked\" AS \"is_current_user_locked\" FROM \"oc_polls_polls\" \"polls_polls\" LEFT JOIN \"oc_polls_options\" \"options\" ON \"polls_polls\".\"id\" = \"options\".\"poll_id\" LEFT JOIN \"oc_polls_votes\" \"user_vote\" ON (\"user_vote\".\"poll_id\" = \"polls_polls\".\"id\") AND (\"user_vote\".\"user_id\" = ?) LEFT JOIN \"oc_polls_share\" \"shares\" ON (\"polls_polls\".\"id\" = \"shares\".\"poll_id\") AND (\"shares\".\"user_id\" = ?) AND (\"shares\".\"deleted\" = ?) WHERE \"polls_polls\".\"misc_settings\" LIKE ? GROUP BY \"polls_polls\".\"id\"",["","",0,"%\"autoReminder\":true%"],[2,2,1,2]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"polls_polls\".*, coalesce(MAX(options.timestamp), 0) AS max_date, coalesce(MIN(options.timestamp), 1711962935) AS min_date, COUNT(\"user_vote\".\"vote_answer\") AS \"current_user_votes\", coalesce(shares.type, \"\") AS user_role, \"shares\".\"locked\" AS \"is_current_user_locked\" FROM \"oc_polls_polls\" \"polls_polls\" LEFT JOIN \"oc_polls_options\" \"options\" ON \"polls_polls\".\"id\" = \"options\".\"poll_id\" LEFT JOIN \"oc_polls_votes\" \"user_vote\" ON (\"user_vote\".\"poll_id\" = \"polls_polls\".\"id\") AND (\"user_vote\".\"user_id\" = ?) LEFT JOIN \"oc_polls_share\" \"shares\" ON (\"polls_polls\".\"id\" = \"shares\".\"poll_id\") AND (\"shares\".\"user_id\" = ?) AND (\"shares\".\"deleted\" = ?) WHERE \"polls_polls\".\"misc_settings\" LIKE ? GROUP BY \"polls_polls\".\"id\"",["","",0,"%\"autoReminder\":true%"],[2,2,1,2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":341,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"polls_polls\".*, coalesce(MAX(options.timestamp), 0) AS max_date, coalesce(MIN(options.timestamp), 1711962935) AS min_date, COUNT(\"user_vote\".\"vote_answer\") AS \"current_user_votes\", coalesce(shares.type, \"\") AS user_role, \"shares\".\"locked\" AS \"is_current_user_locked\" FROM \"oc_polls_polls\" \"polls_polls\" LEFT JOIN \"oc_polls_options\" \"options\" ON \"polls_polls\".\"id\" = \"options\".\"poll_id\" LEFT JOIN \"oc_polls_votes\" \"user_vote\" ON (\"user_vote\".\"poll_id\" = \"polls_polls\".\"id\") AND (\"user_vote\".\"user_id\" = :dcValue1) LEFT JOIN \"oc_polls_share\" \"shares\" ON (\"polls_polls\".\"id\" = \"shares\".\"poll_id\") AND (\"shares\".\"user_id\" = :dcValue2) AND (\"shares\".\"deleted\" = :dcValue3) WHERE \"polls_polls\".\"misc_settings\" LIKE :dcValue4 GROUP BY \"polls_polls\".\"id\"",["","",0,"%\"autoReminder\":true%"],[2,2,1,2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":377,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/polls/lib/Db/PollMapper.php","line":72,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"]]},{"file":"/var/www/html/custom_apps/polls/lib/Service/MailService.php","line":224,"function":"findAutoReminderPolls","class":"OCA\\Polls\\Db\\PollMapper","type":"->","args":[]},{"file":"/var/www/html/custom_apps/polls/lib/Cron/AutoReminderCron.php","line":49,"function":"sendAutoReminder","class":"OCA\\Polls\\Service\\MailService","type":"->","args":[]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":81,"function":"run","class":"OCA\\Polls\\Cron\\AutoReminderCron","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/var/www/html/cron.php","line":152,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"],["OC\\Log"]]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php","Line":62,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","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":7,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[["PDOException",["42601",7,"ERROR:  zero-length delimited identifier at or near \"\"\"\"\nLINE 1: ...\") AS \"current_user_votes\", coalesce(shares.type, \"\") AS use...\n                                                             ^"]]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1098,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"polls_polls\".*, coalesce(MAX(options.timestamp), 0) AS max_date, coalesce(MIN(options.timestamp), 1711962935) AS min_date, COUNT(\"user_vote\".\"vote_answer\") AS \"current_user_votes\", coalesce(shares.type, \"\") AS user_role, \"shares\".\"locked\" AS \"is_current_user_locked\" FROM \"oc_polls_polls\" \"polls_polls\" LEFT JOIN \"oc_polls_options\" \"options\" ON \"polls_polls\".\"id\" = \"options\".\"poll_id\" LEFT JOIN \"oc_polls_votes\" \"user_vote\" ON (\"user_vote\".\"poll_id\" = \"polls_polls\".\"id\") AND (\"user_vote\".\"user_id\" = ?) LEFT JOIN \"oc_polls_share\" \"shares\" ON (\"polls_polls\".\"id\" = \"shares\".\"poll_id\") AND (\"shares\".\"user_id\" = ?) AND (\"shares\".\"deleted\" = ?) WHERE \"polls_polls\".\"misc_settings\" LIKE ? GROUP BY \"polls_polls\".\"id\"",["","",0,"%\"autoReminder\":true%"],[2,2,1,2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":341,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"polls_polls\".*, coalesce(MAX(options.timestamp), 0) AS max_date, coalesce(MIN(options.timestamp), 1711962935) AS min_date, COUNT(\"user_vote\".\"vote_answer\") AS \"current_user_votes\", coalesce(shares.type, \"\") AS user_role, \"shares\".\"locked\" AS \"is_current_user_locked\" FROM \"oc_polls_polls\" \"polls_polls\" LEFT JOIN \"oc_polls_options\" \"options\" ON \"polls_polls\".\"id\" = \"options\".\"poll_id\" LEFT JOIN \"oc_polls_votes\" \"user_vote\" ON (\"user_vote\".\"poll_id\" = \"polls_polls\".\"id\") AND (\"user_vote\".\"user_id\" = :dcValue1) LEFT JOIN \"oc_polls_share\" \"shares\" ON (\"polls_polls\".\"id\" = \"shares\".\"poll_id\") AND (\"shares\".\"user_id\" = :dcValue2) AND (\"shares\".\"deleted\" = :dcValue3) WHERE \"polls_polls\".\"misc_settings\" LIKE :dcValue4 GROUP BY \"polls_polls\".\"id\"",["","",0,"%\"autoReminder\":true%"],[2,2,1,2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":377,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/polls/lib/Db/PollMapper.php","line":72,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"]]},{"file":"/var/www/html/custom_apps/polls/lib/Service/MailService.php","line":224,"function":"findAutoReminderPolls","class":"OCA\\Polls\\Db\\PollMapper","type":"->","args":[]},{"file":"/var/www/html/custom_apps/polls/lib/Cron/AutoReminderCron.php","line":49,"function":"sendAutoReminder","class":"OCA\\Polls\\Service\\MailService","type":"->","args":[]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":81,"function":"run","class":"OCA\\Polls\\Cron\\AutoReminderCron","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/var/www/html/cron.php","line":152,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"],["OC\\Log"]]}],"File":"/var/www/html/3rdparty/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/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1098,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"polls_polls\".*, coalesce(MAX(options.timestamp), 0) AS max_date, coalesce(MIN(options.timestamp), 1711962935) AS min_date, COUNT(\"user_vote\".\"vote_answer\") AS \"current_user_votes\", coalesce(shares.type, \"\") AS user_role, \"shares\".\"locked\" AS \"is_current_user_locked\" FROM \"oc_polls_polls\" \"polls_polls\" LEFT JOIN \"oc_polls_options\" \"options\" ON \"polls_polls\".\"id\" = \"options\".\"poll_id\" LEFT JOIN \"oc_polls_votes\" \"user_vote\" ON (\"user_vote\".\"poll_id\" = \"polls_polls\".\"id\") AND (\"user_vote\".\"user_id\" = ?) LEFT JOIN \"oc_polls_share\" \"shares\" ON (\"polls_polls\".\"id\" = \"shares\".\"poll_id\") AND (\"shares\".\"user_id\" = ?) AND (\"shares\".\"deleted\" = ?) WHERE \"polls_polls\".\"misc_settings\" LIKE ? GROUP BY \"polls_polls\".\"id\"",["","",0,"%\"autoReminder\":true%"],[2,2,1,2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":341,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"polls_polls\".*, coalesce(MAX(options.timestamp), 0) AS max_date, coalesce(MIN(options.timestamp), 1711962935) AS min_date, COUNT(\"user_vote\".\"vote_answer\") AS \"current_user_votes\", coalesce(shares.type, \"\") AS user_role, \"shares\".\"locked\" AS \"is_current_user_locked\" FROM \"oc_polls_polls\" \"polls_polls\" LEFT JOIN \"oc_polls_options\" \"options\" ON \"polls_polls\".\"id\" = \"options\".\"poll_id\" LEFT JOIN \"oc_polls_votes\" \"user_vote\" ON (\"user_vote\".\"poll_id\" = \"polls_polls\".\"id\") AND (\"user_vote\".\"user_id\" = :dcValue1) LEFT JOIN \"oc_polls_share\" \"shares\" ON (\"polls_polls\".\"id\" = \"shares\".\"poll_id\") AND (\"shares\".\"user_id\" = :dcValue2) AND (\"shares\".\"deleted\" = :dcValue3) WHERE \"polls_polls\".\"misc_settings\" LIKE :dcValue4 GROUP BY \"polls_polls\".\"id\"",["","",0,"%\"autoReminder\":true%"],[2,2,1,2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":377,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/polls/lib/Db/PollMapper.php","line":72,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"]]},{"file":"/var/www/html/custom_apps/polls/lib/Service/MailService.php","line":224,"function":"findAutoReminderPolls","class":"OCA\\Polls\\Db\\PollMapper","type":"->","args":[]},{"file":"/var/www/html/custom_apps/polls/lib/Cron/AutoReminderCron.php","line":49,"function":"sendAutoReminder","class":"OCA\\Polls\\Service\\MailService","type":"->","args":[]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":81,"function":"run","class":"OCA\\Polls\\Cron\\AutoReminderCron","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/var/www/html/cron.php","line":152,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"],["OC\\Log"]]}],"File":"/var/www/html/3rdparty/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

Nextcloud is installed via Nextcloud AIO. The original instance is quite old and has been migrated from MySQL to PostgreSQL in the past. The following tables exist in the db, all of them are empty: oc_polls_comments, oc_polls_log, oc_polls_notif, oc_polls_options, oc_polls_polls, oc_polls_preferences, oc_polls_share, oc_polls_votes, oc_polls_watch.

Configuration report

{
    "system": {
        "proxy": "proxy.<<url>>:3128",
        "default_phone_region": "DE",
        "one-click-instance": true,
        "one-click-instance.user-limit": 100,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "apps_paths": [
            {
                "path": "\/var\/www\/html\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/var\/www\/html\/custom_apps",
                "url": "\/custom_apps",
                "writable": true
            }
        ],
        "appsallowlist": false,
        "check_data_directory_permissions": false,
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "password": "***REMOVED SENSITIVE VALUE***",
            "port": 6379
        },
        "overwritehost": "cloud.<<url>>",
        "overwriteprotocol": "https",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost",
            "cloud.<<url>>",
            "proxy.<<url>>"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "pgsql",
        "version": "28.0.3.2",
        "overwrite.cli.url": "https:\/\/cloud.<<url>>\/",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "maintenance": false,
        "loglevel": "2",
        "log_type": "file",
        "logfile": "\/var\/www\/html\/data\/nextcloud.log",
        "log_rotate_size": "10485760",
        "log.condition": {
            "apps": [
                "admin_audit"
            ]
        },
        "preview_max_x": "2048",
        "preview_max_y": "2048",
        "jpeg_quality": "60",
        "enabledPreviewProviders": {
            "1": "OC\\Preview\\Image",
            "2": "OC\\Preview\\MarkDown",
            "3": "OC\\Preview\\MP3",
            "4": "OC\\Preview\\TXT",
            "5": "OC\\Preview\\OpenDocument",
            "6": "OC\\Preview\\Movie",
            "7": "OC\\Preview\\Krita",
            "0": "OC\\Preview\\Imaginary"
        },
        "enable_previews": true,
        "upgrade.disable-web": true,
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "trashbin_retention_obligation": "auto, 30",
        "versions_retention_obligation": "auto, 30",
        "activity_expire_days": "30",
        "simpleSignUpLink.shown": false,
        "share_folder": "\/Shared",
        "one-click-instance.link": "https:\/\/nextcloud.com\/all-in-one\/",
        "upgrade.cli-upgrade-link": "https:\/\/github.com\/nextcloud\/all-in-one\/discussions\/2726",
        "updatedirectory": "\/nc-updater",
        "davstorage.request_timeout": 3600,
        "htaccess.RewriteBase": "\/",
        "dbpersistent": false,
        "files_external_allow_create_new_local": true,
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "allow_local_remote_servers": true,
        "preview_imaginary_url": "***REMOVED SENSITIVE VALUE***",
        "updater.release.channel": "stable",
        "app_install_overwrite": [
            "nextcloud-aio"
        ],
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "maintenance_window_start": 1,
        "preview_imaginary_key": "b3de1ee810ba8785bef42948e7e465338f3440b258db15b3"
    }
}

List of activated Apps

Enabled:
  - activity: 2.20.0
  - admin_audit: 1.18.0
  - announcementcenter: 6.8.1
  - appointments: 2.0.4
  - bookmarks: 13.1.3
  - bruteforcesettings: 2.8.0
  - calendar: 4.7.0-alpha.1
  - circles: 28.0.0-dev
  - cloud_federation_api: 1.11.0
  - collectives: 2.10.1
  - comments: 1.18.0
  - contacts: 5.5.3
  - contactsinteraction: 1.9.0
  - dashboard: 7.8.0
  - dav: 1.29.1
  - deck: 1.12.2
  - event_update_notification: 2.3.0
  - federatedfilesharing: 1.18.0
  - federation: 1.18.0
  - files: 2.0.0
  - files_pdfviewer: 2.9.0
  - files_reminders: 1.1.0
  - files_sharing: 1.20.0
  - files_trashbin: 1.18.0
  - files_versions: 1.21.0
  - firstrunwizard: 2.17.0
  - flow_notifications: 1.8.0
  - forms: 4.1.1
  - groupfolders: 16.0.5
  - logreader: 2.13.0
  - lookup_server_connector: 1.16.0
  - nextcloud-aio: 0.4.0
  - nextcloud_announcements: 1.17.0
  - notes: 4.9.4
  - notifications: 2.16.0
  - notify_push: 0.6.10
  - oauth2: 1.16.3
  - password_policy: 1.18.0
  - passwords: 2024.3.10
  - polls: 7.0.0
  - privacy: 1.12.0
  - provisioning_api: 1.18.0
  - recommendations: 2.0.0
  - related_resources: 1.3.0
  - richdocuments: 8.3.3
  - richdocumentscode: 23.5.1001
  - serverinfo: 1.18.0
  - settings: 1.10.1
  - sharebymail: 1.18.0
  - side_menu: 3.11.8
  - spreed: 18.0.5
  - support: 1.11.0
  - survey_client: 1.16.0
  - systemtags: 1.18.0
  - text: 3.9.1
  - theming: 2.3.0
  - twofactor_admin: 4.5.0
  - twofactor_backupcodes: 1.17.0
  - twofactor_totp: 10.0.0-beta.2
  - user_status: 1.8.1
  - viewer: 2.2.0
  - weather_status: 1.8.0
  - workflowengine: 2.10.0
Disabled:
  - encryption: 2.16.0
  - files_external: 1.20.0
  - files_rightclick: 0.15.1 (installed 1.6.0)
  - keeweb: 0.6.17 (installed 0.6.17)
  - mail: 3.6.0-beta.1 (installed 3.6.0-beta.1)
  - photos: 2.4.0 (installed 1.0.0)
  - suspicious_login: 6.0.0
  - updatenotification: 1.18.0 (installed 1.17.0)
  - user_ldap: 1.19.0
  - workflow_script: 1.13.0 (installed 1.13.0)

Nextcloud Signing status

No errors have been found.

Additional Information

Maybe related to this? Changing any user settings does not do anything tho.

dartcafe commented 5 months ago

Yes https://github.com/nextcloud/polls/issues/3283

RaHoni commented 5 months ago

Hey I have the same Issue with this error message but simply changing a setting does not work.

github-actions[bot] commented 3 months ago

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