Unable to create new char

[lone77wolf 23]

Hi, i have a problem in a server, since i migrate the server to a new machine it is unable to create new characters.

It says that the name of the character already exists but in Database the name doesn't exist.

Anyone can help with this issue please?

 

Best regards,

LoneWolf

Edited August 15, 2022 by Metin2 Dev
Core X - External 2 Internal

[Denis 1460]

Post the syserr of your channel

[lone77wolf 23]

Post the syserr of your channel

Hi, i upload the logs from DB, and all cores from channel 1

http://www.4shared.com/zip/J4zW1p90ba/logs.html

 

noticed one thing in DB syserr, 

 

SYSERR: Jun 10 18:14:54 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Field 'event_pvp' 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, gold, playtime, skill_level, quickslot) VALUES(0, 24260, 'T3st4d0r', 1, 3, 4, 3, 6, 7, 0, 0, 957387, 255145, 0, 860, 320, 0, 0, 0, 800, 0, 0, 0, 0, 0, '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

 

this is the error that appears when i tryed to create a test character.

 

Best regards,

LoneWolf

[Denis 1460]

try to delete the field event_pvp from player.player

[lone77wolf 23]

try to delete the field event_pvp from player.player

hi, i did a quick search in player.player and found the event_pvp field then i went to design table and put allow null on it.

going to see if it works without deleting the event_pvp field.

Thank you very much.

 

best regards,

LoneWolf

 

 

Note: it worked puting Allow Null in event_pvp field, thank you very much once more

[Denis 1460]

No problem