Hi,

I'm new with DotNetNuke, and I tried to upgrade the version from 3.2.2 to 3.3.7. I downloaded the documents and upgrade package, read the instructions on upgrading and executed the upgrade step-by-step, as the instruction said. Before the instalation started I was warned by the installer screen that I have users with same e-mail address and that the password for those users will be reset. I accepted this and clicked "OK" and the instalation started. The installer screen showed that all the steps complited successfully and I managed to open the "Home" page of my portal. But when I tried to open any other page it shows an error page. Error page is shown here:

Server Error in '/mnr' Application.

---

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

[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() +157
   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) +3757
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87

Please some one help me, because I need to fix this as soon as posible. I thank you in advance for any help that you can give me.

this is caused by irregular entries in the tabs and/or modules table.

1. check the tabs table
   make sure, that there aren't duplicate entries with same PortalID AND ParentID, especially not two entries with Null values for both.
2. Check the modules table for admin modules, that are duplicate for the same portal

I tried your suggestions, but I can't find any duplicate entries with same PortalID and ParentID in the Tabs table and I still have the error showing in the browser. Which are the admin modules?