there can be only one TIMESTAMP column with CURRENT_TIMESTAMP
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
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
hostSecTimeTIMESTAMP 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?
Yes, you fixed it :-)
@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!
Can you update and try again?