|
You last visited: Today at 01:01
Advertisement
Shaiya server Failt
Discussion on Shaiya server Failt within the Shaiya Private Server forum part of the Shaiya category.
10/31/2012, 00:14
|
#1
|
elite*gold: 0
Join Date: Jun 2010
Posts: 27
Received Thanks: 0
|
Shaiya server Failt
Wenn ich meinen Shaiya server starte sieht das wie folgt aus:
Die grünen Pfeil-Symbole bei "Game" und "GameLog" gehen nach ca. 3 Sekunden wieder aus!
Was mache ich falsch?
Ich danke im vorhinein.
|
|
|
10/31/2012, 00:26
|
#2
|
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,977
|
Shaiya -> Shaiya Private Server
#Moved to the right section
|
|
|
10/31/2012, 00:32
|
#3
|
elite*gold: 92
Join Date: Aug 2009
Posts: 731
Received Thanks: 971
|
Bitte poste Logs. Es kann mehrere Gründe haben.
PSM_Client/bin/log
|
|
|
10/31/2012, 02:15
|
#4
|
elite*gold: 0
Join Date: Jun 2010
Posts: 27
Received Thanks: 0
|
Da ich mich mit Logs gar nicht auskenne bin ich mir nicht sicher ob ich das Richtige rausgesucht habe.... Unter PSM_Client/bin/log konnte ich nichts finden.
Wenn das Folgende nicht hilfreich ist könntest du mir bitte sagen wie ich an die richtigen Logs komme ? o.O
2012-10-31 01:41:47 PS_DBAGENT__system log start (DBAgent01)
2012-10-31 01:41:47 connect game, Name=
2012-10-31 01:41:47 connect game, Name=
2012-10-31 01:41:48 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Die gespeicherte Prozedur 'usp_Market_INIT' wurde nicht gefunden., SQL STATE: 42000, NATIVE ERROR: 2812 (0xAFC)
2012-10-31 01:41:48 InitMarket failed qerr=-1, {?=call usp_Market_INIT}
2012-10-31 01:41:48 1 1 SAgent:: Disconnect: (9, 1236)
2012-10-31 01:41:48 1 1 T=000:00:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=0,SCS=0, SB=0,SBS=0
2012-10-31 01:41:48 disconnect game, Name=Game01
2012-10-31 01:41:48 save market... wait plz...
2012-10-31 01:41:48 1 1 SAgent:: Disconnect: (4, 64)
2012-10-31 01:41:48 1 1 T=000:00:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=5,SCS=0, SB=2162,SBS=0
2012-10-31 01:41:48 disconnect game, Name=Game01
2012-10-31 01:41:48 save all... wait plz... enter /uc
2012-10-31 01:46:53 connect game, Name=
2012-10-31 01:46:53 connect game, Name=
2012-10-31 01:46:53 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Die gespeicherte Prozedur 'usp_Market_INIT' wurde nicht gefunden., SQL STATE: 42000, NATIVE ERROR: 2812 (0xAFC)
2012-10-31 01:46:53 InitMarket failed qerr=-1, {?=call usp_Market_INIT}
2012-10-31 01:46:53 1 1 SAgent:: Disconnect: (9, 1236)
2012-10-31 01:46:53 1 1 T=000:00:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=0,SCS=0, SB=0,SBS=0
2012-10-31 01:46:53 disconnect game, Name=Game01
2012-10-31 01:46:53 save market... wait plz...
2012-10-31 01:46:54 1 1 SAgent:: Disconnect: (4, 64)
2012-10-31 01:46:54 1 1 T=000:00:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=5,SCS=0, SB=2162,SBS=0
2012-10-31 01:46:54 disconnect game, Name=Game01
2012-10-31 01:46:54 save all... wait plz... enter /uc
2012-10-31 01:41:43 PS_SESSION__system log start (Session)
2012-10-31 01:41:47 connect login
2012-10-31 01:41:48 connect game
2012-10-31 01:41:48 1 1 SAgent:: Disconnect: (4, 64)
2012-10-31 01:41:48 1 1 T=000:00:00:000, RC=2,RCS=0, RB=70,RBS=0, SC=1,SCS=0, SB=5,SBS=0
2012-10-31 01:41:48 disconnect game
2012-10-31 01:46:53 connect game
2012-10-31 01:46:54 1 1 SAgent:: Disconnect: (4, 64)
2012-10-31 01:46:54 1 1 T=000:00:00:000, RC=2,RCS=0, RB=70,RBS=0, SC=1,SCS=0, SB=5,SBS=0
2012-10-31 01:46:54 disconnect game
2012-10-31 01:51:56 1 1 SAgent:: Disconnect: (4, 64)
2012-10-31 01:51:56 1 1 T=000:10:00:000, RC=64,RCS=0, RB=553,RBS=0, SC=7,SCS=0, SB=175,SBS=0
2012-10-31 01:51:56 disconnect login
2012-10-31 01:52:14 connect login
|
|
|
10/31/2012, 02:42
|
#5
|
elite*gold: 92
Join Date: Aug 2009
Posts: 731
Received Thanks: 971
|
Die gespeicherte Prozedur 'usp_Market_INIT' wurde nicht gefunden., SQL STATE: 42000, NATIVE ERROR: 2812 (0xAFC)
*
2012-10-31 01:41:48 disconnect game, Name=Game01
Deine Datenbank ist fehlerhaft. Dir fehlen gespeicherte Prozeduren.
Eventuell Datenbank neu einsetzen und testen. =)
|
|
|
10/31/2012, 09:17
|
#6
|
elite*gold: 5
Join Date: Mar 2012
Posts: 1,007
Received Thanks: 498
|
Schritt 1:
Schritt 2: Das einfügen:
Code:
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Market_INIT] Script Date: 10/31/2012 09:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE Proc [dbo].[usp_Market_INIT]
AS
SET NOCOUNT ON
DECLARE
@CurDate datetime,
@MaxMarketID int
SET @CurDate = GETDATE()
SELECT @MaxMarketID = ISNULL(MAX( MarketID ),0) FROM Market
INSERT INTO [MarketCharResultItems_DelLog]([CharID], [MarketID], [Result], [EndDate], [DelDate])
SELECT [CharID], [MarketID], [Result], [EndDate], @CurDate FROM [MarketCharResultItems] WHERE EndDate <= @CurDate
INSERT INTO [MarketItems_DelLog]([MarketID], [ItemID], [ItemUID], [Type], [TypeID], [Quality], [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [Maketime], [Maketype])
SELECT [MarketID], [ItemID], [ItemUID], [Type], [TypeID], [Quality], [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [Maketime], [Maketype] FROM [MarketItems]
WHERE MarketID IN ( SELECT [MarketID] FROM [MarketCharResultItems] WHERE EndDate <= @CurDate )
DELETE FROM [MarketItems]
WHERE MarketID IN ( SELECT [MarketID] FROM [MarketCharResultItems] WHERE EndDate <= @CurDate )
DELETE FROM [MarketCharResultItems]
WHERE EndDate <= @CurDate
INSERT INTO [MarketCharResultMoney_DelLog]( [MoneyID], [CharID], [MarketID], [Result], [Money], [GuaranteeMoney], [ReturnMoney], [EndDate], [Type], [TypeID], [Quality], [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [DelDate])
SELECT [MoneyID], [CharID], [MarketID], [Result], [Money], [GuaranteeMoney], [ReturnMoney], [EndDate], [Type], [TypeID], [Quality], [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], @CurDate FROM [MarketCharResultMoney] WHERE EndDate <= @CurDate
DELETE FROM [MarketCharResultMoney]
WHERE EndDate <= @CurDate
DELETE FROM [Market]
WHERE Del = 1 AND EndDate < DATEADD(day, -16, @CurDate )
RETURN @MaxMarketID
SET NOCOUNT OFF
Schritt 3:
Schritt 4: server neustarten und spaß haben
|
|
|
10/31/2012, 15:55
|
#7
|
elite*gold: 0
Join Date: Jun 2010
Posts: 27
Received Thanks: 0
|
Danke funzt
|
|
|
10/31/2012, 17:09
|
#8
|
elite*gold: 0
Join Date: Oct 2012
Posts: 64
Received Thanks: 43
|
Bitte beachte dein SQL Sevrer ist auf Deutsch & ich bin mir ziemlich sicher das du in spätestens ein Paar stunden Fragst wegen Itemmall dc/WL Deinstallieren deinen Deutschen sql Server & Setzt ihn auf English neu auf.
MFG
Shaiya Raze
|
|
|
10/31/2012, 17:17
|
#9
|
elite*gold: 0
Join Date: Jun 2010
Posts: 27
Received Thanks: 0
|
Ok danke werde ich tun
|
|
|
10/31/2012, 17:57
|
#10
|
elite*gold: 6
Join Date: Oct 2011
Posts: 914
Received Thanks: 421
|
Oder...
... man stellt die Datum&Zeit Einstellungen in SQL auf ein Englisches Datum
|
|
|
All times are GMT +2. The time now is 01:01.
|
|