Torres 64 Posted July 3, 2019 Share Posted July 3, 2019 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 Link to comment Share on other sites More sharing options...
lastone122 16 Posted July 3, 2019 Share Posted July 3, 2019 Have you tried in design table to tick field not null at column name? Link to comment Share on other sites More sharing options...
Torres 64 Posted July 4, 2019 Author Share Posted July 4, 2019 @lastone122,yes ,not null~! Link to comment Share on other sites More sharing options...
Torres 64 Posted July 5, 2019 Author Share Posted July 5, 2019 UP Link to comment Share on other sites More sharing options...
Torres 64 Posted July 7, 2019 Author Share Posted July 7, 2019 UP ! Link to comment Share on other sites More sharing options...
Torres 64 Posted July 8, 2019 Author Share Posted July 8, 2019 Come~!~ help me~!devs Link to comment Share on other sites More sharing options...
useless69 164 Posted July 8, 2019 Share Posted July 8, 2019 your player table dont like " �ҵ�" so change character set. Link to comment Share on other sites More sharing options...
Torres 64 Posted July 16, 2019 Author Share Posted July 16, 2019 @useless69 I tried using another player table. SQL, same as before! Link to comment Share on other sites More sharing options...
displayjokes 89 Posted July 17, 2019 Share Posted July 17, 2019 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 It's all lies Link to comment Share on other sites More sharing options...
Torres 64 Posted July 20, 2019 Author Share Posted July 20, 2019 @displayjokes can you use andesk or teamviewer help me fix it? thank you!~ Link to comment Share on other sites More sharing options...
Torres 64 Posted July 20, 2019 Author Share Posted July 20, 2019 UP Link to comment Share on other sites More sharing options...
ByLost 142 Posted June 3, 2020 Share Posted June 3, 2020 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now