Hello,
I try to upgrade to the last 1.5.10 and I have this :
* Updating Database...........................................Failed!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!! The installer was not able to run all the way to the end as !!
!! something has caused it to fail. The following few lines are !!
!! from the error log file which might help us figure out what's !!
!! wrong. Please add this information when reporting an error. !!
!! As well you might want to take a look at the full error log !!
!! in /root/fogproject-1.5.10.2482/bin/error_logs/fog_error_1.5.10.2482.log !!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
17900K .......... .......... .......... .......... .......... 130M
17950K .......... .......... .......... .......... ........ 142M=0,1s
2026-10-09 11:39:11 (128 MB/s) - ‘/home//fogDBbackups/fog_sql_1.5.10.2482_20261009_113907.sql’ enregistré [18430465]
Trying with GUI, I have this :
The following errors occurred
Update ID: 284
Database Error:
Failed to query: Error: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for ‘hostSecTime’ Error Message: Error Code: “42000”, Error Message: [“42000”,1067,“Invalid default value for ‘hostSecTime’”], Debug: SQL: [77] ALTER TABLE hosts MODIFY COLUMN hostLastDeploy DATETIME NULL DEFAULT NULL
Params: 0
SQL: ALTER TABLE hosts MODIFY COLUMN hostLastDeploy DATETIME NULL DEFAULT NULL
Params: Array
(
)
ErrorInfo: Array
( [0] => 42000 [1] => 1067 [2] => Invalid default value for ‘hostSecTime’
)
Debug: SQL: [77] ALTER TABLE hosts MODIFY COLUMN hostLastDeploy DATETIME NULL DEFAULT NULL
Params: 0
Variable contains:
Array
( [0] => ALTER TABLE hosts MODIFY COLUMN hostLastDeploy DATETIME NULL DEFAULT NULL [1] => UPDATE hosts SET hostLastDeploy = NULL WHERE hostLastDeploy IS NOT NULL AND YEAR(hostLastDeploy) = 0 [2] => ALTER TABLE hosts MODIFY COLUMN hostSecTime TIMESTAMP NULL DEFAULT NULL [3] => UPDATE hosts SET hostSecTime = NULL WHERE hostSecTime IS NOT NULL AND YEAR(hostSecTime) = 0 [4] => ALTER TABLE images MODIFY COLUMN imageLastDeploy DATETIME NULL DEFAULT NULL [5] => UPDATE images SET imageLastDeploy = NULL WHERE imageLastDeploy IS NOT NULL AND YEAR(imageLastDeploy) = 0 [6] => ALTER TABLE imagingLog MODIFY COLUMN ilFinishTime DATETIME NULL DEFAULT NULL [7] => UPDATE imagingLog SET ilFinishTime = NULL WHERE ilFinishTime IS NOT NULL AND YEAR(ilFinishTime) = 0 [8] => ALTER TABLE inventory MODIFY COLUMN iDeleteDate DATETIME NULL DEFAULT NULL [9] => UPDATE inventory SET iDeleteDate = NULL WHERE iDeleteDate IS NOT NULL AND YEAR(iDeleteDate) = 0 [10] => ALTER TABLE multicastSessions MODIFY COLUMN msStartDateTime DATETIME NULL DEFAULT NULL [11] => UPDATE multicastSessions SET msStartDateTime = NULL WHERE msStartDateTime IS NOT NULL AND YEAR(msStartDateTime) = 0 [12] => ALTER TABLE multicastSessions MODIFY COLUMN msCompleteDateTime DATETIME NULL DEFAULT NULL [13] => UPDATE multicastSessions SET msCompleteDateTime = NULL WHERE msCompleteDateTime IS NOT NULL AND YEAR(msCompleteDateTime) = 0 [14] => ALTER TABLE snapinTasks MODIFY COLUMN stCompleteDate DATETIME NULL DEFAULT NULL [15] => UPDATE snapinTasks SET stCompleteDate = NULL WHERE stCompleteDate IS NOT NULL AND YEAR(stCompleteDate) = 0 [16] => ALTER TABLE tasks MODIFY COLUMN taskCheckIn DATETIME NULL DEFAULT NULL [17] => UPDATE tasks SET taskCheckIn = NULL WHERE taskCheckIn IS NOT NULL AND YEAR(taskCheckIn) = 0 [18] => ALTER TABLE tasks MODIFY COLUMN taskScheduledStartTime DATETIME NULL DEFAULT NULL [19] => UPDATE tasks SET taskScheduledStartTime = NULL WHERE taskScheduledStartTime IS NOT NULL AND YEAR(taskScheduledStartTime) = 0 [20] => ALTER TABLE userTracking MODIFY COLUMN utDate DATE NULL DEFAULT NULL [21] => UPDATE userTracking SET utDate = NULL WHERE utDate IS NOT NULL AND YEAR(utDate) = 0
)
Database SQL:
ALTER TABLE hosts MODIFY COLUMN hostLastDeploy DATETIME NULL DEFAULT NULL
