Jump to content

the items in the storage are lost.


Recommended Posts

the items in the storage are lost.

sysrr

SYSERR: Mar 29 15:23:50.86861 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2, socket3, 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,applytype8, applyvalue8,applytype9, applyvalue9,applytype10, applyvalue10,applytype11, applyvalue11,applytype12, applyvalue12,applytype13, applyvalue13)VALUES(10001250, 1, 3, 11, 1, 469, 28433, 28434, 28435, 0, 17, 10, 5, 12, 3, 12, 15, 15, 9, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1136)

 

clientmanager.cpp safebox

		char szQuery[756];
		snprintf(szQuery, sizeof(szQuery), 
				"SELECT id, window+0, pos, count, vnum, socket0, socket1, socket2, socket3, "
				"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, "
				"applytype8, applyvalue8, "
				"applytype9, applyvalue9, "
				"applytype10, applyvalue10, "
				"applytype11, applyvalue11, "
				"applytype12, applyvalue12, "
				"applytype13, applyvalue13 "
				"FROM item%s WHERE owner_id=%d AND window='%s'",
				GetTablePostfix(), pi->account_id, pi->ip[0] == 0 ? "SAFEBOX" : "MALL");
				pi->account_index = 1;

		CDBManager::instance().ReturnQuery(szQuery, QID_SAFEBOX_LOAD, pkPeer->GetHandle(), pi);

 

Link to comment
Share on other sites

  • Replies 6
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

21 minutes ago, WLsj24 said:

Db / src / ClientManager.cpp:
Doğru değerleri girip girmediğinizi kontrol edin, çünkü syserr sorgusunda sizden 5 sütun daha girdiğinizden emin olun.



Excel'e kopyalayın, sonra ne demek istediğimi göreceksiniz

problem char szQuery [756]; It stems. char szQuery [756]; I don't know what value to write here.

Link to comment
Share on other sites

  • Bot
1 hour ago, enisina said:

problem char szQuery [756]; It stems. char szQuery [756]; I don't know what value to write here.

I have this:
 

Spoiler

		char szQuery[512];
		snprintf(szQuery, sizeof(szQuery),
				"SELECT id, window+0, pos, count, vnum, socket0, socket1, socket2, "
				"attrtype0, attrvalue0, "
				"attrtype1, attrvalue1, "
				"attrtype2, attrvalue2, "
				"attrtype3, attrvalue3, "
				"attrtype4, attrvalue4, "
				"attrtype5, attrvalue5, "
				"attrtype6, attrvalue6 "
				"FROM item%s WHERE owner_id=%d AND window='%s'",
				GetTablePostfix(), pi->account_id, pi->ip[0] == 0 ? "SAFEBOX" : "MALL");

		pi->account_index = 1;

		CDBManager::instance().ReturnQuery(szQuery, QID_SAFEBOX_LOAD, pkPeer->GetHandle(), pi);

 

 

english_banner.gif

Link to comment
Share on other sites

  • Bot
22 minutes ago, enisina said:

char szQuery [512]; If I do, the storage does not open

Then 756 is fine, i think that your problem is here:

2 hours ago, WLsj24 said:

In db/src/ClientManager.cpp:
Check if you are entering the correct values, because in the syserr query you are entering 5 more columns than you have

https://pastebin.com/ijyZ2UC1

Copy it (RAW paste data) in excel, then you will see what I mean

 

english_banner.gif

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



×
×
  • 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.