Using SQL 2008

Jan 23, 2010 at 7:33 PM

I am entirely new to Blogengine.NET, and don't know much about SQL Server. I can create an MS SQL Server 2008 DB using SQL Server Management Studio, but when I run the script to create the tables, I get a raft of errors:

Incorrect syntax near '('

and

Incorrect syntax near 'max'

I note that one post here says BE was not designed to run with SQL 2008. Are there fixes to the script that will work with SQL 2008?

Coordinator
Jan 23, 2010 at 9:29 PM

You should be able to use SQL 2008.  I've actually been testing running the setup script on SQL 2008 with no problems.

It's SQL 2000 that the setup script won't run on because of the nvarchar(max) types that were introduced in SQL 2005 and aren't in SQL 2000.

I would make sure you're running the setup script in the setup\SQLServer folder ... because there's other setup scripts for other databases (setup\MySQL, etc).

If you want, paste the script you're running here.

Jan 24, 2010 at 8:55 PM

Microsoft SQL Management Studio reports itself as having SQL Server 8.0.2055 running on <servername>/SHAREPOINT, which is one of the servers installed on this installation of Microsoft Small Business Server 2003 R2 Premium. There two SQL desktop engines reported to be installed: SHAREPOINT and SBSMONITORING. MS Visual Studio Tools for Applications is also reported as being installed; sometimes VS installs SQL versions that conflict with other installed versions. (This machine also has SQL Compact Edition installed on it.) On that server, I have added a database named BlogEngine. I choose BlogEngine to run the script against. It's this script -- setup/MSSQL/MSSQLSetup1.5.0.0.sql. Here's the content, with the error messages following:

/****** BlogEngine.NET 1.5 SQL Setup Script ******/

/****** Object:  Table [dbo].[be_Categories]    Script Date: 12/22/2007 14:14:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_Categories](
 [CategoryID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_Categories_CategoryID]  DEFAULT (newid()),
 [CategoryName] [nvarchar](50) NULL,
 [Description] [nvarchar](200) NULL,
 [ParentID] [uniqueidentifier] NULL,
 CONSTRAINT [PK_be_Categories] PRIMARY KEY CLUSTERED
(
 [CategoryID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[be_DataStoreSettings]    Script Date: 06/28/2008 19:29:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[be_DataStoreSettings](
 [ExtensionType] [nvarchar](50) NOT NULL,
 [ExtensionId] [nvarchar](100) NOT NULL,
 [Settings] [nvarchar](max) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[be_Pages]    Script Date: 12/22/2007 14:15:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_Pages](
 [PageID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_Pages_PageID]  DEFAULT (newid()),
 [Title] [nvarchar](255) NULL,
 [Description] [nvarchar](max) NULL,
 [PageContent] [nvarchar](max) NULL,
 [Keywords] [nvarchar](max) NULL,
 [DateCreated] [datetime] NULL,
 [DateModified] [datetime] NULL,
 [IsPublished] [bit] NULL,
 [IsFrontPage] [bit] NULL,
 [Parent] [uniqueidentifier] NULL,
 [ShowInList] [bit] NULL,
 CONSTRAINT [PK_be_Pages] PRIMARY KEY CLUSTERED
(
 [PageID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[be_PingService]    Script Date: 12/22/2007 14:15:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_PingService](
 [PingServiceID] [int] IDENTITY(1,1) NOT NULL,
 [Link] [nvarchar](255) NULL,
 CONSTRAINT [PK_be_PingService] PRIMARY KEY CLUSTERED
(
 [PingServiceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[be_Posts]    Script Date: 12/22/2007 14:16:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_Posts](
 [PostID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_Posts_PostID]  DEFAULT (newid()),
 [Title] [nvarchar](255) NULL,
 [Description] [nvarchar](max) NULL,
 [PostContent] [nvarchar](max) NULL,
 [DateCreated] [datetime] NULL,
 [DateModified] [datetime] NULL,
 [Author] [nvarchar](50) NULL,
 [IsPublished] [bit] NULL,
 [IsCommentEnabled] [bit] NULL,
 [Raters] [int] NULL,
 [Rating] [real] NULL,
 [Slug] [nvarchar](255) NULL,
 CONSTRAINT [PK_be_Posts] PRIMARY KEY CLUSTERED
(
 [PostID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[be_Settings]    Script Date: 12/22/2007 14:16:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_Settings](
 [SettingName] [nvarchar](50) NOT NULL,
 [SettingValue] [nvarchar](max) NULL,
 CONSTRAINT [PK_be_Settings] PRIMARY KEY CLUSTERED
(
 [SettingName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[be_Profiles]    Script Date: 06/28/2008 19:33:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_Profiles](
 [ProfileID] [int] IDENTITY(1,1) NOT NULL,
 [UserName] [nvarchar](100) NULL,
 [SettingName] [nvarchar](200) NULL,
 [SettingValue] [nvarchar](max) NULL,
 CONSTRAINT [PK_be_Profiles] PRIMARY KEY CLUSTERED
(
 [ProfileID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[be_StopWords]    Script Date: 06/28/2008 19:33:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_StopWords](
 [StopWord] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_be_StopWords] PRIMARY KEY CLUSTERED
(
 [StopWord] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[be_PostCategory]    Script Date: 12/22/2007 14:17:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_PostCategory](
 [PostCategoryID] [int] IDENTITY(1,1) NOT NULL,
 [PostID] [uniqueidentifier] NOT NULL,
 [CategoryID] [uniqueidentifier] NOT NULL,
 CONSTRAINT [PK_be_PostCategory] PRIMARY KEY CLUSTERED
(
 [PostCategoryID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[be_PostCategory]  WITH CHECK ADD  CONSTRAINT [FK_be_PostCategory_be_Categories] FOREIGN KEY([CategoryID])
REFERENCES [dbo].[be_Categories] ([CategoryID])
GO
ALTER TABLE [dbo].[be_PostCategory] CHECK CONSTRAINT [FK_be_PostCategory_be_Categories]
GO
ALTER TABLE [dbo].[be_PostCategory]  WITH CHECK ADD  CONSTRAINT [FK_be_PostCategory_be_Posts] FOREIGN KEY([PostID])
REFERENCES [dbo].[be_Posts] ([PostID])
GO
ALTER TABLE [dbo].[be_PostCategory] CHECK CONSTRAINT [FK_be_PostCategory_be_Posts]
GO
/****** Object:  Table [dbo].[be_PostComment]    Script Date: 12/22/2007 14:17:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_PostComment](
 [PostCommentID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_PostComment_PostCommentID]  DEFAULT (newid()),
 [PostID] [uniqueidentifier] NOT NULL,
 [ParentCommentID] [uniqueidentifier] NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000'),
 [CommentDate] [datetime] NOT NULL,
 [Author] [nvarchar](255) NULL,
 [Email] [nvarchar](255) NULL,
 [Website] [nvarchar](255) NULL,
 [Comment] [nvarchar](max) NULL,
 [Country] [nvarchar](255) NULL,
 [Ip] [nvarchar](50) NULL,
 [IsApproved] [bit] NULL,
 CONSTRAINT [PK_be_PostComment] PRIMARY KEY CLUSTERED
(
 [PostCommentID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[be_PostComment]  WITH CHECK ADD  CONSTRAINT [FK_be_PostComment_be_Posts] FOREIGN KEY([PostID])
REFERENCES [dbo].[be_Posts] ([PostID])
GO
ALTER TABLE [dbo].[be_PostComment] CHECK CONSTRAINT [FK_be_PostComment_be_Posts]
GO
/****** Object:  Table [dbo].[be_PostNotify]    Script Date: 12/22/2007 14:17:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_PostNotify](
 [PostNotifyID] [int] IDENTITY(1,1) NOT NULL,
 [PostID] [uniqueidentifier] NOT NULL,
 [NotifyAddress] [nvarchar](255) NULL,
 CONSTRAINT [PK_be_PostNotify] PRIMARY KEY CLUSTERED
(
 [PostNotifyID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[be_PostNotify]  WITH CHECK ADD  CONSTRAINT [FK_be_PostNotify_be_Posts] FOREIGN KEY([PostID])
REFERENCES [dbo].[be_Posts] ([PostID])
GO
ALTER TABLE [dbo].[be_PostNotify] CHECK CONSTRAINT [FK_be_PostNotify_be_Posts]
GO
/****** Object:  Table [dbo].[be_PostTag]    Script Date: 12/22/2007 14:17:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_PostTag](
 [PostTagID] [int] IDENTITY(1,1) NOT NULL,
 [PostID] [uniqueidentifier] NOT NULL,
 [Tag] [nvarchar](50) NULL,
 CONSTRAINT [PK_be_PostTag] PRIMARY KEY CLUSTERED
(
 [PostTagID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[be_PostTag]  WITH CHECK ADD  CONSTRAINT [FK_be_PostTag_be_Posts] FOREIGN KEY([PostID])
REFERENCES [dbo].[be_Posts] ([PostID])
GO
ALTER TABLE [dbo].[be_PostTag] CHECK CONSTRAINT [FK_be_PostTag_be_Posts]
GO
/****** Object:  Table [dbo].[be_Users]    Script Date: 07/30/2008 21:55:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_Users](
 [UserID] [int] IDENTITY(1,1) NOT NULL,
 [UserName] [nvarchar](100) NOT NULL,
 [Password] [nvarchar](255) NOT NULL,
 [LastLoginTime] [datetime] NULL,
 [EmailAddress] [nvarchar](100) NULL,
 CONSTRAINT [PK_be_Users] PRIMARY KEY CLUSTERED
(
 [UserID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[be_Roles]    Script Date: 07/30/2008 21:56:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_Roles](
 [RoleID] [int] IDENTITY(1,1) NOT NULL,
 [Role] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_be_Roles] PRIMARY KEY CLUSTERED
(
 [RoleID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[be_UserRoles]    Script Date: 07/31/2008 12:26:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_UserRoles](
 [UserRoleID] [int] IDENTITY(1,1) NOT NULL,
 [UserID] [int] NOT NULL,
 [RoleID] [int] NOT NULL,
 CONSTRAINT [PK_be_UserRoles] PRIMARY KEY CLUSTERED
(
 [UserRoleID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[be_UserRoles]  WITH CHECK ADD  CONSTRAINT [FK_be_UserRoles_be_Roles] FOREIGN KEY([RoleID])
REFERENCES [dbo].[be_Roles] ([RoleID])
GO
ALTER TABLE [dbo].[be_UserRoles] CHECK CONSTRAINT [FK_be_UserRoles_be_Roles]
GO
ALTER TABLE [dbo].[be_UserRoles]  WITH CHECK ADD  CONSTRAINT [FK_be_UserRoles_be_Users] FOREIGN KEY([UserID])
REFERENCES [dbo].[be_Users] ([UserID])
GO
ALTER TABLE [dbo].[be_UserRoles] CHECK CONSTRAINT [FK_be_UserRoles_be_Users]
GO
/****** Object:  Index [FK_PostID]    Script Date: 12/22/2007 14:18:36 ******/
CREATE NONCLUSTERED INDEX [FK_PostID] ON [dbo].[be_PostCategory]
(
 [PostID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Index [FK_CategoryID]    Script Date: 12/22/2007 14:19:19 ******/
CREATE NONCLUSTERED INDEX [FK_CategoryID] ON [dbo].[be_PostCategory]
(
 [CategoryID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Index [FK_PostID]    Script Date: 12/22/2007 14:19:45 ******/
CREATE NONCLUSTERED INDEX [FK_PostID] ON [dbo].[be_PostComment]
(
 [PostID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Index [FK_PostID]    Script Date: 12/22/2007 14:20:29 ******/
CREATE NONCLUSTERED INDEX [FK_PostID] ON [dbo].[be_PostNotify]
(
 [PostID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Index [FK_PostID]    Script Date: 12/22/2007 14:20:43 ******/
CREATE NONCLUSTERED INDEX [FK_PostID] ON [dbo].[be_PostTag]
(
 [PostID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Index [I_TypeID]    Script Date: 06/28/2008 19:34:43 ******/
CREATE NONCLUSTERED INDEX [I_TypeID] ON [dbo].[be_DataStoreSettings]
(
 [ExtensionType] ASC,
 [ExtensionId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Index [I_UserName]    Script Date: 06/28/2008 19:35:12 ******/
CREATE NONCLUSTERED INDEX [I_UserName] ON [dbo].[be_Profiles]
(
 [UserName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/***  Load initial Data ***/
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('administratorrole', 'Administrators');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('alternatefeedurl', '');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('authorname', 'My name');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('avatar', 'combine');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('blogrollmaxlength', '23');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('blogrollupdateminutes', '60');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('blogrollvisibleposts', '3');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('contactformmessage', '<p>I will answer the mail as soon as I can.</p>');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('contactthankmessage', '<h1>Thank you</h1><p>The message was sent.</p>');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('culture', 'Auto');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('dayscommentsareenabled', '0');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('description', 'Short description of the blog');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('displaycommentsonrecentposts', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('displayratingsonrecentposts', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('email', 'user@example.com');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('emailsubjectprefix', 'Weblog');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('enablecommentsearch', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('enablecommentsmoderation', 'False');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('enablecontactattachments', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('enablecountryincomments', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('enablehttpcompression', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('enableopensearch', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('enablepingbackreceive', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('enablepingbacksend', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('enablerating', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('enablereferrertracking', 'False');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('enablerelatedposts', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('enablessl', 'False');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('enabletrackbackreceive', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('enabletrackbacksend', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('endorsement', 'http://www.dotnetblogengine.net/syndication.axd');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('fileextension', '.aspx');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('geocodinglatitude', '0');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('geocodinglongitude', '0');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('handlewwwsubdomain', '');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('iscocommentenabled', 'False');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('iscommentsenabled', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('language', 'en-GB');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('mobiletheme', 'Mobile');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('name', 'Name of the blog');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('numberofrecentcomments', '10');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('numberofrecentposts', '10');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('postsperfeed', '10');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('postsperpage', '10');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('removewhitespaceinstylesheets', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('searchbuttontext', 'Search');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('searchcommentlabeltext', 'Include comments in search');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('searchdefaulttext', 'Enter search term');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('sendmailoncomment', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('showdescriptioninpostlist', 'False');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('showlivepreview', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('showpostnavigation', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('smtppassword', 'password');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('smtpserver', 'mail.example.dk');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('smtpserverport', '25');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('smtpusername', 'user@example.com');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('storagelocation', '~/App_Data/');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('syndicationformat', 'Rss');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('theme', 'Standard');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('timestamppostlinks', 'True');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('timezone', '-5');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('trackingscript', '');

INSERT INTO be_PingService (Link) VALUES ('http://rpc.technorati.com/rpc/ping');
INSERT INTO be_PingService (Link) VALUES ('http://rpc.pingomatic.com/rpc2');
INSERT INTO be_PingService (Link) VALUES ('http://ping.feedburner.com');
INSERT INTO be_PingService (Link) VALUES ('http://www.bloglines.com/ping');
INSERT INTO be_PingService (Link) VALUES ('http://services.newsgator.com/ngws/xmlrpcping.aspx');
INSERT INTO be_PingService (Link) VALUES ('http://api.my.yahoo.com/rpc2 ');
INSERT INTO be_PingService (Link) VALUES ('http://blogsearch.google.com/ping/RPC2');
INSERT INTO be_PingService (Link) VALUES ('http://rpc.pingthesemanticweb.com/');

INSERT INTO be_StopWords (StopWord) VALUES ('a');
INSERT INTO be_StopWords (StopWord) VALUES ('about');
INSERT INTO be_StopWords (StopWord) VALUES ('actually');
INSERT INTO be_StopWords (StopWord) VALUES ('add');
INSERT INTO be_StopWords (StopWord) VALUES ('after');
INSERT INTO be_StopWords (StopWord) VALUES ('all');
INSERT INTO be_StopWords (StopWord) VALUES ('almost');
INSERT INTO be_StopWords (StopWord) VALUES ('along');
INSERT INTO be_StopWords (StopWord) VALUES ('also');
INSERT INTO be_StopWords (StopWord) VALUES ('an');
INSERT INTO be_StopWords (StopWord) VALUES ('and');
INSERT INTO be_StopWords (StopWord) VALUES ('any');
INSERT INTO be_StopWords (StopWord) VALUES ('are');
INSERT INTO be_StopWords (StopWord) VALUES ('as');
INSERT INTO be_StopWords (StopWord) VALUES ('at');
INSERT INTO be_StopWords (StopWord) VALUES ('be');
INSERT INTO be_StopWords (StopWord) VALUES ('both');
INSERT INTO be_StopWords (StopWord) VALUES ('but');
INSERT INTO be_StopWords (StopWord) VALUES ('by');
INSERT INTO be_StopWords (StopWord) VALUES ('can');
INSERT INTO be_StopWords (StopWord) VALUES ('cannot');
INSERT INTO be_StopWords (StopWord) VALUES ('com');
INSERT INTO be_StopWords (StopWord) VALUES ('could');
INSERT INTO be_StopWords (StopWord) VALUES ('de');
INSERT INTO be_StopWords (StopWord) VALUES ('do');
INSERT INTO be_StopWords (StopWord) VALUES ('down');
INSERT INTO be_StopWords (StopWord) VALUES ('each');
INSERT INTO be_StopWords (StopWord) VALUES ('either');
INSERT INTO be_StopWords (StopWord) VALUES ('en');
INSERT INTO be_StopWords (StopWord) VALUES ('for');
INSERT INTO be_StopWords (StopWord) VALUES ('from');
INSERT INTO be_StopWords (StopWord) VALUES ('good');
INSERT INTO be_StopWords (StopWord) VALUES ('has');
INSERT INTO be_StopWords (StopWord) VALUES ('have');
INSERT INTO be_StopWords (StopWord) VALUES ('he');
INSERT INTO be_StopWords (StopWord) VALUES ('her');
INSERT INTO be_StopWords (StopWord) VALUES ('here');
INSERT INTO be_StopWords (StopWord) VALUES ('hers');
INSERT INTO be_StopWords (StopWord) VALUES ('his');
INSERT INTO be_StopWords (StopWord) VALUES ('how');
INSERT INTO be_StopWords (StopWord) VALUES ('i');
INSERT INTO be_StopWords (StopWord) VALUES ('if');
INSERT INTO be_StopWords (StopWord) VALUES ('in');
INSERT INTO be_StopWords (StopWord) VALUES ('into');
INSERT INTO be_StopWords (StopWord) VALUES ('is');
INSERT INTO be_StopWords (StopWord) VALUES ('it');
INSERT INTO be_StopWords (StopWord) VALUES ('its');
INSERT INTO be_StopWords (StopWord) VALUES ('just');
INSERT INTO be_StopWords (StopWord) VALUES ('la');
INSERT INTO be_StopWords (StopWord) VALUES ('like');
INSERT INTO be_StopWords (StopWord) VALUES ('long');
INSERT INTO be_StopWords (StopWord) VALUES ('make');
INSERT INTO be_StopWords (StopWord) VALUES ('me');
INSERT INTO be_StopWords (StopWord) VALUES ('more');
INSERT INTO be_StopWords (StopWord) VALUES ('much');
INSERT INTO be_StopWords (StopWord) VALUES ('my');
INSERT INTO be_StopWords (StopWord) VALUES ('need');
INSERT INTO be_StopWords (StopWord) VALUES ('new');
INSERT INTO be_StopWords (StopWord) VALUES ('now');
INSERT INTO be_StopWords (StopWord) VALUES ('of');
INSERT INTO be_StopWords (StopWord) VALUES ('off');
INSERT INTO be_StopWords (StopWord) VALUES ('on');
INSERT INTO be_StopWords (StopWord) VALUES ('once');
INSERT INTO be_StopWords (StopWord) VALUES ('one');
INSERT INTO be_StopWords (StopWord) VALUES ('ones');
INSERT INTO be_StopWords (StopWord) VALUES ('only');
INSERT INTO be_StopWords (StopWord) VALUES ('or');
INSERT INTO be_StopWords (StopWord) VALUES ('our');
INSERT INTO be_StopWords (StopWord) VALUES ('out');
INSERT INTO be_StopWords (StopWord) VALUES ('over');
INSERT INTO be_StopWords (StopWord) VALUES ('own');
INSERT INTO be_StopWords (StopWord) VALUES ('really');
INSERT INTO be_StopWords (StopWord) VALUES ('right');
INSERT INTO be_StopWords (StopWord) VALUES ('same');
INSERT INTO be_StopWords (StopWord) VALUES ('see');
INSERT INTO be_StopWords (StopWord) VALUES ('she');
INSERT INTO be_StopWords (StopWord) VALUES ('so');
INSERT INTO be_StopWords (StopWord) VALUES ('some');
INSERT INTO be_StopWords (StopWord) VALUES ('such');
INSERT INTO be_StopWords (StopWord) VALUES ('take');
INSERT INTO be_StopWords (StopWord) VALUES ('takes');
INSERT INTO be_StopWords (StopWord) VALUES ('that');
INSERT INTO be_StopWords (StopWord) VALUES ('the');
INSERT INTO be_StopWords (StopWord) VALUES ('their');
INSERT INTO be_StopWords (StopWord) VALUES ('these');
INSERT INTO be_StopWords (StopWord) VALUES ('thing');
INSERT INTO be_StopWords (StopWord) VALUES ('this');
INSERT INTO be_StopWords (StopWord) VALUES ('to');
INSERT INTO be_StopWords (StopWord) VALUES ('too');
INSERT INTO be_StopWords (StopWord) VALUES ('took');
INSERT INTO be_StopWords (StopWord) VALUES ('und');
INSERT INTO be_StopWords (StopWord) VALUES ('up');
INSERT INTO be_StopWords (StopWord) VALUES ('use');
INSERT INTO be_StopWords (StopWord) VALUES ('used');
INSERT INTO be_StopWords (StopWord) VALUES ('using');
INSERT INTO be_StopWords (StopWord) VALUES ('very');
INSERT INTO be_StopWords (StopWord) VALUES ('was');
INSERT INTO be_StopWords (StopWord) VALUES ('we');
INSERT INTO be_StopWords (StopWord) VALUES ('well');
INSERT INTO be_StopWords (StopWord) VALUES ('what');
INSERT INTO be_StopWords (StopWord) VALUES ('when');
INSERT INTO be_StopWords (StopWord) VALUES ('where');
INSERT INTO be_StopWords (StopWord) VALUES ('who');
INSERT INTO be_StopWords (StopWord) VALUES ('will');
INSERT INTO be_StopWords (StopWord) VALUES ('with');
INSERT INTO be_StopWords (StopWord) VALUES ('www');
INSERT INTO be_StopWords (StopWord) VALUES ('you');
INSERT INTO be_StopWords (StopWord) VALUES ('your');

DECLARE @postID uniqueidentifier, @catID uniqueidentifier;

SET @postID = NEWID();
SET @catID = NEWID();

INSERT INTO be_Categories (CategoryID, CategoryName)
 VALUES (@catID, 'General');

INSERT INTO be_Posts (PostID, Title, Description, PostContent, DateCreated, Author, IsPublished)
 VALUES (@postID,
 'Welcome to BlogEngine.NET 1.5 using Microsoft SQL Server',
 'The description is used as the meta description as well as shown in the related posts. It is recommended that you write a description, but not mandatory',
 '<p>If you see this post it means that BlogEngine.NET 1.5 is running with SQL Server and the DbBlogProvider is configured correctly.</p>
 <h2>Setup</h2>
 <p>If you are using the ASP.NET Membership provider, you are set to use existing users.  If you are using the default BlogEngine.NET XML provider, it is time to setup some users.  Find the sign-in link located either at the bottom or top of the page depending on your current theme and click it. Now enter "admin" in both the username and password fields and click the button. You will now see an admin menu appear. It has a link to the "Users" admin page. From there you can change the username and password.</p>
 <h2>Write permissions</h2>
 <p>Since you are using SQL to store your posts, most information is stored there.  However, if you want to store attachments or images in the blog, you will want write permissions setup on the App_Data folder.</p>
 <h2>On the web </h2>
 <p>You can find BlogEngine.NET on the <a href="http://www.dotnetblogengine.net">official website</a>. Here you will find tutorials, documentation, tips and tricks and much more. The ongoing development of BlogEngine.NET can be followed at <a href="http://www.codeplex.com/blogengine">CodePlex</a> where the daily builds will be published for anyone to download.</p>
 <p>Good luck and happy writing.</p>
 <p>The BlogEngine.NET team</p>',
 GETDATE(),
 'admin',
 1);

INSERT INTO be_PostCategory (PostID, CategoryID)
 VALUES (@postID, @catID);
INSERT INTO be_PostTag (PostID, Tag)
 VALUES (@postID, 'blog');
INSERT INTO be_PostTag (PostID, Tag)
 VALUES (@postID, 'welcome');

INSERT INTO be_Users (UserName, Password, LastLoginTime, EmailAddress)
 VALUES ('Admin', '', GETDATE(), 'email@example.com');
INSERT INTO be_Roles (Role)
 VALUES ('Administrators');
INSERT INTO be_Roles (Role)
 VALUES ('Editors');
INSERT INTO be_UserRoles (UserID, RoleID)
VALUES (1, 1);

INSERT INTO be_DataStoreSettings (ExtensionType, ExtensionId, Settings)
VALUES (1, 'be_WIDGET_ZONE',
'<?xml version="1.0" encoding="utf-16"?>
<WidgetData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Settings>&lt;widgets&gt;&lt;widget id="d9ada63d-3462-4c72-908e-9d35f0acce40" title="TextBox" showTitle="True"&gt;TextBox&lt;/widget&gt;&lt;widget id="19baa5f6-49d4-4828-8f7f-018535c35f94" title="Administration" showTitle="True"&gt;Administration&lt;/widget&gt;&lt;widget id="d81c5ae3-e57e-4374-a539-5cdee45e639f" title="Search" showTitle="True"&gt;Search&lt;/widget&gt;&lt;widget id="77142800-6dff-4016-99ca-69b5c5ebac93" title="Tag cloud" showTitle="True"&gt;Tag cloud&lt;/widget&gt;&lt;widget id="4ce68ae7-c0c8-4bf8-b50f-a67b582b0d2e" title="RecentPosts" showTitle="True"&gt;RecentPosts&lt;/widget&gt;&lt;/widgets&gt;</Settings>
</WidgetData>');

GO

And these are the errors that I get:

Msg 170, Level 15, State 1, Line 9
Line 9: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostCategory' because this table does not exist in database 'BlogEngine'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostCategory' because this table does not exist in database 'BlogEngine'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostCategory' because this table does not exist in database 'BlogEngine'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostCategory' because this table does not exist in database 'BlogEngine'.
Msg 170, Level 15, State 1, Line 9
Line 9: Incorrect syntax near 'max'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostComment' because this table does not exist in database 'BlogEngine'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostComment' because this table does not exist in database 'BlogEngine'.
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostNotify' because this table does not exist in database 'BlogEngine'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostNotify' because this table does not exist in database 'BlogEngine'.
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostTag' because this table does not exist in database 'BlogEngine'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostTag' because this table does not exist in database 'BlogEngine'.
Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_UserRoles' because this table does not exist in database 'BlogEngine'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_UserRoles' because this table does not exist in database 'BlogEngine'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_UserRoles' because this table does not exist in database 'BlogEngine'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_UserRoles' because this table does not exist in database 'BlogEngine'.
Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'be_Settings'.

Coordinator
Jan 24, 2010 at 9:32 PM
Edited Jan 24, 2010 at 9:33 PM

Even though you're using Management Studio, it's connected to a SQL 2000 database (version 8.0.2055).  SQL Server version 8 is SQL 2000.  Version 9 and SQL 2005 and Version 10 is SQL 2008.

So you're running that script against a SQL 2000 database engine.

A while back, I modified the script so it can be run against a SQL 2000 database.  See this thread.  The script in that thread will run and create all the necessary tables and indexes.  I've not actually tested running BE against a SQL 2000 database after using that script.  But it *should* work.

EDIT:  The script in that other thread was for BE 1.4.5.

Jan 25, 2010 at 4:09 AM

Yes, I found that one and tried it previously. It returns this error:

Msg 2782, Level 16, State 1, Line 1
DDL statement is not allowed.

Coordinator
Jan 25, 2010 at 6:21 AM

This isn't a problem with the script.  The environment or DB you're trying to run this script against appears to be locked down.

You can search Google for DDL statement is not allowed.

DDL is creating tables, columns, etc.  You mentioned SharePoint and SBS Monitoring.  Based on posts like this and this my guess is that these DB's are reserved for only SharePoint and SBS Monitoring activities, and they don't want other non-related things in the DB.

Technically, I think you can create tables in these Databases.  But the user account you are connecting to the SQL 2000 DBs under probably doesn't have the necessary DDL creation rights.

You might want to consider installing the free SQL Server 2008 Express edition on the machine.  If you can install it, you'll have the latest version and not have to worry about any compatibility issues with BE and SQL 2000.

Jan 30, 2010 at 6:09 AM

OK, after having too much fun with SQL Server, I'm finally connected.

Just to recap:

Stoopid newbie error 1 -- putting Blogengine DB in Sharepoint SQLServer instance. Of course Sharepoint didn't like that.

Stoopid newbie error 2 -- putting Blogengine DB in SBSMonitoring. Of course, that didn't work and ultimately caused SBSMonitoring to fail entirely, requiring about eleventy-seven attempts to restore it, which were ultimately successful.

BTW, SQLServer 2008 Express wouldn't install.

I wasn't paying attention to the scripts in the SQLServer folder, and missed the upgrade script from 1.4.5 to 1.5 for a while. That also flummoxed me for a while.

I include this in case other benighted souls are trying to set up the BlogEngine, and can search to find this.

Many tries at connection strings, authentication methods, user properties, and more. It seems that setting Security on the server instance to Windows and SQL Authentication finally did the trick.

However, when I try to login now as admin, with the password admin (per setup instructions), I am denied access. I found a post which says to go into the db and set the pw for admin (BTW in the db it is Admin) to nothing, and then try. That didn't work. Neither did setting it to admin. That row now looks like this (sort of; pasting from SQLServer db window loses the formatting), after setting pw back to nothing:

UserID UserName Password LastLoginTime                EmailAddress
1          Admin                         2010-01-29 21:53:43.930 email@example.com

What's the next thing to try?

Coordinator
Jan 30, 2010 at 6:24 AM

Sounds like you've come a long way!

A couple of things to verify in the web.config file.  Is the "defaultProvider" for <blogProvider>, <membership> and <roleManager> the DB providers?  They should look like:

<blogProvider defaultProvider="DbBlogProvider">
<membership defaultProvider="DbMembershipProvider">
<roleManager defaultProvider="DbRoleProvider" enabled="true" cacheRolesInCookie="true" cookieName=".BLOGENGINEROLES">

If you make a change directly in the DB, there's a high probability that BE has the old data cached in memory.  After making a direct change to the DB, if you restart the blog application, BE will get the latest data from the DB.  You can restart the blog application by making any change to the web.config file for example (add a space, etc).

If the password column in the be_Users table is an empty value (like it looks like you have), then logging in under "admin" for the username and "admin" for the password should work.

Jan 30, 2010 at 6:39 AM

The web.config file was the problem. Changing those values did the trick. That must be something I missed in the page on switching to SQL. If it's not there, it should be added.

Thanks for all your help.

Aug 24, 2011 at 4:40 PM

I shut off comments temporarily while I was trying to figure out the best way to deal with the spam. Now, when I go to the configurations tab, I get the following error page:

Ooops! An unexpected error has occurred.

This one's down to me! Please accept my apologies for this - I'll see to it that the developer responsible for this happening is given 20 lashes (but only after he or she has fixed this problem).

Error Details:

Url : http://10.16.173.8/admin/Comments/Settings.aspx

Raw Url : /admin/Comments/Settings.aspx

Message : Exception of type 'System.Web.HttpUnhandledException' was thrown.

Source : System.Web

StackTrace : at System.Web.UI.Page.HandleError(Exception e)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

at System.Web.UI.Page.ProcessRequest()

at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)

at System.Web.UI.Page.ProcessRequest(HttpContext context)

at ASP.admin_comments_settings_aspx.ProcessRequest(HttpContext context)

at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

TargetSite : Boolean HandleError(System.Exception)

Message : Object reference not set to an instance of an object.

Source : App_Web_dus982ch

StackTrace : at admin_Comments_Settings.BindFilters()

at admin_Comments_Settings.Page_Load(Object sender, EventArgs e)

at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)

at System.Web.UI.Control.OnLoad(EventArgs e)

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

TargetSite : Void BindFilters()

How can I fix this? Also, how do I eliminate the spam?

Thx.

Bob Ackerman