Quote:
Originally Posted by M>M
hi guy's
iam having a prb with my game001 i cant open it every time i open the game001
it give me an error here an image for the error
no one know how to fix this error
|
The Gameserver tells you the Problem:
In your case, the stored procedure [dbo].[on_server_startup] has an Invalid Column at 'sid'.
To fix that open telecaster -> programmability -> edit dbo.on_server_startup -> Delete all there and insert this
Code:
USE [telecaster]
GO
/****** Object: StoredProcedure [dbo].[on_server_startup] Script Date: 11/03/2011 10:03:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- start of smp_insert_character
ALTER PROCEDURE [dbo].[on_server_startup]
@OUT_SID INT OUTPUT
AS
SET NOCOUNT ON
DECLARE @SID INT;
DECLARE @ITEM INT
SELECT MAX(sid) as max_id FROM Item with (nolock) where sid =@ITEM
SELECT MAX(sid) as max_id FROM Skill with (nolock) where sid =@SID
UPDATE Character SET name = '@' + name WHERE delete_time <= GETDATE() and name not like '@%'
SELECT MAX(sid) as max_id FROM Pet with (nolock) where sid =SID
After you done that, hit F5 and save.
This should solve your Problem.
And next Time dont play with things, that you cant fix on your own.