Hello,
I have newly installed
Roundcube 1.3.10
MySQL 5.7.26
PHP 7.2.18
Apache 2.4.39
The last 3 through wampserver.
When I try to login to Roundcube, it doesn't succeed an I get an error: "Invalid request. No data was saved."
The error log says: ... DB Error: [1292] Incorrect datetime value: '0000-00-00 00:00:00' for column 'created' at row 1..... for an SQL 'INSERT' statement for inserting a row for that login in table 'SESSION' in the RC database.
I am not versed with PHP, but It looks like this SQL statement is generated by ...\Webmail\program\lib\Roundcube\rcube_session_db.php lines 117-133.
With my limited knowledge I assume that probably the value for column 'created' of table 'session' should be $NOW but is '0000-00-00 00:00:00'.
MySQL is setup with 'NO_ZERO_DATE', as is required with the newest versions, so the insert is not accepted by MySQL with the error as result.
Would this seem correct and does anyone know how to correct the situation such that the insert statement gets the correct datetime value.
Reactions would be highly appreciated,
Ciao ciao