【client or src】Character creation, name error!

[Torres 197]

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 17]

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

[Torres 197]

 

@lastone122,yes ,not null~!

[Torres 197]

UP

[Torres 197]

UP   !

[Torres 197]

Come~！~ help me~！devs

[useless69 215]

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

[Torres 197]

@useless69

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

[displayjokes 101]

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 197]

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

 

[Torres 197]

UP

[ByLost 184]

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.