[Urgent] Error when old users acess submission page

[Hugo_Melo]

Hello there, me again. I’ve been trying to fix some errors with notification emails and citation plugin, but somehow, since yesterday, I am receiving complainings about users that cannot acess the submission page (HTTP ERROR 500). The error was:

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

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

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

Fatal error: Call to a member function getContextId() on null in /home/dpgpsifp/psicodebate.dpgpsifpm.com.br/lib/pkp/classes/submission/reviewAssignment/ReviewAssignment.inc.php on line 517

Can someone please give me a clue on how to fix this? Since it is a vital part of the website…
I don’t know why fresh registered users don’t have this error (i did a fake registry to test), must be a clue.

I’ve tried already:

1. Create a new role author2 with default options, and set old users into it. (Don’t work)
2. Clean roles from user, and set it again. (Don’t work)
3. Set those users with manager permission. (Keep ERROR HTTP 500)
4. Clean cache. (Don’t work)

[israel.cefrin]

Hi @Hugo_Melo

Did you try export one of those problematic users and compare resulting XML with a exported fresh one?
Just to double check they hold same data and infos from DB. You could start on it to debug this users issue.

Regards,
Israel Cefrin
Public Knowledge Project Team

[Hugo_Melo]

Hello @israel.cefrin!
First of all, thank you for trying to help in a weekend.

Well, i entered the phpmyadmin and watched over and over into all the users tables to see the ones that interfere in user groups.
Then, i tried to copy data from a fresh user (full working) into a old user. Nothing.
I checked all user groups tables in db looking to some discrepancy including cheking with my backup from ojs 3.0.2. Tried even to edit those user groups via phpmyadmin but nothing changes. This makes me think that the problem may be in other table, don’t know.
Anyway, look for yourself and please let me know if u see anything weird.

**This works**
        <column name="user_id">4</column>
        <column name="username">fulano</column>
        <column name="password">**</column>
        <column name="salutation"></column>
        <column name="first_name">Fulano</column>
        <column name="middle_name">de</column>
        <column name="last_name">Tal</column>
        <column name="suffix"></column>
        <column name="gender"></column>
        <column name="initials">FT</column>
        <column name="email">*</column>
        <column name="url"></column>
        <column name="phone"></column>
        <column name="mailing_address"></column>
        <column name="billing_address">NULL</column>
        <column name="country">BR</column>
        <column name="locales"></column>
        <column name="date_last_email">NULL</column>
        <column name="date_registered">2017-08-29 18:44:32</column>
        <column name="date_validated">NULL</column>
        <column name="date_last_login">2017-08-29 18:44:33</column>
        <column name="must_change_password">0</column>
        <column name="auth_id">NULL</column>
        <column name="auth_str">NULL</column>
        <column name="disabled">0</column>
        <column name="disabled_reason">NULL</column>
        <column name="inline_help">1</column>

**This don't**

<column name="user_id">15</column>
                <column name="username">zidjah</column>
                <column name="password">**</column>
                <column name="salutation"></column>
                <column name="first_name">André</column>
                <column name="middle_name">Luiz Ferreira</column>
                <column name="last_name">Evangelista</column>
                <column name="suffix"></column>
                <column name="gender">M</column>
                <column name="initials">AE</column>
                <column name="email">*@terra.com.br</column>
                <column name="url"></column>
                <column name="phone"></column>
                <column name="mailing_address"></column>
                <column name="billing_address">NULL</column>
                <column name="country">BR</column>
                <column name="locales"></column>
                <column name="date_last_email">NULL</column>
                <column name="date_registered">2017-09-06 18:54:43</column>
                <column name="date_validated">NULL</column>
                <column name="date_last_login">2017-11-04 09:22:43</column>
                <column name="must_change_password">0</column>
                <column name="auth_id">NULL</column>
                <column name="auth_str">NULL</column>
                <column name="disabled">0</column>
                <column name="disabled_reason">NULL</column>
                <column name="inline_help">1</column>

This works:

<table name="user_user_groups">
    <column name="user_group_id">14</column>
    <column name="user_id">4</column>
</table>

This don’t:

<table name="user_user_groups">
    <column name="user_group_id">14</column>
    <column name="user_id">15</column>
</table>

I keep getting this when I access as the second user:

Then i came back in the browser and this appears: (This user group is not allowed to perform this operation.

And this when i access as the first user:

I am completly out of ideas.

[Hugo_Melo]

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

[Hugo_Melo]

(mysql): SELECT * FROM submission_settings WHERE submission_id = '186'  
(mysql): SELECT	ug.* FROM	user_groups ug JOIN user_group_stage ugs ON (ug.user_group_id = ugs.user_group_id AND ug.context_id = ugs.context_id) WHERE	ugs.context_id = 1 AND ugs.stage_id = 3 ORDER BY ug.role_id ASC  
(mysql): SELECT * FROM user_group_settings WHERE user_group_id = '2'  
(mysql): SELECT u.* FROM stage_assignments sa INNER JOIN user_group_stage ugs ON (sa.user_group_id = ugs.user_group_id) INNER JOIN users u ON (u.user_id = sa.user_id) WHERE submission_id = 186 AND ugs.stage_id = 3 AND sa.user_group_id = 2  
(mysql): SELECT * FROM user_group_settings WHERE user_group_id = '3'  
(mysql): SELECT u.* FROM stage_assignments sa INNER JOIN user_group_stage ugs ON (sa.user_group_id = ugs.user_group_id) INNER JOIN users u ON (u.user_id = sa.user_id) WHERE submission_id = 186 AND ugs.stage_id = 3 AND sa.user_group_id = 3  
(mysql): SELECT * FROM user_group_settings WHERE user_group_id = '5'  
(mysql): SELECT u.* FROM stage_assignments sa INNER JOIN user_group_stage ugs ON (sa.user_group_id = ugs.user_group_id) INNER JOIN users u ON (u.user_id = sa.user_id) WHERE submission_id = 186 AND ugs.stage_id = 3 AND sa.user_group_id = 5  
(mysql): SELECT * FROM user_settings WHERE user_id = '1'  
(mysql): SELECT	date_last_viewed FROM	item_views WHERE	assoc_type = 516 AND	assoc_id = '78' AND	user_id = 1  
(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  
(mysql): SELECT * FROM submission_settings WHERE submission_id = '186'  
(mysql): SELECT	ug.* FROM	user_groups ug JOIN user_group_stage ugs ON (ug.user_group_id = ugs.user_group_id AND ug.context_id = ugs.context_id) WHERE	ugs.context_id = 1 AND ugs.stage_id = 3 ORDER BY ug.role_id ASC  
(mysql): SELECT * FROM user_group_settings WHERE user_group_id = '2'  
(mysql): SELECT u.* FROM stage_assignments sa INNER JOIN user_group_stage ugs ON (sa.user_group_id = ugs.user_group_id) INNER JOIN users u ON (u.user_id = sa.user_id) WHERE submission_id = 186 AND ugs.stage_id = 3 AND sa.user_group_id = 2  
(mysql): SELECT * FROM user_group_settings WHERE user_group_id = '3'  
(mysql): SELECT u.* FROM stage_assignments sa INNER JOIN user_group_stage ugs ON (sa.user_group_id = ugs.user_group_id) INNER JOIN users u ON (u.user_id = sa.user_id) WHERE submission_id = 186 AND ugs.stage_id = 3 AND sa.user_group_id = 3  
(mysql): SELECT * FROM user_group_settings WHERE user_group_id = '5'  
(mysql): SELECT u.* FROM stage_assignments sa INNER JOIN user_group_stage ugs ON (sa.user_group_id = ugs.user_group_id) INNER JOIN users u ON (u.user_id = sa.user_id) WHERE submission_id = 186 AND ugs.stage_id = 3 AND sa.user_group_id = 5  
(mysql): SELECT * FROM user_settings WHERE user_id = '1'  
(mysql): SELECT	date_last_viewed FROM	item_views WHERE	assoc_type = 516 AND	assoc_id = '78' AND	user_id = 1  
(mysql): SELECT	user_group_id FROM	user_groups WHERE role_id = 65536  
(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 WHERE sa.submission_id = 186 AND sa.user_id = 15  
(mysql): SELECT	a.*, ug.show_title FROM	authors a JOIN user_groups ug ON (a.user_group_id=ug.user_group_id) WHERE	a.submission_id = 186 AND a.include_in_browse = 1 ORDER BY seq  
(mysql): SELECT * FROM author_settings WHERE author_id = '349'  
(mysql): SELECT	ps.*, s.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM	published_submissions ps JOIN submissions s ON ps.submission_id = s.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')INNER JOIN submission_settings sst ON s.submission_id = sst.submission_id WHERE	sst.setting_name = 'pub-id::publisher-id' AND sst.setting_value = '186' ORDER BY ps.issue_id, s.submission_id  
(mysql): SELECT	ps.*, s.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM	published_submissions ps JOIN submissions s ON ps.submission_id = s.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')INNER JOIN submission_settings sst ON s.submission_id = sst.submission_id WHERE	sst.setting_name = 'pub-id::publisher-id' AND sst.setting_value = '186' ORDER BY ps.issue_id, s.submission_id  
(mysql): SELECT	ps.*, s.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM	published_submissions ps JOIN submissions s ON (ps.submission_id = s.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  
(mysql): SELECT	ps.*, s.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM	published_submissions ps JOIN submissions s ON ps.submission_id = s.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')INNER JOIN submission_settings sst ON s.submission_id = sst.submission_id WHERE	sst.setting_name = 'pub-id::publisher-id' AND sst.setting_value = '186' ORDER BY ps.issue_id, s.submission_id  
(mysql): SELECT	ps.*, s.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM	published_submissions ps JOIN submissions s ON ps.submission_id = s.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')INNER JOIN submission_settings sst ON s.submission_id = sst.submission_id WHERE	sst.setting_name = 'pub-id::publisher-id' AND sst.setting_value = '186' ORDER BY ps.issue_id, s.submission_id  
(mysql): SELECT	ps.*, s.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM	published_submissions ps JOIN submissions s ON (ps.submission_id = s.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  
(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 = 117 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 = 117 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 = 117 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 = 117 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 = 117 AND sf.file_stage = 15 AND rrf.review_round_id = 16 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 = 117 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 = 117 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 = 117 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 = 117 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 = 117 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 = 117 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 = '117' ORDER BY stage_id ASC, round ASC  
(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 = 117 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 = 117  

Fatal error: Call to a member function getContextId() on null in /home/dpgpsifp/psicodebate.dpgpsifpm.com.br/lib/pkp/classes/submission/reviewAssignment/ReviewAssignment.inc.php on line 517
(mysql): UPDATE sessions SET user_id = 15, ip_address = '186.210.68.160', user_agent = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36', created = 1509895787, last_used = 1509900876, remember = 1, data = 'csrf|a:2:{s:9:\"timestamp\";i:1509900876;s:5:\"token\";s:32:\"213f51b63201d83e13349fddacb0ac55\";}userId|i:15;username|s:6:\"zidjah\";signedInAs|s:1:\"1\";', domain = 'psicodebate.dpgpsifpm.com.br' WHERE session_id = 'h4vduedto2at047ou8shqiqae7'  

Please, any thoughts?

[Hugo_Melo]

In the end, the error that keep showing in log is:

[06-Nov-2017 12:40:59 UTC] PHP Fatal error: Call to a member function getContextId() on null in /home/dpgpsifp/psicodebate/lib/pkp/classes/submission/reviewAssignment/ReviewAssignment.inc.php on line 517

Please help me.

[israel.cefrin]

Hi @Hugo_Melo

Did you export user directly from Database?
To compare users, please use Export/Import tool from OJS admin panel.

Regards,
Israel Cefrin
Public Knowledge Project Team

[Hugo_Melo]

Many thanks for trying to help me @israel.cefrin.

No differences:

Diffchecker

[israel.cefrin]

Could you confirm OJS version you had and the one you have now?
This error starts after an upgrade, right?

Regards,
Israel Cefrin
Public Knowledge Project Team

[Hugo_Melo]

This specific error started from nothing, but its possible that it started after I upgraded from 3.0.2 since the error is showing only with olders users. I confirmed with the server that they didn’t change any version of php or mysql.
But I am using 3.1 now.

[bozana]

Hmmm… I am not sure, but it seems like a submission is missing i.e. null. Do you have submission with id 117 in your DB table submissions? – this seems to be the last query before the error…

I.e. when you execute this SQL what do you get:

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 = 117

[Hugo_Melo]

@bozana

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 = 117

@bozana
Yes, i do have an article 117, and its from this user.

Running the code i got:

MySQL said: Documentation

#1054 - Unknown column ‘‘title’’ in ‘on clause’

[Hugo_Melo]

@bozana
However looks like we are getting close to the issue.
My users are basic students, so they constantly make more than one submission of the same article. I took a look at the folder in /files/journals/1/articles/117/submission and i saw the article of this user.
When i looked at the article accepted of this user it is 112.
I tried to access the submission 117 and got “404 Not Found”
My doubt is, how i should proceed to delete the submission 117 since i cannot access it?

[bozana]

Hi @Hugo_Melo

Maybe to first figure out what is wrong with that submission – before trying to delete it?

The SQL above, when copied, had some strange single quotes (" ’ "), so could you maybe try the SQL again, but replace all single quotes manually anew?
Or could you post how does you row in the DB table submissions where submission_id = 117 looks like?
Also the row in the DB table stage_assignments, where submission_id = 117?

Can you see that submission as admin, on the dashboard, somewhere in a submissions list?

Best,
Bozana

[Hugo_Melo]

Thank you so much for trying to help me @bozana!

Here is the row of submission 117 on table submissions:

CREATE TABLE `submissions` (
  `submission_id` bigint(20) NOT NULL,
  `locale` varchar(5) DEFAULT NULL,
  `context_id` bigint(20) NOT NULL,
  `section_id` bigint(20) DEFAULT NULL,
  `language` varchar(10) DEFAULT 'en',
  `citations` text,
  `date_submitted` datetime DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  `date_status_modified` datetime DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `submission_progress` tinyint(4) NOT NULL DEFAULT '1',
  `current_round` tinyint(4) NOT NULL DEFAULT '1',
  `pages` varchar(255) DEFAULT NULL,
  `fast_tracked` tinyint(4) NOT NULL DEFAULT '0',
  `hide_author` tinyint(4) NOT NULL DEFAULT '0',
  `stage_id` bigint(20) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `submissions`
--

INSERT INTO `submissions` (`submission_id`, `locale`, `context_id`, `section_id`, `language`, `citations`, `date_submitted`, `last_modified`, `date_status_modified`, `status`, `submission_progress`, `current_round`, `pages`, `fast_tracked`, `hide_author`, `stage_id`) VALUES
(117, 'pt_BR', 1, NULL, '', NULL, '2017-09-19 11:08:15', '2017-09-19 22:29:17', '2017-09-19 22:29:17', 1, 0, 1, '', 0, 0, 5); 

On stage_assignments i have three rows for submission 117:

CREATE TABLE `stage_assignments` (
  `stage_assignment_id` bigint(20) NOT NULL,
  `submission_id` bigint(20) NOT NULL,
  `user_group_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `date_assigned` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `stage_assignments`
--

INSERT INTO `stage_assignments` (`stage_assignment_id`, `submission_id`, `user_group_id`,     `user_id`, `date_assigned`) VALUES
    (117, 107, 14, 16, '2017-09-13 19:47:22'),
    (135, 117, 14, 15, '2017-09-19 11:04:52'),
(136, 117, 5, 1, '2017-09-19 11:08:16');

No, i can’t see the submission 117. It shows as error 404 when i try direct adress.

[bozana]

Hi @Hugo_Melo

It seems that section_id is NULL, which should not be the case. Could you insert a real section_id? Also, if there are any other submissions with section_id = NULL, could you please repair them?
I hope this could solve the problem, but lets see…

Best,
Bozana

[Hugo_Melo]

I have located 17 articles with section_id missing. I will fix them and let you know. Thnx!

[Hugo_Melo]

Dear @bozana.
% days have passed and looks like it really solved all error 500 in here! You are a life savior! Thank you very much.

The only problem that persists is the email notification, as described here:

[Solved] Questions about OJS 3.0.2

Hello there. I’ve been using OJS 3.0.2 for some months now, without any major problems. I come here to ask u guys about a few concerns i have, and things i couldn’t find alone: First of all, how to make a full backup of the site, automatic or manual. I can imagine how I can make a backup of the files direct from server, but Its possible to make a backup of files and database, easily? Maybe a plugin? I can create new models of emails, however, when in submission page or avaliation page, when i…

[Syaifur_Rohman]

Dear @Hugo_Melo
I found errors in OJS that I manage, and I’m looking for ways how to solve it in google and I find the same error you have been through,
ie on

lib / pkp / classes / submission / reviewAssignment / ReviewAssignment.inc.php on line 517

how to solve the problem
for the answer I say
Thank you very much

[bozana]

@Syaifur_Rohman, if that should be the same issue/problem and as it is posted above: could you check if there are missing section IDs in your DB submissions and if so enter the correct ones there?