Error 500 Issue in Viewing Workflow

Hello

Using OJS 3.1.2.4. The website was working fine until the editor told me that he is getting HTTP ERROR 500 whenever he hits

  • New submission
  • Viewing workflow
  • Opening and clicking tasks

I tried to disable some plugins but didnt worked. Its a live website and this issue is causing a delay a lot. Please help

An error log is this

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli): SELECT sf., g.
FROM submission_galleys g

  		LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
  		LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
  		WHERE g.submission_id = 111
  			AND nsf.file_id IS NULL
  			
  		ORDER BY g.seq   

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

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli): SELECT i.*
FROM issues i INNER JOIN issue_settings ist ON i.issue_id = ist.issue_id
WHERE ist.setting_name = ‘pub-id::publisher-id’ AND ist.setting_value = ‘5’ ORDER BY i.issue_id

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli): SELECT i.* FROM issues i WHERE issue_id = 5

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

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli): SELECT g.*
FROM submission_galleys g
INNER JOIN submissions a ON a.submission_id = g.submission_id
LEFT JOIN published_submissions pa ON g.submission_id = pa.submission_id INNER JOIN submission_galley_settings gs ON g.galley_id = gs.galley_id
WHERE gs.setting_name = ‘pub-id::publisher-id’ AND gs.setting_value = ‘57’ AND g.submission_id = 111 ORDER BY a.context_id, pa.issue_id, g.galley_id

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli): SELECT sf., g.
FROM submission_galleys g

  		LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
  		LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
  	WHERE	g.galley_id = 57
  		AND nsf.file_id IS NULL  AND g.submission_id = 111   

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

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli):
SELECT iss.subscription_id
FROM institutional_subscriptions iss
JOIN subscriptions s ON (iss.subscription_id = s.subscription_id)
JOIN subscription_types st ON (s.type_id = st.type_id)
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, ‘.’)) IN UPPER(LPAD(‘crawl-66-249-79-83.googlebot.com’, LENGTH(‘crawl-66-249-79-83.googlebot.com’)+1, ‘.’))) != 0
AND iss.domain != ‘’
AND s.journal_id = 1
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND (‘2021-03-22 19:00:11’ >= s.date_start AND ‘2021-03-22 19:00:11’ <= s.date_end)))
AND (st.format = 1
OR st.format = 17)

[22-Mar-2021 19:00:11 UTC] PKP-Database-Logger 1616439610.8777:
(mysqli): SELECT isip.subscription_id
FROM institutional_subscription_ip isip
JOIN subscriptions s ON (isip.subscription_id = s.subscription_id)
JOIN subscription_types st ON (s.type_id = st.type_id)
WHERE ((isip.ip_end IS NOT NULL
AND ‘1123635027’ >= isip.ip_start AND ‘1123635027’ <= isip.ip_end
AND s.journal_id = 1
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND (‘2021-03-22 19:00:11’ >= s.date_start AND ‘2021-03-22 19:00:11’ <= s.date_end)))
AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND ‘1123635027’ = isip.ip_start
AND s.journal_id = 1
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND (‘2021-03-22 19:00:11’ >= s.date_start AND ‘2021-03-22 19:00:11’ <= s.date_end)))
AND (st.format = 1
OR st.format = 17)))

[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 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’

Hi @a2usmani, none of those error log entries indicate a 500 server response. We’d expect to see something like “Fatal Error” or “Exception”.

@NateWr Then what could be the issue? log sseems fine according to you

If you are receiving a 500 response from the server, then you are not looking at the right error log or the right log entries where this error is recorded.

@NateWr

Should i post the whole error log here?

Try to reproduce the error, for example by going to a page that doesn’t load, and then search the error log for entries that occurred around that time. Share the log entries that occurred at the time that the error occurred.

You should also disable or remove the PKP-Database-Logger items. These entries can contain sensitive information that should not be shared.