Hi,
I am upgrading a journal from OJS 2.3.7 to 3.0.1. I do this in two stages, first from 2.3.7 to 2.4.8 and then to 3.0.1. Both steps finish without errors or warnings, but I have a problem that occurs in the second upgrade: If I click on any submission, under 3.0.1 I get “no items” everywhere under “Submission files”, “Review files”, etc. (in 2.4.8 everything is still ok, as far as I can tell). Something seems to have gone wrong with the remapping of file stages in the upgrade. Below is an example from the database
After upgrading to 2.4.8
> select * from article_files where article_id=3439;
file_id | revision | source_file_id | source_revision | article_id | file_name | file_type | file_size | original_file_name | file_stage | viewable | date_uploaded | date_modified | round | assoc_id
--------+----------+----------------+-----------------+------------+--------------------+-----------+-----------+--------------------+------------+----------+---------------------+---------------------+-------+----------
8427 | 2 | | | 3439 | 3439-8427-2-SM.rtf | text/rtf | 40408 | uk01.rtf | 1 | | 2016-12-25 17:41:38 | 2016-12-25 17:41:38 | 1 |
8428 | 1 | 8427 | | 3439 | 3439-8428-1-RV.rtf | text/rtf | 40408 | 3439-8427-2-SM.rtf | 2 | | 2016-12-25 17:42:46 | 2016-12-25 17:42:46 | 1 |
(2 rows)
The corresponding files have the locations journals/1/articles/3439/submission/original/3439-8427-2-SM.rtf
journals/1/articles/3439/submission/review/3439-8428-1-RV.rtf
, i.e. as far as I can tell everything is correct.
After upgrading to 3.0.1
> select * from submission_files where submission_id=3439;
file_id | revision | source_file_id | source_revision | submission_id | file_type | file_size | original_file_name | file_stage | viewable | date_uploaded | date_modified | assoc_id | genre_id | direct_sales_price | sales_type | user_group_id | uploader_user_id | assoc_type
---------+----------+----------------+-----------------+---------------+-----------+-----------+--------------------+------------+----------+---------------------+---------------------+----------+----------+--------------------+------------+---------------+------------------+------------
8427 | 2 | | | 3439 | text/rtf | 40408 | uk01.rtf | 7 | 0 | 2016-12-25 17:41:38 | 2016-12-25 17:41:38 | 703 | 1 | | | 2 | 1 | 521
8428 | 1 | 8427 | | 3439 | text/rtf | 40408 | 3439-8427-2-SM.rtf | 7 | 0 | 2016-12-25 17:42:46 | 2016-12-25 17:42:46 | 703 | 1 | | | 2 | 1 | 521
(2 rows)
And the corresponding files are located at journals/1/articles/3439/submission/fairCopy/3439-1-8428-1-7-20161225.rtf
and journals/1/articles/3439/submission/fairCopy/3439-1-8427-2-7-20161225.rtf
SUBMISSION_FILE_FAIR_COPY
is defined as 7, so the database entries seem to match the files, and the files have been moved properly (i.e. no permissions issues), but they should in this case be at stage SUBMISSION_FILE_ORIGINAL
, i.e. 2, right?
Everything works when I submit new files.
We use a postgres database, in case it matters.
best regards,
Simon Mitternacht