Upgrade Problem - Installing 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

11/26/2006 4:25 PM

md

Joined: 11/21/2006

Posts: 2

Upgrade Problem

I'm trying to upgrade from 2.1.2 to 4.3.5 (via 3.3.6) and getting nowhere fast.
The upgrade completes (with errors) and then when I try to access the site I get a login screen and nothing else, the login doesn't work either.
I'm trying to upgrade to 3.3.6 first as I've read that you can't move straight from 2.x to 4.x but I'm still getting the same problems in the upgrade process.
The real killer seems to be in the Member Role stuff - I get this error in the 02.02.01.log

"System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'Telephone' does not exist in table 'Users'.
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

---- snip snip ---

ALTER TABLE dbo.Users
    DROP COLUMN Street, City, Region, PostalCode, Country, Password, Email, Unit, Telephone"

Which is quite right there's no "Telephone" column in my Users table. I've got HomePhone, WorkPhone, Mobile andFax.

Is there something I'm missing here? Is this a customisation of the table or some "magic" setting I need to look at?

11/26/2006 8:08 PM

Nina M

www.berrydigital.com.au
Joined: 1/23/2004

Posts: 1961

Re: Upgrade Problem

I hope you've got a backup! I'm sure you do - but I spoke with a core team developer who told me he spent 8 hours or more upgrading a DNN 2 site to dnn4, but I thought he upgraded to DNN 3.1.1 or 3.2.2 first - and then 3.3 since the the memberrole changed between 3.22 and 3.3

I don't have an answer, just a comment based on my questions to someone else who upgraded a site to dnn 4 and it was alot of work.

You're braver than me that's for sure!!

Nina Meiers

Nina Meiers My Little Website

If it's on DNN, I fix, build, deploy, support,skin, host, design, consult, implement, integrate and done since 2003.
Who am I? Just a city chic, having a crack at organic berry farming.. and creating awesome websites.

11/26/2006 9:23 PM

md

Joined: 11/21/2006

Posts: 2

Re: Upgrade Problem

Thanks for the encouragement :-)
I've got backups up the wazzoo fortunantely as everything I try seems to completely bork the site/db/world at large.
I might try the 3.2.2 - 3.3.6 - 4.3.5 route and see if that gives me any joy.
The whole thing is made even more fun by the fact I'm picking this up cold from another (now ex-) co-worker. (cue hysterical laughter)

MD.

11/26/2006 10:22 PM

Nina M

www.berrydigital.com.au
Joined: 1/23/2004

Posts: 1961

Re: Upgrade Problem

I think if I had the time I'd even do the 3.1.1 step - you know DNN 3.1.1 was one of the best DNN 3 builds and I think, if memory serves me right, there was alot of work in upgradability between dnn 2 & 3, I know there is always testing between builds, but I do recall this one being quite good.

And that's a good start to see how it works with DNN3

I know your situation.. picking up other people's work is somewhat character building.. whether we like it or not.

I think sometimes I've got an over engineered character *sigh* brought about that force learning.. so I opt out to easier things when I can.. then when I get enough sleep I get silly and optimistic again!

Good Luck and let's see how you go.

Nina Meiers

Nina Meiers My Little Website

If it's on DNN, I fix, build, deploy, support,skin, host, design, consult, implement, integrate and done since 2003.
Who am I? Just a city chic, having a crack at organic berry farming.. and creating awesome websites.

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)