From 495 to 541 - Upgrading DNN Platform

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
2
3
4
5

4/29/2010 7:27 PM

Mauro Miotello

www.dnn-italia.it
Joined: 4/5/2003

Posts: 105

From 495 to 541

I've tried to upgrade my site from dnn495 to dnn541 but some script fail:

05.00.00.SqlDataProvider
05.01.00.SqlDataProvider
Application Upgrades: 05.03.00
Installing Package File HTML_Community_05.02.00_Install: Error!
Installing Package File Messaging_01.01.00_Install: Error!
Installing Package File Taxonomy_01.01.00_Install: Error!

On 05.00.00.log under /* Update IconFile References for Admin Tabs */ i see "System.Data.SqlClient.SqlException: subquery return multiple values!...
similar error on 05.01.00.log !

Someone know how to fix my dnn495 database to prevent this errors during upgrade ?

blondie

4/30/2010 1:24 AM

Chris Hammond

www.christoc.com
Joined: 1/14/2003

Posts: 7319

Re: From 495 to 541

I would look at what the query does, and see if you have multiple pages with the same name perhaps?

Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions

4/30/2010 4:50 AM

Mauro Miotello

www.dnn-italia.it
Joined: 4/5/2003

Posts: 105

Re: From 495 to 541 Modified By Mauro Miotello on 4/30/2010 4:54:29 AM

Chris Hammond wrote:
I would look at what the query does, and see if you have multiple pages with the same name perhaps?

The first query fail is:

UPDATE dbo.Tabs SET IconFile = '~/images/' + IconFile WHERE IconFile LIKE 'icon_%' AND (TabPath LIKE '//Host%' OR TabPath LIKE '//Admin%')

I've launch this modified query to see the problem:

SELECT * from dbo.Tabs WHERE IconFile LIKE 'icon_%' AND (TabPath LIKE '//Host%' OR TabPath LIKE '//Admin%') ORDER BY tabname

the result is:

There's some pages with same name but with portalID = NULL ! do you think that i've to delete this pages portalID = NULL ?

Mauro

blondie

4/30/2010 11:23 AM

Alex Shirley

Joined: 1/30/2006

Posts: 5038

Re: From 495 to 541

Please check this thread: http://www.dotnetnuke.com/Community/F...

Page 1 of 1

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

DNN Corp. (DotNetNuke)