[Help] Problem in Guild Creation

[sandolkakos]

Hi guys, i am geting a error in Guild Creation.
I can Create one Guild, but if i Shutdown my server, the Guild dont appears in next Server Start. Cause the Guild only stay recorded in Memory.

in my logs i have detected the error, that also happen when i try execute the script to create manually in SQL Query.

I already have looked about this error in Google, but dont sucess in all results.
If somebody know how fix, and can help me, i thank you now

PS_DBAGENT__system.log:

2010-03-04 02:30:21 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server][COLOR="Red"]Transaction context in use by another session[/COLOR]., SQL STATE: 42000, NATIVE ERROR: 3910 (0xF46)

2010-03-04 02:30:21 DBGuild::CreateGuild Failed 2, TesteGuilde, 3, Kirsten01[ADM], qerr=-1, EXEC usp_Create_Guild2_E 2,'TesteGuilde','myLogin',3,'myCharName',0,'Teste Guilde 01'

Test 01 with Procedure in SQL Query:

EXEC usp_Create_Guild2_E 2,'TesteGuilde','myLogin',3,'myCharName',0,'Teste Guilde 01'

error:
Msg 3910, Level 16, State 2, Line 1
[COLOR="Red"]Transaction context in use by another session.[/COLOR]

Test 02 with Direct INSERT in SQL Query:

INSERT INTO Guilds(GuildID,GuildName,MasterUserID,MasterCharID,MasterName,Country,TotalCount,GuildPoint,CreateDate)
	VALUES(2,'TesteGuilde','myLogin',3,'myCharName',0,0,0,GETDATE())

error:
Msg 3910, Level 16, State 2, Line 1
[COLOR="Red"]Transaction context in use by another session.[/COLOR]

************************************************** *
@edit - FIX BELLOW
i have fixed, the problem was the Language in Table Structure.
With Guild Leaders Name Purple working; and without crashes when to view Guild Message.

i have traded = Korean_Wansung_CI_AS
for = Chinese_PRC_Stroke_CI_AS

if you already have some Guild created, CAUTION! SAVE BEFORE!

1. DELETE your dbo.Guilds TABLE
2. Use this SQL Query:

USE [PS_GameData]
GO
/****** Creation Guild Fixed by sandolkakos: Shaiya-UGO Server - www.universalgamesonline.com.br  ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Guilds](
	[RowID] [int] IDENTITY(1,1) NOT NULL,
	[GuildID] [int] NOT NULL,
	[GuildName] [varchar](30) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[MasterUserID] [varchar](18) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[MasterCharID] [int] NOT NULL,
	[MasterName] [varchar](30) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[Country] [tinyint] NOT NULL,
	[TotalCount] [smallint] NOT NULL,
	[GuildPoint] [int] NOT NULL,
	[Del] [tinyint] NOT NULL CONSTRAINT [DF_Guilds_Del]  DEFAULT ((0)),
	[CreateDate] [datetime] NOT NULL,
	[DeleteDate] [datetime] NULL,
 CONSTRAINT [PK_Guilds] PRIMARY KEY CLUSTERED 
(
	[GuildID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

if somebody have other doubt about this, i will help.

[Schwap]

i found this:

but i didnt got it working, might be cause of my miserable knowledge of mssql

[ProfNerwosol]

There is a Trigger on dbo.Guilds, which whenever this table is changed, adds a record to PS_UserData.dbo.CreatedGuilds which doesn't exist. I tried creating it to make it work but without success so I deleted that Trigger. Everything went smoothly after that, but I don't have my guild listed in Guild List ingame. Figures...

[sandolkakos]

thanks for your helps, i will try the oLago and ProfNerwosol solutions.

ProfNerwosol, you speak that your guilds dont appears listed inGame, but when you restart the server, the Guilds continue ?

[ProfNerwosol]

Originally Posted by sandolkakos

thanks for your helps, i will try the oLago and ProfNerwosol solutions.

ProfNerwosol, you speak that your guilds dont appears listed inGame, but when you restart the server, the Guilds continue ?

Yup, the guild exists even when I restart the server. The only problems I encountered is ... guild name over guild leaders head is white not purple; oh and game crashes when I try to view guild message. No idea why.

[sandolkakos]

Originally Posted by ProfNerwosol

Yup, the guild exists even when I restart the server. The only problems I encountered is ... guild name over guild leaders head is white not purple; oh and game crashes when I try to view guild message. No idea why.

Thanks for Explain my brother, i will test this, and go back here to inform my result.

@edit
i have fixed, the problem was the Language in Table Structure.
With Guild Leaders Name Purple working; and without crashes when to view Guild Message.

i have traded = Korean_Wansung_CI_AS
for = Chinese_PRC_Stroke_CI_AS

if you already have some Guild created, CAUTION! SAVE BEFORE!

1. DELETE your dbo.Guilds TABLE
2. Use this SQL Query:

USE [PS_GameData]
GO
/****** Creation Guild Fixed by sandolkakos: Shaiya-UGO Server - www.universalgamesonline.com.br  ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Guilds](
	[RowID] [int] IDENTITY(1,1) NOT NULL,
	[GuildID] [int] NOT NULL,
	[GuildName] [varchar](30) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[MasterUserID] [varchar](18) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[MasterCharID] [int] NOT NULL,
	[MasterName] [varchar](30) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[Country] [tinyint] NOT NULL,
	[TotalCount] [smallint] NOT NULL,
	[GuildPoint] [int] NOT NULL,
	[Del] [tinyint] NOT NULL CONSTRAINT [DF_Guilds_Del]  DEFAULT ((0)),
	[CreateDate] [datetime] NOT NULL,
	[DeleteDate] [datetime] NULL,
 CONSTRAINT [PK_Guilds] PRIMARY KEY CLUSTERED 
(
	[GuildID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

if somebody have other doubt about this, i will help.

[thunderxc]

OkaY I tried this in my test server. Im not sure if working because I have not reset the server.

How do I change the guild rank? Also how can I turn on the GRB Event?

Thanks

[sandolkakos]

Originally Posted by thunderxc

OkaY I tried this in my test server. Im not sure if working because I have not reset the server.

How do I change the guild rank? Also how can I turn on the GRB Event?

Thanks

i still dont know about this events,
i am knowing this game now in my PServer, and i am learning all things

Because this error in Guild, only today with the FIX, that my players have created GUILDs.

[thunderxc]

Originally Posted by sandolkakos

i still dont know about this events,
i am knowing this game now in my PServer, and i am learning all things

Because this error in Guild, only today with the FIX, that my players have created GUILDs.

Thank you sir for the update. I really appreciate it.


EDIT: How to remove 5 days waiting on Guild House ?

[remnikalija]

this is not working to me

[(Virus)]

Thank You verry much for this, sandolkakos

[FU84R]

Originally Posted by thunderxc

Thank you sir for the update. I really appreciate it.


EDIT: How to remove 5 days waiting on Guild House ?

Not sure if there is a script available, but if you go into the PS_GameData dbo.GuildDetails table and in the UseHouse collum, change the 0 to a 1. worked for me. Hop its ok as at least a temp fix.

EDIT: To change the guild rank, the rank collum is also in the dbo.GuildDetails table. simply change the info to the desired rank and hey hey, your good to go.

[Xx.LaMin.xX]

You can also use the GM commands =)