Kunoji 1 Posted October 4, 2018 Share Posted October 4, 2018 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. 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 More sharing options...
Xploitz 8 Posted October 4, 2018 Share Posted October 4, 2018 Syserr? Link to comment Share on other sites More sharing options...
Kunoji 1 Posted October 5, 2018 Author Share Posted October 5, 2018 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 More sharing options...
Xploitz 8 Posted October 5, 2018 Share Posted October 5, 2018 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. Link to comment Share on other sites More sharing options...
Kunoji 1 Posted October 5, 2018 Author Share Posted October 5, 2018 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 More sharing options...
Premium WeedHex 635 Posted October 6, 2018 Premium Share Posted October 6, 2018 /mysql.sock Link to comment Share on other sites More sharing options...
Kunoji 1 Posted October 6, 2018 Author Share Posted October 6, 2018 1 godzinę temu, WeedHex napisał: /mysql.sock And what should i do with it? 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