I have an interesting problem that I could use some help understanding.
I have multiple DNN instances on my localhost (some from live sites and other from new installs 4.8.x, 4.9, & 5.0).
On a live site that I am testing locally, I am having issues updating the page settings Title, Description, and Keywords.
I have developed a variation of the script from the tutorial in Issue 33 regarding updating the page settings using SQL.
I developed the variation on a new local install (v.4.9) which it works great and allows me to update all th pages at one time and provides a before and after snapshot of what was changed. The variation difference is that updates multiple TabID's that meet the '
where' criteria. It works perfectly on the new local host instance and fails on the live/local copy. The error message refers to a procedure installed by "DNN 360 tab module". However, I can't find the stored procedure that the error message refers to.
Error message:
Msg 512, Level 16, State 1, Procedure DNN360Menu_Update, Line 9
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
SQL Statement
use
db_name
DECLARE
@TabOrder int
SET @TabOrder = 10000
DECLARE
@PortalIDEdit int
SET @PortalIDEdit = 0
DECLARE
@IsVisible int
SET @IsVisible = 1
select Title, Description, KeyWords from tabs
where portalid = @PortalIDEdit
and TabOrder < @TabOrder
and IsVisible = @IsVisible
UPDATE
Tabs
SET Title = 'page title text'
WHERE portalid = @PortalIDEdit
and TabOrder < @TabOrder
and IsVisible = @IsVisible
UPDATE
Tabs
SET Description = 'description text.'
WHERE portalid = @PortalIDEdit
and TabOrder < @TabOrder
and IsVisible = @IsVisible
UPDATE Tabs
SET KeyWords = 'Keyword text'
WHERE portalid = @PortalIDEdit
and TabOrder < @TabOrder
and IsVisible = @IsVisible
select
Title, Description, KeyWords from tabs
WHERE portalid = @PortalIDEdit
and TabOrder < @TabOrder
and IsVisible = @IsVisible<>
So the question is, how do I find this procedure? Has anyone run in to this or have any thoughts how to get around it?
I do like being able to update all the tabs I select at one time and understand I could probably specify each one and this would no longer be an issue. However, I would sooner remove this tabs module and seek a non-conflicting alternative provider of the tabs function.
Regards,
AggieDan97