telecaster|problem party

[abady100]

Hi I have a problem in the telecaster in party

- smp_insert_party -

Please solution

[c1ph3r]

A little more information? What is the problem? If Server crashes i guess you are using 7.3 dbs with 7.4 gs but without an error message or sth. like this it's hard to help.

[abady100]

7.4 server stops working completely because the Panel error code
smp_insert_party

CaptainHerlockServer closes itself

[c1ph3r]

Post your gamelog.txt

[abady100]

2012/08/03 17:55:35 DB COM ERROR(Thread:238, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_InsertParty(dbo.smp_insert_party) : Procedure or function smp_insert_party has too many arguments specified.

2012/08/03 19:17:21 DB COM ERROR(Thread:32, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_InsertParty(dbo.smp_insert_party) : Procedure or function smp_insert_party has too many arguments specified.

[c1ph3r]

Looks like you are using 7.3 Databases with the 7.4 GameServer

[abady100]

no i'm use DB 7.3 add 7.4

[c1ph3r]

Originally Posted by abady100

no i'm use DB 7.3 add 7.4

Don't say no At least your Telecaster isn't complete 7.4

USE [Telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_insert_party]    Script Date: 08/03/2012 18:42:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[smp_insert_party]
	@IN_NAME [nvarchar](31),
	@IN_PARTY_SID [int],
	@IN_LEADER_SID [int],
	@IN_PARTY_TYPE [int]
WITH EXECUTE AS CALLER
AS
SET NOCOUNT ON

insert into Party( sid, name, leader_id, share_mode, party_type, lead_party_id )
 values( @IN_PARTY_SID, @IN_NAME, @IN_LEADER_SID, 0, @IN_PARTY_TYPE, 0 );

This will fix it. But you should use complete 7.4 DBs from the RappelzDownloadCenter

[abady100]

Well I'm going to try the fix

[Audric123]

Originally Posted by c1ph3r

Don't say no At least your Telecaster isn't complete 7.4

USE [Telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_insert_party]    Script Date: 08/03/2012 18:42:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[smp_insert_party]
	@IN_NAME [nvarchar](31),
	@IN_PARTY_SID [int],
	@IN_LEADER_SID [int],
	@IN_PARTY_TYPE [int]
WITH EXECUTE AS CALLER
AS
SET NOCOUNT ON

insert into Party( sid, name, leader_id, share_mode, party_type, lead_party_id )
 values( @IN_PARTY_SID, @IN_NAME, @IN_LEADER_SID, 0, @IN_PARTY_TYPE, 0 );

This will fix it. But you should use complete 7.4 DBs from the RappelzDownloadCenter

Or my fix for 7.4 smp on the Rappelz Download Center.