*Problemă/Întrebare: o rezolvare la acel sysser
Tipologie server(PvM / PvP):
*Resursă folosită: *Link exclusiv J4M*
*ServerFiles utilizat:
*Syserr:
SYSERR: Jun 1 17:41:27 :: heart_idle: losing 96 seconds. (lag occured)
SYSERR: Jun 5 07:41:54 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Jun 5 07:41:54 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Jun 5 08:33:42 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2880, 'Pumnal foaie neagra+0', 10006328, 0, NOW(), 1, 'POWER') errno: 1062)
SYSERR: Jun 5 08:33:48 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2880, 'Pumnal foaie neagra+1', 10006331, 1, NOW(), 0, 'POWER') errno: 1062)
SYSERR: Jun 5 08:34:44 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2880, 'Pumnal foaie neagra+0', 10006332, 0, NOW(), 1, 'SCROLL') errno: 1062)
SYSERR: Jun 5 08:34:50 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2880, 'Pumnal foaie neagra+1', 10006333, 1, NOW(), 1, 'SCROLL') errno: 1062)
SYSERR: Jun 5 08:34:58 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2880, 'Pumnal foaie neagra+2', 10006334, 2, NOW(), 1, 'SCROLL') errno: 1062)
SYSERR: Jun 5 08:35:11 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2880, 'Pumnal foaie neagra+3', 10006335, 3, NOW(), 1, 'SCROLL') errno: 1062)
SYSERR: Jun 5 08:35:17 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2880, 'Pumnal foaie neagra+4', 10006347, 4, NOW(), 1, 'SCROLL') errno: 1062)
SYSERR: Jun 5 08:35:25 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2880, 'Pumnal foaie neagra+5', 10006348, 5, NOW(), 1, 'SCROLL') errno: 1062)
SYSERR: Jun 5 08:35:33 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2880, 'Pumnal foaie neagra+6', 10006349, 6, NOW(), -1, 'SCROLL') errno: 1062)
SYSERR: Jun 5 08:35:42 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2880, 'Pumnal foaie neagra+5', 10006350, 5, NOW(), 1, 'SCROLL') errno: 1062)
SYSERR: Jun 5 08:35:53 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2880, 'Pumnal foaie neagra+6', 10006351, 6, NOW(), 1, 'SCROLL') errno: 1062)
SYSERR: Jun 5 08:35:59 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2880, 'Pumnal foaie neagra+7', 10006352, 7, NOW(), 1, 'SCROLL') errno: 1062)
SYSERR: Jun 5 08:36:07 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2880, 'Pumnal foaie neagra+8', 10006353, 8, NOW(), 1, 'SCROLL') errno: 1062)
SYSERR: Jun 5 08:40:34 :: GetQuestStateIndex: QUEST wrong quest state file levelup.run
SYSERR: Jun 5 09:00:51 :: SyncPosition: Too often SyncPosition Interval(5ms)(Orc Negru Urias) from Name(kaioken) VICTIM(315614,728093) SYNC(315614,728093)
SYSERR: Jun 5 09:07:37 :: Analyze: Handshake phase does not handle packet 3 (fd 20)
SYSERR: Jun 5 09:07:39 :: Analyze: Handshake phase does not handle packet 3 (fd 20)
SYSERR: Jun 5 09:08:49 :: Analyze: Handshake phase does not handle packet 3 (fd 20)
SYSERR: Jun 5 09:10:07 :: Analyze: Handshake phase does not handle packet 3 (fd 20)
SYSERR: Jun 5 09:10:07 :: Analyze: Handshake phase does not handle packet 3 (fd 20)
SYSERR: Jun 5 09:10:29 :: Analyze: Handshake phase does not handle packet 3 (fd 20)

Anuleaza scrierea din sursa game -> log.cpp
cauta : void LogManager::RefineLog(DWORD pid, const char* item_name, DWORD item_id, int item_refine_level, int is_success, const char* how)
inlocuieste asa :

void LogManager::RefineLog(DWORD pid, const char* item_name, DWORD item_id, int item_refine_level, int is_success, const char* how)
{
//    m_sql.EscapeString(__escape_hint, sizeof(__escape_hint), item_name, strlen(item_name));

//    Query("INSERT INTO refinelog%s (pid, item_name, item_id, step, time, is_success, setType) VALUES(%u, '%s', %u, %d, NOW(), %d, '%s')",
//            get_table_postfix(), pid, __escape_hint, item_id, item_refine_level, is_success, how);
}

banuliciraul123 scrie: ↑08 Iun 2021, 08:44 Anuleaza scrierea din sursa game -> log.cpp
cauta : void LogManager::RefineLog(DWORD pid, const char* item_name, DWORD item_id, int item_refine_level, int is_success, const char* how)
inlocuieste asa :

void LogManager::RefineLog(DWORD pid, const char* item_name, DWORD item_id, int item_refine_level, int is_success, const char* how)
{
//    m_sql.EscapeString(__escape_hint, sizeof(__escape_hint), item_name, strlen(item_name));

//    Query("INSERT INTO refinelog%s (pid, item_name, item_id, step, time, is_success, setType) VALUES(%u, '%s', %u, %d, NOW(), %d, '%s')",
//            get_table_postfix(), pid, __escape_hint, item_id, item_refine_level, is_success, how);
}

Rezolvat T/C

T/C.
Mutat în probleme rezolvate.