Hi @juancure,
OK, from what I see, I think you will not have to do any changes in submission_galleys and submission_galley_settings tables. You have the entries for those 15 files in the table submission_galleys, correct?
In that case the table submission_files will also contain the correct values for assoc_type (521) and assoc_id (the appropriate galley_id) for those 15 files, correct?
If so, then you would only need to:
– change the genre_id (to e.g. 1) in the table submission_files.
(I cannot see what is the genre_id for the genre OTHER in your table genres. And I do not know/understand what are those other genres (with no entry_key) – a custom ones? Thus, please check what is the correct genre_id that you should use – e.g. what genre_id have the other, correct galleys)
– rename the file in the files folder. You will find the files in the subfolder journals//articles//submission/proof/. The file name is generated like this: pkp-lib/SubmissionFile.inc.php at omp-3_1_1-4 · pkp/pkp-lib · GitHub. Thus, it is submissionId-genreId-fileId… You would only need to change the genreId part (to e.g. 1).
– check now that everything is OK, that you can download the galley via UI as editor and that you can see it as reader on the article view page.
– remove all setting_names except the setting_name = ‘name’ from the table submission_file_settings for those 15 files.
– remove the entry from the submission_supplementary_files.
Do this file-by-file and be sure/double check that everything is correct with one file before you proceed with the other file.
Best,
Bozana