Problem with EP 4.5 Itemmall

02/14/2019 00:15 [IX]Sefa#1
Dear community,

I've searched for hours in epvp now for a possible fix of my Problem.

My database got like 5-6 new scripts about NCash or files like Itemmallfix.dll, but everything i tried didn't work.

Everything else seems to be fine but just itemmall crashes after 1 buy.

Informations :
- Ep 4.5 Database by [ADM]Grr
- Sql Express 2012
- Ep 4.5 Client

Hope you can help me with my issue.

Best Regards, [IX]Sefa
02/14/2019 07:40 {Skrillex}#2
Hi,
the Itemmallfix.dll is not needed in Episode 4.5. Please post your logs in a [SPOILER][./SPOILER] Tag. You need to remove the dot in the bbcode. You can find your logs under
"C:\ShaiyaServer\SERVER\PSM_Client\Bin\Log" Or something like this if you donīt changed the path.

Regards
02/14/2019 10:24 [IX]Sefa#3
Thanks for the quick answer.

Part 1 : ps_Game logs :


Part 2 : ps_UserLog


Part 3 : PS_DBAgent

02/14/2019 11:11 RebirthEpic#4
Quote:
Originally Posted by [IX]Sefa View Post
Thanks for the quick answer.

Part 1 : ps_Game logs :


Part 2 : ps_UserLog


Part 3 : PS_DBAgent

I'm Sure He'il Solve Your Problem.
[Only registered and activated users can see links. Click Here To Register...]
02/14/2019 11:29 Velocity.#5
Quote:
Originally Posted by [IX]Sefa View Post
Thanks for the quick answer.

Part 1 : ps_Game logs :


Part 2 : ps_UserLog


Part 3 : PS_DBAgent
To fix the G.Rank issue just run this:
Code:
USE [PS_GameData]
GO

/****** Object:  StoredProcedure [dbo].[usp_Read_Guild2_R]    Script Date: 2/14/2019 11:27:11 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO







ALTER Proc [dbo].[usp_Read_Guild2_R]

AS

SET NOCOUNT ON

SELECT G.GuildID, G.GuildName, G.MasterName, G.Country, G.GuildPoint, 
ISNULL(H.Rank,31) Rank, ISNULL(H.Etin,0) Etin, ISNULL(H.UseHouse,0) UseHouse, ISNULL(H.Remark, '') Remark, ISNULL( H.BuyHouse,0) BuyHouse, ISNULL(H.EtinReturnCnt, 0 )  EtinReturnCnt, ISNULL(H.KeepEtin, 0) KeepEtin
FROM Guilds G
LEFT OUTER JOIN GuildDetails H ON G.GuildID = H.GuildID
WHERE G.Del=0
ORDER BY H.Rank DESC

SET NOCOUNT OFF

GO
or change G.Rank to H.Rank on the last line in usp_Read_Guild2_R

As to the item mall fix, the error is right in the log. All you had to do was read : )

Check out this link: [Only registered and activated users can see links. Click Here To Register...] "MSDTC on server 'DESKTOP-PDR30JE' is unavailable."
02/14/2019 11:31 XareL#6
Quote:
2019-02-13 23:59:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Rank'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2019-02-13 23:59:29 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R
You can solve this problem by [Only registered and activated users can see links. Click Here To Register...] and applying it.
If you are using SQL 2012 Edition,
If you don't implement it, guild names won't appear in the game.
02/14/2019 12:44 [IX]Sefa#7
Quote:
Originally Posted by RebirthEpic View Post
I'm Sure He'il Solve Your Problem.
[Only registered and activated users can see links. Click Here To Register...]
I've done that one already. Does not work for me.

Instant DC after buying 1x in Itemmall.

Quote:
Originally Posted by Velocity. View Post
To fix the G.Rank issue just run this:
I've included the Script and restarted Services, still i'm getting DC.

New PS_DBAgent Log :


I've found the issue :

I changed the MSDTC to delayed start but forgot to start the Service itself.

But thanks for your time and for helping me to fix this Guild Bug :)

Best Regards, [IX]Sefa
02/14/2019 15:56 [MXD]Takeshi#8
Quote:
Originally Posted by [IX]Sefa View Post
I've done that one already. Does not work for me.

Instant DC after buying 1x in Itemmall.



I've included the Script and restarted Services, still i'm getting DC.

New PS_DBAgent Log :


I've found the issue :

I changed the MSDTC to delayed start but forgot to start the Service itself.

But thanks for your time and for helping me to fix this Guild Bug :)

Best Regards, [IX]Sefa

the service was stopped. solution: need to turn the MSDTC service on

go to Services. (START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES)
Find the service called 'Distributed Transaction Coordinator' and RIGHT CLICK (on it and select) > Start.
make this service to run Automatically for solving this issue permanently

source: Google, a search instead of asking is always the right solution o.o