Products

Solutions

Resources

Partners

Community

Blog

About

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

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Database UpgradeDatabase Upgrade
Previous
 
Next
New Post
7/27/2006 4:59 AM
 

Hey everyone.

Currently have DNN 3.1.0 runnning. Thinking of redoing my site with DNN 4.3.3. I am on MS SQL 2000. I want to upgrade this to MS SQL 2005. If I create a backup of my DB and then restore it to SQL 2005 will DNN 4.3.3 have any issues with it?

Thanks,

OrNot2B

 
New Post
7/27/2006 9:04 AM
 
I've done just as you described a number of times, and I've had a number of problems. I'm using SQL Server 2005 Enterprise.

1. Upgrading 3.1.0 to DNN 4.3.3 have caused major problems for me, and I've not yet been able to do this for any of my DNN sites. On my current site, all my new users come up blank and I can no longer list users. However, they can register & login fine. I think I'm going to have to start over. No one here has been able to help me or explain why this happened. Put me 3 weeks out of business, or on life support basically.

I have another site where the upgrade for some reason would run the file synch sp's over and over until 100% CPU and the app pool would crash. I fixed this by clearing out the schedule history table, but no one has been able to tell me why this happened. Put me another 2 weeks out of business.

2. On several of my sites, I had to stay in sql 2000 compat mode (80?) or I get errors. I think I still see some other errors from old modules, but I've not looked into this or upgraded them to see if there are fixes to work for sql 2005. It seems like a fresh DNN 4.3.3 install with the core modules work fine, but I've not testing them all.

Jason Honingford - Web & Software Developer
www.PortVista.com
 
New Post
7/27/2006 3:55 PM
 

Thanks for the info Jason. Luckily I'm at a point where a fresh install of everything is possible, so I'm going to go that route. I'm not savey enough to work out all the issues as you've described.

Thanks again.

 
New Post
7/27/2006 6:17 PM
 
On one of my sites, I'm definately doing a fresh install. If you backup everything and have the ability to do restores/backups of your database, you can always try the upgrade path and see. May save time, may waste time! lol!

Jason Honingford - Web & Software Developer
www.PortVista.com
 
New Post
7/30/2006 8:28 AM
 

[QUOTE]PortVista wrote

1. Upgrading 3.1.0 to DNN 4.3.3 have caused major problems for me, and I've not yet been able to do this for any of my DNN sites. On my current site, all my new users come up blank and I can no longer list users. However, they can register & login fine. I think I'm going to have to start over. No one here has been able to help me or explain why this happened. Put me 3 weeks out of business, or on life support basically.

Prior to DNN 4.3, the users are stored in MS Memberships table (those aspnet_* tables).  With DNN 4.3 and 3.3, the membership data are stored in User* tables.  My understand is that part of the upgrade, there is a script to move data from aspnet_Profile to UserProfile and DNN 4.3/3.3 will no longer use the aspnet_Profile table.

There must be upgrade SQL scipt somewhere that do this data move.  I suspect if you have a large site, this script may take a while to complete.  Just a guess

 


Robert Tango
www.workcontrol.com
Custom Modules: UserManager|UserDirectory|UserImport|PortalSSO
 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Database UpgradeDatabase Upgrade


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