fluxcp error please help

[blakbord]

how to fix this? I'm using latest fluxcp, and WAMPSERVER in my PC.. thanks..

bump for this..

[Rahul Dev]

The above fix by daewin should work. Though he did not told the fluxcp file location.

 

You can change it in fluxcp inside folder data/schemas/logindb/cp_createlog*****.sql

`reg_date` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',

[blakbord]

anybody here? I really need to know how to fix this.. thanks..

[Cyro]

Re-check you application and server file configuration.. they match with your MySQL database?

[blakbord]

yes it matches all in my MySQL..

[Cyro]

Well.. I guess there is some mss configuration in installer in theams.. we don't touch that folder in general while install.. I think you better.. retry with frsh flux

Or pm me

[blakbord]

one more thing when I run my test server this is the error..

[Akkarin]

Welp, something is screwed because `birthdate` accepts 0000-00-00 as it's not-null default value:

`birthdate` DATE NOT NULL DEFAULT '0000-00-00',

I'm wondering if there's something within Windows that causes format discrepancies between dates, maybe it's something hardcoded? Dunno, it's a wild stab in the dark. Or rebuild your `login` table.

[daewin]

I fixed this by using the default values '1000-01-01 00:00:00' for the DATETIME type, and '1000-01-01' for the DATE type. Occurs both in main.sql and logs.sql.

 

Hope this helps!

[Akkarin]

I guess it was too much to submit this as a pull request.

[blakbord]

thank you guys for helping me.. that fixed my problem..

[skwal]

The real issue is with the MySQL 5.7 server. It doesn't accept invalid custom date value for datetime field. A quick solution would be to run

SET SQL_MODE='ALLOW_INVALID_DATES';

In your mysql server.

You can also do this inside your phpMyAdmin panel in the Query tab.