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
    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?



  • Yes, you fixed it :-)


  • Developer

    @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!


  • Senior Developer

    Can you update and try again?


Log in to reply
 

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.