search

julien-nc / cospend-nc

💰 💲hared budget manager Nextcloud app
GNU Affero General Public License v3.0
213 stars 29 forks source link

Error while running background job (class: OCA\\Polls\\Cron\\AutoReminderCron, arguments: ) #268

Closed witchent closed 3 months ago

witchent commented 3 months ago

Since yesterday I seem to get an error every cron run, and I don't know why (I can't remember changing anything that could be connected to this. The full error log is below. Any idea what I could do to fix this without deleting all cospend data?

{
  "reqId": "6QDCuQvmAJ0eyng0v2bY",
  "level": 3,
  "time": "2024-03-28T08:01:38+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), 1711612898) 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), 1711612898) 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": 337,
          "function": "executeQuery",
          "class": "OC\\DB\\Connection",
          "type": "->",
          "args": [
            "SELECT \"polls_polls\".*, coalesce(MAX(options.timestamp), 0) AS max_date, coalesce(MIN(options.timestamp), 1711612898) 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), 1711612898) 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": 337,
            "function": "executeQuery",
            "class": "OC\\DB\\Connection",
            "type": "->",
            "args": [
              "SELECT \"polls_polls\".*, coalesce(MAX(options.timestamp), 0) AS max_date, coalesce(MIN(options.timestamp), 1711612898) 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), 1711612898) 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": 337,
              "function": "executeQuery",
              "class": "OC\\DB\\Connection",
              "type": "->",
              "args": [
                "SELECT \"polls_polls\".*, coalesce(MAX(options.timestamp), 0) AS max_date, coalesce(MIN(options.timestamp), 1711612898) 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: )"
  },
  "id": "66052518a6693"
}
julien-nc commented 3 months ago

Hi, this is not related with Cospend at all. The running job is OCA\\Polls\\Cron\\AutoReminderCron from the polls app. You can report this issue (or check if someone did) there: https://github.com/nextcloud/polls/issues

witchent commented 3 months ago

Oh my god, I have no idea why I filled it here instead of over at polls. I am so sorry for wasting your time.

julien-nc commented 3 months ago

No worries. Thank you for the effort of reporting issues.