• Due to recent spam attacks that heavily used compormised accounts we did reset all user passwords, AGAIN, if it happens and your account got compromised again due to re-used passwords your account will be perma-banned.

DB error - Incorrect date value

Singularity

New member
Messages
5
Points
0
Hi.
When I try to start server, I get this error
 

[SQL]: DB error - Incorrect date value: '0000-00-00' for column 'birthdate' at row 1
[Debug]: at account_sql.c:640 - UPDATE `login` SET `userid`=?,`user_pass`=?,`sex`=?,`email`=?,`level`=?,`state`=?,`unban_time`=?,`expiration_time`=?,`logincount`=?,`lastlogin`=?,`last_ip`=?,`birthdate`=? WHERE `account_id` = '1' 

How can I fix this?Any ideas?

 
Hello!

Try changing the date value in "login" table from 0000-00-00 to any numbers but zeros and see if the problem resolved, if yes, change the default birthday value in your registration page from zeros to other numbers too and it should be totally fixed.

 
Back
Top