Upgrade Issue - Missing Applications

Bartec Support asked on September 3, 2014 22:17

We've got several Kentico websites. Recently we upgraded the websites from V4.1 to V8.

Most functionality is working really well in V8, but we have an issue with a couple of missing applications. Compared to the standard V8 Kentico installation our upgraded websites are missing the "UI personalization" and "Widgets" applications. They aren't visible on the dashboard, and they don't appear within the applications list.

Checking the database I can see the following tables: CMS_Personalization CMS_Widget CMS_WidgetCategory CMS_WidgetRole

In the CMS_UIElement table I can also see a record for "Development.Widgets" and two records for "UIPersonalization".

As we had several live websites to upgrade we attempted to streamline the upgrade process as much as possible. We did the following:

Upgrade the website code files from V4.1 to V7.
Run the following SQL upgrade scripts against the database: - V4.1 to V5. - V5 to V5.5. - V5.5 to V5.5R2. - V5.5R2 to V6. - V6 to V7.
Run the website at V7 (we needed to do this to avoid later errors in the upgrade process).
Upgrade the website code files from V7 to V8.
Run the V7 to V8 SQL upgrade script against the database.

From reading various forum posts I now see we should have run the site at every upgrade point.

Is there a way to fix this issue by running a SQL script or modifying table data? We now have a number of upgraded live websites that have passed testing, and we don't have the time or resources to re-do the upgrades.

Regards, Dave

upgrade upgrade kentico 8 upgraded installation

Correct Answer

Brenden Kehren answered on September 4, 2014 04:30

Have you looked in the Modules application to see if they do exist? If so, it may be that the users may not be assigned to roles that have permissions to those modules.

Another option might be to create a fresh install of v8 and export those modules and import them into your other sites. You'll want to check to see if your live site(s) have the code files already but it won't hurt to export them and import them either.

2 votesVote for this answer Unmark Correct answer

Recent Answers

Joshua Adams answered on September 4, 2014 15:09

After every upgrade that you do, I think you are supposed to run the site. So after upgrading from 4-5, run it, 5-6, run it, etc. I have had issues with this in the past. If you don't mind doing the upgrade again, then you could always do that, or you could do what Brenden suggested, which could save you a lot of time.

0 votesVote for this answer Mark as a Correct answer

Bartec Support answered on September 4, 2014 16:22

I’ve checked the following Modules: Modules -> UI personalization Modules -> Widgets They both appear, and have the website listed under the Sites section.

I'll try the import/export function.

Thanks.

0 votesVote for this answer Mark as a Correct answer

Bartec Support answered on September 5, 2014 14:28

I've tried the export/import from a fresh install of v8 as recommended and it now has the "UI personalization" and "Widget" applications working correctly :)

One final issue remaining - when adding widgets they don't display icons. To try and fix this I exported Development -> Widgets from the fresh install of v8 and tried importing them to my site. On import I was given the following error:

Error importing 'Widget categories' objects (Banner management)

Query: 
UPDATE CMS_WidgetCategory SET [WidgetCategoryName] = @WidgetCategoryName, [WidgetCategoryDisplayName] = @WidgetCategoryDisplayName, [WidgetCategoryParentID] = @WidgetCategoryParentID, [WidgetCategoryPath] = @WidgetCategoryPath, [WidgetCategoryLevel] = @WidgetCategoryLevel, [WidgetCategoryOrder] = @WidgetCategoryOrder, [WidgetCategoryChildCount] = @WidgetCategoryChildCount, [WidgetCategoryWidgetChildCount] = @WidgetCategoryWidgetChildCount, [WidgetCategoryImagePath] = @WidgetCategoryImagePath, [WidgetCategoryGUID] = @WidgetCategoryGUID, [WidgetCategoryLastModified] = @WidgetCategoryLastModified WHERE [WidgetCategoryID] = @WidgetCategoryID

Caused exception: 
Invalid column name 'WidgetCategoryOrder'.

Is there a way to fix this?

Many thanks for your help.

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on September 6, 2014 07:27

There is a good chance there is some missing info in the export or your current site. Is your fresh install hotfixed up to the site you're importing the items into? If not, do so, then export out of the fresh site and import into your site.

0 votesVote for this answer Mark as a Correct answer

Bartec Support answered on September 6, 2014 12:09

Yes I've applied the same hotfix to the fresh install.

I managed to get this import working by adding the WidgetCategoryOrder (int) column to the CMS_WidgetCategory table. From looking back on the Kentico SQL upgrade scripts I can see that WidgetCategoryOrder used to be a column on that table, but was removed between version 7 and 8. There must still be a reference to this column somewhere (although without knowing the internal workings of the export/import process I'm not sure where).

The widgets have successfully imported, although the icons are still missing (looking in CMS_Widget, the WidgetIconClass field is NULL for each record). I'm guessing this is related to the same problem (the export/import process isn't aware of the new columns, so doesn't import that data).

0 votesVote for this answer Mark as a Correct answer

Bartec Support answered on September 7, 2014 21:37

I’ve managed to resolve the icon issue – I updated all WidgetIconClass values directly in the database from the default Kentico 8 database (matching on the WidgetName column). After a restart they are successfully showing :)

I’m still slightly concerned with regards to the export/import not fully working – other widget values may still be outdated?

0 votesVote for this answer Mark as a Correct answer