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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...DNN 5 migration - error.DNN 5 migration - error.
Previous
 
Next
New Post
6/3/2009 7:51 PM
 

Hi All,

As the subject states, i have an error migrating my DNN5 hosting - and cannot seem to work out why.

Of note is this: i tested the portal internally on my own test server, IIS 6 and SQL 2005 standard.
I then relocated the files to another local iis6 server that is accessible from the internet for remote testing - this worked fine

Now the project is complete i'm trying to migrate to my web hosting, the hosting is on IIS 7, i can choose between SQL 2005 and sql 2008 - i chose 2005 (NOT EXPRESS).

I have copied up all the files, and i used SQL manager on my local server to Export the entire database directly into the SQL 2005 database on the remote end.

I Experience this problem initially. Instead of seeing my portal load up (aliases/DNS are all correctly pointed), i get the Installation Wizard... I cant seem to get past the wizard, at one point i decided to just step through it and see what happened. the Database scripts failed, and now the portal shows this error.

 

Cannot insert the value NULL into column 'ServerID', table 'CL1679_storewebsites.dbo.Servers'; column does not allow nulls. INSERT fails.
The statement has been terminated.

I have confirmed that the exported database structure is all identical, i have no idea what i might do to rectify this situation.

One idea i have, that i think might not work - What if i remove all the files and DB, and install a fresh DNN - then copy my files over the top (same version), and inject my database over the top? I have not yet tried this as i can only see it making a bigger mess.

I have read the moving DNN faq here, as well as others, and see no google results for my particular error (other than one on this forum that went unanswered)

Any ideas, help would be greatly appreciated, Charles

 
New Post
6/4/2009 5:33 AM
 

 if you transfer your site you shouldn't use export/import but backup and restore of the database, otherwise you might encounter additional problems (like intering ID values).


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...DNN 5 migration - error.DNN 5 migration - error.


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