Article Copyright Settings & Reset Article Permissions

[ezeqd]

@asmecher Yes, i not searched very well in the forum… im gonna delete the post…

Anyway, I think I need the same solution but i only have access to database and files, there is a way to do this with db access or only on the admin area?

EDIT: i find a solution in this post License disappears after upgrade to 3.2.1 - #4 by IOPNdev

it seems ojs search a value ‘licenseUrl’ instead ‘licenseURL’

@thf

select * from publication_settings where setting_name like "%lic%" limit 3;
+----------------+--------+--------------+-----------------------------------------------+
| publication_id | locale | setting_name | setting_value                                 |
+----------------+--------+--------------+-----------------------------------------------+
|              1 |        | licenseURL   | http://creativecommons.org/licenses/by-sa/4.0 |
|              2 |        | licenseURL   | http://creativecommons.org/licenses/by-sa/4.0 |
|              4 |        | licenseURL   | http://creativecommons.org/licenses/by-sa/4.0 |
+----------------+--------+--------------+-----------------------------------------------+

so i do the next

@IOPNdev

START TRANSACTION;
UPDATE publication_settings SET setting_name = 'licenseUrl' WHERE setting_name = 'licenseURL';
#check to make sure everything looks right
COMMIT;

And the magic appears. Thanks and sorry for trouble