Jump to content
  • 0

fluxcp error please help


blakbord

Question


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  108
  • Reputation:   1
  • Joined:  02/10/12
  • Last Seen:  

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


bump for this..

Link to comment
Share on other sites

11 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  30
  • Reputation:   4
  • Joined:  11/20/11
  • Last Seen:  

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',
  • Upvote 1
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  108
  • Reputation:   1
  • Joined:  02/10/12
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  1137
  • Reputation:   290
  • Joined:  04/29/13
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  108
  • Reputation:   1
  • Joined:  02/10/12
  • Last Seen:  

yes it matches all in my MySQL..

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  1137
  • Reputation:   290
  • Joined:  04/29/13
  • Last Seen:  

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

  • 0

  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  108
  • Reputation:   1
  • Joined:  02/10/12
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Forum Manager
  • Topic Count:  282
  • Topics Per Day:  0.06
  • Content Count:  3122
  • Reputation:   1614
  • Joined:  03/26/12
  • Last Seen:  

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

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  1
  • Reputation:   0
  • Joined:  10/06/16
  • Last Seen:  

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

  • 0

  • Group:  Forum Manager
  • Topic Count:  282
  • Topics Per Day:  0.06
  • Content Count:  3122
  • Reputation:   1614
  • Joined:  03/26/12
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  108
  • Reputation:   1
  • Joined:  02/10/12
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  2
  • Reputation:   0
  • Joined:  06/15/14
  • Last Seen:  

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

×
×
  • Create New...