DesktopModules Table SupportedFeatures Field

The supported Features of a DotNetNuke module relate to the 3 parameters:

• Portable
• Searchable
• Upgradeable

The features of a module are illustrated by editing a specific module, from the Host/Extensions page. Here they are shown as the three read only items

• Is Portable?
• is Searchable?
• Is Upgradable?

These three options are stored as the single field SupportedFeatures in the DesktopModules table.

A binary value is used to represent the summation of the three options. Summing the individual items gives the value stored.

IPortable = 1
ISearchable = 2
IUpgradable = 4

For example, for an item which is both Portable and Searchable the SupportedFeatures field will have the value 3.

Whilst the value is not editable from within the Host/Extensions page it can be changed by executing SQL. To do this navigate to the page Host/SQL.

To select all of the modules within the DesktopModules table  enter the following code in the Script textbox on the page and click on Run Script.

SELECT
  *
FROM
  DesktopModules

Scrolling down the list you can find the module which you are interested in.

Rather than listing all of the module again, either the DesktopModuleID or the FriendlyName fields can be used to filter the results.

To select a single row, given the DesktopModuleID

SELECT
  *
FROM
  DesktopModules
WHERE
  DesktopModuleID = 72

Change the value 72 according to the module to be edited.

To select a number of entries, perhaps from a single developer, or related to the same module package it may be better to select all at once, picking a common string from the Friendly Name. As an example the Catalook shop has modules prefaced by cat_

SELECT
  *
FROM
  DesktopModules
WHERE
  FriendlyName like '%cat_%'

To update the value of the SupportedFeatures value using the example from before, is settings it to 3.

UPDATE
  DesktopModules
SET
  SupportedFeatures = 3
WHERE
  DesktopModuleID = 72

DotNetNuke will ignore your changes to the database until the application is restarted. Navigate to the page Host/Host Settings , scroll to the bottom and click on Restart Application.