blakbord Posted September 15, 2016 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 108 Reputation: 1 Joined: 02/10/12 Last Seen: March 10, 2024 Share Posted September 15, 2016 how to fix this? I'm using latest fluxcp, and WAMPSERVER in my PC.. thanks.. bump for this.. Link to comment Share on other sites More sharing options...
0 Rahul Dev Posted October 9, 2016 Group: Members Topic Count: 2 Topics Per Day: 0.00 Content Count: 30 Reputation: 4 Joined: 11/20/11 Last Seen: November 3, 2022 Share Posted October 9, 2016 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', 1 Link to comment Share on other sites More sharing options...
0 blakbord Posted September 17, 2016 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 108 Reputation: 1 Joined: 02/10/12 Last Seen: March 10, 2024 Author Share Posted September 17, 2016 anybody here? I really need to know how to fix this.. thanks.. Link to comment Share on other sites More sharing options...
0 Cyro Posted September 17, 2016 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 1138 Reputation: 290 Joined: 04/29/13 Last Seen: July 20, 2024 Share Posted September 17, 2016 Re-check you application and server file configuration.. they match with your MySQL database? Link to comment Share on other sites More sharing options...
0 blakbord Posted September 18, 2016 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 108 Reputation: 1 Joined: 02/10/12 Last Seen: March 10, 2024 Author Share Posted September 18, 2016 yes it matches all in my MySQL.. Link to comment Share on other sites More sharing options...
0 Cyro Posted September 18, 2016 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 1138 Reputation: 290 Joined: 04/29/13 Last Seen: July 20, 2024 Share Posted September 18, 2016 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 Link to comment Share on other sites More sharing options...
0 blakbord Posted September 18, 2016 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 108 Reputation: 1 Joined: 02/10/12 Last Seen: March 10, 2024 Author Share Posted September 18, 2016 one more thing when I run my test server this is the error.. Link to comment Share on other sites More sharing options...
0 Akkarin Posted September 20, 2016 Group: Forum Manager Topic Count: 282 Topics Per Day: 0.06 Content Count: 3144 Reputation: 1632 Joined: 03/26/12 Last Seen: April 15 Share Posted September 20, 2016 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. Link to comment Share on other sites More sharing options...
0 daewin Posted October 9, 2016 Group: Members Topic Count: 0 Topics Per Day: 0 Content Count: 1 Reputation: 0 Joined: 10/06/16 Last Seen: October 9, 2016 Share Posted October 9, 2016 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! Link to comment Share on other sites More sharing options...
0 Akkarin Posted October 11, 2016 Group: Forum Manager Topic Count: 282 Topics Per Day: 0.06 Content Count: 3144 Reputation: 1632 Joined: 03/26/12 Last Seen: April 15 Share Posted October 11, 2016 I guess it was too much to submit this as a pull request. Link to comment Share on other sites More sharing options...
0 blakbord Posted October 17, 2016 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 108 Reputation: 1 Joined: 02/10/12 Last Seen: March 10, 2024 Author Share Posted October 17, 2016 thank you guys for helping me.. that fixed my problem.. Link to comment Share on other sites More sharing options...
0 skwal Posted August 5, 2020 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 2 Reputation: 0 Joined: 06/15/14 Last Seen: August 13, 2020 Share Posted August 5, 2020 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. Link to comment Share on other sites More sharing options...
Question
blakbord
how to fix this? I'm using latest fluxcp, and WAMPSERVER in my PC.. thanks..
bump for this..
Link to comment
Share on other sites
11 answers to this question
Recommended Posts