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
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...05.04.00.SqlDataProvider error when upgrading from 05.03.0105.04.00.SqlDataProvider error when upgrading from 05.03.01
Previous
 
Next
New Post
5/25/2010 12:12 PM
 
COSMOS4U

Joined: 1/16/2010
Posts: 3
I have the same problem. I have some records in the PortalLocalization table that does not have a corresponding record in the Portals table and delete them. Then I run the upgrade and worked!.There wasn't any error. But.... when I logon and went to Host->Portals, from the 22 portals I only see 3!! The tables Portals and PortalLocalization seems ok, with their records, but somehow I can't see my portals. Can't see means, don't work, too!! Any ideas?
 
New Post
5/26/2010 2:24 AM
 
Fanny Lie

Joined: 4/16/2003
Posts: 45
Hi all,

I'm experiencing the same problem. I notice this is caused by deleting portals not purging these portals references in some tables (table Tabs, PortalLocalization, etc) but physical directory is no longer exist. I don't know either all tables corresponded to these deleted portals.
How to delete these portals manually?
Could somebody give complete corresponded tables? Complete scripts to purge complete portal references in database will be very helpful.

Upgraded to 5.4.2 doesn't help anything, the result some active portals are missing. I'm very sure these deleted portals references must be purged completely from database. If not, upgrading will fail or other active portals will be gone as the result. Please somebody who could help. I think this is very serious issue.
 
New Post
6/7/2010 4:31 AM
 
COSMOS4U

Joined: 1/16/2010
Posts: 3
Fanny Lie wrote:
Hi all,

I'm experiencing the same problem. I notice this is caused by deleting portals not purging these portals references in some tables (table Tabs, PortalLocalization, etc) but physical directory is no longer exist. I don't know either all tables corresponded to these deleted portals.
How to delete these portals manually?
Could somebody give complete corresponded tables? Complete scripts to purge complete portal references in database will be very helpful.

Upgraded to 5.4.2 doesn't help anything, the result some active portals are missing. I'm very sure these deleted portals references must be purged completely from database. If not, upgrading will fail or other active portals will be gone as the result. Please somebody who could help. I think this is very serious issue.

 Fanny Lie any luck with the upgrade? My problem still exist.... what about you?
 
New Post
6/7/2010 9:54 PM
 
Fanny Lie

Joined: 4/16/2003
Posts: 45
Hi, no luck so far with the upgrade. Hope somebody from DNN core team could resolve this. If they can provide the scripts or tables references to purge all unused portals left in database, it will be very helpful. Then we'll give another try with the upgrade. So far I believe this is caused by some unused portals references are still left in the database. THanks
 
New Post
6/21/2010 8:57 AM
 
Timo Breumelhof


Timo Breumelhof's Avatar

www.40fingers.net
Joined: 2/9/2006
Posts: 4430
 
 Page 5 of 6
Previous123456Next 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...05.04.00.SqlDataProvider error when upgrading from 05.03.0105.04.00.SqlDataProvider error when upgrading from 05.03.01


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