[Help]Disappearing Items

[Cookie@Diavolo]

Originally Posted by [ADM]Bedlam

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, Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

Your error code gives the solution. As i posted before, i still think it's the names of the dbo.items in your database.

Sorry for double posting, but your problem concerns me since days. And i think its nothing "big", just a database issue.

Greets Cookie

[sominus]

We're getting the same problem on our server, items are dissapearing all the time. It started about a week ago. Not only traded items, also recent drops, npc items, AP items, everything. And is happening to a lot pf users. Seems that it happens when players re-log.

Searching for duplicated ItemUID just show a few duplicateds (about 20).

The ADM is installing SQL 2008 R2 now (we had 2005), to se if it helps.

[Cookie@Diavolo]

I can think of 3 issues that can cause losing items. But there will be much more, i guess.

1. The windows server needs a restart. Because of a internal windows counter(i forgot that name). It needs to be reset every 45 days, because then it overflows and gives weired data to Shaiya.
2. The duping script dont work proper. But i think then just items disapear which were traded since last relog of the player.
3. The names of the items contain a single apostrophe ( ' ).


And it is normal that the items disapear not before relog, as long as they disapeared server sided.