Short of installing SQL Server Management Studio, I found this : "sp_helptext 'xxxxx' " that will show the contents of named Stored Procedures.

The Stored Procedure: "CoreMessaging_CountNewThreads" had my typo error so I was able to correct.

Also, RemoveStringCharacters function was missing from the database (?) so had to create using this useful site for reference to DNN database objects, dependencies, and definitions: http://dotnetnukeru.com/dnn6docs/db...acters.htm

Check table definitions on this site as there seem to be errors of duplicating column names in some of the table definition TSQL code provided.

I didn't go through the whole list of Stored Procedures related to CoreMessaging, but there seems to be some missing eg. "CoreMessaging_CountArchivedMessagesByConversation" .

My site is working properly again for now (can add pages and set permissions), but do you think I am missing a DNN upgrade, or skipped an upgrade?

Thanks for your advice.

As far as SQL is concerned, there's no such thing as missing or skipping an upgrade. During the upgrade process, DotNetNuke checks to see which version of the data providers exist in the database and then applies all needed upgrades.

But, I'm glad that you got this working!

Thanks very much for your useful guidance Joe. I have a question to clarify further about the upgrading of DNN:

I understand your useful explanation about the SQL part of the upgrade ie. that all I need to do is install the latest upgrade. It will take care of what is necessary to install from previous upgrades. Great.

Does the same principle apply for the DNN system components? Right now I'm on Community version 06.02.02. So am I OK to install the latest 07.00.00 version ie. not install any upgrade number less than 07.00.00 before?

One problem I'm encountering is that when installing a zipped download of the upgrade files ( DotNetNuke_Community_07.00.00_Upgrade.zip ) it looks like the server is 'timing out' and I can't get it 'up there'. I'm using the 'Install Extensions Wizard' facility in the 'Extensions' Module. Many thanks for any advice.

Yes, you should be able to go from 6.2.2 to 7.0.0 in a single step.

As always ... MAKE A BACKUP BEFORE YOU START! You'll need to backup the database and the web directory.

As for upgrading, that cannot be done using the Install Extensions Wizard. That is because an upgrade is NOT an extension.

Here is the process:

1. BACKUP!
2. Download the Upgrade package.
3. Select the upgrade ZIP file, right-click, Properties, and click the Unblock button.
4. Unzip the upgrade package.

5. Now move the unzipped files -- all of them -- to the web directory, overwriting files.

6. Browse to your website. You should be guided through the upgrade process.

With a little good luck following you, that should be it!

Whoops. Thanks for that Joe. I've done those steps. All fine. But on the website I get the http://www.masharqi.com/Install/Upg...zard.aspx# page OK, but it doesn't do anything more (apparently) when I enter sign in details and hit the 'Upgrade Now' button "javascript:_doPostBack('continueLink',").

The 'Retry' and 'View Logs' buttons below are faded and inactive. Any way to determine what's hanging?

Thanks

Andre:

Your server does meet the requirements for DotNetNuke 7, correct? That means ASP.NET 4, Server 2008 and SQL Server 2008 as minimum requirements.

Also, you are entering a valid host username and password?

Are there any error messages?

Hi Joe, yes, yes, and yes re. the requirements

Valid userid and password: yes, definitely.

No error messages. Just 'nothing happens', incl. "view logs" button.

Hi Joe. I logged in to the host control panel for my account. Here's the last reference to UpgradeWizard.aspx in the latest log:

"2012-12-17 23:33:21 W3SVC494 PINE 174.122.105.131 GET /Install/UpgradeWizard.aspx - 80 - 91.236.74.121 HTTP/1.0 Opera/9.80+(Windows+NT+6.1;+U;+MRA+5.10+(build+5339);+ru)+Presto/2.10.289+Version/12.00 - http://www.masharqi.com/Install/Upg...izard.aspx www.masharqi.com 200 0 0 29313 494 4180
"

Can't find any reference to errors or warnings in this logfile. If any of this means anything to you welcome your comments.

Many thanks

If I go to http://www.masharqi.com/Install/Upg...zard.aspx, I see the upgrade wizard ready to go, and waiting for a host username and password.

If you fill in those credentials and click update, are you saying that nothing happens? (If I click without doing anything, I get error messages to fill in those items.)

Hi Joe. Yes, that's right. I get the same screen as you mentioned, but after entering my (correct) host userid and password, and clicking the 'Upgrade Now' button, nothing further happens.

I don't get any error message after entering the userid and password.

This is what I would do.

1. Restore your site to its working state, assuming that you have a backup.
2. Install a copy of the site locally and try the upgrade there. With it installed locally, you may be able to do some additional debugging.

Perhaps the first suggestion on this page might help.