Could you please explain with detail what to do? I have the same issue:
DB Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
Stack Trace:
File: /home/colefnet/public_html/revistas/ojs/classes/submission/editor/EditorSubmissionDAO.inc.php line 356
Function: DAO->retrieveRange(“SELECT DISTINCT a.*, scf.date_completed as copyedit_comp…”, Array(21), Object(DBResultRange))
File: /home/colefnet/public_html/revistas/ojs/classes/submission/editor/EditorSubmissionDAO.inc.php line 428
Function: EditorSubmissionDAO->_getUnfilteredEditorSubmissions(“2”, 0, 0, Null, Null, Null, Null, Null, Null, “a.status = 1 AND ea.edit_id IS NOT NULL AND (edec.decision IS NU…”, Object(DBResultRange), “id”, 1)
File: /home/colefnet/public_html/revistas/ojs/pages/editor/EditorHandler.inc.php line 263
Function: EditorSubmissionDAO->getEditorSubmissionsInReview(“2”, 0, 0, Null, Null, Null, Null, Null, Null, Object(DBResultRange), “id”, 1)
File: (unknown) line (unknown)
Function: EditorHandler->submissions(Array(1), Object(Request))
File: /home/colefnet/public_html/revistas/ojs/lib/pkp/classes/core/PKPRouter.inc.php line 362
Function: call_user_func(Array(2), Array(1), Object(Request))
File: /home/colefnet/public_html/revistas/ojs/lib/pkp/classes/core/PKPPageRouter.inc.php line 220
Function: PKPRouter->_authorizeInitializeAndCallRequest(Array(2), Object(Request), Array(1), False)
File: /home/colefnet/public_html/revistas/ojs/lib/pkp/classes/core/Dispatcher.inc.php line 134
Function: PKPPageRouter->route(Object(Request))
File: /home/colefnet/public_html/revistas/ojs/lib/pkp/classes/core/PKPApplication.inc.php line 178
Function: Dispatcher->dispatch(Object(Request))
File: /home/colefnet/public_html/revistas/ojs/index.php line 63
Function: PKPApplication->execute()
According to Replace JournalStatisticsDAO cross product with two queries by ctgraham · Pull Request #655 · pkp/ojs · GitHub
I just edit the page /classes/journal/JournalStatisticsDAO.inc.php as:
function getFirstActivityDate($journalId) {
$result =& $this->retrieve(
'SELECT LEAST(a.date_submitted, COALESCE(pa.date_published, NOW()), COALESCE(i.date_published, NOW())) AS first_date
FROM articles a
LEFT JOIN published_articles pa ON (a.article_id = pa.article_id)
LEFT JOIN issues i ON (pa.issue_id = i.issue_id)
LEFT JOIN articles a2 ON (a2.article_id < a.article_id AND a2.date_submitted IS NOT NULL AND a2.journal_id = ?)
WHERE a2.article_id IS NULL AND
a.date_submitted IS NOT NULL AND
a.journal_id = ?',
array(
(int) $journalId,
(int) $journalId
)
);
$row = $result->GetRowAssoc(false);
$firstActivityDate = $this->datetimeFromDB($row['first_date']);
$result->Close();
// An earlier user registration can override the earliest article activity date
$result =& $this->retrieve(
'SELECT MIN(u.date_registered) AS first_date FROM users u JOIN roles r ON (u.user_id = r.user_id) WHERE r.journal_id = ?',
array(
(int) $journalId
)
);
$row = $result->GetRowAssoc(false);
$firstUserDate = $this->datetimeFromDB($row['first_date']);
if (!$firstActivityDate || ($firstUserDate && $firstActivityDate && strtotime($firstUserDate) < strtotime($firstActivityDate))) {
$firstActivityDate = $firstUserDate;
}
Im getting the same error. It only show on Editor users by clicking In review
index.php/migracionesinternacionales/editor/submissions/submissionsInReview
And:
sql big selects OFF
max join size 1,000,000,000
Thank you!
Regards