[ERROR] No create character

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"
[Only registered and activated users can see links. Click Here To Register...]
How to fix please?

thx

Quote:

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" [Only registered and activated users can see links. Click Here To Register...] How to fix please? thx

you have to watch in your db syserr

Quote:

Originally Posted by GucciMane. you have to watch in your db syserr

Me syserr db....

Quote:

SYSERR: Sep 4 13:09:27 :: DirectQuery: AsyncSQL::DirectQuery : 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

Quote:

Originally Posted by jAkErCZ Me syserr db....

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

Quote:

Originally Posted by GucciMane. Edit your player table and set "money2" default value to 0

I set default value and fix :)

Thx

Please LOCK