For those of you on the night shift, I really need some help. I did an upgrade from DNN 3.3.5 to 3.3.6. This is the fourth DNN install I am upgrading over the last week and the first to give me real issues. I am getting the error below. I have researched as much as I could find. I did find one thread where someone discussed a possible duplication in the PortalAlias table. Well, I have looked into the PortalAlias, Portals, and Tabs tables and cannot find a duplicate.
Is there any kind of upgrade log I can look into to see more about this. For some reason, I was multi-tasking and did not get a full backup before the upgrade. I cannot believe that I did that. I have full backups of all the upgrades that worked. Just my luck!
One note is that I was having issues creating child portals from this DNN install today and I tried 3 times to create a child portal and got an error each time. When I looked into the Portals table I saw three portals with the same name but no data in the fields. So I deleted those rows.
Thanks for any ideas on this. I am pretty desparate at this point.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: 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.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. |
Stack Trace:
[SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.]
System.Data.SqlClient.SqlDataReader.Read() +176
DotNetNuke.Common.Utilities.CBO.FillObject(IDataReader dr, Type objType, Boolean ManageDataReader) +57
DotNetNuke.Entities.Portals.PortalController.GetPortal(Int32 PortalId) +38
DotNetNuke.Entities.Portals.PortalSettings.GetPortalSettings(Int32 TabId, PortalAliasInfo objPortalAliasInfo) +243
DotNetNuke.Entities.Portals.PortalSettings..ctor(Int32 tabId, PortalAliasInfo objPortalAliasInfo) +93
DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +5917
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87
|
Server Error in '/' Application.
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300