20616: Invalid datetime format: 1292 Incorrect datetime value

This issue affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update
20616	Bug reports	Installation	public	2026-07-21 18:13	2026-07-21 18:13

Reporter	tassoman	Assigned To
Priority	none	Severity	block
Status	new	Resolution	open

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 `lime_surveys` ADD `showregisterpolicy` varchar(1) NOT NULL DEFAULT 'I'
Steps To Reproduce	Steps to reproduce install LS 6.16.1+260303 open admin page install 6.17.12 build 260721 open admin page see exeption error Expected result admin 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.
Attached Files	Screenshot 2026-07-21 at 17-58-21 CDbException.png (73,103 bytes) Screenshot 2026-07-21 at 17-58-21 CDbException.png (73,103 bytes)

Bug heat	2
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

User List	tassoman

Date Modified	Username	Field	Change
2026-07-21 18:13	tassoman	New Issue
2026-07-21 18:13	tassoman	File Added: Screenshot 2026-07-21 at 17-58-21 CDbException.png
2026-07-21 18:13	tassoman	Issue Monitored: tassoman
2026-07-21 18:13	tassoman	Bug heat	0 => 2