Hello @asmecher and @israel.cefrin
I turned on the database debug trying to have a clue on the issue. But for me is like reading greek:
(mysql): SELECT * FROM sessions WHERE session_id = 'h4vduedto2at047ou8shqiqae7'
(mysql): SELECT * FROM users WHERE user_id = 15
(mysql): SELECT * FROM user_settings WHERE user_id = '15'
Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/dpgpsifp/psicodebate.dpgpsifpm.com.br/lib/pkp/lib/adodb/adodb.inc.php:519) in /home/dpgpsifp/psicodebate.dpgpsifpm.com.br/lib/pkp/classes/session/SessionManager.inc.php on line 59
(mysql): DELETE FROM sessions WHERE (last_used < 1509814476 AND remember = 0) OR (last_used < 1507308876 AND remember = 1)
Warning: Cannot modify header information - headers already sent by (output started at /home/dpgpsifp/psicodebate.dpgpsifpm.com.br/lib/pkp/lib/adodb/adodb.inc.php:519) in /home/dpgpsifp/psicodebate.dpgpsifpm.com.br/lib/pkp/classes/session/SessionManager.inc.php on line 225
Warning: Cannot modify header information - headers already sent by (output started at /home/dpgpsifp/psicodebate.dpgpsifpm.com.br/lib/pkp/lib/adodb/adodb.inc.php:519) in /home/dpgpsifp/psicodebate.dpgpsifpm.com.br/lib/pkp/classes/session/SessionManager.inc.php on line 234
(mysql): SELECT * FROM journals WHERE path = 'periodico'
(mysql): SELECT * FROM journal_settings WHERE journal_id = '1'
(mysql): SELECT * FROM site
(mysql): SET time_zone = '-2:00'
(mysql): SELECT v.* FROM versions v LEFT JOIN plugin_settings ps ON lower(v.product_class_name) = ps.plugin_name AND ps.setting_name = 'enabled' AND (context_id = '1' OR v.sitewide = 1) WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
Strict Standards: Declaration of DRIVERDAO::setOAI() should be compatible with PKPOAIDAO::setOAI($oai) in /home/dpgpsifp/psicodebate.dpgpsifpm.com.br/plugins/generic/driver/DRIVERDAO.inc.php on line 19
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.usageStats.UsageStatsLoader'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.datacite.DataciteInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.doaj.DOAJInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.medra.MedraInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'lib.pkp.classes.task.ReviewReminder'
(mysql): SELECT ug.* FROM user_groups ug JOIN user_user_groups uug ON ug.user_group_id = uug.user_group_id WHERE uug.user_id = 15
(mysql): SELECT * FROM user_group_settings WHERE user_group_id = '14'
(mysql): SELECT * FROM user_group_settings WHERE user_group_id = '17'
(mysql): SELECT count(*) FROM notifications WHERE user_id = 15 AND date_read IS NULL AND level = 3
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'defaultthemeplugin' AND context_id = 1
(mysql): SELECT * FROM journals WHERE path = 'periodico'
(mysql): SELECT * FROM journal_settings WHERE journal_id = '1'
(mysql): SELECT ug.* FROM user_groups ug JOIN user_user_groups uug ON ug.user_group_id = uug.user_group_id WHERE uug.user_id = 15
(mysql): SELECT * FROM user_group_settings WHERE user_group_id = '14'
(mysql): SELECT * FROM user_group_settings WHERE user_group_id = '17'
(mysql): SELECT * FROM navigation_menus WHERE context_id = 1
(mysql): SELECT nmi.* FROM navigation_menu_item_assignments as nmh LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id) WHERE nmh.navigation_menu_id = 1 ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '1'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '4'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '2'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '5'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '3'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '6'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '7'
(mysql): SELECT nmi.*,nmh.navigation_menu_id,nmh.parent_id,nmh.seq, nmh.navigation_menu_item_assignment_id FROM navigation_menu_item_assignments as nmh LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id) WHERE nmh.navigation_menu_id = 1 ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '1'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '4'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '5'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '3'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '6'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '7'
(mysql): SELECT DISTINCT ug.role_id FROM user_groups ug JOIN user_user_groups uug ON ug.user_group_id = uug.user_group_id WHERE uug.user_id = 15 AND ug.context_id = 1
(mysql): SELECT DISTINCT ug.role_id FROM user_groups ug JOIN user_user_groups uug ON ug.user_group_id = uug.user_group_id WHERE uug.user_id = 15
(mysql): SELECT nmi.* FROM navigation_menu_item_assignments as nmh LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id) WHERE nmh.navigation_menu_id = 2 ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '8'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '12'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '9'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '13'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '10'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '14'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '11'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '15'
(mysql): SELECT nmi.*,nmh.navigation_menu_id,nmh.parent_id,nmh.seq, nmh.navigation_menu_item_assignment_id FROM navigation_menu_item_assignments as nmh LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id) WHERE nmh.navigation_menu_id = 2 ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '8'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '12'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '9'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '13'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '10'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '14'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '11'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '15'
(mysql): SELECT * FROM notifications WHERE user_id = 15 AND level = 1 ORDER BY date_created DESC
Strict Standards: Declaration of CustomBlockPlugin::getSeq() should be compatible with BlockPlugin::getSeq($contextId = NULL) in /home/dpgpsifp/psicodebate.dpgpsifpm.com.br/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 129
Strict Standards: Declaration of CustomBlockPlugin::getBlockContext() should be compatible with BlockPlugin::getBlockContext($contextId = NULL) in /home/dpgpsifp/psicodebate.dpgpsifpm.com.br/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 129
Strict Standards: Declaration of CustomBlockPlugin::getEnabled() should be compatible with BlockPlugin::getEnabled($contextId = NULL) in /home/dpgpsifp/psicodebate.dpgpsifpm.com.br/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 129
Strict Standards: Declaration of CustomBlockPlugin::getContents() should be compatible with BlockPlugin::getContents($templateMgr, $request = NULL) in /home/dpgpsifp/psicodebate.dpgpsifpm.com.br/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 129
(mysql): select `s`.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev from `submissions` as `s` left join `stage_assignments` as `sa` on `s`.`submission_id` = `sa`.`submission_id` and `sa`.`user_id` = 15 left join `review_assignments` as `ra` on `s`.`submission_id` = `ra`.`submission_id` and `ra`.`reviewer_id` = 15 left join `section_settings` as `stpl` on `s`.`section_id` = stpl.section_id and `stpl`.`setting_name` = 'section_title' and `stpl`.`locale` = 'pt_BR' left join `section_settings` as `stl` on `s`.`section_id` = stl.section_id and `stl`.`setting_name` = 'section_title' and `stl`.`locale` = 'pt_BR' left join `section_settings` as `sapl` on `s`.`section_id` = sapl.section_id and `sapl`.`setting_name` = 'section_abbrev' and `sapl`.`locale` = 'pt_BR' left join `section_settings` as `sal` on `s`.`section_id` = sal.section_id and `sal`.`setting_name` = 'section_abbrev' and `sal`.`locale` = 'pt_BR' where `s`.`context_id` = '1' and `s`.`status` in (1) and (`sa`.`stage_assignment_id` is not null or `ra`.`review_id` is not null) group by `s`.`submission_id`, COALESCE(stl.setting_value, stpl.setting_value), COALESCE(sal.setting_value, sapl.setting_value) order by `s`.`date_submitted` desc LIMIT 0,20
(mysql): SELECT * FROM submission_settings WHERE submission_id = '186'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '117'
(mysql): SELECT * FROM submission_settings WHERE submission_id = '112'
Strict Standards: Declaration of SubmissionFileDAO::fromRow() should be compatible with PKPSubmissionFileDAO::fromRow($row, $fileImplementation) in /home/dpgpsifp/psicodebate.dpgpsifpm.com.br/classes/article/SubmissionFileDAO.inc.php on line 23
(mysql): SELECT DISTINCT q.* FROM queries q LEFT JOIN notes n ON n.assoc_type = 1048586 AND n.assoc_id = q.query_id INNER JOIN query_participants qp ON (q.query_id = qp.query_id AND qp.user_id = 15) WHERE q.assoc_type = 1048585 AND q.assoc_id = 186 AND q.stage_id = 1 AND (n.user_id = 15 OR n.title IS NOT NULL OR n.contents IS NOT NULL) ORDER BY q.seq
(mysql): SELECT COUNT(*) FROM stage_assignments sa JOIN user_groups ug ON (sa.user_group_id = ug.user_group_id) JOIN user_group_stage ugs ON (ug.user_group_id = ugs.user_group_id) WHERE sa.submission_id = 186 AND ug.role_id IN (16, 17) AND ugs.stage_id = 1
(mysql): SELECT DISTINCT q.* FROM queries q LEFT JOIN notes n ON n.assoc_type = 1048586 AND n.assoc_id = q.query_id INNER JOIN query_participants qp ON (q.query_id = qp.query_id AND qp.user_id = 15) WHERE q.assoc_type = 1048585 AND q.assoc_id = 186 AND q.stage_id = 3 AND (n.user_id = 15 OR n.title IS NOT NULL OR n.contents IS NOT NULL) ORDER BY q.seq
(mysql): SELECT * FROM review_rounds WHERE submission_id = 186 AND stage_id = 3 ORDER BY stage_id DESC, round DESC LIMIT 1
(mysql): 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 INNER JOIN review_round_files rrf ON sf.submission_id = rrf.submission_id AND sf.file_id = rrf.file_id AND sf.revision = rrf.revision WHERE sf.submission_id = 186 AND sf.file_stage = 15 AND rrf.review_round_id = 75 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): 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 INNER JOIN review_round_files rrf ON sf.submission_id = rrf.submission_id AND sf.file_id = rrf.file_id AND sf.revision = rrf.revision WHERE sf.submission_id = 186 AND sf.file_stage = 15 AND rrf.review_round_id = 75 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): 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 INNER JOIN review_round_files rrf ON sf.submission_id = rrf.submission_id AND sf.file_id = rrf.file_id AND sf.revision = rrf.revision WHERE sf.submission_id = 186 AND sf.file_stage = 15 AND rrf.review_round_id = 75 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT ugs.stage_id AS stage_id, sa.* FROM stage_assignments sa JOIN user_group_stage ugs ON sa.user_group_id = ugs.user_group_id LEFT JOIN user_groups ug ON sa.user_group_id = ug.user_group_id WHERE sa.submission_id = 186 AND ugs.stage_id = 3 AND ug.role_id = 16
(mysql): SELECT ugs.stage_id AS stage_id, sa.* FROM stage_assignments sa JOIN user_group_stage ugs ON sa.user_group_id = ugs.user_group_id LEFT JOIN user_groups ug ON sa.user_group_id = ug.user_group_id WHERE sa.submission_id = 186 AND ugs.stage_id = 3 AND ug.role_id = 17
(mysql): SELECT DISTINCT q.* FROM queries q LEFT JOIN notes n ON n.assoc_type = 1048586 AND n.assoc_id = q.query_id INNER JOIN query_participants qp ON (q.query_id = qp.query_id AND qp.user_id = 15) WHERE q.assoc_type = 1048585 AND q.assoc_id = 186 AND q.stage_id = 4 AND (n.user_id = 15 OR n.title IS NOT NULL OR n.contents IS NOT NULL) ORDER BY q.seq
(mysql): 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.submission_id = 186 AND sf.file_stage = 9 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT DISTINCT q.* FROM queries q LEFT JOIN notes n ON n.assoc_type = 1048586 AND n.assoc_id = q.query_id INNER JOIN query_participants qp ON (q.query_id = qp.query_id AND qp.user_id = 15) WHERE q.assoc_type = 1048585 AND q.assoc_id = 186 AND q.stage_id = 5 AND (n.user_id = 15 OR n.title IS NOT NULL OR n.contents IS NOT NULL) ORDER BY q.seq
(mysql): 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.submission_id = 186 AND sf.file_stage = 10 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM review_rounds WHERE submission_id = '186' ORDER BY stage_id ASC, round ASC
(mysql): 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 INNER JOIN review_round_files rrf ON sf.submission_id = rrf.submission_id AND sf.file_id = rrf.file_id AND sf.revision = rrf.revision WHERE sf.submission_id = 186 AND sf.file_stage = 15 AND rrf.review_round_id = 75 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): 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 INNER JOIN review_round_files rrf ON sf.submission_id = rrf.submission_id AND sf.file_id = rrf.file_id AND sf.revision = rrf.revision WHERE sf.submission_id = 186 AND sf.file_stage = 15 AND rrf.review_round_id = 75 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT r.*, r2.review_revision, u.first_name, u.last_name FROM review_assignments r LEFT JOIN users u ON (r.reviewer_id = u.user_id) LEFT JOIN review_rounds r2 ON (r.review_round_id = r2.review_round_id) WHERE r.submission_id = 186 ORDER BY review_id, r2.review_round_id, r2.stage_id
(mysql): SELECT s.*, ps.date_published, 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 = 'pt_BR') LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'pt_BR') LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'pt_BR') LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'pt_BR') WHERE s.submission_id = 186
Continue in the next post