Jump to content

Problem - I can't create a new character


Recommended Posts

Hello!
I downloaded server files (Best production V4) from one of Turkish forum and I have a problem... When i'm trying to create new character, I can't.
image.png.230e0500421f82643f3ccdda89974f27.png

 

account.account
log.*
player.player
player.player_index
player.player_deleted
player.item
player.quest
player.safebox
player.horse_name
player.guild*
player.affect

I cleaned up all of these tables and still nothing... 


 

Link to comment
Share on other sites

  • Replies 6
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

16 godzin temu, Xploitz napisał:

Syserr?

SYSERR: Oct  5 15:21:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Field 'bossazrail' 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, part_acce, gold, cheque, playtime, skill_level, quickslot, newquickslot) VALUES(0, 63390, 'hjiorhijorhoijr', 1, 3, 4, 3, 6, 7, 0, 0, 957094, 254932, 0, 860, 320,0, 0, 0, 800, 0, 0, 0, 0, 0, 0, 119, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\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: Oct  5 15:21:36 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index  SET pid5=0 WHERE id=63390

field 'bossazrail' has value '0'
field 'pid5' already has value '0'
sysser from usr/game/cores/db
@EDIT
new sysser:
 

SYSERR: Oct  5 15:21:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Field 'bossazrail' 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, part_acce, gold, cheque, playtime, skill_level, quickslot, newquickslot) VALUES(0, 63390, 'hjiorhijorhoijr', 1, 3, 4, 3, 6, 7, 0, 0, 957094, 254932, 0, 860, 320,0, 0, 0, 800, 0, 0, 0, 0, 0, 0, 119, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\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: Oct  5 15:21:36 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index  SET pid5=0 WHERE id=63390
SYSERR: Oct  5 15:25:49 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Oct  5 15:25:49 :: ChildLoop: AsyncSQL: retrying
SYSERR: Oct  5 15:25:54 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Oct  5 15:25:54 :: ChildLoop: AsyncSQL: retrying
SYSERR: Oct  5 15:25:54 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Oct  5 15:25:54 :: ChildLoop: AsyncSQL: retrying
SYSERR: Oct  5 15:25:59 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Oct  5 15:25:59 :: ChildLoop: AsyncSQL: retrying
SYSERR: Oct  5 15:25:59 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Oct  5 15:25:59 :: ChildLoop: AsyncSQL: retrying
SYSERR: Oct  5 15:25:59 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Oct  5 15:25:59 :: ChildLoop: AsyncSQL: retrying
SYSERR: Oct  5 15:26:04 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Oct  5 15:28:30 :: DirectQuery: MySQL connection was reconnected. querying locale set
SYSERR: Oct  5 15:28:30 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Field 'bossazrail' 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, part_acce, gold, cheque, playtime, skill_level, quickslot, newquickslot) VALUES(0, 63390, 'hjiorhijorhoijr', 1, 3, 4, 3, 6, 7, 0, 0, 957477, 254969, 0, 860, 320,0, 0, 0, 800, 0, 0, 0, 0, 0, 0, 119, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\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: Oct  5 15:28:30 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index  SET pid5=0 WHERE id=63390
SYSERR: Oct  5 15:28:38 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Field 'bossazrail' 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, part_acce, gold, cheque, playtime, skill_level, quickslot, newquickslot) VALUES(0, 63390, 'testtesttest', 1, 3, 4, 3, 6, 7, 0, 0, 957138, 255139, 0, 860, 320,0, 0, 0, 800, 0, 0, 0, 0, 0, 0, 119, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\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: Oct  5 15:28:38 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index  SET pid5=0 WHERE id=63390

 

Link to comment
Share on other sites

28 minut temu, Xploitz napisał:

U have to give a default value to bossazrail column. (I have absolutely no idea what is that) You can do it through navicat. Check the player_index table as well, maybe the pid5 column dosen't exist.

I give value '0' to bossazrail
pid5 exists, it has value '0'
What about other errors? 
 

SYSERR: Oct  5 15:25:59 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Oct  5 15:25:59 :: ChildLoop: AsyncSQL: retrying
SYSERR: Oct  5 15:26:04 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Oct  5 15:28:30 :: DirectQuery: MySQL connection was reconnected. querying locale set

What it means?

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • 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.