Shaiya server Failt

10/31/2012 00:14 metaljojo#1
Wenn ich meinen Shaiya server starte sieht das wie folgt aus:

[Only registered and activated users can see links. Click Here To Register...]

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 JohnHeatz#2
#Moved to the right section
10/31/2012 00:32 nephren#3
Bitte poste Logs. Es kann mehrere Gründe haben.

PSM_Client/bin/log
10/31/2012 02:15 metaljojo#4
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 nephren#5
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 Sh1nra#6
Schritt 1: [Only registered and activated users can see links. Click Here To Register...]


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: [Only registered and activated users can see links. Click Here To Register...]


Schritt 4: server neustarten und spaß haben ;)
10/31/2012 15:55 metaljojo#7
Danke funzt ;)
10/31/2012 17:09 Shaiya-Raze#8
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 metaljojo#9
Ok danke werde ich tun ;)
10/31/2012 17:57 thetruestarr1337#10
Oder...

... man stellt die Datum&Zeit Einstellungen in SQL auf ein Englisches Datum