Thank you ALL for your help.

I ran my upgrade triggered from .../Install/Install.aspx?mode=upgrade and got the following report:

Current Assembly Version: 05.02.02
Current Database Version: 05.01.04



Upgrade Status Report
00:00:00.091 - Upgrading to Version: 05.02.02
00:00:00.140 - Executing Script: 05.02.00.SqlDataProvider Success
00:00:06.264 - Executing Script: 05.02.01.SqlDataProvider Success
00:00:06.681 - Executing Script: 05.02.02.SqlDataProvider Success
00:00:06.889 - Executing Application Upgrades: 05.02.00 Success
00:00:08.081 - Executing Application Upgrades: 05.02.01 Error!
00:00:08.293 - Executing Application Upgrades: 05.02.02 Success
00:00:08.295 - Cleaning Up Files: 05.02.00 Success
00:00:08.296 - Cleaning Up Files: 05.02.01 Success
00:00:08.297 - Cleaning Up Files: 05.02.02 Success
00:00:08.297 - Updating Config Files: 05.02.00 Success
00:00:08.335 - Updating Config Files: 05.02.01 Success
00:00:08.379 - Updating Config Files: 05.02.02 Success
00:00:08.379 - Performing General Upgrades
00:00:08.499 - Installing Optional Modules:
00:00:08.502 - Installing Package File HTML_Community_05.02.00_Install: Success
00:00:10.009 - Installing Optional Skins:
00:00:10.010 - Installing Optional Containers:
00:00:10.010 - Installing Optional Languages:
00:00:10.011 - Installing Optional Providers:
00:00:10.011 - Installing Package File AspNetMembershipProvider_05.02.00_Install: Success
00:00:10.140 - Installing Package File CorePermissionProvider_05.01.01_Install: Success
00:00:10.231 - Installing Package File DatabaseLoggingProvider_05.01.01_Install: Success
00:00:10.352 - Installing Package File DNNMembershipProvider_05.01.03_Install: Success
00:00:10.472 - Installing Package File DNNMenuNavigationProvider_05.01.00_Install: Success
00:00:10.642 - Installing Package File DNNTreeNavigationProvider_05.01.00_Install: Success
00:00:10.757 - Installing Package File FckHtmlEditorProvider_02.00.04_Install: Success
00:00:16.339 - Installing Package File FileBasedCachingProvider_05.01.03_Install: Success
00:00:16.599 - Installing Package File FileModuleCachingProvider_05.02.01_Install: Success
00:00:16.756 - Installing Package File MemoryModuleCachingProvider_05.02.01_Install: Success
00:00:16.938 - Installing Package File SchedulingProvider_05.02.01_Install: Success
00:00:17.079 - Installing Package File SearchIndexProvider_05.01.00_Install: Success
00:00:17.171 - Installing Package File SearchProvider_05.01.01_Install: Success
00:00:17.323 - Installing Package File SolpartMenuNavigationProvider_05.01.00_Install: Success
00:00:17.501 - Installing Optional AuthSystems:
00:00:17.501 - Installing Package File LiveID_01.00.01_Install: Success
00:00:17.709 - Installing Package File OpenID_02.00.00_Install: Success
00:00:18.014 - Installing Optional Packages:

Upgrade Complete



Click Here To Access Your Portal

Any  idea what to do with the Error  - yellow background ?

Chris

Chris - I suspect that you will find an empty 05.02.01.log file and if you look in your site's Event Viewer will find an error relating to an invalid database object named PortalLanguages. I also suspect that your database is using a non-blank objectQualifier string.  If so, . . .

The error is being caused by missing {databaseOwner}{objectQualifier} tokens in the 05.02.01.SqlDataProvider script's UpgradeDefaultLanguages stored proceedure which is only run during the upgrade then automatically deleted.

The statement

if  not exists(select * from PortalLanguages where PortalID=@PortalID)

should have been

if  not exists(select * from {databaseOwner}{objectQualifier}PortalLanguages where PortalID=@PortalID)

It is a known issue that had been reported in Gemini (DNN-11446) and shows a resolution of checked-in/duplicate but was not included in the 5.2.2 package nor does it (yet) appear on the roadmap for a potential 5.2.3 package. I have added a comment to this Gemini issue so that it does not get lost.

Provided that a default language has been assigned for each of your portals and you are not having problems saving Site Settings for any of your portals I think you can ignore this error.

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner