Our shared hosting provided upgraded our DNN3 installation to DNN4.0.3. Unfortunately things didn't go smoothly and a number of errors popped up related to viewing and installing modules while under admin and host modes (specifically, so far, errors indicating missing GetDesktopModulesByPortal and GetDesktopModuleByModuleName procedures). We seem to have fixed these by copying the missing procedures into the db , but now the failure pasted below comes up after an otherwise successful processing of module upload.
So here are some questions:
- Is there any way to fix all these errors related to Module management with an SQL procedure?
- Would an upgrade to 4.3.3 replace all the missing procedures?
- Does the appearance of "PaDnnInstaller_V3" provide any clues? Should this be "V4" instead? If so, what does that mean and any suggestions for a fix?
Thanks everybody.
ExceptionSystem.Data.SqlClient.SqlException: Invalid object name 'dnn_DesktopModules'. 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.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.GetDesktopModuleByModuleName(String ModuleName) at DotNetNuke.Entities.Modules.DesktopModuleController.GetDesktopModuleByModuleName(String ModuleName) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstaller_V3.GetDesktopModule(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.ValidateVersion(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install()