[Fluxcp 'reg_date' Error !]

following the first answers, this is the solution for linux (ubuntu 18.04) users. You can jump right to the solution a little lower...

I took like 4 information sources to get it all going for me, thats why I put it all together a little more detailed...

After preconfiguring fluxCP (see github wiki) I had the same problem mentioned here after hitting fluxCP "update all".

 

Quote

 

Critical Error

An error was encountered during the lifetime of the application.

This could be due to a variety of problems, such as a bug in the application.

However, normally it is caused by misconfiguration.

 

To make sure its actually this error, you need to enable full error log in the error.php:

sudo nano /var/www/html/config/error.php

now set this from false to true:

Quote

$showExceptions  = true;

exit with STRG+X and confirm save with Y and RETURN

Then you are able to see the full error log:

Quote

Exception Details

Error: Flux_Error

Message: Critical MySQL error in Installer/Updater: Invalid default value for 'reg_date'

File: /var/www/html/lib/Flux/Installer/Schema.php:131

...

 

My working Solution

 

open the mysqld.cnf with write permissions (e.g. sudo):

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

append this in the [mysql] section:

 sql_mode=NO_ENGINE_SUBSTITUTION

exit with STRG+X and confirm save with Y and RETURN

now restart the mysql service:

sudo systemctl restart mysql.service