Nextcloud version : 24.0.3
Operating system and version : 20.04.4 LTS
Apache or nginx version: Apache 2.4.41
PHP version : PHP 8.1.8
Hello everyone,
I’ve recently had an error in the log every two minutes.
OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'next_send_time' at row 1
Does anyone have any idea where that comes from?
Nextcloud Verion 24.0.2
Thanks in advance for your help.
Greetings, Sasha
Here’s the full message
Error core OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'next_send_time' at row 1
/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 329:
OC\DB\Exceptions\DbalException::wrap()
/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php - line 221:
OC\DB\QueryBuilder\QueryBuilder->executeStatement()
/var/www/nextcloud/apps/notifications/lib/MailNotifications.php - line 150:
OCP\AppFramework\Db\QBMapper->update("*** sensiti ... *")
/var/www/nextcloud/apps/notifications/lib/BackgroundJob/SendNotificationMails.php - line 49:
OCA\Notifications\MailNotifications->sendEmails()
/var/www/nextcloud/lib/public/BackgroundJob/Job.php - line 79:
OCA\Notifications\BackgroundJob\SendNotificationMails->run()
/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php - line 95:
OCP\BackgroundJob\Job->execute()
/var/www/nextcloud/cron.php - line 151:
OCP\BackgroundJob\TimedJob->execute()
Caused by Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'next_send_time' at row 1
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1780:
Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1719:
Doctrine\DBAL\Connection->handleDriverException()
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1173:
Doctrine\DBAL\Connection->convertExceptionDuringQuery()
/var/www/nextcloud/lib/private/DB/Connection.php - line 294:
Doctrine\DBAL\Connection->executeStatement()
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:
OC\DB\Connection->executeStatement()
/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 281:
Doctrine\DBAL\Query\QueryBuilder->execute()
/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 327:
OC\DB\QueryBuilder\QueryBuilder->execute()
/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php - line 221:
OC\DB\QueryBuilder\QueryBuilder->executeStatement()
/var/www/nextcloud/apps/notifications/lib/MailNotifications.php - line 150:
OCP\AppFramework\Db\QBMapper->update("*** sensiti ... *")
/var/www/nextcloud/apps/notifications/lib/BackgroundJob/SendNotificationMails.php - line 49:
OCA\Notifications\MailNotifications->sendEmails()
/var/www/nextcloud/lib/public/BackgroundJob/Job.php - line 79:
OCA\Notifications\BackgroundJob\SendNotificationMails->run()
/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php - line 95:
OCP\BackgroundJob\Job->execute()
/var/www/nextcloud/cron.php - line 151:
OCP\BackgroundJob\TimedJob->execute()
Caused by Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'next_send_time' at row 1
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 94:
Doctrine\DBAL\Driver\PDO\Exception::new()
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1163:
Doctrine\DBAL\Driver\PDO\Statement->execute()
/var/www/nextcloud/lib/private/DB/Connection.php - line 294:
Doctrine\DBAL\Connection->executeStatement()
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:
OC\DB\Connection->executeStatement()
/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 281:
Doctrine\DBAL\Query\QueryBuilder->execute()
/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 327:
OC\DB\QueryBuilder\QueryBuilder->execute()
/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php - line 221:
OC\DB\QueryBuilder\QueryBuilder->executeStatement()
/var/www/nextcloud/apps/notifications/lib/MailNotifications.php - line 150:
OCP\AppFramework\Db\QBMapper->update("*** sensiti ... *")
/var/www/nextcloud/apps/notifications/lib/BackgroundJob/SendNotificationMails.php - line 49:
OCA\Notifications\MailNotifications->sendEmails()
/var/www/nextcloud/lib/public/BackgroundJob/Job.php - line 79:
OCA\Notifications\BackgroundJob\SendNotificationMails->run()
/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php - line 95:
OCP\BackgroundJob\Job->execute()
/var/www/nextcloud/cron.php - line 151:
OCP\BackgroundJob\TimedJob->execute()
Caused by PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'next_send_time' at row 1
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 92:
PDOStatement->execute()
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1163:
Doctrine\DBAL\Driver\PDO\Statement->execute()
/var/www/nextcloud/lib/private/DB/Connection.php - line 294:
Doctrine\DBAL\Connection->executeStatement()
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:
OC\DB\Connection->executeStatement()
/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 281:
Doctrine\DBAL\Query\QueryBuilder->execute()
/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 327:
OC\DB\QueryBuilder\QueryBuilder->execute()
/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php - line 221:
OC\DB\QueryBuilder\QueryBuilder->executeStatement()
/var/www/nextcloud/apps/notifications/lib/MailNotifications.php - line 150:
OCP\AppFramework\Db\QBMapper->update("*** sensiti ... *")
/var/www/nextcloud/apps/notifications/lib/BackgroundJob/SendNotificationMails.php - line 49:
OCA\Notifications\MailNotifications->sendEmails()
/var/www/nextcloud/lib/public/BackgroundJob/Job.php - line 79:
OCA\Notifications\BackgroundJob\SendNotificationMails->run()
/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php - line 95:
OCP\BackgroundJob\Job->execute()
/var/www/nextcloud/cron.php - line 151:
OCP\BackgroundJob\TimedJob->execute()