Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Upgrade error from 5.6.3 to 6.0Upgrade error from 5.6.3 to 6.0
Previous
 
Next
New Post
7/21/2011 9:56 AM
 
Im getting an Object reference not set to an instance of an object. heres the stack trace:
DotNetNuke.Services.Exceptions.ModuleLoadException: The underlying system threw an exception. ---> DotNetNuke.Services.FileSystem.FolderProviderException: The underlying system threw an exception. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at DotNetNuke.Services.FileSystem.FolderProvider.Instance(String friendlyName)
at DotNetNuke.Services.FileSystem.FileManager.GetUrl(IFileInfo file)
--- End of inner exception stack trace ---
at DotNetNuke.UI.Navigation.GetNavigationNodes(DNNNode objRootNode, ToolTipSource eToolTips, Int32 intStartTabId, Int32 intDepth, Int32 intNavNodeOptions)
at DotNetNuke.UI.Navigation.GetNavigationNodes(String strNamespace, ToolTipSource eToolTips, Int32 intStartTabId, Int32 intDepth, Int32 intNavNodeOptions)
at DotNetNuke.UI.Skins.NavObjectBase.GetNavigationNodes(DNNNode objNode)
at DotNetNuke.UI.Skins.Controls.Nav.BuildNodes(DNNNode objNode)
at DotNetNuke.UI.Skins.Controls.Nav.OnLoad(EventArgs e)
--- End of inner exception stack trace ---

Also getting an error at the Admin page:

Error: Basic Features is currently unavailable.DotNetNuke.Services.Exceptions.ModuleLoadException: Property accessor 'IconFile' on object 'DotNetNuke.Entities.Tabs.TabInfo' threw the following exception:'The underlying system threw an exception.' ---> System.Reflection.TargetInvocationException: Property accessor 'IconFile' on object 'DotNetNuke.Entities.Tabs.TabInfo' threw the following exception:'The underlying system threw an exception.' ---> DotNetNuke.Services.FileSystem.FolderProviderException: The underlying system threw an exception. ---> System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Services.FileSystem.FolderProvider.Instance(String friendlyName) at DotNetNuke.Services.FileSystem.FileManager.GetUrl(IFileInfo file) --- End of inner exception stack trace --- at DotNetNuke.Services.FileSystem.FileManager.GetUrl(IFileInfo file) at DotNetNuke.Entities.Tabs.TabInfo.IconFileGetter(String& iconFile, String iconRaw) at DotNetNuke.Entities.Tabs.TabInfo.get_IconFile() --- End of inner exception stack trace --- at System.ComponentModel.ReflectPropertyDescriptor.GetValue(Object component) at System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) at System.Web.UI.DataBinder.Eval(Object container, String[] expressionParts) at System.Web.UI.DataBinder.Eval(Object container, String expression) at DotNetNuke.Modules.Admin.Console.ViewConsole.GetIconUrl(Object dataItem, String size) at DotNetNuke.Modules.Admin.Console.ViewConsole.GetHtml(Object dataItem) at ASP.desktopmodules_admin_console_viewconsole_ascx.__DataBind__control3(Object sender, EventArgs e) at System.Web.UI.Control.OnDataBinding(EventArgs e) at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBind() at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBind() at System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) at System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) at System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) at System.Web.UI.WebControls.Repeater.DataBind() at DotNetNuke.Modules.Admin.Console.ViewConsole.OnLoad(EventArgs e) --- End of inner exception stack trace ---


Can someone tell me what it means and how to fix it?

www.nflmadness.com
 
New Post
7/21/2011 11:25 AM
 
did you have any errors when upgrading i.e. check Providers\DataProviders\SqlDataProvider and look at the .log.resources files and they'll show any errors. Can you also check your web.config and make sure that you have the folder definitions i.e. a line such as followed by some definitions for folder providers.

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
7/21/2011 11:33 AM
 
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
 
New Post
7/21/2011 11:44 AM
 
based on that it looks like the scripts might have run twice - can you roll back to your backup of 5.6.3 and try again?

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
7/21/2011 11:56 AM
 
ok, give me a bit.

www.nflmadness.com
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Upgrade error from 5.6.3 to 6.0Upgrade error from 5.6.3 to 6.0


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out