to be honest, this error message doesn't seem to match the SQL statement.
if you execute the statement from Host > SQL or SQL Server Management Studio, do you get the same error?

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

Here's the section of 07.01.00.SqlDataProvider that leads up to the sql script that generates the error message:

/* Update Content ItemId's on files */
/************************************/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'{databaseOwner}[{objectQualifier}CountLegacyFiles]') AND type in (N'P', N'PC'))
 DROP PROCEDURE {databaseOwner}[{objectQualifier}CountLegacyFiles]
GO

CREATE PROCEDURE {databaseOwner}[{objectQualifier}CountLegacyFiles]
AS
BEGIN

SELECT COUNT(*) FROM {databaseOwner}[{objectQualifier}Files] WHERE ContentItemID IS NULL
END
GO

IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'[{objectQualifier}Folders]' AND COLUMN_NAME = 'MappedPath')
 BEGIN
  ALTER TABLE {databaseOwner}[{objectQualifier}Folders]
   ADD MappedPath nvarchar(300) NULL
 END
GO

UPDATE {databaseOwner}{objectQualifier}Folders
 SET MappedPath = FolderPath
GO

I manually ran the sql scripts for 07.00.06.SqlDataProvider and 07.01.00.SqlDataProvider in MS SQL Server Management Studio and I came across the follow syntax error while executing SQL statements section by section for 07.01.00.SqlDataProvider :

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'FolderID'.

/* add calculated column for file folderpaths to help with extensions that do not use the API */
/*********************************************************************************************/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[GetFileFolderFunc]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [GetFileFolderFunc]
GO

CREATE FUNCTION [GetFileFolderFunc](@FolderD INT)
RETURNS nvarchar(246)
AS
BEGIN
DECLARE @folderPath nvarchar(246)
select @folderPath=folderpath from [Folders] where folderid=@FolderD
return @folderPath

END;

GO
ALTER TABLE [Files]
ADD Folder AS [GetFileFolderFunc](FolderID)
GO

Any suggestions why it does not like the statement "ADD Folder AS [GetFileFolderFunc](FolderID)" ?