[Help]Disappearing Items

[[ADM]Bedlam]

Hello all, I have in recent weeks had a problem with items disappearing from players on my server. I have seen a post at some point covering this but I can't seem to find it. I'd like to be able to correct this without getting rid of the anti-dupe feature but I can't seem to come up with the answer no matter how much I look into it, and I don't ask for help until all resources are covered... (I love to learn it for myself & quickly usually:P )

Anyone have a clue how I can resolve this?
TY in advance

[kraken.zhangar]

many players have the same problem?

[MC Flip]

Items dissapearing from players inventories sounds like Duping to me, even though you mentioned a Anti-Dupe Fix.

[JohnHeatz]

Can you explain a little bit more of how is that those items are disappearing? Because as MC_Flip said, the only situation I can think of for this to happen is with dupped items, which as everyone know, disappear after relogging

[[ADM]Bedlam]

items disappearing are normally gears, most times linked ones, many it happens just after one of the upper staff does a GM enchant on the items and trades it back... a few cases i've had people who witnessed the lost item come from a drop. There has even been a time it was a shield of a [GS] which i knew had the item for some time. But most cases it seems to be an item they received within their last login period. I do have the AdminPanel modification to my DB released by [DEV]xXDASHXx and have for some time.

[[ADM]Reaper]

its not all duped items item mall items disappearing players gear and we checked and they wasn't duped

[MC Flip]

Then there might be an issue with updating the CharItems.dbo for some reason.

[[ADM]Bedlam]

Looking into my LogGathers i've noticed a couple of repetitive errors involving ODBC....

one, in PS_GAMELOG__system.log after every entry on the log:

2012-05-30 14:51:46 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '******',1613,3462,'******', 77,1011362800,42, 43.577400,1.891644,44.511642, '2012-05-30 14:51:45' ,122, 3565807940789207041,100082, 30,22,NULL,2,15,1500,NULL,NULL,'Operator's Exclusive',NULL,'0,0,0,0,0,0 (Option:)','2012-05-30 04:45:46'

2012-05-30 14:51:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

PS_LOGIN__system.log after each toon's login:

2012-05-30 14:42:43 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan '******','******', 3565982977886257153,'***.***.**.**', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2012-05-30 14:42:45 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)

PS_DBAGENT__system.log:

2012-05-30 12:21:58 ::LoadBillingItem 2953  qerr=-1, EXEC usp_Read_Char_Product_Item_E 2953

2012-05-30 12:55:41 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'PS_Billing' is being recovered. Waiting until recovery is finished., SQL STATE: 42000, NATIVE ERROR: 922 (0x39A)

2012-05-30 12:55:41 ::LoadBillingItem 105  qerr=-1, EXEC usp_Read_Char_Product_Item_E 105

2012-05-30 12:57:56 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'PS_Billing' is being recovered. Waiting until recovery is finished., SQL STATE: 42000, NATIVE ERROR: 922 (0x39A)

2012-05-30 12:57:56 ::LoadBillingItem 1748  qerr=-1, EXEC usp_Read_Char_Product_Item_E 1748

2012-05-30 13:32:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'PS_Billing' is being recovered. Waiting until recovery is finished., SQL STATE: 42000, NATIVE ERROR: 922 (0x39A)

2012-05-30 13:32:42 ::LoadBillingItem 2384  qerr=-1, EXEC usp_Read_Char_Product_Item_E 2384

2012-05-30 13:37:02 err=-1, [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification, SQL STATE: 22018, NATIVE ERROR: 0 (0x0)

2012-05-30 13:37:02 ::SaveCharacter 8131 --Karciuuu-- ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(8131,70, 0,63, 706,12,11,8,7,11, -22913,3661,19130, 2,358, 2000000000,630576739, 1.#QNAN0,68.475410,1.#QNAN0, 0,200,0,0,0, 0,0,0,0, 0,0)}

2012-05-30 13:37:02 err=-1, [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification, SQL STATE: 22018, NATIVE ERROR: 0 (0x0)

2012-05-30 13:37:02 ::SaveCharacter 8131 --Karciuuu-- ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(8131,70, 0,63, 706,12,11,8,7,11, -22913,3661,19130, 2,358, 2000000000,630576739, 1.#QNAN0,68.475410,1.#QNAN0, 0,200,0,0,0, 0,0,0,0, 0,0)}

2012-05-30 13:44:25 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'PS_Billing' is being recovered. Waiting until recovery is finished., SQL STATE: 42000, NATIVE ERROR: 922 (0x39A)

(health state on PS_Billing is showing as normal not recovery)


Edited out logged account info..... Is it an issue with item names including apostrophe? "Incorrect syntax near 's' " Not all the items disappearing have " 's " in the name though. Not sure how related these issues might be...

as you see I'm having several issues with database efficiency and though I'm a fast learner & use brain.exe fairly well could use some advice.
Again TY in advance for any help

[Cookie@Diavolo]

I've seen in your PS_GAMELOG__system.log post. there is an apostrophe ( ' ) in the item name ('Operator's Exclusive') , the one before the "s". The SQL "thinks" the Item name is ending there.
I would delete all apostrophes like (') in the names or maybe you can replace them with an (`) or (´).

This is the solution if all of your disappearing items have an ( ' ) in their names.

Greets Cookie

[KarmaIsMe]

Have you ever truncated old data?
Are you using SQL 2005? 2008? 2012? Each of these versions has either 4GB~10GB of storage space. If you have either a moderately large server with many players/items on it or you simply NEVER clean up your databases or shrink them, this error can occure due to the fact that the information has exceeded the ammount of storage space for the database.

Simple fix is just to truncate all data previous of prior to the last week~month. This should free up some space on your databases so that you can continue to safe data without having items disappear.

To check to see if this is your problem look at your SQL logs.

Hope it helps,
Karma

[[ADM]Bedlam]

Time will tell fully, but despite knowing the size limitation on databases I had forgotten & didn't occur to me lol. thanks for this reminder... seems for now to have helped.

[zokylove]

[ADM]Bedlam use LPH dupe fix(dbAgent Fixed) cas the problem is the dupe fix haved same problems some time ago

[Bаne]

Dupeing can also be traced, remeber that.

[mulletman]

another server was having an similar problem but the biggest disappearing culprit were etain potions. It wasn't a problem for those that had been on server for a while and had massive stores of gold but for those starting out they would spend almost all their gold to buy the etain pots then if something as small as a DC happened there was the possibility that they would log in to find their stack on etain pots gone.

[[ADM]Bedlam]

Yes I am still having items vanish, seemed to have slowed but still happening.

Originally Posted by zokylove

[ADM]Bedlam use LPH dupe fix(dbAgent Fixed) cas the problem is the dupe fix haved same problems some time ago

As far as i've found, this no longer exists here.