Fluxcp 'reg_date' Error !

[Diana]

Please help me if you can 

when I setup fluxcp in my own Computer I get this error : 

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

how can i fix it?

[sekall]

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

 

Edited September 13, 2019 by sekall

[Earnestinence]

9 minutes ago, Diana said:

I already tried this 

but in Wampserver there's no mysql.ini and it's only my.ini 

but still the same error 

yes my.ini last line add 

sql_mode=NO_ENGINE_SUBSTITUTION

http://prntscr.com/foixkb

[Earnestinence]

add
sql_mode=NO_ENGINE_SUBSTITUTION

to your mysql.ini / my.ini

Edit: update ur fluxcp files to latest 

Edited June 28, 2017 by Ciel Phantomhive

[Diana]

I already tried this 

but in Wampserver there's no mysql.ini and it's only my.ini 

but still the same error 

@Ciel Phantomhive Solved and Thank you very much

[Rahul Dev]

This comment should help you. https://rathena.org/board/topic/107379-fluxcp-error-please-help/?do=findComment&comment=310079