Here is the 6.0 log.resource file
System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'FolderMappingID' in table 'dbo.Folders' is specified more than once.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Add FolderMappingID column to Folders table and fill it with right values */
/*****************************************************************************/
ALTER TABLE dbo.[Folders] ADD [FolderMappingID] int NULL
System.Data.SqlClient.SqlException (0x80131904): Table 'PortalLocalization' already has a primary key defined on it.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
ALTER TABLE dbo.[PortalLocalization] ADD CONSTRAINT [PK_PortalLocalization] PRIMARY KEY CLUSTERED ([PortalID], [CultureCode])
System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'vw_PortalsDefaultLanguage' in the database.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE VIEW dbo.[vw_PortalsDefaultLanguage]
AS
SELECT DISTINCT
P.PortalID,
PL.PortalName as PortalName,
PL.LogoFile,
PL.FooterText as FooterText,
P.ExpiryDate,
P.UserRegistration,
P.BannerAdvertising,
P.AdministratorId,
P.Currency,
P.HostFee,
P.HostSpace,
P.PageQuota,
P.UserQuota,
P.AdministratorRoleId,
P.RegisteredRoleId,
PL.Description as Description,
PL.KeyWords as KeyWords,
PL.BackgroundFile,
P.GUID,
P.PaymentProcessor,
P.ProcessorUserId,
P.ProcessorPassword,
P.SiteLogHistory,
U.Email,
P.DefaultLanguage,
P.TimezoneOffset,
PL.AdminTabId as AdminTabId,
P.HomeDirectory,
PL.SplashTabId as SplashTabId,
PL.HomeTabId as HomeTabId,
PL.LoginTabId as LoginTabId,
PL.RegisterTabId as RegisterTabId,
PL.UserTabId as UserTabId,
PL.SearchTabId as SearchTabId,
(SELECT TOP 1 TabID FROM dbo.Tabs WHERE (PortalID IS NULL) AND (ParentId IS NULL)) AS SuperTabId,
P.CreatedByUserID,
P.CreatedOnDate,
P.LastModifiedByUserID,
P.LastModifiedOnDate,
PL.CultureCode
FROM dbo.Portals AS P
INNER JOIN ( SELECT PortalID ,
PortalName ,
CASE WHEN LEFT(LOWER(LogoFile), 7) = 'fileid='
THEN ( SELECT Folder + FileName
FROM dbo.Files
WHERE fileid = CAST(( RIGHT(LOWER(LogoFile),
LEN(LogoFile) - 7) ) AS INT)
)
ELSE LogoFile
END AS LogoFile ,
FooterText ,
Description ,
KeyWords ,
CASE WHEN LEFT(LOWER(BackgroundFile), 7) = 'fileid='
THEN ( SELECT Folder + FileName
FROM dbo.Files
WHERE fileid = CAST(( RIGHT(LOWER(BackgroundFile),
LEN(BackgroundFile)
- 7) ) AS INT)
)
ELSE BackgroundFile
END AS BackgroundFile ,
AdminTabId ,
SplashTabId ,
HomeTabId ,
LoginTabId ,
RegisterTabId ,
UserTabId ,
SearchTabId ,
CultureCode
FROM dbo.PortalLocalization
) AS PL ON P.PortalID = PL.PortalID AND PL.CultureCode = P.DefaultLanguage
LEFT OUTER JOIN dbo.Users AS U ON P.AdministratorId = U.UserID
System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_FileName' already exists on table 'dbo.Files'.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
ALTER TABLE dbo.[Files] ADD CONSTRAINT [IX_FileName] UNIQUE NONCLUSTERED ([FolderID] ASC, [FileName] ASC)
System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'UpdateFile' in the database.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[UpdateFile]
@FileId int,
@VersionGuid uniqueidentifier,
@FileName nvarchar(246),
@Extension nvarchar(100),
@Size int,
@Width int,
@Height int,
@ContentType nvarchar(200),
@Folder nvarchar(246),
@FolderID int,
@LastModifiedByUserID int,
@Hash varchar(40)
AS
BEGIN
UPDATE dbo.[Files]
SET
[FileName] = @FileName,
VersionGuid = @VersionGuid,
Extension = @Extension,
Size = @Size,
Width = @Width,
Height = @Height,
ContentType = @ContentType,
Folder = @Folder,
FolderID = @FolderID,
LastModifiedByUserID = @LastModifiedByUserID,
LastModifiedOnDate = getdate(),
SHA1Hash = @Hash
WHERE FileId = @FileId
END
System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DeleteFile' in the database.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[DeleteFile]
@PortalID int,
@FileName nvarchar(246),
@FolderID int
AS
BEGIN
IF @PortalID is null
BEGIN
DELETE FROM dbo.[Files] WHERE [FileName] = @FileName AND FolderID = @FolderID AND PortalId IS Null
END ELSE BEGIN
DELETE FROM dbo.[Files] WHERE [FileName] = @FileName AND FolderID = @FolderID AND PortalId = @PortalID
END
END
System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'GetVendorsByEmail' in the database.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[GetVendorsByEmail]
@Filter nvarchar(50),
@PortalID int,
@PageSize int,
@PageIndex int
AS
DECLARE @PageLowerBound int
DECLARE @PageUpperBound int
-- Set the page bounds
SET @PageLowerBound = @PageSize * @PageIndex
SET @PageUpperBound = @PageLowerBound + @PageSize + 1
CREATE TABLE #PageIndex
(
IndexID int IDENTITY (1, 1) NOT NULL,
VendorId int
)
INSERT INTO #PageIndex (VendorId)
SELECT VendorId
FROM dbo.Vendors
WHERE ( (Email like @Filter + '%') AND ((PortalId = @PortalID) or (@PortalID is null and PortalId is null)) )
ORDER BY VendorId DESC
SELECT COUNT(*) as TotalRecords
FROM #PageIndex
SELECT dbo.Vendors.*,
'Banners' = ( select count(*) from dbo.Banners where dbo.Banners.VendorId = dbo.Vendors.VendorId )
FROM dbo.Vendors
INNER JOIN #PageIndex PageIndex
ON dbo.Vendors.VendorId = PageIndex.VendorId
WHERE ( (PageIndex.IndexID > @PageLowerBound) OR @PageLowerBound is null )
AND ( (PageIndex.IndexID < @PageUpperBound) OR @PageUpperBound is null )
ORDER BY
PageIndex.IndexID
System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'GetBanner' in the database.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.GetBanner
@BannerId int
as
select B.BannerId,
B.VendorId,
'ImageFile' = case when F.FileName is null then B.ImageFile else F.Folder + F.FileName end,
B.BannerName,
B.Impressions,
B.CPM,
B.Views,
B.ClickThroughs,
B.StartDate,
B.EndDate,
'CreatedByUser' = U.FirstName + ' ' + U.LastName,
B.CreatedDate,
B.BannerTypeId,
B.Description,
B.GroupName,
B.Criteria,
B.URL,
B.Width,
B.Height,
B.ImageFile AS ImageFileRaw
from dbo.Banners B
inner join dbo.Vendors V ON B.VendorId = V.VendorId
left outer join dbo.Users U ON B.CreatedByUser = U.UserID
left outer join dbo.Files F on B.ImageFile = 'FileId=' + convert(varchar,F.FileID)
where B.BannerId = @BannerId
System.Data.SqlClient.SqlException (0x80131904): Cannot drop the procedure 'dbo.FindBanners', because it does not exist or you do not have permission.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.[FindBanners]') AND type in (N'P', N'PC'))
DROP PROCEDURE dbo.[FindBanners]
System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FindBanners' in the database.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[FindBanners]
@PortalID int,
@BannerTypeId int,
@GroupName nvarchar(100)
AS
SELECT B.BannerId,
B.VendorId,
BannerName,
URL,
CASE WHEN LEFT(LOWER(ImageFile), 6) = 'fileid'
THEN
(SELECT Folder + FileName
FROM dbo.Files
WHERE 'fileid=' + convert(varchar,dbo.Files.FileID) = ImageFile
)
ELSE
ImageFile
END
AS ImageFile,
Impressions,
CPM,
B.Views,
B.ClickThroughs,
StartDate,
EndDate,
BannerTypeId,
Description,
GroupName,
Criteria,
B.Width,
B.Height,
B.ImageFile AS ImageFileRaw
FROM dbo.Banners B
INNER JOIN dbo.Vendors V ON B.VendorId = V.VendorId
WHERE (B.BannerTypeId = @BannerTypeId or @BannerTypeId is null)
AND (B.GroupName = @GroupName or @GroupName is null)
AND ((V.PortalId = @PortalID) or (@PortalID is null and V.PortalId is null))
AND V.Authorized = 1
AND (getdate() <= B.EndDate or B.EndDate is null)
ORDER BY BannerId
System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'GetDatabaseTimeUtc' in the database.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[GetDatabaseTimeUtc]
AS
BEGIN
SELECT GETUTCDATE()
END
System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'GetDatabaseTime' in the database.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[GetDatabaseTime]
AS
BEGIN
SELECT GETDATE()
END
System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_Files_Portals' in the database.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
ALTER TABLE dbo.[Files] ADD
CONSTRAINT [FK_Files_Portals] FOREIGN KEY ([PortalId]) REFERENCES dbo.[Portals] ([PortalID]),
CONSTRAINT [FK_Files_Folders] FOREIGN KEY ([FolderID]) REFERENCES dbo.[Folders] ([FolderID]) ON DELETE CASCADE
System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'IX_ModuleControls'. Cannot insert duplicate key in object 'dbo.ModuleControls'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Add new Download host ModuleControl */
/***************************************/
IF (SELECT COUNT(*) FROM dbo.ModuleControls WHERE ModuleDefID IS NULL AND ControlKey = 'Download') = 0
BEGIN
DECLARE @ModuleDefID int
SET @ModuleDefID = (SELECT ModuleDefID FROM dbo.ModuleDefinitions WHERE FriendlyName = 'Extensions')
INSERT INTO dbo.ModuleControls
( ModuleDefID, ControlKey, ControlTitle, ControlSrc, ControlType )
VALUES ( @ModuleDefID, 'Download', 'Downloader', 'DesktopModules/Admin/Extensions/Download.ascx', 3)
END
www.nflmadness.com
|