Web register error

[noob1994]

-vitalityms source
-cype cms

i get this message when tring to register an account to my server:

Incorrect datetime value: '0000-00-00 00:00:00' for column 'tempban' at row 1

 

[Eric]

You can either change your MySQL options to allow that date value, or you can otherwise change the default timestamps from the year 0000 to the year 1970.

 

[Linnxy]

Solution:
ALTER TABLE `accounts` CHANGE `tempban` `tempban` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00';

 

[ETTETT]

-vitalityms source
-cype cms

i get this message when tring to register an account to my server:

Incorrect datetime value: '0000-00-00 00:00:00' for column 'tempban' at row 1

I know I'm late, but it seems that your registeration page doesn't submit the datetime value in correct format to tempban column. As someone mentioned you can change this column default value to be something so it doesn't need to be posted using a form or you can inspect the code and fix it.