Column not found: 1054 Unknown column 'overwrite_download_perm' in 'field list' when adding new publications

[rfcmaXi]

Describe the bug If you try to add a new publication via the plugin options, the error appears.

To Reproduce Plugin-Settings -> Publications -> Add -> Make some entries and and save

Expected behavior The inputs should be saved ;)

Log PDOException thrown with message "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'overwrite_download_perm' in 'field list'"

Stacktrace:

19 PDOException in /srv/www/ilias/Services/Database/classes/PDO/class.ilDBPdo.php:451

18 PDO:exec in /srv/www/ilias/Services/Database/classes/PDO/class.ilDBPdo.php:451

17 ilDBPdo:insert in /srv/www/ilias/Services/ActiveRecord/Connector/class.arConnectorDB.php:183

16 arConnectorDB:create in /srv/www/ilias/Services/ActiveRecord/class.ActiveRecord.php:332

15 ActiveRecord:create in /srv/www/ilias/Customizing/global/plugins/Services/Repository/RepositoryObject/OpenCast/classes/Conf/PublicationUsage/class.xoctPublicationUsageFormGUI.php:256

14 xoctPublicationUsageFormGUI:saveObject in /srv/www/ilias/Customizing/global/plugins/Services/Repository/RepositoryObject/OpenCast/classes/Conf/PublicationUsage/class.xoctPublicationUsageGUI.php:229

13 xoctPublicationUsageGUI:update in /srv/www/ilias/Customizing/global/plugins/Services/Repository/RepositoryObject/OpenCast/classes/class.xoctGUI.php:74

12 xoctGUI:performCommand in /srv/www/ilias/Customizing/global/plugins/Services/Repository/RepositoryObject/OpenCast/classes/class.xoctGUI.php:68

11 xoctGUI:executeCommand in /srv/www/ilias/Services/UICore/classes/class.ilCtrl.php:203

10 ilCtrl:forwardCommand in /srv/www/ilias/Customizing/global/plugins/Services/Repository/RepositoryObject/OpenCast/classes/class.xoctMainGUI.php:114

9 xoctMainGUI:executeCommand in /srv/www/ilias/Services/UICore/classes/class.ilCtrl.php:203

8 ilCtrl:forwardCommand in /srv/www/ilias/Customizing/global/plugins/Services/Repository/RepositoryObject/OpenCast/classes/class.ilOpenCastConfigGUI.php:75

7 ilOpenCastConfigGUI:executeCommand in /srv/www/ilias/Services/UICore/classes/class.ilCtrl.php:203

6 ilCtrl:forwardCommand in /srv/www/ilias/Services/Component/classes/Settings/class.ilObjComponentSettingsGUI.php:162

5 ilObjComponentSettingsGUI:forwardConfigGUI in /srv/www/ilias/Services/Component/classes/Settings/class.ilObjComponentSettingsGUI.php:119

4 ilObjComponentSettingsGUI:executeCommand in /srv/www/ilias/Services/UICore/classes/class.ilCtrl.php:203

3 ilCtrl:forwardCommand in /srv/www/ilias/Services/Administration/classes/class.ilAdministrationGUI.php:237

2 ilAdministrationGUI:executeCommand in /srv/www/ilias/Services/UICore/classes/class.ilCtrl.php:203

1 ilCtrl:forwardCommand in /srv/www/ilias/Services/UICore/classes/class.ilCtrl.php:178

0 ilCtrl:callBaseClass in /srv/www/ilias/ilias.php:24

Environment (please complete the following information):

• ILIAS version: v8.13
• PHP version: PHP 8.0.30
• Plugin version: v8.1.1
• Opencast version 14.6
• Browser: Firefox

[rfcmaXi]

Note: You can also simply edit an existing publication to throw the error.

An undefined database exception occurred. SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘overwrite_download_perm’ in ‘field list’ QUERY: UPDATE xoct_publication_usage SET usage_id = ‘download’, title = ‘Download Links’, display_name = ‘’, description = ‘Download links of processed videos in different resolutions for download button. ', group_id = NULL, channel = “api”, status = NULL, search_key = “tag”, flavour = “/delivery”, tag = “engage-download”, md_type = 2, allow_multiple = 1, mediatype = “”, overwrite_download_perm = 0, ext_dl_source = 1 WHERE usage_id = “download”

[ferishili]

This is because you went to the latest version without updating your plugin via CLI. To fix this you would need to perform update of the plugin via CLI from yout ILIAS root dir! e.g. (not sure if the command is correct) php setup/setup.php update --config=[the path to the conifg] --plugin=OpenCast

You would need to refer to the ILIAS docs for the update command!

[rfcmaXi]

Thank you for the relevant information!!! The need to run the CLI with DB steps for plugin changes is a bit surprising. However, I now understand where the approach or the necessity comes from and also that OC is the first plugin, of that we have in use, which makes use of the new modular option.

In this respect, I would at least like to give the hint to mention this in the readme :)

[ferishili]

I've tried to explain it here in Wiki but seems to be not enough!

[chfsx]

I'm thinking about whether we want to make the installation/update "cli only". e.g. check in the beforeInstall and beforeUpdate method whether PHP_SAPI === 'cli', and if not, issue an error message and point to the installation process on how to install or update the plugin.