I recently upgraded from 4.9.5 to 5.2. While the site appears to be working properly further inspection and attempts at adding modules or reconfiguring some items show that things are a bit more shakey. At this point there's no going back so we need to try to fix what's wrong.
Can anyone offer advice???
Install Package:: DNN_UsersOnline_Install
Info:: Reading files
Info:: File UsersOnline.ascx read successfully
Info:: File Providers/DataProviders/SqlDataProvider\04.09.04.SqlDataProvider read successfully
Info:: File Providers/DataProviders/SqlDataProvider\05.01.00.SqlDataProvider read successfully
Info:: File Providers/DataProviders/SqlDataProvider\Uninstall.SqlDataProvider read successfully
Info:: File Settings.ascx read successfully
Info:: File bin\DotNetNuke.Modules.UsersOnline.dll read successfully
Info:: File bin\DotNetNuke.Modules.UsersOnline.SqlDataProvider.dll read successfully
Info:: File Images\uoGroup1.gif read successfully
Info:: File Images\uoGroup2.gif read successfully
Info:: File Images\uoGroup3.gif read successfully
Info:: File Images\uoLatest.gif read successfully
Info:: File Images\uoMembers.gif read successfully
Info:: File Images\uoNewToday.gif read successfully
Info:: File Images\uoNewYesterday.gif read successfully
Info:: File Images\uoOverall.gif read successfully
Info:: File Images\uoTotal.gif read successfully
Info:: File Images\uoVisitors.gif read successfully
Info:: File App_LocalResources\Settings.ascx.resx read successfully
Info:: File App_LocalResources\UsersOnline.ascx.resx read successfully
Info:: File DNN_UsersOnline_Install.dnn read successfully
Info:: Reading files done.
Info:: Reading Installation Manifest file
Info:: Reading Package Manifest - Module - DNN_UsersOnline
Info:: Reading Component Manifest - Script
Info:: Found valid path (Providers\DataProviders\SqlDataProvider) for 04.09.04.SqlDataProvider.
Info:: Found valid path (Providers\DataProviders\SqlDataProvider) for 05.01.00.SqlDataProvider.
Info:: Found valid path (Providers\DataProviders\SqlDataProvider) for Uninstall.SqlDataProvider.
Info:: Reading Component Manifest - Module
Info:: Module Manifest read successfully
Info:: Reading Component Manifest - Assembly
Info:: Found valid path (bin) for DotNetNuke.Modules.UsersOnline.dll.
Info:: Found valid path (bin) for DotNetNuke.Modules.UsersOnline.SqlDataProvider.dll.
Info:: Reading Component Manifest - File
Info:: Found valid path (App_LocalResources) for Settings.ascx.resx.
Info:: Found valid path (App_LocalResources) for UsersOnline.ascx.resx.
Info:: Found valid path (Images) for uoGroup1.gif.
Info:: Found valid path (Images) for uoGroup2.gif.
Info:: Found valid path (Images) for uoGroup3.gif.
Info:: Found valid path (Images) for uoLatest.gif.
Info:: Found valid path (Images) for uoMembers.gif.
Info:: Found valid path (Images) for uoNewToday.gif.
Info:: Found valid path (Images) for uoNewYesterday.gif.
Info:: Found valid path (Images) for uoOverall.gif.
Info:: Found valid path (Images) for uoTotal.gif.
Info:: Found valid path (Images) for uoVisitors.gif.
Info:: Found valid path () for Settings.ascx.
Info:: Found valid path () for UsersOnline.ascx.
Info:: Reading Component Manifest - Cleanup
Info:: Manifest file finished successfully
Info:: Starting Installation
Info:: Starting Installation - DNN_UsersOnline
Info:: Starting Installation - Script
Info:: Begin Sql execution
Info:: Creating backup of previous version - Providers\DataProviders\SqlDataProvider\04.09.04.SqlDataProvider
Info:: Created - Providers\DataProviders\SqlDataProvider\04.09.04.SqlDataProvider
Info:: Executing 04.09.04.SqlDataProvider
Info:: Start Sql execution: 04.09.04.SqlDataProvider file
Info:: SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot find the object 'dnn_NTForums_GetForumStats', because it does not exist or you do not have permission. Cannot find the object 'dnn_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='username removed') 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('dnn_')) = 'dnn_' 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 [username removed]' execute (@exec) fetch sp_cursor into @name end deallocate sp_cursor end
Info:: End Sql execution: 04.09.04.SqlDataProvider file
Info:: Finished Sql execution
Info:: Installation Failed - Script
Info:: Installation Failed - DNN_UsersOnline
Info:: Deleted temporary install folder
Info:: Installation Failed
AssemblyVersion: 5.2.0
PortalID: 0
PortalName: JustCircuit.com
UserID: 5
UserName: Shane
ActiveTabID: 66
ActiveTabName: Newsletters
RawURL: /Staff/Newsletters/tabid/66/navcmd/OptInSettings/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://justcircuit.com/Staff/Newsletters/tabid/66/navcmd/BounceSettings/Default.aspx
UserAgent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 040b4d92-5f58-4926-ba81-47717228c9c2
InnerException: Invalid column name 'PortalName'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Invalid column name 'PortalName'. ---> System.Data.SqlClient.SqlException: Invalid column name 'PortalName'. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ByDesign.BDPDT.SQLServer.QueryReturnTable(String ConnectionString, Hashtable ht, String tablename, String CommandText) at ByDesign.BDPDT.SprocHandler.SelectData(Hashtable ht, String commandtext) at ByDesign.BD_EMailManager.DB.EMail_OptInList.GetByPortalId() at ByDesign.BD_EMailManager.OptInAPI.CreateOptInList(ListControl ctl, Int32 portalid, Boolean addnone, ListSelectionMode multiselect, ArrayList ShowMailingListItems) at ByDesign.BD_EMailManager.OptInControl.Page_Load(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source: