I just performed an upgrade from 4.5 to 4.8.2. I did so by copying the full installation package over the existing installation, editing the web.config file and running the upgrade. Here is the text presented by the upgrade.

Upgrading DotNetNuke

Current Assembly Version: 04.08.02

Current Database Version: 04.05.05

 

Upgrade Status Report

00:00:00.031 - Upgrading to Version: 4.8.2
00:00:00.250 -   Executing Script: 04.06.00.SqlDataProvider Error! (see 04.06.00.log for more information)
00:00:02.218 -   Executing Script: 04.06.01.SqlDataProvider Error! (see 04.06.01.log for more information)
00:00:02.500 -   Executing Script: 04.06.02.SqlDataProvider Error! (see 04.06.02.log for more information)
00:00:02.828 -   Executing Script: 04.07.00.SqlDataProvider Error! (see 04.07.00.log for more information)
00:00:03.328 -   Executing Script: 04.08.00.SqlDataProvider Error! (see 04.08.00.log for more information)
00:00:07.031 -   Executing Script: 04.08.01.SqlDataProvider Error! (see 04.08.01.log for more information)
00:00:07.390 -   Executing Script: 04.08.02.SqlDataProvider Error! (see 04.08.02.log for more information)
00:00:07.750 - Performing General Upgrades
00:00:11.890 - Installing Module File Adsense_01.00.01_Install:  Success
00:00:18.843 - Installing Module File HTML_04.08.01_Install:  Success
00:00:23.703 - Installing Module File Links_03.03.07_Install:  Success
00:00:27.062 - Installing Module File MarketShare_01.00.00_Install:  Success
00:00:33.343 - Installing Package File LiveID_01.00.00_Install:  Success
00:00:34.140 - Installing Package File OpenID_01.00.00_Install:  Success

Upgrade Complete

I check the logs as I was instructed to do and there are 100's of messages like thus:

Cannot find the object 'GetSearchItemWord', because it does not exist or you do not have permission.

I know that I have the correct database user in the web.config file and that user has dbo.

Windows Server 2003, IIS, ASPNET 2.0.50727

I'm trying to determine if this is the expected behavior? Are these objects really not there or am I missing some database permissions? The site comes up, but some of the modules aren't working. From what I've read, this is not uncommon after an upgrade and that I may have to finess them into behaving? The  ultimate goal is to get this poor, neglected installation up to the lastest version with the least pain. Any help is appreciated.

 

 

In the web.config, the databaseOwner property is ASPNET. I don't think this will work. ;) I will change it to the proper user account. Now this begs the question, do I need to go back and perform the entire upgrade again? I have everything backed up and this is on a test instance, so no production servers were harmed in the making of this upgrade.

ok, I'm tapped out. I have made sure that the user that is the database owner is dbo, owns the schema and I am still getting the same error. Can you tell me what permissions on the database this user needs to have? I've done pretty much everything except make him sysadmin. Thanks, Carson