Important Note On Upgrading to Subtext 1.9

Let me start off by noting that Subtext 1.9 requires ASP.NET 2.0!  Thus the upgrade process from a prior version of Subtext (all which run on ASP.NET 1.1) will not be quite as simple as before, but should hopefully not be overly complicated as is the spirit of Subtext.

For Users Who Have Control Of Their Hosting Server

Users who host on their own server, or have Remote Desktop access to their hosting server will have an easier time with the upgrade.  My recommendation is to simply setup a new folder with the new version of Subtext, copy in your modifications, and then switch IIS over to ASP.NET 2.0 to point to the new directory.  The following is a step-by-step detailed procedure.

  1. Backup your Database. This should go without saying.
  2. While you are in Enterprise Manager, make sure the database user that your blog uses to access the database has DBO permissions temporarily.  This is required so that the web-based upgrade procedure will work.
  3. Make sure you can login to the HostAdmin section.  On most blogs this would be the /HostAdmin/ directory of the site. For example, on my blog the HostAdmin is located at http://haacked.com/HostAdmin/.  If you forget your HostAdmin password, there is a query you can run in Query Analyzer to reset your password at the bottom of this page.
  4. Download and unzip the Subtext 1.9 binaries into a new directory parallel to your current installation.  For example, on my server I host my blog in the d:\Websites\Haacked.com\ directory.  When upgrading to Subtext 1.9, I unzipped the distribution to the following path d:\Websites\Haacked.com.1.9\.
  5. Merge any customizations from your old web.config file into the new web.config file.  Be sure to note that some settings have moved. For example, the connection string has been moved into the <ConnectionStrings> section.  Also take a look at any new settings you may be interested in.
  6. Copy all your images, videos, audio files and any other non-Subtext files and customizations into the appropriate place in the new directory. For example, I copied the images folder as well as my own Demos folder which contained some demo code on my site into the Haacked.com.1.9 folder.
  7. Now in IIS Manager, configure your existing site to use ASP.NET 2.0 and point it to your new directory.  For details, see the section at the bottom of this post.  You may need to change the Application Pool your site runs in if you are running Windows 2003.
  8. Visit your website and follow the instructions.  At this point, the normal web-based upgrade wizard should kick in, asking you to login to the HostAdmin tool and click the upgrade button.  This will upgrade your database schema and stored procedures.
  9. Make sure to reverse the change you made in step 2!  Subtext does not require DBO permissions for normal operations. The user that Subtext uses to connect to your database should just be in the public group.

For Users With Hosted Solutions Such as WebHost4Life

Unfortunately I am not familiar with the procedure that the various hosting providers use to upgrade a site from ASP.NET 1.1 to ASP.NET 2.0.  If the upgrade happens on the same machine that your site is currently hosted in, the upgrade may bring down your site for a short bit.  You may have to coordinate the above steps with a technician at your hosting company, except for the following changes.

  • Step 4: Download and unzip the Subtext 1.9 binaries to your local machine.
  • Step 6: Have your hosting support technician upgrade your site to ASP.NET 2.0
  • Step 7:  Copy your local files over to your hosting provider.

Configuring IIS for ASP.NET 2.0

To configure a website in IIS for ASP.NET 2.0, right click on the website in the IIS Manager tool and select properties. Click on the ASP.NET tab in the dialog box. It should look something like this...

ASP.NET Version Dialog

Makes sure to select 2.0.50727 in the ASP.NET version dropdown.

On Windows 2003, I created a separate Application Pool for my ASP.NET 2.0 websites.  To select the Application Pool for a website, cilck on the Virtual Directory tab and select the Application Pool in the dropdown at the bottom of the dialog as in the following screenshot.

App Pool Dialog

Good luck and smooth sailing!

What others have said

Requesting Gravatar... Wyatt Barnett Aug 31, 2006 9:12 AM
# re: Important Note On Upgrading to Subtext 1.9
Protip: Add an app_offline.htm file to your site before the host upgrades it. Once upgraded to 2.0, this file will be displayed until you get things in place and delete it, allowing one to have at least a friendly error message rather than the yellow screen of death.
Requesting Gravatar... haacked Aug 31, 2006 11:38 AM
# re: Important Note On Upgrading to Subtext 1.9
Wyatt, but that would stop anyone from hitting the site, right? We actually stop all requests when an upgrade is in progress and present users the message that an upgrade is in progress.
Requesting Gravatar... haacked Aug 31, 2006 11:39 AM
# re: Important Note On Upgrading to Subtext 1.9
Let me clarify. For Subtext users with hosted blogs, they can't necessarily get on the local machine. In order to run the web-based upgrade, they need to be able to access the site.
Requesting Gravatar... Wyatt Barnett Aug 31, 2006 11:54 AM
# re: Important Note On Upgrading to Subtext 1.9
Doh, forgot about that angle. You should definiely delete that file once the upgrade is underway.

I was really speaking to the "while your site is in the host's queue waiting to get upgraded to 2.0 phase so it does not blow up once they make the switch and fail to tell you about it."
Requesting Gravatar... Braden Sep 14, 2006 9:58 AM
# re: Important Note On Upgrading to Subtext 1.9
I cannot get the upgrade to work. It asks me for the site admin username and password, which does not work. I performed the password reset via SQL query analyzer and it still does not work. I am confident that I know what the username and password are, but they just do not work when I attempt to perform the upgrade to 1.9. Any suggestions?

Also, since I am stuck using the previous version of subtext for now, I am getting spam via my comments in older blog entries, even though comments are disabled after 5 days. Weird.
Requesting Gravatar... Paul Edwards Sep 30, 2006 10:46 AM
# re: Important Note On Upgrading to Subtext 1.9
Just done my upgrade...worked like a dream...

Thanks Phil...
Requesting Gravatar... Haacked Sep 30, 2006 3:02 PM
# re: Important Note On Upgrading to Subtext 1.9
w00t!
Requesting Gravatar... you've been HAACKED Oct 25, 2006 10:09 PM
# Subtext 1.9.2
Subtext 1.9.2
Requesting Gravatar... you've been HAACKED Oct 25, 2006 10:27 PM
# Essential Subtext 1.9.2 Crib Notes
Essential Subtext 1.9.2 Crib Notes
Requesting Gravatar... JRB Technology Oct 28, 2006 2:27 PM
# Important Note On Upgrading to Subtext 1.9
Don&amp;#8217;t you hate the fact the Microsoft nearly forced you to use their database system when creating database driven applications? They want you to use the Microsoft SQL Server Desktop Engine when making even the most basic applications. MSDE is a hog, and I&amp;#8217;ll never use it in my applications, especially now that I have [...]
Requesting Gravatar... scott willeke Jan 07, 2010 11:55 AM
# re: Important Note On Upgrading to Subtext 1.9
Since the links are now broken, what is the query that we can run in query analyzer to see the hostadmin password?

What do you have to say?

(will show your gravatar)
Please add 4 and 3 and type the answer here: