Jump to content
  • 0

Unable to create new char


lone77wolf

Question

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

30j32ol.png

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

Link to comment
  • Answers 5
  • Created
  • Last Reply

Top Posters For This Question

Popular Days

5 answers to this question

Recommended Posts

  • 0

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
Link to comment
  • 0

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 :)

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.