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 ...DNN 4.4.0 - Subquery returned more than 1 valueDNN 4.4.0 - Subquery returned more than 1 value
Previous
 
Next
New Post
12/27/2006 11:18 AM
 
InSoMnIa

Joined: 11/20/2005
Posts: 49
For example, where 'Host' appear in tabid 7 and others rows have 89 tabid
UPDATE Tabs
SET parentid = 7
WHERE  tabid = 89
 
New Post
12/28/2006 2:19 PM
 
Mark Garcia


www.lacodiatech.com
Joined: 6/8/2003
Posts: 113
nadersoliman wrote

I got the same error, there is a fix (needs some SQL)

Simply doing the following SQL
SELECT * FROM Tabs
WHERE (PortalID IS NULL) AND (ParentId IS NULL)
returns many tabs. You need to look for a tab with TabName='Host' and note its ID (in my case it was 7)
For the other returned rows use the previous obtained ID in the ParentId.

Kill the aspnet process and browse the site again, things are working fine. 

 

It's a good thing I waited to upgrade to 4.4.0. I ran into this very same bug, but was at a complete loss as how to fix it. Thanks for your help. I did loose the skin setting for the website, and several of the modules were in different panes, but other than that everything seems to be working fine. I hope this bug can be fixed, so that this problem dosen't occur everytime you have to upgrade an older site.

Thanks
Mark
 
New Post
12/28/2006 3:52 PM
 
Nader Soliman

Joined: 3/4/2005
Posts: 5

Lacodia wrote
 

It's a good thing I waited to upgrade to 4.4.0. I ran into this very same bug, but was at a complete loss as how to fix it. Thanks for your help. I did loose the skin setting for the website, and several of the modules were in different panes, but other than that everything seems to be working fine. I hope this bug can be fixed, so that this problem dosen't occur everytime you have to upgrade an older site.

Thanks
Mark

Hi Mark,

What version did you upgrade from? It will help other users to know ... I didn't get the problem you described I was upgrading from 4.3.6 to 4.4.0.

Nader Soliman
 
New Post
12/28/2006 7:38 PM
 
Mark Garcia


www.lacodiatech.com
Joined: 6/8/2003
Posts: 113
nadersoliman wrote

 Lacodia wrote
 

 

It's a good thing I waited to upgrade to 4.4.0. I ran into this very same bug, but was at a complete loss as how to fix it. Thanks for your help. I did loose the skin setting for the website, and several of the modules were in different panes, but other than that everything seems to be working fine. I hope this bug can be fixed, so that this problem dosen't occur everytime you have to upgrade an older site.

Thanks
Mark

 

Hi Mark,

What version did you upgrade from? It will help other users to know ... I didn't get the problem you described I was upgrading from 4.3.6 to 4.4.0.

Nader Soliman

 

So I upgraded from 4.3.5, but Bill in the post above pointed out . . .

"I then looked at the database backup I had made just before the upgrade and found that the ParentId for the Lists tab in the Tabs table was null - so the error had been introduced at some time prior to the 4.4 upgrade and possibly sometime since the upgrade to 3.5.6 about a month ago"

 . . . which may mean the bug was introduced even further back. The website has been upgraded thru many versions.

Mark
 
New Post
1/2/2007 8:47 PM
 
Roy Dean Leighton, Jr.

www.ardee.com
Joined: 3/1/2005
Posts: 17
nadersoliman wrote

 Lacodia wrote
 

 

It's a good thing I waited to upgrade to 4.4.0. I ran into this very same bug, but was at a complete loss as how to fix it. Thanks for your help. I did loose the skin setting for the website, and several of the modules were in different panes, but other than that everything seems to be working fine. I hope this bug can be fixed, so that this problem dosen't occur everytime you have to upgrade an older site.

Thanks
Mark

 

Hi Mark,

What version did you upgrade from? It will help other users to know ... I didn't get the problem you described I was upgrading from 4.3.6 to 4.4.0.

Nader Soliman

I am upgrading from 4.3.7 and I am getting the error. I am not sure how to fix it. Your instructions when comparing to my Tabs table are not clear to me.

My Tabs table has the Host TabName that is TabID 7. All the records for the Host menu have a ParentID of 7. The same is true with the Admin record. Both the Host and Admin records have (NULL) in the ParentID column. Is this the column that you suggest be changed to 7 for Host and 38 for Admin?
 
 Page 2 of 5
Previous123...5Next 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...DNN 4.4.0 - Subquery returned more than 1 valueDNN 4.4.0 - Subquery returned more than 1 value


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