Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

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
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Application Error / after Upgrade 4.4.0Application Error / after Upgrade 4.4.0
Previous
 
Next
New Post
1/19/2007 7:40 AM
 
Fabian Müller

www.prodigio.de
Joined: 1/19/2005
Posts: 2

Hi,

my upgrade to 4.4.0 was successfull. However calling the website again fails with this error from the database:
Where can I get more information about the SQL causing this Problem?
Thanks, Fabian

Exception Details: System.Data.SqlClient.SqlException: Die Unterabfrage gab mehr als einen Wert zurück. Das ist ungültig, wenn die Unterabfrage auf =, !=, <, <= , >, >= folgt oder als Ausdruck verwendet wird.

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 (0x80131904): Die Unterabfrage gab mehr als einen Wert zurück. Das ist ungültig, wenn die Unterabfrage auf =, !=, <, <= , >, >= folgt oder als Ausdruck verwendet wird.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857370
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734982
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
   System.Data.SqlClient.SqlDataReader.HasMoreRows() +150
   System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +214
   System.Data.SqlClient.SqlDataReader.Read() +9
   DotNetNuke.Entities.Portals.PortalController.FillPortalInfo(IDataReader dr, Boolean CheckForOpenDataReader) +60
   DotNetNuke.Entities.Portals.PortalController.GetPortal(Int32 PortalId) +191
   DotNetNuke.Entities.Portals.PortalSettings.GetPortalSettings(Int32 TabId, PortalAliasInfo objPortalAliasInfo) +121
   DotNetNuke.Entities.Portals.PortalSettings..ctor(Int32 tabId, PortalAliasInfo objPortalAliasInfo) +83
   DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +5773
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

 
New Post
1/19/2007 11:45 AM
 
Fabian Müller

www.prodigio.de
Joined: 1/19/2005
Posts: 2

Looks like I have found something that causes this error:
The View vw_portals is not working correctly in my db:

SELECT PortalID, PortalName, CASE WHEN LEFT(LOWER(LogoFile), 6) = 'fileid' THEN (SELECT Folder + FileName FROM Files WHERE 'fileid=' + convert(varchar,Files.FileID) = LogoFile ) ELSE LogoFile END AS LogoFile, FooterText, ExpiryDate, UserRegistration, BannerAdvertising, AdministratorId, Currency, HostFee, HostSpace, PageQuota, UserQuota, AdministratorRoleId, RegisteredRoleId, Description, KeyWords, GUID, PaymentProcessor, ProcessorUserId, ProcessorPassword, SiteLogHistory, Email, DefaultLanguage, TimezoneOffset, AdminTabId, HomeDirectory, SplashTabId, HomeTabId, LoginTabId, UserTabId, (SELECT TabID FROM Tabs WHERE (PortalID IS NULL) AND (ParentId IS NULL)) AS SuperTabId, (SELECT RoleName FROM Roles WHERE (RoleID = P.AdministratorRoleId)) AS AdministratorRoleName, (SELECT RoleName FROM Roles WHERE (RoleID = P.RegisteredRoleId)) AS RegisteredRoleName FROM Portals AS P LEFT OUTER JOIN Users AS U ON P.AdministratorId = U.UserID

If I take out this sqlSELECT TabID FROM Tabs WHERE (PortalID IS NULL) AND (ParentId IS NULL)) AS SuperTabIdthe view shows up...
 
New Post
1/25/2007 7:39 AM
 
rob

Joined: 11/15/2006
Posts: 2
Removing the line did not help me, but changing it to
    (SELECT TabID FROM Tabs WHERE (PortalID IS NULL) AND (ParentId IS NULL) AND TabName='Host') AS SuperTabId,
fixed it, after the first page after upgrade had been displayed.
Changing the view back to how it was originally and the error does NOT come back.
 
New Post
2/6/2007 4:14 AM
 
Marc Huber

Joined: 10/19/2005
Posts: 7

I received the same error message where do i have to change it ? Sorry i'm a Newbie. What was the original line ? Better how can i fix the issue. Thanks in advance
 
New Post
2/6/2007 7:32 AM
 
rob

Joined: 11/15/2006
Posts: 2
The line is inside the view vw_portals, views are ways of shaping SQL queries and for me I opened up SQL enterprise manager, selected the DNN database server I had setup and located vw_portals in the views section.
you can then see the line
    (SELECT TabID FROM Tabs WHERE (PortalID IS NULL) AND (ParentId IS NULL)) AS SuperTabId,
and replace it with
    (SELECT TabID FROM Tabs WHERE (PortalID IS NULL) AND (ParentId IS NULL) AND TabName='Host') AS SuperTabId,
Let us know if you are still stuck.
 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Application Error / after Upgrade 4.4.0Application Error / after Upgrade 4.4.0


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:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. 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.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out