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