problema syser

yonr1 · 07 Feb 2021, 13:24

*Problemă/Întrebare: la fiecare + la item imi apare acel syser
Tipologie server:
*Resursă folosită:
*ServerFiles utilizat: personal
*Syserr:

Cod: Selectaţi tot

SYSERR: Feb  8 20:06:35 :: 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(2876, 'Lama Dintele Stafiei+0', 10000070, 0, NOW(), 1, 'POWER') errno: 1062)
SYSERR: Feb  8 20:13: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(2876, 'Lama Dintele Stafiei+1', 10000071, 1, NOW(), 1, 'POWER') errno: 1062)
SYSERR: Feb  8 20:13: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(2876, 'Lama Dintele Stafiei+2', 10000072, 2, NOW(), 1, 'POWER') errno: 1062)
SYSERR: Feb  8 20:13:15 :: 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(2876, 'Lama Dintele Stafiei+3', 10000073, 3, NOW(), 1, 'POWER') errno: 1062)
SYSERR: Feb  8 20:15:04 :: 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(2876, 'Sabie otravita+0', 10000075, 0, NOW(), 1, 'POWER') errno: 1062)
SYSERR: Feb  8 20:15:08 :: 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(2876, 'Sabie otravita+1', 10000076, 1, NOW(), 1, 'POWER') errno: 1062)
SYSERR: Feb  8 20:15:12 :: 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(2876, 'Sabie otravita+2', 10000077, 2, NOW(), 1, 'POWER') errno: 1062)
SYSERR: Feb  8 20:15:15 :: 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(2876, 'Sabie otravita+3', 10000078, 3, NOW(), 1, 'POWER') errno: 1062)

yonr1 · 08 Feb 2021, 20:12

Am gasit acest tutorial si degeaba, la fie care + la item am acel sysser Doar pe ch 1 core1 /2/3 sysser 0

+ Open db/src/ClientManager.cpp.
+ Search this: QUERY_SAFEBOX_CHANGE_SIZE.
+ Edit this:

if (p->bSize == 1)

snprintf(szQuery, sizeof(szQuery), "INSERT INTO safebox%s (account_id, size) VALUES(%u, %u)", GetTablePostfix(), p->dwID, p->bSize);

else

snprintf(szQuery, sizeof(szQuery), "UPDATE safebox%s SET size=%u WHERE account_id=%u", GetTablePostfix(), p->bSize, p->dwID);

with:

snprintf(szQuery, sizeof(szQuery), "REPLACE INTO safebox%s (account_id, size) VALUES(%u, %u)", GetTablePostfix(), p->dwID, p->bSize);

yonr1 · 09 Feb 2021, 19:00

Din pacate nici un ajutor aici, Am primit raspuns pe alt forum.
rezolvare

anuleaza scrierea din game src 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)

si inlocuieste cu

Cod: Selectaţi tot

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);
}

Tommy Shelby · 09 Feb 2021, 19:06

Subiect marcat ca fiind rezolvat.

problema syser

Problema syser

Problema syser

Problema syser

Problema Syser

Cine este conectat