telecaster|problem party

08/03/2012 17:10 abady100#1
Hi I have a problem in the telecaster in party

- smp_insert_party -

Please solution
08/03/2012 17:28 c1ph3r#2
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.
08/03/2012 17:31 abady100#3
7.4 server stops working completely because the Panel error code
smp_insert_party

CaptainHerlockServer closes itself
08/03/2012 18:19 c1ph3r#4
Post your gamelog.txt
08/03/2012 18:32 abady100#5
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.
08/03/2012 18:38 c1ph3r#6
Looks like you are using 7.3 Databases with the 7.4 GameServer
08/03/2012 18:47 abady100#7
no i'm use DB 7.3 add 7.4
08/03/2012 18:59 c1ph3r#8
Quote:
Originally Posted by abady100 View Post
no i'm use DB 7.3 add 7.4
Don't say no :D At least your Telecaster isn't complete 7.4

Code:
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
08/03/2012 19:02 abady100#9
Well I'm going to try the fix
08/03/2012 23:07 Audric123#10
Quote:
Originally Posted by c1ph3r View Post
Don't say no :D At least your Telecaster isn't complete 7.4

Code:
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.