Here is where I am... After a trip back to 4.9.0, I was able to fix (convert) the skin. I was then able to run the site when I got back to 5.5.1 [keep in mind GoDaddy rolls forward only in one step, but rolls back one version at a time so my only step from 4.9.0 forward was to 5.5.1]
Everything worked except the HTML module. It gave me the same direct 2.2.0.7 vs indirect 2.2.2.0 BC32206 dotnetnuke.webcontrol.dll error as before, but only returned for the HTML module call so all else ran !!
At the suggestion from a different/earlier post on the same error, I performed the following except using the 5.5.1 install package:
" .vb files are no longer needed for HTML module, it has been converted to WAP format using a dll.
if you have problems to run HTML on your site:
delete content of folder /app_code/html/
delete content of folder /desktopmodules/html/ (if present)
delete file /bin/dotnetnuke.modules.html.dll (if present)
delete file /bin/dotnetnuke.modules.html.sqldataprovider.dll (if present)
unzip dnn_html_05.02.00.zip from /install/module in DNN 5.2.0 upgrade package
in Host :: Extensions menu item, use command "extensions installation wizard" to re-install html module.
HTH "
I get the following error on install; the html module is obviously now gone go it throws no error but I need an HTML module to install... :
Package Installation Report
See below for the results of the package installation
Error loading files from temporary folder - see below
StartJob Starting Installation
Info Starting Installation - DNN_HTML
Info Starting Installation - Script
Info Begin Sql execution
Info Folder Created - d:\hosting\ilborough\dotnetnuke\DesktopModules\HTML\Providers\DataProviders\SqlDataProvider
Info Created - Providers\DataProviders\SqlDataProvider\03.00.00.SqlDataProvider
Info Executing 03.00.00.SqlDataProvider
Info Start Sql execution: 03.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'DesktopHtml'. Invalid column name 'DesktopSummary'. Invalid column name 'CreatedByUser'. Invalid column name 'CreatedDate'. 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) /** Create Stored Procedures **/ create procedure dbo.AddHtmlText @ModuleId int, @DesktopHtml ntext, @DesktopSummary ntext, @UserID int as insert into HtmlText ( ModuleId, DesktopHtml, DesktopSummary, CreatedByUser, CreatedDate ) values ( @ModuleId, @DesktopHtml, @DesktopSummary, @UserID, getdate() ) System.Data.SqlClient.SqlException: Invalid column name 'DesktopHtml'. Invalid column name 'DesktopSummary'. Invalid column name 'CreatedByUser'. Invalid column name 'CreatedDate'. 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) create procedure dbo.UpdateHtmlText @ModuleId int, @DesktopHtml ntext, @DesktopSummary ntext, @UserID int as update HtmlText set DesktopHtml = @DesktopHtml, DesktopSummary = @DesktopSummary, CreatedByUser = @UserID, CreatedDate = getdate() where ModuleId = @ModuleId
Info End Sql execution: 03.00.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
I can roll back again, but I figured I might be better off setting at 5.5.1 and trying to recover the HTML module. Ideas??
|