Help with creation of new character?

[DimaN1ckson 2]

Hello, please help me figure this out. I set up the server on hosting, and when creating a new character on a new account, it shows the error "That is the wrong character name." What could be the problem? I already don't know where to look. The log is attached.

 

Spoiler

Jan 23 20:39:28 :: SYSTEM: new connection from [37.57.147.120] fd: 22 handshake 4170427922 output input_len 0, ptr 0x28f52100
Jan 23 20:39:28 :: Handshake: lower than zero -20
Jan 23 20:39:29 :: Handshake: client_time 0 server_time 2567108
Jan 23 20:39:29 :: GLOBAL_TIME: Jan 23 20:39:29 time_gap 0
Jan 23 20:39:29 :: LOGIN_BY_KEY: dima1 key 611917647
Jan 23 20:39:29 :: LoginSuccess
Jan 23 20:39:29 ::     player().job(0)
Jan 23 20:39:29 ::     player().job(0)
Jan 23 20:39:29 ::     player().job(0)
Jan 23 20:39:29 ::     player().job(0)
Jan 23 20:39:29 ::     player().job(0)
Jan 23 20:39:29 :: InputDB::login_success: dima1
Jan 23 20:39:30 :: SYSTEM: new connection from [37.57.147.120] fd: 23 handshake 2642867089 output input_len 0, ptr 0x28f52600
Jan 23 20:39:30 :: MARK_SERVER: Login
Jan 23 20:39:31 :: LargePacket Size 44
Jan 23 20:39:31 :: MARK_SERVER: GuildMarkIDXList 51 bytes sent.
Jan 23 20:39:32 :: MARK_SERVER: Sending blocks. (imgIdx 0 diff 0 size 10)
Jan 23 20:39:32 :: SYSTEM: closing socket. DESC #23
Jan 23 20:39:33 :: EmpireSelect 0x28f52100
Jan 23 20:39:42 :: PlayerCreate: name test pos 0 job 2 shape 0
Jan 23 20:39:42 :: NewPlayerTable2(name=test, race=2, job=2)
Jan 23 20:39:42 :: PlayerCreate: name test account_id 0, TPlayerCreatePacketSize(2519), Packet->Gold 0
Jan 23 20:39:46 :: SYSTEM: closing socket. DESC #22
 

 

[DimaN1ckson 2]

up!

syserr log from db 

Spoiler

SYSERR: Jan 26 20:01:39 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Data too long for column 'quickslot' at row 1
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, gem, pin, inventory, skill_inventory, material_inventory, stone_inventory, chest_inventory, enchant_inventory, costume_inventory, playtime, skill_level, quickslot, battlepass, stats) VALUES(0, 8, 'rtgt', 1, 6, 4, 3, 3, 4, 0, 0, 483300, 968600, 0, 760, 260, 0, 0, 0, 800, 0, 0, 0, 0, 0, 0, '1111', 0, 0, 0, 0, 0, 0, 0, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\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: Jan 26 20:01:39 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid2=0 WHERE id=8
 

 

[Froslass 904]

9 hours ago, DimaN1ckson said:

up!

syserr log from db 

  Hide contents

SYSERR: Jan 26 20:01:39 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Data too long for column 'quickslot' at row 1
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, gem, pin, inventory, skill_inventory, material_inventory, stone_inventory, chest_inventory, enchant_inventory, costume_inventory, playtime, skill_level, quickslot, battlepass, stats) VALUES(0, 8, 'rtgt', 1, 6, 4, 3, 3, 4, 0, 0, 483300, 968600, 0, 760, 260, 0, 0, 0, 800, 0, 0, 0, 0, 0, 0, '1111', 0, 0, 0, 0, 0, 0, 0, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\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: Jan 26 20:01:39 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid2=0 WHERE id=8
 

 

That error is self explanatory..  "Data too long for column 'quickslot'", either your source is corrupted, or the database is, make sure the column quick_slot is of type tinyblob

[DimaN1ckson 2]

3 hours ago, [GF]Froslass said:

That error is self explanatory..  "Data too long for column 'quickslot'", either your source is corrupted, or the database is, make sure the column quick_slot is of type tinyblob

The thing is, everything works perfectly on my home computer – characters are created without any issues. I copied these databases and moved them to hosting, and now I get this error. Can you please tell me where exactly I can find the quickslot column?

[Khabib Nurmagomedov 388]

2 hours ago, DimaN1ckson said:

The thing is, everything works perfectly on my home computer – characters are created without any issues. I copied these databases and moved them to hosting, and now I get this error. Can you please tell me where exactly I can find the quickslot column?

Just type mysql_upgrade into the ssh window, it will automatically fix any errors thin your database. Make sure that the server is turned off.

[DimaN1ckson 2]

7 hours ago, Khabib Nurmagomedov said:

Just type mysql_upgrade into the ssh window, it will automatically fix any errors thin your database. Make sure that the server is turned off.

mysql_upgrade: Got error: 1045: Access denied for user 'root'@'localhost' (using       password: NO) while connecting to the MySQL server
 

[DimaN1ckson 2]

up!

[DimaN1ckson 2]

fixed. can closed.

[rexy420 0]

what  was the fix?