All is working except for the Submission and Workflow

Software Support
1

Hello

I have a live website and it was working fine until the workflow is getting error 500 and it’s causing problems for me.

Please help urgently someone since the website is live. PHP log is here

[22-Mar-2021 19:24:05 UTC] ojs2: 404 Not Found
[22-Mar-2021 19:24:21 UTC] ojs2: 404 Not Found
[22-Mar-2021 19:55:42 UTC] ojs2: 404 Not Found
[22-Mar-2021 20:16:04 UTC] ojs2: 404 Not Found
[23-Mar-2021 04:47:45 UTC] ojs2: 404 Not Found
[23-Mar-2021 06:19:35 UTC] ojs2: 404 Not Found
[23-Mar-2021 06:24:47 UTC] ojs2: 404 Not Found
[23-Mar-2021 06:26:36 UTC] ojs2: 404 Not Found
[23-Mar-2021 06:52:41 UTC] ojs2: 404 Not Found
[23-Mar-2021 06:56:16 UTC] ojs2: 404 Not Found
[23-Mar-2021 07:47:54 UTC] ojs2: 404 Not Found

2

Hello @a2usmani,

Could you please tell us the version of OJS that you are using? Additionally, is this a fresh install or an upgrade?

3

@EmmaU

I am using OJS 3.1.2.4 . Actually I tried to upgrade via softaculous in cpanel then the website didn’t worked. I asked the hosting provider to revert it back. After that we didn’t checked the workflow for a month. 3 days back my editor checked this and told me. That everything is working fine except for the workflow.

4

Dear @EmmaU

The problem isnt solved yet. Actually many articles have been submitted and we cant access the workflow and we are stuck. Please help

5

HI @a2usmani, I’m sorry to hear about the upgrade. Unfortunately, we don’t support upgrades through softaculous and they are a common source of problems. We always recommend performing an upgrade on a test instance and testing it thoroughly before trying to upgrade a live instance.

At this point, I think you’ll need to enlist the services of technical support at your host or institutional provider. The error log that you provided does not show any 500 errors.

6

@NateWr

Please see the log below. When I Open an article in Queue it gives ojs2: 404 Not found
What is the log before that. Does that helps and I didn’t upgraded. I tried to did that but reverted

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli): SELECT * FROM submission_file_settings WHERE file_id = ‘184’

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli): SELECT DISTINCT
sf.file_id AS submission_file_id, sf.revision AS submission_revision,
af.file_id AS artwork_file_id, af.revision AS artwork_revision,
suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision,
s.locale AS submission_locale,
sf., af., suf.*
FROM submission_files sf
LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision
LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision
LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision
WHERE sf2.revision IS NULL AND sf.file_id = 184 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli): SELECT * FROM submission_file_settings WHERE file_id = ‘184’

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli): SELECT DISTINCT
sf.file_id AS submission_file_id, sf.revision AS submission_revision,
af.file_id AS artwork_file_id, af.revision AS artwork_revision,
suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision,
s.locale AS submission_locale,
sf., af., suf.*
FROM submission_files sf
LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision
LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision
LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision
WHERE sf2.revision IS NULL AND sf.file_id = 184 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli): SELECT * FROM submission_file_settings WHERE file_id = ‘184’

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli): SELECT s., ps., s.submission_id AS submission_id,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM submissions s
LEFT JOIN published_submissions ps ON (s.submission_id = ps.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = ‘title’ AND stpl.locale = ‘en_US’)
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = ‘title’ AND stl.locale = ‘en_US’)
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = ‘abbrev’ AND sapl.locale = ‘en_US’)
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = ‘abbrev’ AND sal.locale = ‘en_US’)
WHERE s.submission_id = 111

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli): SELECT * FROM submission_settings WHERE submission_id = ‘111’

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli): SELECT * FROM genres WHERE genre_id = 1 ORDER BY seq

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli): SELECT * FROM genre_settings WHERE genre_id = ‘1’

[22-Mar-2021 19:24:05 UTC] ojs2: 404 Not Found
[22-Mar-2021 19:24:21 UTC] ojs2: 404 Not Found
[22-Mar-2021 19:55:42 UTC] ojs2: 404 Not Found
[22-Mar-2021 20:16:04 UTC] ojs2: 404 Not Found
[23-Mar-2021 04:47:45 UTC] ojs2: 404 Not Found
[23-Mar-2021 06:19:35 UTC] ojs2: 404 Not Found
[23-Mar-2021 06:24:47 UTC] ojs2: 404 Not Found
[23-Mar-2021 06:26:36 UTC] ojs2: 404 Not Found
[23-Mar-2021 06:52:41 UTC] ojs2: 404 Not Found
[23-Mar-2021 06:56:16 UTC] ojs2: 404 Not Found
[23-Mar-2021 07:47:54 UTC] ojs2: 404 Not Found
[23-Mar-2021 17:07:12 UTC] ojs2: 404 Not Found
[23-Mar-2021 17:18:08 UTC] ojs2: 404 Not Found
[23-Mar-2021 18:24:57 UTC] ojs2: 404 Not Found
[23-Mar-2021 18:34:15 UTC] ojs2: 404 Not Found
[23-Mar-2021 19:05:59 UTC] ojs2: 404 Not Found
[23-Mar-2021 19:16:25 UTC] ojs2: 404 Not Found
[23-Mar-2021 19:40:32 UTC] ojs2: 404 Not Found
[24-Mar-2021 05:08:38 UTC] ojs2: 404 Not Found
[24-Mar-2021 13:17:22 UTC] ojs2: 404 Not Found
[24-Mar-2021 13:17:49 UTC] ojs2: 404 Not Found
[24-Mar-2021 13:19:20 UTC] ojs2: 404 Not Found
[24-Mar-2021 13:33:46 UTC] ojs2: 404 Not Found
[24-Mar-2021 18:37:26 UTC] ojs2: 404 Not Found