SQL Script Errors

Jan 17, 2008 at 11:13 PM
Hi, I just tried switching to the SQL provider and am having problems with the provded script 'MSSQLSetup1.3.0.0.sql'. Here are the errors:

Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostCategory' because this table does not exist in database 'BlogEngine'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostCategory' because this table does not exist in database 'BlogEngine'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostCategory' because this table does not exist in database 'BlogEngine'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostCategory' because this table does not exist in database 'BlogEngine'.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near 'max'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostComment' because this table does not exist in database 'BlogEngine'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostComment' because this table does not exist in database 'BlogEngine'.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostNotify' because this table does not exist in database 'BlogEngine'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostNotify' because this table does not exist in database 'BlogEngine'.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostTag' because this table does not exist in database 'BlogEngine'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.be_PostTag' because this table does not exist in database 'BlogEngine'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.

Anyone have any ideas?

Thanks,
Nik
Jan 17, 2008 at 11:43 PM
Edited Jan 17, 2008 at 11:44 PM
Come on. Try to learn a little bit about Sql langage.
Something i can tell you about grant_access i am going to do so
Jan 19, 2008 at 12:49 AM
Hey Now Everybody,
I just tryed executing the script in the file MSSQLSetup 1.3 ( blogengine13/blogengine/setup/mssqlsetup1.3). I got the exact same error as nwahlberg. I see it may have something to do with Grant_access. What steps should I take to be able to run the script so the tables are created?
Any advice is greatly appriciated.
Thank you,
Catto.
Jan 19, 2008 at 12:56 AM
I'm using SQLServer 2000. I think this is the reason why it's not running.
Jan 19, 2008 at 11:24 AM
Hi

SQL Server 2000 doesn't support the VARCHAR(MAX), only varchar(numberOfChars).

Replacing this by Varchar(4000) would limit your posts up to 4000 characters.
(Pay attention, because you can have maximum 8000 characters per record in SQL 2000).

Replacing varchar(max) by ntext would disable the ability to do a full text search. if this is not installed. Depending on how it is coded, you can even receive errors.
Jan 20, 2008 at 5:02 PM
Edited Jan 20, 2008 at 5:03 PM
Does Blog engine use full text search? I don't believe that it does anyway; you'd have several stored procs saved using the various functions for full text search, and have to enable the service, create catalogues, jobs to refresh, etc etc. I didn't see that when I loaded it up, but could have missed it.

Lee Everest
MCP MCDBA
SQL Server Consultant
SQLRx.com
Blog: http://www.texastoo.com
Jan 21, 2008 at 4:16 PM
Hi,
I've been editing the SQLSetup1.3.sql file & still receiving errors as mentioned above. I saw a previous post where a person tries to replace the varcar(max) with ntext. I have tried this like on line 25 for example
original: Descriptionnvarchar(max) NULL,
Modified to : Descriptionntext NULL,

I'm still unsuccessful at running this script. Is there a post or a file available with the SQLSetup.sql file modified for SQLServer 2000? Any suggestions, comments help is appriciated.
Thx,
Catto
Jan 22, 2008 at 9:30 AM
Hi Catto

Are you trying to upgrade of to install a new blog?
If you are still unsuccessful running the script AND you have changed the values like mentioned. What is the new error message?

Kind regards
Jan 22, 2008 at 10:23 AM
Hi guys
The problem is that you are using SQL 2000, it do not support varchar(max) or nvarchar(max). Solution change all field types to ntext. Better go to SQL 2005 (and then to SQL 2008).
First the DB engine do not create the tables so you have more errors when trying to use tables that do not exist.

At this version BlogEngine do not use text search. I think developers team can add it functionallity later, but the try to take same functionallity over data providers ...
Jan 23, 2008 at 5:25 PM
Hey Now, SQLSetup1.3.sql file gives me errors on SQLServer 2000 still. I thank you all for your assistance this far as we have made some progress. I have adjusted the script to replace nvarchar(max) to ntext. This removed about of the errors. The other errors are still there. for example
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
I think what causes this is line WITH (PADINDEX = OFF, STATISTICSNORECOMPUTE = OFF, IGNOREDUPKEY = OFF, ALLOWROWLOCKS = ON, ALLOWPAGELOCKS = ON) ON PRIMARY
) ON PRIMARY.
Any ideas on how to get the script to run on SQLServer 2000 and remove the sytax errors?
Thx in advance for any suggestions.
Catto
Jan 24, 2008 at 2:07 AM
SQLSetup 1.3 executing with SQL2000! Whew. I removed the lines
WITH (PADINDEX = OFF, STATISTICSNORECOMPUTE = OFF, IGNOREDUPKEY = OFF, ALLOWROWLOCKS = ON, ALLOWPAGELOCKS = ON) ON PRIMARY

now I just wonder what that effects. Anyone have any thoughts?
Thx,
Catto
Jan 31, 2008 at 12:43 AM
In the next posts I'm placing the script I ran.
Catto
/****** BlogEngine.NET 1.3 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(
CategoryIDuniqueidentifier ROWGUIDCOL NOT NULL CONSTRAINT DF_be_Categories_CategoryID DEFAULT (newid()),
CategoryNamenvarchar(50) NULL,
Descriptionnvarchar(200) NULL,
CONSTRAINT PK_be_Categories PRIMARY KEY CLUSTERED
(
CategoryID ASC
)
) 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(
PageIDuniqueidentifier ROWGUIDCOL NOT NULL CONSTRAINT DF_be_Pages_PageID DEFAULT (newid()),
Titlenvarchar(255) NULL,
Descriptionntext NULL,
PageContentntext NULL,
Keywordsntext NULL,
DateCreateddatetime NULL,
DateModifieddatetime NULL,
IsPublishedbit NULL,
IsFrontPagebit NULL,
Parentuniqueidentifier NULL,
ShowInListbit NULL,
CONSTRAINT PK_be_Pages PRIMARY KEY CLUSTERED
(
PageID ASC
)
) 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(
PingServiceIDint IDENTITY(1,1) NOT NULL,
Linknvarchar(255) NULL,
CONSTRAINT PK_be_PingService PRIMARY KEY CLUSTERED
(
PingServiceID ASC
)
) 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(
PostIDuniqueidentifier ROWGUIDCOL NOT NULL CONSTRAINT DF_be_Posts_PostID DEFAULT (newid()),
Titlenvarchar(255) NULL,
Descriptionntext NULL,
PostContentntext NULL,
DateCreateddatetime NULL,
DateModifieddatetime NULL,
Authornvarchar(50) NULL,
IsPublishedbit NULL,
IsCommentEnabledbit NULL,
Ratersint NULL,
Ratingreal NULL,
Slugnvarchar(255) NULL,
CONSTRAINT PK_be_Posts PRIMARY KEY CLUSTERED
(
PostID ASC
)
) 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(
SettingNamenvarchar(50) NOT NULL,
SettingValuentext NULL,
CONSTRAINT PK_be_Settings PRIMARY KEY CLUSTERED
(
SettingName ASC
)
) 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(
PostCategoryIDint IDENTITY(1,1) NOT NULL,
PostIDuniqueidentifier NOT NULL,
CategoryIDuniqueidentifier NOT NULL,
CONSTRAINT PK_be_PostCategory PRIMARY KEY CLUSTERED
(
PostCategoryID ASC
)
) 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(
PostCommentIDuniqueidentifier ROWGUIDCOL NOT NULL CONSTRAINT DF_be_PostComment_PostCommentID DEFAULT (newid()),
PostIDuniqueidentifier NOT NULL,
CommentDatedatetime NOT NULL,
Authornvarchar(255) NULL,
Emailnvarchar(255) NULL,
Websitenvarchar(255) NULL,
Commentntext NULL,
Countrynvarchar(255) NULL,
Ipnvarchar(50) NULL,
IsApprovedbit NULL,
CONSTRAINT PK_be_PostComment PRIMARY KEY CLUSTERED
(
PostCommentID ASC
)
) 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(
PostNotifyIDint IDENTITY(1,1) NOT NULL,
PostIDuniqueidentifier NOT NULL,
NotifyAddressnvarchar(255) NULL,
CONSTRAINT PK_be_PostNotify PRIMARY KEY CLUSTERED
(
PostNotifyID ASC
)
) 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(
PostTagIDint IDENTITY(1,1) NOT NULL,
PostIDuniqueidentifier NOT NULL,
Tagnvarchar(50) NULL,
CONSTRAINT PK_be_PostTag PRIMARY KEY CLUSTERED
(
PostTagID ASC
)
) 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: Index FK_PostID Script Date: 12/22/2007 14:18:36 ******/
CREATE NONCLUSTERED INDEX FK_PostID ON dbo.be_PostCategory
(
PostID ASC
)
GO
/****** Object: Index FK_CategoryID Script Date: 12/22/2007 14:19:19 ******/
CREATE NONCLUSTERED INDEX FK_CategoryID ON dbo.be_PostCategory
(
CategoryID ASC
)
GO
/****** Object: Index FK_PostID Script Date: 12/22/2007 14:19:45 ******/
CREATE NONCLUSTERED INDEX FK_PostID ON dbo.be_PostComment
(
PostID ASC
)
GO
/****** Object: Index FK_PostID Script Date: 12/22/2007 14:20:29 ******/
CREATE NONCLUSTERED INDEX FK_PostID ON dbo.be_PostNotify
(
PostID ASC
)
GO
/****** Object: Index FK_PostID Script Date: 12/22/2007 14:20:43 ******/
CREATE NONCLUSTERED INDEX FK_PostID ON dbo.be_PostTag
(
PostID ASC
)

Jan 31, 2008 at 12:45 AM
In the previous post & this post is the script that will run in SQL 2000.
Thx,
Catto



/*** Load initial Data ***/
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', 'True');
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 ('htmlheader', '');
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 ('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', '15');
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 beSettings (SettingName, SettingValue) VALUES ('storagelocation', '~/AppData/');
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', '1');
INSERT INTO be_Settings (SettingName, SettingValue) VALUES ('trackingscript', '');

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.3 with MSSQL provider',
'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.3 is running and the SQL Server provider 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>',
'09/30/07',
'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');
Apr 5, 2008 at 9:55 AM
I'ved edited the script so that it runs on MS SQL 2000, I'd upload the file here if I knew how :). You can grab it here: http://www.bennymichielsen.be/post/2008/04/Ms-Sql-2000-script-for-BlogEngineNET.aspx
May 17, 2008 at 4:12 PM
Edited May 17, 2008 at 5:01 PM
Thanks for the work I picked up your script and it ran fine but it is missing the following lines.

/****** Object:  Table [dbo].[be_ExtensionSettings]    Script Date: 12/27/2007 00:12:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_ExtensionSettings](
    [Settings] [varbinary](max) NOT NULL
) ON [PRIMARY]
GO
INSERT INTO [be_ExtensionSettings] ([Settings]) VALUES (CONVERT(varbinary(max),'<?xml version="1.0"?><ArrayOfManagedExtension xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"></ArrayOfManagedExtension>'))
GO

/****** Object:  Table [dbo].[be_DataStoreSettings]    Script Date: 03/09/2008 12:32:51 ******/
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] [varbinary](max) NOT NULL
) ON [PRIMARY]
GO


is this new?

I converted to varbinary(8000) but not sure what all they are being used for


 Any idea when searching will be implemented?

Thanks

Tom

BennyM wrote:
I'ved edited the script so that it runs on MS SQL 2000, I'd upload the file here if I knew how :). You can grab it here: http://www.bennymichielsen.be/post/2008/04/Ms-Sql-2000-script-for-BlogEngineNET.aspx



May 21, 2008 at 10:55 AM
Edited May 21, 2008 at 7:39 PM
I'll look into it when I'm at home. Do you use the last 'official' release (1.3.1.0) or did you grab the source code. I'm using the first and haven't run into any issues yet, search is also working I think, you can try it out on my site.

Edit: at home now, I donwloaded the Web installation and searched for extensionsettings in the sql script, couldn't find it. So I'm guessing you checked out the source code. You'll have to take a look at how these Settings fields of the db tables are handled to make sure the code would still work.
May 22, 2008 at 7:02 PM
I checked out a copy of the source code myself to look into this and have updated the scripts, which can be found on my blog. I think it's better to use the image datatype instead of varbinary(8000). The scripts can be downloaded here: http://www.bennymichielsen.be/post/2008/05/Updated-BlogEngineNET-scripts.aspx
Jul 2, 2008 at 8:47 PM
I've migrated to BE1.4, so I've also changed to SQL scripts that come with the release to work on MS SQL 2000, you can get them here.
Aug 5, 2008 at 9:38 PM
Everyone who is looking for MS SQL 2000 scripts for BE 1.4.5, you can find them here.