Interesting Problem...

[Su1ph3r]

So...I am having an issue with the item mall. After a small update a day ago for some minor gear changes, every time I try to buy something from the item mall I instantly DC, and when I log back in all of my Points are gone. Add more points, try again, insta DC, points are gone.

I searched the forums here and I found the Item Mall fix that was posted on here that was an issue with the Distributed Transaction Coordinator service in Windows. So I checked that and the service was in fact running, but I restarted it a few times for good measure, still nothing.

I also rolled back the update, and made sure that all of the .sdata's were replaced with clean unmodified versions, still nothing.

But the interesting thing is that I have literally the exact same files running on another test server and it is working perfectly, so it has to be something with either the server files themselves or some kind of shenanigans happening in the db, but I am uber frustrated and getting nowhere so hopefully one of you has had a similar problem and can shed some light on it for me.

[_-Phoenix-_]

will you post a copy of the error report here so we can see it and maybe we might be able to help. also are you useing the ep 6 server files that are posted here?

[TeddyBear94]

Originally Posted by _-Phoenix-_

will you post a copy of the error report here so we can see it and maybe we might be able to help. also are you useing the ep 6 server files that are posted here?

he is not using the ep6 files and here is the error report he has.

 Spoiler

2012-11-18 19:29:30 error exp over usern=Su1ph3r2,charn=[GM]Su1ph3r[F], level=80,exp=-1,exppn=0

2012-11-18 19:30:07 discon client: (104, 1236) T=000:00:00:000, RC=6,RCS=0, RB=90,RBS=2, SC=40,SCS=0, SB=2572,SBS=61

2012-11-18 19:30:41 error exp over usern=Su1ph3r2,charn=[GM]Su1ph3r[F], level=80,exp=-1,exppn=0

2012-11-18 19:35:24 error exp over usern=Su1ph3r,charn=[GM]Su1ph3r, level=80,exp=-1,exppn=0

2012-11-18 19:37:22 discon client: (104, 1236) T=000:02:00:000, RC=7,RCS=0, RB=73,RBS=0, SC=135,SCS=0, SB=5845,SBS=41

2012-11-18 19:38:12 error exp over usern=wolf420,charn=Brom, level=80,exp=0,exppn=0

2012-11-18 19:39:34 discon client: (104, 1236) T=000:01:00:000, RC=8,RCS=0, RB=85,RBS=0, SC=87,SCS=0, SB=8381,SBS=91

2012-11-18 19:40:04 1 1 SWorker::Run():m_iocp.GetStatus() 121 (1036)

2012-11-18 19:40:04 discon client: ( 5, 121) T=000:09:00:000, RC=2,RCS=0, RB=32,RBS=0, SC=24,SCS=0, SB=1284,SBS=2

2012-11-18 19:40:23 error exp over usern=Su1ph3r,charn=[GM]Su1ph3r, level=80,exp=-1,exppn=0

[ShaiyaOmega]

Why would your level 80 have EXP of -1 that looks like one of those errors people ran into after using instant leveling scripts... Because they set the level in the database but not the EXP to a level that would coincide with the level.

This was discussed where Snuggles Released the ILS.

But that error "which is all i see in that" can not be causing the disconnect after item mall purchase.

[Su1ph3r]

Originally Posted by ShaiyaOmega

Why would your level 80 have EXP of -1 that looks like one of those errors people ran into after using instant leveling scripts... Because they set the level in the database but not the EXP to a level that would coincide with the level.

This was discussed where Snuggles Released the ILS.

But that error "which is all i see in that" can not be causing the disconnect after item mall purchase.

That's it exactly. The exp is set at -1 on my test server as well and everything is working perfectly there. I'm also not using instant leveling scripts.

Edit:
I found this error that I hadn't seen before

2012-11-18 23:27:20 SaveBuyPointItem 15 [GM]Su1ph3r[F] qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(15,15,500,'lc',' 2012-11-18 23:27:19')}

Edit 2:

Fixed it, ended up having to restore all my databases.