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

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...DNN 5 Upgrade Error- Should I be worried?DNN 5 Upgrade Error- Should I be worried?
Previous
 
Next
New Post
1/4/2009 4:23 AM
 

Is this really bad? My website is working fine (for now). Is there something I should do?

 

Upgrading DotNetNuke

Current Assembly Version: 05.00.00

Current Database Version: 04.09.00



 

Upgrade Status Report

00:00:00.020 - Upgrading to Version: 5.0.0
00:00:00.050 -   Executing Script: 04.09.01.SqlDataProvider Error! (see 04.09.01.log for more information)
00:00:09.333 -   Executing Script: 05.00.00.SqlDataProvider Error! (see 05.00.00.log for more information)
00:00:30.533 - Performing General Upgrades
00:00:33.698 - Installing Optional Modules:
00:00:33.698 -   Installing Package File Links_04.00.01_Install:  Success
00:00:35.060 - Installing Optional Skins:
00:00:35.060 - Installing Optional Containers:
00:00:35.060 - Installing Optional Languages:
00:00:35.060 - Installing Optional Providers:
00:00:35.060 -   Installing Package File AspNetMembershipProvider_05.00.00_Install:  Success
00:00:35.260 -   Installing Package File DatabaseLoggingProvider_05.00.00_Install:  Success
00:00:35.420 -   Installing Package File DNNMembershipProvider_05.00.00_Install:  Success
00:00:35.591 -   Installing Package File DNNMenuNavigationProvider_05.00.00_Install:  Success
00:00:35.711 -   Installing Package File DNNTreeNavigationProvider_05.00.00_Install:  Success
00:00:35.831 -   Installing Package File FckHtmlEditorProvider_02.00.02_Install:  Success
00:00:40.067 -   Installing Package File FileBasedCachingProvider_05.00.00_Install:  Success
00:00:40.267 -   Installing Package File SchedulingProvider_05.00.00_Install:  Success
00:00:40.418 -   Installing Package File SearchIndexProvider_05.00.00_Install:  Success
00:00:40.578 -   Installing Package File SearchProvider_05.00.00_Install:  Success
00:00:40.698 -   Installing Package File SolpartMenuNavigationProvider_05.00.00_Install:  Success
00:00:40.928 - Installing Optional AuthSystems:
00:00:40.928 -   Installing Package File LiveID_01.00.01_Install:  Success
00:00:41.269 -   Installing Package File OpenID_02.00.00_Install:  Success
00:00:41.529 - Installing Optional Packages:
00:00:41.529 -   Installing Package File LiveID_01.00.00_Install:  Error!
00:00:41.790 -   Installing Package File OpenID_01.00.00_Install:  Error!

 
New Post
1/4/2009 5:32 AM
 

It might be that some stored procedures have not been installed. So might be (become) bad. Most likely the last two errors are a result of the fact that in the first 3 sql statements some table or sp's are not created. So I think authentication or installing new authentication will cause problems.

I would check the errors in the upgrade log and patch them.

 
New Post
1/4/2009 6:29 AM
 

Frozen,

please review .log files in /providers/dataproviders/sqldataprovider folder. post content here, if necessary.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
1/4/2009 4:30 PM
 

4.9.0 Log

 

System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   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)

/************************************************************/
/*****              SqlDataProvider                     *****/
/*****                                                  *****/
/*****                                                  *****/
/***** Note: To manually execute this script you must   *****/
/*****       perform a search and replace operation     *****/
/*****       for dbo. and   *****/
/*****                                                  *****/
/************************************************************/

update dbo.[Tabs] set IsSecure = 1
    where PortalID is NULL
        or TabID in (select AdminTabId from dbo.[Portals])
        or ParentId in (select AdminTabId from dbo.[Portals])

 

 

 
New Post
1/4/2009 4:32 PM
 

4.9.1 Log

 

System.Data.SqlClient.SqlException: Cannot find the object 'Register_ResponseListByModuleIDUserID', because it does not exist or you do not have permission.
Cannot find the object 'Register_ResponseListUserIDByModuleID', because it does not exist or you do not have permission.
Cannot find the object 'NTForums_GetForumsByGroup2', because it does not exist or you do not have permission.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[]

commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[]

commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
   at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole)

if exists (select * from dbo.sysusers where name='website1')  begin    declare @exec nvarchar(2000)     declare @name varchar(150)     declare sp_cursor

cursor for select o.name as name     from dbo.sysobjects o     where ( OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') =

1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 1 )     and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0     and o.name not like N'#%%'     and (left(o.name,len(''))

= '' or left(o.name,7) = 'aspnet_')     open sp_cursor     fetch sp_cursor into @name     while @@fetch_status >= 0       begin        select @exec = 'grant

EXECUTE on ' +  @name  + ' to [website1]'        execute (@exec)        fetch sp_cursor into @name       end     deallocate sp_cursor  end

System.Data.SqlClient.SqlException: Cannot find the object 'ColumnAlreadyExists', because it does not exist or you do not have permission.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[]

commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[]

commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
   at DotNetNuke.Data.SqlDataProvider.GrantUserDefinedFunctionsPermission(String ScalarPermission, String TablePermission, String LoginOrRole)

if exists (select * from dbo.sysusers where name='website1')  begin    declare @exec nvarchar(2000)     declare @name varchar(150)     declare

@isscalarfunction int     declare @istablefunction int     declare sp_cursor cursor for select o.name as name, OBJECTPROPERTY(o.id, N'IsScalarFunction') as

IsScalarFunction     from dbo.sysobjects o     where ( OBJECTPROPERTY(o.id, N'IsScalarFunction') = 1 OR OBJECTPROPERTY(o.id, N'IsTableFunction') = 1 )      

and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0       and o.name not like N'#%%'       and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_')     open

sp_cursor     fetch sp_cursor into @name, @isscalarfunction     while @@fetch_status >= 0       begin         if @IsScalarFunction = 1           begin       

    select @exec = 'grant EXECUTE on ' +  @name  + ' to [website1]'            execute (@exec)            fetch sp_cursor into @name, @isscalarfunction      

     end         else           begin            select @exec = 'grant SELECT on ' +  @name  + ' to [website1]'            execute (@exec)            fetch

sp_cursor into @name, @isscalarfunction          

 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...DNN 5 Upgrade Error- Should I be worried?DNN 5 Upgrade Error- Should I be worried?


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