Commands out of sync;

09/07/2013 18:16 distil#1
Hi,

Some days ago, I got this repetitive problem and I've not found the solution for now.
I hope someone will be able to help me or redirect me in the right way.

I start the server, all is ok for some few hours.

After some minutes/hours, I got this exemples of repetitives errors in the DB syserr/syslog like 5-10 times per seconds:

PHP Code:
SYSERRSep  4 11:02:43 :: ChildLoopAsyncSQLquery failedCommands out of syncyou can't run this command now (query: DELETE FROM affect WHERE dwPID=64686 AND bType=210 AND bApplyOn=0 errno: 2014)
SYSERR: Sep  4 11:02:44 :: ChildLoop: AsyncSQL: query failed: Commands out of sync; you can'
t run this command now (queryDELETE FROM item WHERE id=160183640 errno2014
PHP Code:
SYSERRSep  3 09:46:56 :: ChildLoopAsyncSQLquery failedCommands out of syncyou can't run this command now (query: DELETE FROM item WHERE id=240184341 errno: 2014)
SYSERR: Sep  3 09:46:57 :: ChildLoop: AsyncSQL: query failed: Commands out of sync; you can'
t run this command now (queryREPLACE INTO affect (dwPIDbTypebApplyOnlApplyValuedwFlaglDurationlSPCostVALUES(6456449520916600errno2014)
SYSERRSep  3 09:46:58 :: ChildLoopAsyncSQLquery failedCommands out of syncyou can't run this command now (query: UPDATE monarch set money=3190265 where empire=1 errno: 2014) 
PHP Code:
SYSERRSep  6 18:52:36 :: ChildLoopAsyncSQLquery failedCommands out of syncyou can't run this command now (query: DELETE FROM item WHERE id=60662832 errno: 2014)
SYSERR: Sep  6 18:52:38 :: ChildLoop: AsyncSQL: query failed: Commands out of sync; you can'
t run this command now (queryDELETE FROM affect WHERE dwPID=60516 AND bType=63 AND bApplyOn=100 errno2014)
SYSERRSep  6 18:52:43 :: ChildLoopAsyncSQLquery failedCommands out of syncyou can't run this command now (query: REPLACE INTO affect (dwPID, bType, bApplyOn, lApplyValue, dwFlag, lDuration, lSPCost) VALUES(59019, 94, 99, 45, 23, 310, 0) errno: 2014) 
I tryed to open all the syserr / syslog file I have on my differents cores but I've not found any error that can cause that until know.

If you have an idea from where this synchronisation error can come from..

Thank you in advance for your help.
09/07/2013 18:37 .Shōgun#2
That's caused by the function oh.takemonarchmoney() which is bugged.
09/07/2013 18:48 distil#3
Oh !
Thank you for your reply, I will try that.

There is a way to debug it or not at all ?

Thank you again, I'm looking for this since some long days ago and it's really difficult with many players playing on a server while the synchronisation of affect is not good ^^! So Thank you ! :D
09/07/2013 19:37 .Shōgun#4
Try to look in your quest folder, if this function is being used, and comment it out.

We have no fix for this atm, maybe some kind soul wants to release one.