there can be only one TIMESTAMP column with CURRENT_TIMESTAMP

[raice]

searched a lot in the forums, but couldn’t find the answer.
Try to set up a new FOG image server. Installed Debian (later also tried CENTOS and Ubuntu) and get the latest developer release. I need this release because of the Broadcom chipset in the workstations.
When I install it, everything works fine. But at some point in the Install script one needs to go to the url
http://xxx.xxx.xxx.xxx/fog/management
to create the database and create the tables.
After pressing the button, the following message appears:

Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

ALTER TABLE fog.hosts ADD COLUMN hostSecTime TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

The login works, but there is no possibility creating hosts. Every registration fails.
What needs to be done to get it running?

[Tom Elliott]

Can you update and try again?

[Sebastian Roth]

@raice Thanks a lot for reporting this. We recently made some major changes in the MySQL schema scripts to make it run on MySQL version 5.7 (ubuntu 16.04 default mysql version). Seems like we overdid things. Will be fixed soon!

[raice]

Yes, you fixed it