Backported schema update from 1.37.25 to 1.36.34 won't work on some versions of mysql databases

[itsTurnip]

Describe Your Environment

• Version of ZoneMinder [release version, development version, or commit]
  1.36.34
• How you installed ZoneMinder [e.g. PPA, RPMFusion, from-source, etc]
  zoneminder-containers image
• Full name and version of OS
  Debian 12 (as for image base)

Describe the bug
Upgrading from 1.36.33 to 1.36.34 will fail with some old versions of databases. The following error will appear for mariadb 5.5.68 which is packed on CentOS 7.

To Reproduce
Run upgrade from 1.36.33 to 1.36.34 with mysql version < 5.6.5.

Expected behavior
Successfull migration from 1.36.33 to 1.36.34

Debug Logs

Upgrading DB to 1.36.34 from 1.36.33
ERROR 1067 (42000) at line 10: Invalid default value for 'UpdatedOn'

[welcome]

Thanks for opening your first issue here! Just a reminder, this forum is for Bug Reports only. Be sure to follow the issue template!

[itsTurnip]

I know it's kind of an old database which is not likely to be supported anymore, but I think 1.36.* version should not drop this support.

For anyone who is looking for a workaround: you can just add column UpdateOn to MonitorStatus table and then create a trigger to fill it out.

[connortechnology]

The fix was included in 1.36.35. I think we can close this.