prb with game001 and DB

[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

[Raskim2000]

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

 Spoiler

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.