00 Uhr wird nicht akzeptiert

[exscorp]

Prerequisites

• I checked for duplicate issues (open and closed)
• I am using the latest stable version/release of the Contao Recommendation Bundle
• I have read the contributing guidelines

Please select the topic(s) that most closely match your concern

Backend (PHP)

Description

Hallo, beim erstellen einer Bewertung im Backend (Contao 4.13.43) wird die Uhrzeit 00:xx Uhr nicht akzeptiert. Hier erscheint folgende Fehlermeldung:

An exception occurred while executing a query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'time' at row 1

Relevant log output

No response

[zoglo]

Cause full stack-trace wasn't posted (please post it next time)

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 'time' at row 1

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1943)
  at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1885)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), 'UPDATE tl_recommendation SET `time`=?, `tstamp`=? WHERE id=?', array(-420, 1714112332, '12'), array(null, null))
     (vendor/doctrine/dbal/src/Connection.php:1106)
  at Doctrine\DBAL\Connection->executeQuery('UPDATE tl_recommendation SET `time`=?, `tstamp`=? WHERE id=?', array(-420, 1714112332, '12'), array(null, null))
     (vendor/contao/core-bundle/contao/library/Contao/Database/Statement.php:261)
  at Contao\Database\Statement->query('', array(-420, 1714112332, '12'), array(null, null))
     (vendor/contao/core-bundle/contao/drivers/DC_Table.php:3498)
  at Contao\DC_Table->submit()
     (vendor/contao/core-bundle/contao/drivers/DC_Table.php:2192)
  at Contao\DC_Table->edit()
     (vendor/contao/core-bundle/contao/classes/Backend.php:546)
  at Contao\Backend->getBackendModule('recommendation', null)
     (vendor/contao/core-bundle/contao/controllers/BackendMain.php:144)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:44)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:181)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:197)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (public/index.php:42)    
     ```

[zoglo]

@exscorp, this has been fixed in the latest release:
https://github.com/oveleon/contao-recommendation-bundle/releases/tag/1.5.2

Please mind that you have to run contao:migrate / update your database for the change to take effect.