SR_ShardManager

[naplet]

After 5second i got crash it, what i can do wrong? pls help, thanks

[Dracula Untold]

check again ini files

[mtnman33]

ok according to what i am seeing by the 42000 error code it seams like your char is set to log into a forbidden area or area that is not loaded by the gameserver , try changing the spawn point of your char back to china such as > 25000 reagion 1 x 1 y 1 z and then log back in or restart your server and if thats the problem and fixes it then you need to find out what area it is so that it can be fixed . hope this helps

[Dracula Untold]

Originally Posted by mtnman33

ok according to what i am seeing by the 42000 error code it seams like your char is set to log into a forbidden area or area that is not loaded by the gameserver , try changing the spawn point of your char back to china such as > 25000 reagion 1 x 1 y 1 z and then log back in or restart your server and if thats the problem and fixes it then you need to find out what area it is so that it can be fixed . hope this helps

really ??? are u serious ?
can u read what is the problem ? SR_SHARD crash after 5 sec

(Check again your files)

or add me on skype i help u

[naplet]

this querry repaired my problem thx for help


/****** Object: StoredProcedure [dbo].[_ExistsServiceOffRentItem] Script Date: 09/13/2011 12:03:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE procedure [dbo].[_ExistsServiceOffRentItem]
as

if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )
begin
return -1
end


GO