Article Copyright Settings & Reset Article Permissions

[asmecher]

Hi @athmsiforum,

OJS doesn’t automatically stamp the PDF with the copyright etc.; that’s up to the tool you use to generate your PDFs.

Regards,
Alec Smecher
Public Knowledge Project Team

[athmsiforum]

Thanks, Alec.We will create it manually.

[ezeqd]

Hi @asmecher there is a way to edit some field in database for show license?

[asmecher]

Hi @ezeqd,

This is related to your other post, correct? Someone will respond over there; it’s best not to post about the same issue in several places, as it clutters the forum.

Regards,
Alec Smecher
Public Knowledge Project Team

[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