【client or src】Character creation, name error!

[Torres 62]

Hi，devs~

I have a error·

I changed the database, player table name field is gb2312, epk also USES locale_newcibn, but, I created the character, the name USES simplified Chinese, he reported an error!

This is syserr of DB：

SYSERR: Jul  4 00:24:48 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' cannot be null
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_sash, gold, playtime, skill_level, quickslot) VALUES(0, 1, '�ҵ�', 1, 6, 4, 3, 3, 0, 0, 0, 459514, 953855, 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\0\0\0\0\0\0\0\
SYSERR: Jul  4 00:24:48 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid3=0 WHERE id=1
SYSERR: Jul  4 00:24:52 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' cannot be null

Thank you for your answer！

Best wishes to you

[lastone122 16]

Have you tried in design table to tick field not null at column name?

[Torres 62]

 

@lastone122,yes ,not null~!

[Torres 62]

UP

[Torres 62]

UP   !

[Torres 62]

Come~！~ help me~！devs

[useless69 152]

your player table dont like " �ҵ�" so change character set.

[Torres 62]

@useless69

I tried using another player table. SQL, same as before!

[displayjokes 87]

On 7/16/2019 at 3:12 PM, Torres said:

@useless69

I tried using another player table. SQL, same as before!

it has to be the character set has useless69 said, it doesn't matter if you use another tables, if it does not have the right character set for that "word"/name, it will keep giving you this error

[Torres 62]

@displayjokes can you use andesk or teamviewer help me fix it? thank you!~

 

[Torres 62]

UP

[ByLost 136]

Fix: remove "NOT" 

Open table player and dump structure and data edit:
 

`name` varchar(24) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'NONAME',

to

`name` varchar(24) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'NONAME',

And player_deleted.

Thanks.