Renumbering Image IDs

[DJslimD1k]

Hope you fine folks are doing well! While I’m running the community script to change my Image ID numbers, I get this error at the end of the script. Has anyone else seen this issue? ERROR 1292

[george1421]

Its not specifically an issue with the community script but a default setting ubuntu has added to the mysql startup. Let me see if I can find the fix.

[george1421]

I realize this thread talks a lot about other things but this post should get you pretty close. https://forums.fogproject.org/topic/14254/high-cpu-usage/10

You need to set the sqlmode parameter without the NO_ZERO_IN_DATE and NO_ZERO_DATE values. Then restart mysql and then rerun the command that should take care of the zero date error.

[Wayne Workman]

@george1421 is this something we could add to the script?

[george1421]

@Wayne-Workman What has happened is mariadb starting at version 10 (?? I think) added some default values to mysql startup that are causing an issue with some of FOG’s default values (such as 0’s in date fields) I think we need to update the schema to use a invalid, but valid date of something like 1/1/1900 instead of 0/0/0000 as an unset date.

Again its not a problem with the renumber script, but the default startup values used for the sql server that was introduced with the later releases of mariadb.