Syserr Error

[Bercol 0]

i can not create a character

I can not register account

does anyone know what is the problem?

 

FreeBSD 10.3 64 Bit

Mysql 5.7

 

SYSERR: Jun 22 11:39:54 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_play' at row 1
query: INSERT INTO player (id, account_id, name, level, st, ht, dx, iq, job, voice, dir, x, y, z, hp, mp, random_hp, random_sp, stat_point, stamina, part_base, part_main, part_hair, gold, playtime, skill_level, quickslot) VALUES(0, 768, 'ewtgdfgdfg', 1, 5, 3, 3, 5, 2, 0, 0, 957125, 255320, 0, 770, 300, 0, 0, 0, 800, 0, 0, 0, 0, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
SYSERR: Jun 22 11:39:54 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid4=0 WHERE id=768

[iltizio 286]

Change sql_mode.

On your my.cnf, on section [mysqld], insert this line:

sql-mode="NO_ENGINE_SUBSTITUTION"

Restart mysql-server.

[Bercol 0]

54 minutes ago, iltizio said:

Change sql_mode.

On your my.cnf, on section [mysqld], insert this line:

sql-mode="NO_ENGINE_SUBSTITUTION"

Restart mysql-server.

It work's now. Thank you soo much