Missing CC License badge after upgrading from 3.1 to 3.3

Software Support
, ,
1

Description of issue or problem I’m having:
Our licenses doesn’t show up in the healthSciences theme for individual articles.

Steps I took leading up to the issue:

We’ve updated from 3.1 to 3.3

What I tried to resolve the issue:
We’ve debugged in pages/article/ArticleHandler.inc.php in particular for

   $templateMgr->assign([
                        'ccLicenseBadge' => Application::get()->getCCLicenseBadge($publication->getData('licenseUrl')),
                        'publication' => $publication,
                        'section' => $sectionDao->getById($publication->getData('sectionId')),

$publication->getData('licenseUrl') always returns no value. If I change ArticleHandler.php.inc to use $context->getData('licenseUrl')
the badge appears. This looks like $context points to the submission table. Should we also have licenses in the publication_settings after the upgrade?

Application Version - e.g., OJS 3.1.2:
3.3 stable

Additional information, such as screenshots and error log messages if applicable:
We have the current results from database queries related to licenseUrl

SELECT * FROM submission_settings WHERE setting_name ='licenseUrl';
submission_id | locale | setting_name |                   setting_value
---------------+--------+--------------+---------------------------------------------------
          1256 |        | licenseUrl   | http://creativecommons.org/licenses/by/3.0
          1517 |        | licenseUrl   | http://creativecommons.org/licenses/by/3.0/
...

SELECT * FROM publication_settings WHERE setting_name ='licenseUrl' or setting_name='licenseURL';
 publication_id | locale | setting_name | setting_value
----------------+--------+--------------+---------------
(0 rows)

 journal_id | locale | setting_name |                   setting_value                   | setting_type
------------+--------+--------------+---------------------------------------------------+--------------
         37 |        | licenseUrl   | http://creativecommons.org/licenses/by/4.0        | string
         29 |        | licenseUrl   | https://creativecommons.org/licenses/by/4.0       | string
 ...

Thanks for any help!

2

This was fixed by updating the licenseURL → licenseUrl in the submission_settings table prior to running the upgrade. I thought I had added the sql update to our upgrade script, but had somehow not added the query.

UPDATE submission_settings SET setting_name='licenseUrl' WHERE setting_name='licenseURL';

seems to do the trick.