Nextcloud BOX version 11.0.0 (production)
I am facing the issue as already reported here:
–>
Error while running background job (Doctrine\DBAL\Exception\SyntaxErrorException): An exception occurred while executing ‘DELETE FROM oc_activity_mq WHERE amq_timestamp <= ? AND amq_affecteduser IN ()’ with params [1484683659]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1
OCA\Activity\BackgroundJob\EmailNotification ):
/snap/nextcloud/550/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128: Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(‘An exception oc…’, Object(Doctrine\DBAL\Driver\PDOException))
/snap/nextcloud/550/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php - line 177: Doctrine\DBAL\DBALException driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), ‘DELETE FROM `oc…’, Array)
/snap/nextcloud/550/htdocs/apps/activity/lib/MailQueueHandler.php - line 334: Doctrine\DBAL\Statement->execute(Array)
/snap/nextcloud/550/htdocs/apps/activity/lib/BackgroundJob/EmailNotification.php - line 131: OCA\Activity\MailQueueHandler->deleteSentItems(Array, 1484683659)
/snap/nextcloud/550/htdocs/apps/activity/lib/BackgroundJob/EmailNotification.php - line 81: OCA\Activity\BackgroundJob\EmailNotification->runStep(500, 1484683659)
/snap/nextcloud/550/htdocs/lib/private/BackgroundJob/Job.php - line 53: OCA\Activity\BackgroundJob\EmailNotification->run(NULL)
/snap/nextcloud/550/htdocs/lib/private/BackgroundJob/TimedJob.php - line 54: OC\BackgroundJob\Job->execute(Object(OC\BackgroundJob\JobList), Object(OC\Log))
/snap/nextcloud/550/htdocs/cron.php - line 121: OC\BackgroundJob\TimedJob->execute(Object(OC\BackgroundJob\JobList), Object(OC\Log))
{main}
The solution is as I saw, is to modify MailQueueHandler.php.
But as the nextcloud BOX uses snaps, I can not modify it.
So, should I just wait for a service release?
thx