This has been my 2nd attempt to upgrade and not sure if it's an "easy" fix or if I should just stick with 4.9.5.
I apologise if this is covered elsewhere and please feel free to point me there if it is! I'm sure most are aware the DNN forum search doesn't work and with Google I could only find stuff over 3yrs old.
The error lines in the upgrade are as follows:
00:00:00.171 - Executing Script: 05.00.00.SqlDataProvider
Error! (see 05.00.00.log for more information)
00:00:24.343 - Executing Script: 05.00.01.SqlDataProvider
Error! (see 05.00.01.log for more information)
00:00:28.046 - Executing Script: 05.01.00.SqlDataProvider
Error! (see 05.01.00.log for more information)
00:00:34.234 - Executing Script: 05.01.01.SqlDataProvider
Error! (see 05.01.01.log for more information)
00:00:36.578 - Executing Script: 05.01.02.SqlDataProvider
Error! (see 05.01.02.log for more information)
and
00:02:32.406 - Installing Package File HTML_Community_05.01.03_Install:
Error!
everything else was fine.
The log files all show the following:
System.Data.SqlClient.SqlException: Cannot find the object 'tacuk_Forum_NewsArticleAdd', 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='public') 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('tacuk_')) = 'tacuk_' 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 [public]' execute (@exec) fetch sp_cursor into @name end deallocate sp_cursor end
When viewing the site - the skin seems fine but there is no content shown at all, just the module containers.
It shows the error:
A critical error has occurred.
Could not load type 'DotNetNuke.Data.NonCommandParameterAttribute' from assembly 'DotNetNuke, Version=5.1.2.51, Culture=neutral, PublicKeyToken=null'.
The General Exception detail is:
AssemblyVersion: 5.1.2
PortalID: 0
PortalName: x
UserID: -1
UserName:
ActiveTabID: 36
ActiveTabName: Home
RawURL: /Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.2; Trident/4.0; GTB6; .NET CLR 1.1.4322; .NET CLR 3.0.04506.30; .NET CLR 2.0.50727; FDM; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 7a787c0e-539a-482f-95fe-09496caa0a16
InnerException: Could not load type 'DotNetNuke.Data.NonCommandParameterAttribute' from assembly 'DotNetNuke, Version=5.1.2.51, Culture=neutral, PublicKeyToken=null'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: CATALooK.Data.SqlCommandGenerator.GenerateCommandParameters
StackTrace:
Message: System.TypeLoadException: Could not load type 'DotNetNuke.Data.NonCommandParameterAttribute' from assembly 'DotNetNuke, Version=5.1.2.51, Culture=neutral, PublicKeyToken=null'. at CATALooK.Data.SqlCommandGenerator.GenerateCommandParameters(SqlCommand command, MethodInfo method, Object[] values) at CATALooK.Data.SqlCommandGenerator.GenerateCommand(SqlConnection Connection, MethodInfo Method, Object[] Values, CommandType SQLCommandType, String SQLCommandText) at CATALooK.StoreAdminInfo.CAT_GetSettings(Int32 PortalID) at CATALooK.StoreAdminInfo.GetStoreSettings(Int32 PortalID, String ModuleSkin) at CATALooK.StoreAdminInfo..ctor(Int32 PortalId, String ModuleSkin) at CATALooK.DashBoard.Page_Init(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.UserControl.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at DotNetNuke.UI.Modules.ModuleHost.InjectModuleContent(Control content) at DotNetNuke.UI.Modules.ModuleHost.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at DotNetNuke.UI.Modules.ModuleHost.get_ModuleControl() at DotNetNuke.UI.Containers.Container.get_ModuleControl() at DotNetNuke.UI.Containers.Container.ProcessModule() at DotNetNuke.UI.Skins.Pane.InjectModule(ModuleInfo objModule)
Source:
Server Name: A418
Which I had thought may indicate an error with Catalook, but I have modue exceptions such as:
ModuleId: 1441
ModuleDefId: 95
FriendlyName: x
ModuleControlSource: DesktopModules/HTML/HtmlModule.ascx
AssemblyVersion: 5.1.2
PortalID: 0
PortalName: x
UserID: -1
UserName:
ActiveTabID: 36
ActiveTabName: Home
RawURL: /Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.2; Trident/4.0; GTB6; .NET CLR 1.1.4322; .NET CLR 3.0.04506.30; .NET CLR 2.0.50727; FDM; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: f5e2ddba-ace4-459b-a552-1986e7b18a88
InnerException: Parameter count does not match Parameter Value count.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.HTML.SqlDataProvider.GetHtmlText(Int32 moduleId) at DotNetNuke.Modules.HTML.HtmlTextController.GetHtmlText(Int32 moduleId) at DotNetNuke.Modules.Html.HtmlModule.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server Name: A418
Does anyone have further insight into this?
Thanks