Live Fields Not Migrating from Version RC04

If any of the pre-release versions of 5.8.0 were installed it is possible that some Live Fields configurations were not migrated over properly. Specifically, this bug appears in PowerScripts 5.8.0.0 RC04 / SIL Engine 5.8.0.0 RC4 when the Live Fields engine has been moved to the SIL Engine, making it available to all the addons, which will not require anymore Power Scripts to manipulate UI fields. The bug was fixed in the general release version but since the upgrade task has been executed, it will not migrate again the configurations. If your Live Fields were not migrated and you have a prior RC04 installation, the following trick will force re-execution of the upgrade task.

1. Uninstall Power Scripts and the SIL Engine

2. Shut down Jira (recommended). We also recommend a backup. Any modification of the database should be done while Jira is offline

3. Run the following SQL to check if the result of the next query over Jira's database is returning propertyvalue > 0
   
   

   SELECT * from PROPERTYSTRING where ID = (SELECT ID FROM PROPERTYENTRY WHERE PROPERTY_KEY = 'com.keplerrominfo.jira.plugins.commons:build')

    

4. If the propertyvalue > 0 (it should be >= 5800), then it needs to be reset to 0. Run the following SQL to reset the propertyvalue
   
   

   UPDATE PROPERTYSTRING SET PROPERTYVALUE = '0' where ID = (SELECT ID FROM PROPERTYENTRY WHERE PROPERTY_KEY = 'com.keplerrominfo.jira.plugins.commons:build')

    

5. (optional) Re-execute the first query just to make sure that the value is set to 0
   
   

   SELECT * from PROPERTYSTRING where ID = (SELECT ID FROM PROPERTYENTRY WHERE PROPERTY_KEY = 'com.keplerrominfo.jira.plugins.commons:build')

    

6. Start Jira and reinstall Power Scripts (SIL Engine will be installed automatically)

7. Check to make sure all other add-ons that may be using the SIL Engine are enabled