[HELP]Guilds deleted after restart

[[Dev]Cataclysm]

I did use the search function before posting, but what I found and used, didn't really work out too well for me. Of course In comparing the dependicies of a working Guild table, I can not seem to figure out how to transfer them or get it to work on the Guild table that is having the issue.

So is there a correct query that can be ran to fix this, or is it a modification of the table where I must change something to get it to work correctly? All help is appreciated.

[[Admin]Snuggle]

I had this issue at first too.
Took me awhile to figure out exactly what the issue was even though I thought I looked though everything lol
I thought it was an SP issue so I kept looking there..
Here's what I used to fix it:

Use PS_gamedata

drop table [dbo].[Guilds]

CREATE TABLE [dbo].[Guilds] (
	[RowID] [int] IDENTITY (1, 1) NOT NULL ,
	[GuildID] [int] NOT NULL ,
	[GuildName] [varchar] (30) COLLATE Latin1_General_CI_AS NOT NULL ,
	[MasterUserID] [varchar] (18) COLLATE Latin1_General_CI_AS NOT NULL ,
	[MasterCharID] [int] NOT NULL ,
	[MasterName] [varchar] (30) COLLATE Latin1_General_CI_AS NOT NULL ,
	[Country] [tinyint] NOT NULL ,
	[TotalCount] [smallint] NOT NULL ,
	[GuildPoint] [int] NOT NULL ,
	[Del] [tinyint] DEFAULT (0) ,
	[CreateDate] [datetime] (getdate())  ,
	[DeleteDate] [datetime] (getdate()) 
) ON [PRIMARY]

Credits go to [GM]Recover for his post about it here:

Not sure who originally showed how to fix it.

[Xx.LaMin.xX]

originally one is Twillight from r a n g e z o n e if im not wrong.

[[Dev]Cataclysm]

This is going to sound nubby but eh, I am still readin up on SQL. I have came accross a slight error when executing it. I have even tried playing around with it to see if it would work, but all it gave me was

"Msg 102, Level 15, State 1, Line 16
Incorrect syntax near '('.

So as I have been trying to read up on this through Google & staring at the query to see what to change, i have failed to fix it lol

[Xx.LaMin.xX]

It isnt look like the same i have on my server.. mine is

USE [PS_GameData]
GO
/****** Object: Table [dbo].[Guilds] Script Date: 09/29/2011 06:36:30 ******/
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_AI NOT NULL,
[MasterUserID] [varchar](12) COLLATE Chinese_PRC_Stroke_CI_AI NOT NULL,
[MasterCharID] [int] NOT NULL,
[MasterName] [varchar](30) COLLATE Chinese_PRC_Stroke_CI_AI 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 (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

[[Dev]Cataclysm]

Ok I dropped the table and used your query, going to test it out now Thanks LaMin

*Edit* Tested it and the guild is still there after restart Ty again

[[ADM]BLooM]

Originally Posted by Xx.LaMin.xX

It isnt look like the same i have on my server.. mine is

Ok i tryed this one and i get this error on SQL


Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Guilds' in the database.

[DarkAngel71]

check first line :

USE [PS_GameData]

Add under :

drop table [dbo].[Guilds]

this will delete the table you've got actually, then create the new one ...

(but the first code in this thread seems to be the better one to me -_- ..)

[[ADM]BLooM]

Originally Posted by DarkAngel71

check first line :

USE [PS_GameData]

Add under :

drop table [dbo].[Guilds]

this will delete the table you've got actually, then create the new one ...

(but the first code in this thread seems to be the better one to me -_- ..)

is give me an eror this to

Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'check'.
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near ':'.

Anyone know how to fix it ? Ill aprecied any good post about this !

Done. ! Fixed ... i deleted dbo.Guilds manually and i used this script :

USE [PS_GameData]
GO
/****** Object: Table [dbo].[Guilds] Script Date: 09/29/2011 06:36:30 ******/
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_AI NOT NULL,
[MasterUserID] [varchar](12) COLLATE Chinese_PRC_Stroke_CI_AI NOT NULL,
[MasterCharID] [int] NOT NULL,
[MasterName] [varchar](30) COLLATE Chinese_PRC_Stroke_CI_AI 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 (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Thx to everyone !

[DarkAngel71]

well ... seems I failed my code syntax, or you failed understanding it !!!

I meant :
after first line :

USE [PS_GameData]

add :

drop table [dbo].[Guilds]