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