PROCEDURE [dbo].[GetPortalSettings]

Jun 6, 2015 at 8:38 PM
!!!!! Not Filter by PortalId


FROM dbo.[PortalSettings] PS
WHERE PS.PortalID = @PortalID AND PortalSettingID = (SELECT
Jun 7, 2015 at 12:01 PM
Edited Jun 7, 2015 at 12:04 PM
Thank you, but I can't find this SQL fragment in latest release (0.9.8 h)
If you are missing a check for PortalID, it is contained in subquery (PortalSettingID is unique across all Portals).
Jun 7, 2015 at 12:18 PM
file -- TurboDNN741.sql --> lines: 11542

(PortalSettingID is unique across all Portals). !!!!

PROCEDURE {databaseOwner}[{objectQualifier}GetPortalSettings]
@PortalId    Int,            -- not Null!
.............
..............
...........


no by @PortalID -- > procedure result All lines settings
Jun 7, 2015 at 12:24 PM

SELECT …
FROM dbo.PortalSettings PS
WHERE PortalSettingID = (SELECT Top(1) PortalSettingID FROM dbo.PortalSettings S

WHERE PS.PortalID = S.PortalID AND PS.SettingName = S.SettingName

ORDER BY CASE CultureCode WHEN @CultureCode THEN 2 WHEN Null THEN 1 ELSE 0 END DESC)

Jun 7, 2015 at 12:37 PM
Edited Jun 7, 2015 at 12:40 PM
!!!!! NO filter by portal!!!!

in this request are consistent only tables

PS and S

result all tables dbo.PortalSettings
Jun 7, 2015 at 12:47 PM
Edited Jun 7, 2015 at 12:55 PM
Ah, I see the issue now, sorry. I will fix it ASAP!
Sebastian

PS: I am working currently on improved addTab/moveTab procedures, healing inconsistencies automatically
Jun 26, 2015 at 1:58 PM
Thanks, fixed in TurboDNN 0.9.8 Revision k
Marked as answer by leupold on 6/26/2015 at 5:58 AM