Problema creare caracter

YouTube · 09 Mai 2020, 16:37

*Problemă/Întrebare: apare cand intru pe un caracter nou
Tipologie server(PvM / PvP): pvp
*Resursă folosită: *Link exclusiv J4M*
*ServerFiles utilizat: Aries2
*Syserr: 0509 17:19:12100 :: CArea::LoadObject Property(4267061261) Load ERROR
Poză:-
*Detalii suplimentare: fac un caracter nou intru pe el se incarca, ma da la login si nmk

Dex · 09 Mai 2020, 16:51

Your database is broken, check up your database syserr and post it

YouTube · 09 Mai 2020, 17:51

SYSERR: May 9 14:37:52 :: pid_init:
Start of pid: 980

SYSERR: May 9 14:37:52 :: Start: TABLE_POSTFIX not configured use default
SYSERR: May 9 14:37:52 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist
query: DELETE FROM priv_settings WHERE value <= 0 OR duration <= NOW();
SYSERR: May 9 14:37:52 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist
query: SELECT priv_type, id, type, value, UNIX_TIMESTAMP(duration) FROM priv_settings
SYSERR: May 9 15:35:04 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: REPLACE INTO hb_20050915_player SELECT * FROM player.player WHERE id=1 errno: 1317)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(1, 'iteme_inceput_new', '__status', 1807258209) errno: 1317)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(1, 'mythical_peach', 'last_use_time', 1569938166) errno: 2002)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(1, 'mythical_peach', 'last_use_time', 1569938166) errno: 2002)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(1, 'mythical_peach', 'last_use_time', 1569938166) errno: 2002)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(1, 'mythical_peach', 'last_use_time', 1569938166) errno: 2002)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(1, 'mythical_peach', 'last_use_time', 1569938166) errno: 2002)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(1, 'mythical_peach', 'last_use_time', 1569938166) errno: 2002)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(1, 'mythical_peach', 'last_use_time', 1569938166) errno: 2002)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(1, 'mythical_peach', 'last_use_time', 1569938166) errno: 2002)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: REPLACE INTO affect (dwPID, bType, bApplyOn, lApplyValue, dwFlag, lDuration, lSPCost) VALUES(1, 515, 6, 17000, 0, 1892140714, 0) errno: 1317)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO affect (dwPID, bType, bApplyOn, lApplyValue, dwFlag, lDuration, lSPCost) VALUES(1, 515, 8, 4000, 0, 1892140714, 0) errno: 2002)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO affect (dwPID, bType, bApplyOn, lApplyValue, dwFlag, lDuration, lSPCost) VALUES(1, 515, 8, 4000, 0, 1892140714, 0) errno: 2002)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO affect (dwPID, bType, bApplyOn, lApplyValue, dwFlag, lDuration, lSPCost) VALUES(1, 515, 8, 4000, 0, 1892140714, 0) errno: 2002)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO affect (dwPID, bType, bApplyOn, lApplyValue, dwFlag, lDuration, lSPCost) VALUES(1, 515, 8, 4000, 0, 1892140714, 0) errno: 2002)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO affect (dwPID, bType, bApplyOn, lApplyValue, dwFlag, lDuration, lSPCost) VALUES(1, 515, 8, 4000, 0, 1892140714, 0) errno: 2002)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO affect (dwPID, bType, bApplyOn, lApplyValue, dwFlag, lDuration, lSPCost) VALUES(1, 515, 8, 4000, 0, 1892140714, 0) errno: 2002)
SYSERR: May 9 15:35:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 9 15:35:04 :: pid_deinit:
End of pid

SYSERR: May 9 15:36:09 :: pid_init:
Start of pid: 924

SYSERR: May 9 15:36:09 :: Start: TABLE_POSTFIX not configured use default
SYSERR: May 9 15:36:09 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist
query: DELETE FROM priv_settings WHERE value <= 0 OR duration <= NOW();
SYSERR: May 9 15:36:09 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist
query: SELECT priv_type, id, type, value, UNIX_TIMESTAMP(duration) FROM priv_settings

10 Mai 2020, 01:46

Daca ai priv_settings vechi (cel postat pe epvp acum multi ani) e posibil sa fie cel care iti inchide mysql daca nu ai tabelul respectiv si de aia nu merge. Poti sa verifici aici daca face asta:
ClientManager.cpp

Imagine

Ruleaza query-ul asta pentru tabel (in common!)

Cod: Selectaţi tot

CREATE TABLE `priv_settings` (
`priv_type`  enum('PLAYER','GUILD','EMPIRE') NOT NULL DEFAULT 'EMPIRE' COMMENT 'GUILD and PLAYER are untested.' ,
`id`  int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'this is for empire_id, player_id or guild_id' ,
`type`  int UNSIGNED NOT NULL DEFAULT 4 COMMENT '1:item_drop, 2:gold_drop, 3:gold10_drop, 4:exp (1~4)' ,
`value`  int NOT NULL DEFAULT 0 COMMENT '0~1000%' ,
`duration`  datetime NOT NULL DEFAULT 0 ,
PRIMARY KEY (`priv_type`, `id`, `type`)
)
;

YouTube · 10 Mai 2020, 10:54

cer T/C

28 Mai 2020, 21:11

Rezolvat! topic mutat probleme rezolvate.

Problema creare caracter

Cine este conectat