Jump to content

Recommended Posts

  • Premium
Spoiler

SYSERR: Jun 21 23:35:33 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '11171' for key 'PRIMARY' (query: INSERT INTO safebox (account_id, size) VALUES(11171, 1) errno: 1062)
SYSERR: Jun 21 23:35:43 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0,attrtype1, attrvalue1,attrtype2, attrvalue2,attrtype3, attrvalue3,attrtype4, attrvalue4,attrtype5, attrvalue5,attrtype6, attrvalue6,applytype0, applyvalue0,applytype1, applyvalue1,applytype2, applyvalue2,applytype3, applyvalue3,applytype4, applyvalue4,applytype5, applyvalue5,applytype6, applyvalue6,applytype7, applyvalue7)VALUES(12314632, 11171, 3, 34, 1, 19, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, errno: 1064)

Syserr db

Link to comment
Share on other sites

Hi, you're using a quest that is trying to change the actual safebox's size when isn't necessary, because already set. Change your quest, or if you're using sources:

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

 
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



  • Similar Content

  • Activity

    1. 5

      Effect weapons

    2. 3

      Crystal Metinstone

    3. 3

      Feeding game source to LLM

    4. 113

      Ulthar SF V2 (TMP4 Base)

    5. 3

      Feeding game source to LLM

    6. 0

      Target Information System

    7. 3

      Feeding game source to LLM

    8. 2

      anti exp explanation pls

  • Recently Browsing

    • No registered users viewing this page.
×
×
  • 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.