[ERROR] No create character

[jAkErCZ]

Hi,
I have this problem turned on the server and when I want to create a character it will write to me "that the character can not be created"

How to fix please?

thx

[FetteRatte.]

Originally Posted by jAkErCZ

Hi,
I have this problem turned on the server and when I want to create a character it will write to me "that the character can not be created"

How to fix please?

thx

you have to watch in your db syserr

[jAkErCZ]

Originally Posted by GucciMane.

you have to watch in your db syserr

Me syserr db....

SYSERR: Sep 4 13:09:27 :: DirectQuery: AsyncSQL:irectQuery : mysql_query error: Field 'money2' doesn't have a default value
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, part_acce, gold, playtime, skill_level, quickslot) VALUES(0, 1, 'Ahoj', 1, 6, 4, 3, 3, 0, 0, 0, 957323, 255132, 0, 760, 260, 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\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0
SYSERR: Sep 4 13:09:27 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid2=0 WHERE id=1

[FetteRatte.]

Originally Posted by jAkErCZ

Me syserr db....

Edit your player table and set "money2" default value to 0

[jAkErCZ]

Originally Posted by GucciMane.

Edit your player table and set "money2" default value to 0

I set default value and fix

Thx

Please LOCK