can't create account

[Earnestinence]

Hello rAthena community,

 

[Edit]please edit topic Title to " can't create account " , not character

 

I have a problem when running my server, SQL error 

 

 

http://imgur.com/a/e2BeS

[SQL]: DB error - Incorrect date value: '0000-00-00' for column 'birthdate' at row 1
[Debug]: at ..\src\login\account.c:649 - UPDATE `login` SET `userid`=?,`user_pass`=?,`sex`=?,`email`=?,`group_id`=?,`sta
te`=?,`unban_time`=?,`expiration_time`=?,`logincount`=?,`lastlogin`=?,`last_ip`=?,`birthdate`=?,`character_slots`=?,`pin
code`=?, `pincode_change`=? WHERE `account_id` = '1 

i tried to change it , but still same error , can someone please help me with that?

Up UP!

Edited September 9, 2016 by Ciel Phantomhive

[TiMz]

You aren't supposed to change the first line. Only the 2nd line onwards is for Admin/Player accounts.

[blakbord]

I'm having the same error, I didn't change anything in mysql.. I install Wampserver in my PC..

[anacondaq]

I'm having the same error, I didn't change anything in mysql.. I install Wampserver in my PC..

this is not your fault, it's fault of changes in mysql 5.7.*

Read it: http://stackoverflow.com/questions/36374335/error-in-mysql-when-setting-default-value-for-date-or-datetime/36374690#36374690

 

How to solve:

roll-back to mysql 5.5 - 5.6, or update manually these tables, or implement custom fixes to my.cnf from link above.

Edited September 19, 2016 by Anacondaqq