DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.
  • Search Forums
    Advanced Search
Prev
Next
Forums Using DNN Platform Upgrading DNN Platform

Moving to new server

 11 Replies
 2 Subscribed to this topic
 34 Subscribed to this forum
Sort:
Page 2 of 2 << < 12
Author
Messages
John3
New Around Here
Posts: 8
New Around Here
4/1/2022 7:50 PM

Perhaps I was a little to quick to blame Sebastian. Sorry.

After trying dozens of things that did not work, I decided to try to re-install only the import export module in a working copy of dnn. Failure! Unfortunately, it does not come with an uninstall script. The SiteExportImport may roll back the files and folders but not the database.

Reason Michael does not see the script/error is because his installed successfully. You can see it here: 

\Install\Module\DNNCE_SiteExportImport_09.03.02_Install.zip\Providers\DataProviders\SqlDataProvider

Now I am wondering which tables and views, etc that I need to delete from database to successfully install this module and hopefully upgrade to 9.3.2 and then to latest DNN version.

StartJob Starting Installation

Info Starting Installation - SiteExportImport

Info Starting Installation - Assembly

Info Assembly updated - bin\DotNetNuke.SiteExportImport.dll

Info Creating backup of previous version - bin\DotNetNuke.SiteExportImport.dll

Info Created - bin\DotNetNuke.SiteExportImport.dll

Info Assembly updated - bin\DotNetNuke.SiteExportImport.Library.dll

Info Creating backup of previous version - bin\DotNetNuke.SiteExportImport.Library.dll

Info Created - bin\DotNetNuke.SiteExportImport.Library.dll

Info Assembly updated - bin\LiteDB.dll

Info Creating backup of previous version - bin\LiteDB.dll

Info Created - bin\LiteDB.dll

Info Binding redirect added for assembly - bin\LiteDB.dll

Info Component installed successfully - Assembly

Info Starting Installation - ResourceFile

Info Expanding Resource file

Info Creating backup of previous version - App_LocalResources\ExportImport.resx

Info Created - App_LocalResources/ExportImport.resx

Info Resource Files created

Info Component installed successfully - ResourceFile

Info Starting Installation - Script

Info Begin Sql execution

Info Created - Providers\DataProviders\SqlDataProvider\09.03.00.SqlDataProvider

Info Executing 09.03.00.SqlDataProvider

Info Start Sql execution: 09.03.00.SqlDataProvider file

Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'oa_Export_GetActiveTabModules' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:392f2475-2996-4c1d-b1b2-e84b04adaf66 Error Number:2714,State:3,Class:16 CREATE FUNCTION dbo.[oa_Export_GetActiveTabModules] ( @TabID int, @IncludeDeleted BIT ) RETURNS @ModuleIds TABLE ( ModuleId INT ) AS BEGIN DECLARE @StateId int; SELECT @StateId=StateID FROM dbo.[oa_ContentItems] WHERE TabID=@TabID AND ModuleID=-1; --IF there is versioninig with the tab IF(@StateId IS NOT NULL) BEGIN -- Get all distinct module ids which belong to any published version of the tab INSERT INTO @ModuleIds (ModuleId) SELECT DISTINCT TM.ModuleId From dbo.[oa_TabModules] TM LEFT JOIN dbo.[oa_TabVersions] TV ON TM.TabID=TV.TabId LEFT JOIN dbo.[oa_TabVersionDetails] TVD ON TV.TabVersionId=TVD.TabVersionId WHERE TM.TabId=@TabID AND (TV.IsPublished=1 OR TV.IsPublished IS NULL) AND (@IncludeDeleted = 1 OR TM.IsDeleted = 0) END ELSE BEGIN INSERT INTO @ModuleIds (ModuleId) SELECT DISTINCT ModuleId FROM dbo.[oa_TabModules] WHERE TabID=@TabID AND (@IncludeDeleted = 1 OR IsDeleted = 0) END RETURN; END System.Data.SqlClient.SqlException (0x80131904): Procedure or function dbo.oa_Export_GetActiveTabModules has too many arguments specified. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:392f2475-2996-4c1d-b1b2-e84b04adaf66 Error Number:8144,State:3,Class:16 CREATE PROCEDURE dbo.[oa_Export_TabModules] @TabID int, @IncludeDeleted bit, @ToDate datetime, @FromDate datetime=NULL AS BEGIN DECLARE @Now datetime = GETDATE() SELECT ModuleId INTO #ActiveModuleIds FROM dbo.[oa_Export_GetActiveTabModules](@TabID, @IncludeDeleted) SELECT tm.*, md.FriendlyName,m.InheritViewPermissions,m.IsShareable,m.IsShareableViewOnly, u1.Username AS CreatedByUserName, u2.Username AS LastModifiedByUserName FROM dbo.oa_TabModules AS tm INNER JOIN dbo.oa_Tabs AS t ON tm.TabID = t.TabID INNER JOIN dbo.oa_Modules AS m ON tm.ModuleID = m.ModuleID INNER JOIN dbo.oa_ModuleDefinitions AS md ON md.ModuleDefID = m.ModuleDefID LEFT OUTER JOIN dbo.oa_Users AS u1 ON tm.CreatedByUserID = u1.UserID LEFT OUTER JOIN dbo.oa_Users AS u2 ON tm.LastModifiedByUserID = u2.UserID WHERE tm.TabID = @TabID AND tm.ModuleID IN (SELECT ModuleId FROM #ActiveModuleIds) AND (@IncludeDeleted = 1 OR tm.IsDeleted = 0) AND COALESCE(tm.LastModifiedOnDate, tm.CreatedOnDate, @Now) <= @ToDate AND (@FromDate IS NULL OR ISNULL(tm.LastModifiedOnDate, tm.CreatedOnDate) >= @FromDate) DROP TABLE #ActiveModuleIds END System.Data.SqlClient.SqlException (0x80131904): Procedure or function dbo.oa_Export_GetActiveTabModules has too many arguments specified. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:392f2475-2996-4c1d-b1b2-e84b04adaf66 Error Number:8144,State:3,Class:16 CREATE PROCEDURE dbo.[oa_Export_TabModuleSettings] @TabID int, @IncludeDeleted bit, @ToDate datetime, @FromDate datetime=NULL AS BEGIN DECLARE @Now datetime = GETDATE() SELECT ModuleId INTO #ActiveModuleIds FROM dbo.[oa_Export_GetActiveTabModules](@TabID, @IncludeDeleted) SELECT tms.*, u1.Username AS CreatedByUserName, u2.Username AS LastModifiedByUserName FROM dbo.oa_TabModuleSettings AS tms INNER JOIN dbo.oa_TabModules AS tm ON tm.TabModuleID = tms.TabModuleID INNER JOIN dbo.oa_Tabs AS t ON tm.TabID = t.TabID LEFT OUTER JOIN dbo.oa_Users AS u1 ON tm.CreatedByUserID = u1.UserID LEFT OUTER JOIN dbo.oa_Users AS u2 ON tm.LastModifiedByUserID = u2.UserID WHERE t.TabID = @TabID AND tm.ModuleID IN (SELECT ModuleId FROM #ActiveModuleIds) AND COALESCE(tms.LastModifiedOnDate, tms.CreatedOnDate, @Now) <= @ToDate AND (@FromDate IS NULL OR ISNULL(tms.LastModifiedOnDate, tms.CreatedOnDate) >= @FromDate) DROP TABLE #ActiveModuleIds END System.Data.SqlClient.SqlException (0x80131904): Procedure or function dbo.oa_Export_GetActiveTabModules has too many arguments specified. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:392f2475-2996-4c1d-b1b2-e84b04adaf66 Error Number:8144,State:3,Class:16 CREATE PROCEDURE dbo.[oa_Export_Modules] @TabID int, @IncludeDeleted bit, @ToDate datetime, @FromDate datetime=NULL AS BEGIN DECLARE @Now datetime = GETDATE() SELECT ModuleId INTO #ActiveModuleIds FROM dbo.[oa_Export_GetActiveTabModules](@TabID, @IncludeDeleted) SELECT DISTINCT m.*, md.FriendlyName, u1.Username AS CreatedByUserName, u2.Username AS LastModifiedByUserName FROM dbo.oa_Modules AS m INNER JOIN dbo.oa_TabModules AS tm ON tm.ModuleID = m.ModuleID INNER JOIN dbo.oa_ModuleDefinitions AS md ON md.ModuleDefID = m.ModuleDefID LEFT OUTER JOIN dbo.oa_Users AS u1 ON tm.CreatedByUserID = u1.UserID LEFT OUTER JOIN dbo.oa_Users AS u2 ON tm.LastModifiedByUserID = u2.UserID WHERE tm.TabID = @TabID AND tm.ModuleID IN (SELECT ModuleId FROM #ActiveModuleIds) AND (@IncludeDeleted = 1 OR m.IsDeleted = 0) AND ( COALESCE(m.LastModifiedOnDate, m.CreatedOnDate, @Now) <= @ToDate AND (@FromDate IS NULL OR ISNULL(m.LastModifiedOnDate, m.CreatedOnDate) >= @FromDate) OR COALESCE(tm.LastModifiedOnDate, tm.CreatedOnDate, @Now) <= @ToDate AND (@FromDate IS NULL OR ISNULL(tm.LastModifiedOnDate, tm.CreatedOnDate) >= @FromDate) ) DROP TABLE #ActiveModuleIds END

Info End Sql execution: 09.03.00.SqlDataProvider file

Info Finished Sql execution

Failure Installation Failed - Script

Info Rolling back component install - Assembly

Info Restored backup of previous version - bin\DotNetNuke.SiteExportImport.dll

Info Restored backup of previous version - bin\DotNetNuke.SiteExportImport.Library.dll

Info Restored backup of previous version - bin\LiteDB.dll

Info Component rolled back successfully - Assembly

Info Rolling back component install - ResourceFile

Failure Exception - Could not find file 'C:\www\newOasisCruise\Install\Temp\qshuo2csResources.zip'.

Info Component rolled back successfully - ResourceFile

Info Installation Failed - SiteExportImport

Info Deleted temporary install folder

EndJob Installation Failed

John3
New Around Here
Posts: 8
New Around Here
4/2/2022 7:49 PM
I tried the uninstall sql from 9.1 for the exportImport module. This gets rid of the tables, then upgrade but the error is same.
Then tried upgrade to 9.3.2 without the ExportImport zip in the /install folder. Yeah, that works.
Will try to upgrade to latest version (removing ExportImport each time) and try to deal with ExportImport later.
Page 2 of 2 << < 12

These Forums are for the discussion of the open source CMS DNN platform and ecosystem.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy. 
  2. No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
  3. 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.
  4. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  5. No Flaming or Trolling.
  6. No Profanity, Racism, or Prejudice.
  7. Site Moderators have the final word on approving / removing a thread or post or comment.
  8. English language posting only, please.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved