Massive UPDATE 'article component' of galleys

Software Support
1

Hello.
OJS 3.1.X multijournal.

I need to do a massive UPDATE for change article component (genre) from SOURCETEXTS to SUBMISSION. Only for one journal in OJS multijournal.

Is that very difficult? Thanks

2

Hi @juanito,

This might be possible, but I think this change would have to be made in the database - I’m not sure what tables though. I will see if some of our other team members can advise on how to go about this.

Please note, however, that the version of OJS that you’re using is no longer supported by PKP. I recommend that you upgrade to the newest version of OJS, as it is possible that your issue will be resolved by upgrading. However, other community members may wish to offer assistance.

Upgrading instructions are available in the PKP Administrator’s Guide.

Information about the latest version of OJS can be found on the PKP Website

-Roger
PKP Team

3

Thanks, @rcgillis .

I did

UPDATE submission_files INNER JOIN submissions ON submissions.submission_id = submission_files.submission_id SET submission_files.genre_id=373 WHERE submissions.context_id=10 AND submission_files.genre_id=380;

But then, pdfs don’t load.

Thanks