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

HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...An unhandled error has occurred.An unhandled error has occurred.
Previous
 
Next
New Post
2/3/2012 2:54 PM
 

How do I edit the database file?  Been years since I touch SQL.  I have tried to open the file with SQL Server Management Express.  No luck

Thank you,

Dale Graham

 
New Post
2/3/2012 3:09 PM
Accepted Answer 

Hi Dave,

You need to stop the website on IIS, stop the application pool associated with that site also on iis. Then the DB file will become read by SQL Server Manager. 

You need to then 'Attach' the database rather than attempt to open it directly. So you open SQL svr Manager connect, then open the folder called Databases and highlight it - right click and select attach - then click add (assuming your using 2008 version) then navigate to it.

Once you have it attached expand the database, and expand Tables, in there you will find dbo.version - right click and select 'Edit top 200 rows' then you will see the columns/rows - delete the one that has 6.1.3.

Close the open row, right click the top of the attached database, select tasks and detach, in the next window tick 'drop' and click OK.

You will have to then reset permissions in windows as editing the database in this way often resets permissions to just administrator. once done - start the iis website, then start the app pool.

then run the upgrade again by typing YOURDOMAIN.COM/install/install.aspx?mode=upgrade

This should work fine - it worked for me once I reset the permissions on all subfolders.

 Cheers,

Andre

 
New Post
2/3/2012 6:04 PM
 

All Sites Back Online!  THANK YOU for excellent step by step directions.

Dale Graham

 
New Post
2/3/2012 6:09 PM
 
it depends on the format of your connection string, whether you need to attach the SQL database or not. If you are accessing DNN database in SQL server express user instance mode, you CANNOT have the database attached, when running the database.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
2/3/2012 6:29 PM
 
Glad it helped Dale and sorry for mispelling your name in my last post.
Have a great weekend buddy. :-)
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...An unhandled error has occurred.An unhandled error has occurred.


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