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
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.