To modify the merger procedure or procedures were safe. And my problem was solved.


/****** Object: StoredProcedure [dbo].[GetModulePackagesInUse] Script Date: 2016/05/20 7:22:54 PM ******/

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetModulePackagesInUse]
@PortalID INT,
@ForHost BIT
AS

IF (@ForHost = 1)
-- Get in use for all host pages and portal pages
SELECT AllPackages.* FROM dbo.Packages AS AllPackages
INNER JOIN (
SELECT DISTINCT P.PackageID
FROM dbo.Packages P
INNER JOIN dbo.DesktopModules DM
ON P.PackageID=DM.PackageID
INNER JOIN dbo.vw_Modules M
ON M.DesktopModuleID=DM.DesktopModuleID
INNER JOIN dbo.tabs T
ON T.TabID=M.TabID
WHERE T.IsDeleted=0
AND M.IsDeleted=0) AS InUsePackages
ON AllPackages.PackageID = InUsePackages.PackageID
ORDER BY AllPackages.FriendlyName
ELSE
-- Get in use for portal or host only
SELECT AllPackages.* FROM dbo.Packages AS AllPackages
INNER JOIN (
SELECT DISTINCT P.PackageID
FROM dbo.Packages P
INNER JOIN dbo.DesktopModules DM
ON P.PackageID=DM.PackageID
INNER JOIN dbo.vw_Modules M
ON M.DesktopModuleID=DM.DesktopModuleID
INNER JOIN dbo.tabs T
ON T.TabID=M.TabID
WHERE ((@PortalID IS NULL AND T.PortalID IS NULL) OR T.PortalID = @PortalID)
AND T.IsDeleted=0
AND M.IsDeleted=0) AS InUsePackages
ON AllPackages.PackageID = InUsePackages.PackageID
ORDER BY AllPackages.FriendlyName

Hi,

I was having same problem as Soleil after having installed TurboDNN, and I've applied Soleil's script and the error has gone. But now, when I click on the extension link to see in which tabs is installed, I get nothing if I choose my site, and I get this error if I choose "System":
Error: no está disponible ahora. DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'TabVersions'. ---> System.Data.SqlClient.SqlException: Invalid object name 'TabVersions'. at System.Data.SqlClient.SqlConnection. (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.SqlDataReader.TryConsumeMetaData() 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 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 DotNetNuke.Data.PetaPoco.PetaPocoExt.ExecuteReader(Database database, String sql, Object[] args) at DotNetNuke.Data.SqlDataProvider.ExecuteReader(String procedureName, Object[] commandParameters) at DotNetNuke.Entities.Tabs.TabController.GetTabsByPackageID(Int32 portalID, Int32 packageID, Boolean forHost) at DotNetNuke.Modules.Admin.Extensions.UsageDetails.BuildData(Int32 portalID) at DotNetNuke.Modules.Admin.Extensions.UsageDetails.BindUsageList(Int32 selectedPortalID, String selectedPortalName) at DotNetNuke.Modules.Admin.Extensions.UsageDetails.FilterUsageList_SelectedIndexChanged(Object sender, EventArgs e) --- End of inner exception stack trace ---

IMPORTANT: In this DNN instance, all tables have got the prefix "dnn_"

Thank you,
Francisco

---

Expertos DNN en Madrid - Blog DNN España