While upgrading from 4.9.0.1 to 5.0.1.2 I recieved a couple errors, but I am not sure what to do, I don't see any indication that they are module related.
With SQL for version 5.0.0:
System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
UPDATE dbo.nfit_Tabs
SET IconFile = '~/images/' + IconFile
WHERE IconFile LIKE 'icon_%'
AND (TabPath LIKE '//Host%' OR TabPath LIKE '//Admin%')
System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
UPDATE dbo.[nfit_Tabs]
SET IsSecure = 1
WHERE PortalID IS NULL
OR TabID IN (SELECT AdminTabId FROM dbo.[nfit_Portals])
OR ParentId IN (SELECT AdminTabId FROM dbo.[nfit_Portals])
With SQL for version 5.1.0:
System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
(This produces a huge list of path names for icon files and tab descriptions.
System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
UPDATE dbo.nfit_Tabs SET Title='Pages', TabName='Pages' WHERE TabPath='//Admin//Tabs'
/* Enable link of Admin, Host tabs */
UPDATE dbo.nfit_Tabs SET DisableLink=0 WHERE TabPath='//Admin' OR TabPath='//Host'
Everything seems to work correctly except icon paths, and descriptions are all messed up. Can anyone help me so that I can move on from this?
Thanks...