| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 20616 | Bug reports | Installation | public | 2026-07-21 18:13 | 2026-08-03 16:01 |
| Reporter | tassoman | Assigned To | c_schmitz | ||
| Priority | none | Severity | block | ||
| Status | closed | Resolution | no change required | ||
| Summary | 20616: Invalid datetime format: 1292 Incorrect datetime value | ||||
| Description | CDbCommand ha riportato un errore nell'esecuzione della query SQL: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'lastmodified' at row 23. The SQL statement executed was: ALTER TABLE | ||||
| Steps To Reproduce | Steps to reproduce
Expected resultadmin page with upgrade notification Actual result/opt/app-root/src/application/helpers/update/updates/Update_649.php(16): CDbCommand->addColumn("{{surveys}}", "showregisterpolicy", "string(1) NOT NULL DEFAULT 'I'") | ||||
| Tags | No tags attached. | ||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | 6.17.12+260721 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | any | ||||
| Database type & version | MySQL Server 5.7.44-1.el7 | ||||
| Server OS (if known) | Oracle linux | ||||
| Webserver software & version (if known) | Apache 2.4 | ||||
| PHP Version | PHP 8.3 | ||||
| Git branch / Pull Request URL | |||||
 |
I was not able to reproduce this issue locally following steps to reproduce in this ticket. I suspect that you have some corrupted data in the database. |
 |
This is a MySQL mode setting you need to set. You need to remove NO_ZERO_DATE from your MySQL mode setting . see https://stackoverflow.com/questions/43589048/mysql-need-to-allow-0000-00-00-000000-dates It was allowed in you server past, probably some update disallowed it, but there is still data with zeros in the table. Upon upgrading the table the new table structure is checked against the existing data, leading to the error. |
