New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

1/28/2007 11:44 PM

Robert Farrer

Joined: 7/6/2005

Posts: 6

v3.3.7 upgrade error

I'm using 2003 server, IIS, and was using SQL2000. First I upgraded to SQL2005 but it was so slow it wasn't acceptable. So then I tried to upgrade to v3.3.7 hoping it would improve the SQL2005 performance. But the install bombed. Then I restored back to SQL2000 and all was back to normal.

Then I tried to upgrade the SQL2000 and DNN v3.1 to v3.3.7 and I got the same failure at the same place. So I'm including all the documentation to see if there is a path or something I missed. Eventually I'd like to go to v4.x but so far haven't had a successful install---another post addresses that. For now, since it is my main website, I'd like to simply get to the latest v3.3.7.

Upgrading DotNetNuke

Current Assembly Version: 03.03.07

Current Database Version: 03.01.00

00:00:00.010 - Executing Script: C:\Inetpub\wwwroot\www.dotnetnuke\Providers\DataProviders\SqlDataProvider\Upgrade.SqlDataProvider

Upgrade Status Report

00:00:00.220 - Upgrading to Version: 3.1.1 Success
00:00:54.888 - Upgrading to Version: 3.2.0 Success
00:00:55.009 - Upgrading to Version: 3.2.1 Error! (seeC:\Inetpub\wwwroot\www.dotnetnuke\Providers\DataProviders\SqlDataProvider\03.02.01.log for more information)
00:00:55.690 - Upgrading to Version: 3.2.2 Success
00:00:55.720 - Upgrading to Version: 3.2.3 Success
00:00:59.916 - Upgrading to Version: 3.2.4 Success
00:00:59.986 - Upgrading to Version: 3.2.5 Success
00:01:00.096 - Upgrading to Version: 3.2.6 Success
00:01:00.166 - Upgrading to Version: 3.2.7 Success
00:01:00.176 - Upgrading to Version: 3.3.0 Success
00:01:00.306 - Upgrading to Version: 3.3.1 Success
00:01:00.436 - Upgrading to Version: 3.3.2 Success
00:01:00.647 - Upgrading to Version: 3.3.3 Success
00:01:00.917 - Upgrading to Version: 3.3.4 Success
00:01:00.937 - Upgrading to Version: 3.3.5 Success
00:01:01.228 - Upgrading to Version: 3.3.6 Success
00:01:01.478 - Upgrading to Version: 3.3.7 Success
00:01:01.618 - Performing General Upgrades
00:01:03.060 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\Announcements_03.03.05_Install.zip: Success
00:01:03.911 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\Blog_3.02.00_Install.zip: Success
00:01:04.402 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\Contacts_3.1_Install.zip: Success
00:01:04.502 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\Documents_03.01.05_Install.zip: Success
00:01:05.153 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\Events_3.2_Install.zip: Success
00:01:07.416 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\FAQs_3.1_Install.zip: Success
00:01:07.527 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\Feedback_03.02.01_Install.zip: Success
00:01:07.877 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\Forum_3.20.08_Install.zip: Success
00:01:12.994 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\Gallery_3.0.12_Install.zip: Error!
00:01:16.960 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\Help_2.0.4_Install.zip: Success
00:01:18.032 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\HTML_3.3.0_Install.zip: Success
00:01:18.132 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\IFrame_3.2_Install.zip: Success
00:01:18.542 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\Links_3.3_Install.zip: Success
00:01:18.793 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\Media_03.02.02_Install.zip: Success
00:01:19.394 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\NewsFeeds_3.1.1_Install.zip: Success
00:01:19.494 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\Repository_3.1.10_Install.zip: Success
00:01:33.173 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\Store_01.00.01_Install.zip: Success
00:01:36.498 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\Survey_3.3_Install.zip: Success
00:01:36.769 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\UserDefinedTable_03.03.06_Install.zip: Success
00:01:38.341 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\UsersOnline_3.1_Install.zip: Success
00:01:38.481 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\WhatsNew_3.3_Install.zip: Success
00:01:38.561 - Installing Module File C:\Inetpub\wwwroot\www.dotnetnuke\Install\Module\XML_3.1_Install.zip: Success

Upgrade Complete

Click Here To Access Your Portal

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.

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) +37

   DotNetNuke.Entities.Portals.PortalSettings.GetPortalSettings(Int32 TabId, PortalAliasInfo objPortalAliasInfo) +242

   DotNetNuke.Entities.Portals.PortalSettings..ctor(Int32 tabId, PortalAliasInfo objPortalAliasInfo) +92

   DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +5895

   System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60

   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87

Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300

From the log as mentioned in the upgrade error report:

System.Data.SqlClient.SqlException: CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 3. Most significant primary key is 'cleansing'.

Could not create constraint. See previous errors.

The statement has been terminated.

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)

at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

ALTER TABLE dbo.SearchWord ADD CONSTRAINT

IX_SearchWord UNIQUE NONCLUSTERED (Word) ON [PRIMARY]

1/29/2007 4:37 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: v3.3.7 upgrade error

Clear the search tables prior to the upgrade. I also got confrontated with this issue in an installation with dbowner <> "dbo", where there were duplicate host menu entries, so you might need to theck your database.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

1/29/2007 6:47 AM

William Severance

www.wesnetdesigns.com
Joined: 2/18/2005

Posts: 3253

Re: v3.3.7 upgrade error

Also check the following thread:

http://www.dotnetnuke.com/Community/ForumsDotNetNuke/tabid/795/forumid/107/threadid/93605/scope/posts/Default.aspx

Although this happened during an upgrade from 4.3.6 to 4.4.0, I believe that the problem had been introduced during an earlier upgrade.

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner

1/29/2007 10:56 AM

Robert Farrer

Joined: 7/6/2005

Posts: 6

Re: v3.3.7 upgrade error

additional info.... I do have a portal on my site that bombed during install so I later created a new one with a slilghtly different name. DNN won't let me have access or delete this portal otherwise I would have done so. The error on this site is:

Site Settings

Error: Site Settings is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The parameter 'roleName' must not be empty. Parameter name: roleName ---> System.ArgumentException: The parameter 'roleName' must not be empty. Parameter name: roleName at Microsoft.ScalableHosting.Security.SecUtility.CheckParameter(String& param, Boolean checkForNull, Boolean checkIfEmpty, Boolean checkForCommas, Int32 maxSize, String paramName) at Microsoft.ScalableHosting.Security.Roles.GetUsersInRole(String roleName) at DotNetNuke.Security.Roles.RoleController.GetUsersInRole(Int32 PortalID, String RoleName) at DotNetNuke.Modules.Admin.PortalManagement.SiteSettings.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Perhaps this is the error in my database that won't let me go any further? How to delete when in host mode I can't access or edit?

1/29/2007 2:05 PM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

s Re: v3.3.7 upgrade error

I suggest to compare the portal entries in database tables with the entries for a properly created portal. There might be roles missing or the portal alias, that is preventing the deletion. If you cot a portal crashed on istall, do not try to make it work, but delete it and create a new one.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

Page 1 of 2

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

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.

DNN Corp. (DotNetNuke)