|
You last visited: Today at 18:51
Advertisement
Problem with EP 4.5 Itemmall
Discussion on Problem with EP 4.5 Itemmall within the Shaiya PServer Development forum part of the Shaiya Private Server category.
02/14/2019, 00:15
|
#1
|
elite*gold: 0 
Join Date: Feb 2019
Posts: 9
Received Thanks: 0
|
Problem with EP 4.5 Itemmall
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
|
![[IX]Sefa is offline](images/elitepvpers/statusicon/user_offline.gif)
|
|
|
02/14/2019, 07:40
|
#2
|
elite*gold: 0
Join Date: Mar 2013
Posts: 850
Received Thanks: 408
|
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
|
#3
|
elite*gold: 0
Join Date: Feb 2019
Posts: 9
Received Thanks: 0
|
Thanks for the quick answer.
Part 1 : ps_Game logs :
2019-02-13 23:58:17 PS_GAME__system log start (Game01) [KR]
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/sorp1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/croco1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/croco2
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Troll1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Spink1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/GoldenPig
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Sorp3
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/SorpNamed1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/SorpNamed2
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Sorp2
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/CrocoNamed1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/CrocoNamed2
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/CrocoNamed3
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/OrcNamed1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/OrcNamed2
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/OrcNamed3
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/TrollNamed1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Deinos
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Parridalis
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Alcarian
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/ZinAlcaria
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Belizabeth
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Kirhiross
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/CrypticOne
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Haruhion
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Freezing
2019-02-13 23:58:33 <Console input> /nprotectoff
2019-02-13 23:58:33 <Console output> cmd NProtect off ok
2019-02-13 23:59:28 connect mgr 1296
2019-02-13 23:59:29 connect dbagent 1300
2019-02-13 23:59:29 connect dbagent2 1292
2019-02-13 23:59:29 connect gamelog 1316
2019-02-13 23:59:29 Market End -----------------------
2019-02-13 23:59:30 Load Shaiya.SData 2
2019-02-14 00:00:53 discon client: (104, 1236) T=000:01:00:000, RC=6,RCS=0, RB=69,RBS=0, SC=72,SCS=0, SB=1528,SBS=20
2019-02-14 00:59:39 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 01:59:39 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 02:59:40 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 03:59:40 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 04:59:40 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 05:59:40 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 06:59:40 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 07:59:41 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 08:59:41 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 09:59:41 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
Part 2 : ps_UserLog
2019-02-13 23:58:09 PS_USERLOG__system log start (UserLog)
2019-02-13 23:58:11 connect
2019-02-13 23:58:21 connect
2019-02-13 23:59:29 connect
Part 3 : PS_DBAgent
2019-02-13 23:58:15 PS_DBAGENT__system log start (DBAgent01)
2019-02-13 23:59:29 connect game, Name=
2019-02-13 23:59:29 connect game, Name=
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
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
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
2019-02-14 00:00:53 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'DESKTOP-PDR30JE' is unavailable., SQL STATE: 42000, NATIVE ERROR: 8501 (0x2135)
2019-02-14 00:00:53 SaveBuyPointItem 3 test2 qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,3,0,'FD_Goddes s_Set','2019-02-14 00:00:53')}
|
|
|
|
|
02/14/2019, 11:11
|
#4
|
elite*gold: 0
Join Date: Mar 2017
Posts: 111
Received Thanks: 123
|
Quote:
Originally Posted by [IX]Sefa
Thanks for the quick answer.
Part 1 : ps_Game logs :
2019-02-13 23:58:17 PS_GAME__system log start (Game01) [KR]
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/sorp1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/croco1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/croco2
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Troll1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Spink1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/GoldenPig
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Sorp3
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/SorpNamed1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/SorpNamed2
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Sorp2
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/CrocoNamed1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/CrocoNamed2
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/CrocoNamed3
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/OrcNamed1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/OrcNamed2
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/OrcNamed3
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/TrollNamed1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Deinos
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Parridalis
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Alcarian
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/ZinAlcaria
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Belizabeth
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Kirhiross
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/CrypticOne
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Haruhion
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Freezing
2019-02-13 23:58:33 <Console input> /nprotectoff
2019-02-13 23:58:33 <Console output> cmd NProtect off ok
2019-02-13 23:59:28 connect mgr 1296
2019-02-13 23:59:29 connect dbagent 1300
2019-02-13 23:59:29 connect dbagent2 1292
2019-02-13 23:59:29 connect gamelog 1316
2019-02-13 23:59:29 Market End -----------------------
2019-02-13 23:59:30 Load Shaiya.SData 2
2019-02-14 00:00:53 discon client: (104, 1236) T=000:01:00:000, RC=6,RCS=0, RB=69,RBS=0, SC=72,SCS=0, SB=1528,SBS=20
2019-02-14 00:59:39 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 01:59:39 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 02:59:40 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 03:59:40 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 04:59:40 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 05:59:40 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 06:59:40 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 07:59:41 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 08:59:41 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 09:59:41 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
Part 2 : ps_UserLog
2019-02-13 23:58:09 PS_USERLOG__system log start (UserLog)
2019-02-13 23:58:11 connect
2019-02-13 23:58:21 connect
2019-02-13 23:59:29 connect
Part 3 : PS_DBAgent
2019-02-13 23:58:15 PS_DBAGENT__system log start (DBAgent01)
2019-02-13 23:59:29 connect game, Name=
2019-02-13 23:59:29 connect game, Name=
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
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
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
2019-02-14 00:00:53 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'DESKTOP-PDR30JE' is unavailable., SQL STATE: 42000, NATIVE ERROR: 8501 (0x2135)
2019-02-14 00:00:53 SaveBuyPointItem 3 test2 qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,3,0,'FD_Goddes s_Set','2019-02-14 00:00:53')}
|
I'm Sure He'il Solve Your Problem.
|
|
|
|
|
02/14/2019, 11:29
|
#5
|
elite*gold: 0
Join Date: Jul 2016
Posts: 237
Received Thanks: 324
|
Quote:
Originally Posted by [IX]Sefa
Thanks for the quick answer.
Part 1 : ps_Game logs :
2019-02-13 23:58:17 PS_GAME__system log start (Game01) [KR]
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/sorp1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/croco1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/croco2
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Troll1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Spink1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/GoldenPig
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Sorp3
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/SorpNamed1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/SorpNamed2
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Sorp2
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/CrocoNamed1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/CrocoNamed2
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/CrocoNamed3
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/OrcNamed1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/OrcNamed2
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/OrcNamed3
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/TrollNamed1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Deinos
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Parridalis
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Alcarian
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/ZinAlcaria
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Belizabeth
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Kirhiross
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/CrypticOne
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Haruhion
2019-02-13 23:58:18 Loaded Behavior In Factory : data/ai/Freezing
2019-02-13 23:58:33 <Console input> /nprotectoff
2019-02-13 23:58:33 <Console output> cmd NProtect off ok
2019-02-13 23:59:28 connect mgr 1296
2019-02-13 23:59:29 connect dbagent 1300
2019-02-13 23:59:29 connect dbagent2 1292
2019-02-13 23:59:29 connect gamelog 1316
2019-02-13 23:59:29 Market End -----------------------
2019-02-13 23:59:30 Load Shaiya.SData 2
2019-02-14 00:00:53 discon client: (104, 1236) T=000:01:00:000, RC=6,RCS=0, RB=69,RBS=0, SC=72,SCS=0, SB=1528,SBS=20
2019-02-14 00:59:39 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 01:59:39 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 02:59:40 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 03:59:40 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 04:59:40 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 05:59:40 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 06:59:40 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 07:59:41 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 08:59:41 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2019-02-14 09:59:41 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
Part 2 : ps_UserLog
2019-02-13 23:58:09 PS_USERLOG__system log start (UserLog)
2019-02-13 23:58:11 connect
2019-02-13 23:58:21 connect
2019-02-13 23:59:29 connect
Part 3 : PS_DBAgent
2019-02-13 23:58:15 PS_DBAGENT__system log start (DBAgent01)
2019-02-13 23:59:29 connect game, Name=
2019-02-13 23:59:29 connect game, Name=
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
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
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
2019-02-14 00:00:53 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'DESKTOP-PDR30JE' is unavailable., SQL STATE: 42000, NATIVE ERROR: 8501 (0x2135)
2019-02-14 00:00:53 SaveBuyPointItem 3 test2 qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,3,0,'FD_Goddes s_Set','2019-02-14 00:00:53')}
|
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: "MSDTC on server 'DESKTOP-PDR30JE' is unavailable."
|
|
|
|
|
02/14/2019, 11:31
|
#6
|
elite*gold: 0
Join Date: Nov 2017
Posts: 159
Received Thanks: 346
|
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 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
|
#7
|
elite*gold: 0
Join Date: Feb 2019
Posts: 9
Received Thanks: 0
|
Re : RebirthEpic
Quote:
Originally Posted by RebirthEpic
I'm Sure He'il Solve Your Problem.
|
I've done that one already. Does not work for me.
Instant DC after buying 1x in Itemmall.
Quote:
Originally Posted by Velocity.
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 :
2019-02-14 12:45:31 PS_DBAGENT__system log start (DBAgent01)
2019-02-14 12:46:44 connect game, Name=
2019-02-14 12:46:44 connect game, Name=
2019-02-14 12:48:09 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'DESKTOP-PDR30JE' is unavailable., SQL STATE: 42000, NATIVE ERROR: 8501 (0x2135)
2019-02-14 12:48:09 SaveBuyPointItem 3 test2 qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,3,0,'FD_Goddes s_Set','2019-02-14 12:48:09')}
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
|
#8
|
elite*gold: 0
Join Date: Nov 2017
Posts: 137
Received Thanks: 148
|
Quote:
Originally Posted by [IX]Sefa
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 :
2019-02-14 12:45:31 PS_DBAGENT__system log start (DBAgent01)
2019-02-14 12:46:44 connect game, Name=
2019-02-14 12:46:44 connect game, Name=
2019-02-14 12:48:09 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'DESKTOP-PDR30JE' is unavailable., SQL STATE: 42000, NATIVE ERROR: 8501 (0x2135)
2019-02-14 12:48:09 SaveBuyPointItem 3 test2 qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,3,0,'FD_Goddes s_Set','2019-02-14 12:48:09')}
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
|
|
|
|
 |
Similar Threads
|
[Problem] With ItemMall
03/21/2016 - Shaiya PServer Development - 2 Replies
Hello, this is my first post on this issue because they do not usually do post because I first look how to get to the solution of the problem but apparently no post about this problem, I tried to fix it myself from the same DB but equally not I could tried several things but all got a rejection or fail, Al grain .. some time ago I installed it on my Private Server EP6 with a DB EP4 update most important data for work until now is working 100% I have not had any problems with pets, potions,...
|
I curse ITEMMALL, I hate ITEMMALL, I'll burn ITEMMALL [calm down szokersonik]
02/19/2016 - SRO Private Server - 7 Replies
Hey Fellas!
As You can see my patient is over, ITEMALL ruined it.
I dont fcking get it, no matter wich one(item), no matter how, if i add any new ITEM to itemmall im getting DC all time when im trying to buy it(with any other items old, existed in itemmall i dont have any problems, i can buy'em easily).
IF i add exacly the same item using the same rule to NPC shop i dont have any problems, so wth is wrong with that ITEMMALL?
Okay:
|
ps_game.exe/ItemMall Problem
07/02/2014 - Shaiya PServer Development - 4 Replies
Hallo ihr Lieben.
Ich habe da ein Problem.
Ich wollte eine andere ps_game.exe verwenden für mein Server.
Aber sobald ich sie verwende,kann ich die ItemMall nicht mehr benutzen. Sowie keine AP ingame angezeigt wird.
Verwende ich wieder die alte ps_game.exe funktioniert alles wieder.
Kennt da vielleicht jemand die Ursache?
lg grüße
|
Give me Solution from problem of ItemMall
01/17/2014 - Rohan - 3 Replies
http://www.elitepvpers.com/forum/attachment.php?at tachmentid=201461&stc=1&d=1389449922
|
ItemMall |Jupiter Teample |Problem !
06/23/2012 - SRO Private Server - 2 Replies
Hello Elitepvper's , today ihave 2 problem !
:)
i have add new all avarar ksro vsro ,,,,,
so if open itemall ! icant foud it's a litle Avatar !
i can get avatar with GM Command ! only but i not see this avatar on itemmall
This the litlte avatar :( only this found :-
|
All times are GMT +1. The time now is 18:53.
|
|
![[MXD]Takeshi's Avatar](https://www.elitepvpers.com/forum/customavatars/avatar7305562_2.gif){kind=avatar}
