Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 3024 Query execution was interrupted, maximum statement execution time exceeded in /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:453 Stack trace: #0 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(453): PDOStatement->execute() #1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #3 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(456): Illuminate\Database\Connection->run() #4 /var/www/ojs/classes/search/ArticleSearchDAO.php(113): Illuminate\Database\Connection->cursor() #5 /var/www/ojs/lib/pkp/classes/search/SubmissionSearch.php(224): APP\search\ArticleSearchDAO->getPhraseResults() #6 /var/www/ojs/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults() #7 /var/www/ojs/lib/pkp/classes/search/SubmissionSearch.php(220): PKP\search\SubmissionSearch->_getMergedKeywordResults() #8 /var/www/ojs/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults() #9 /var/www/ojs/lib/pkp/classes/search/SubmissionSearch.php(156): PKP\search\SubmissionSearch->_getMergedKeywordResults() #10 /var/www/ojs/lib/pkp/classes/search/SubmissionSearch.php(289): PKP\search\SubmissionSearch->_getMergedArray() #11 /var/www/ojs/pages/search/SearchHandler.php(191): PKP\search\SubmissionSearch->retrieveResults() #12 /var/www/ojs/pages/search/SearchHandler.php(94): APP\pages\search\SearchHandler->search() #13 [internal function]: APP\pages\search\SearchHandler->index() #14 /var/www/ojs/lib/pkp/classes/core/PKPRouter.php(334): call_user_func() #15 /var/www/ojs/lib/pkp/classes/core/PKPPageRouter.php(278): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #16 /var/www/ojs/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route() #17 /var/www/ojs/lib/pkp/classes/core/PKPApplication.php(395): PKP\core\Dispatcher->dispatch() #18 /var/www/ojs/index.php(21): PKP\core\PKPApplication->execute() #19 {main} Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 3024 Query execution was interrupted, maximum statement execution time exceeded (SQL: SELECT o.submission_id, MAX(s.context_id) AS journal_id, MAX(i.date_published) AS i_pub, MAX(p.date_published) AS s_pub, COUNT(*) AS count FROM submissions s JOIN publications p ON (p.publication_id = s.current_publication_id) JOIN publication_settings ps ON (ps.publication_id = p.publication_id AND ps.setting_name='issueId' AND ps.locale='') JOIN issues i ON (CAST(i.issue_id AS CHAR(20)) = ps.setting_value AND i.journal_id = s.context_id) JOIN submission_search_objects o ON (s.submission_id = o.submission_id) JOIN journals j ON j.journal_id = s.context_id LEFT JOIN journal_settings js ON j.journal_id = js.journal_id AND js.setting_name = 'publishingMode' NATURAL JOIN submission_search_object_keywords o0 NATURAL JOIN submission_search_keyword_list k0 WHERE (js.setting_value <> '2' OR js.setting_value IS NULL) AND j.enabled = 1 AND s.status = 3 AND i.published = 1 AND k0.keyword_text = sri AND i.journal_id = 17 GROUP BY o.submission_id ORDER BY count DESC LIMIT 500) in /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760 Stack trace: #0 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(456): Illuminate\Database\Connection->run() #2 /var/www/ojs/classes/search/ArticleSearchDAO.php(113): Illuminate\Database\Connection->cursor() #3 /var/www/ojs/lib/pkp/classes/search/SubmissionSearch.php(224): APP\search\ArticleSearchDAO->getPhraseResults() #4 /var/www/ojs/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults() #5 /var/www/ojs/lib/pkp/classes/search/SubmissionSearch.php(220): PKP\search\SubmissionSearch->_getMergedKeywordResults() #6 /var/www/ojs/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults() #7 /var/www/ojs/lib/pkp/classes/search/SubmissionSearch.php(156): PKP\search\SubmissionSearch->_getMergedKeywordResults() #8 /var/www/ojs/lib/pkp/classes/search/SubmissionSearch.php(289): PKP\search\SubmissionSearch->_getMergedArray() #9 /var/www/ojs/pages/search/SearchHandler.php(191): PKP\search\SubmissionSearch->retrieveResults() #10 /var/www/ojs/pages/search/SearchHandler.php(94): APP\pages\search\SearchHandler->search() #11 [internal function]: APP\pages\search\SearchHandler->index() #12 /var/www/ojs/lib/pkp/classes/core/PKPRouter.php(334): call_user_func() #13 /var/www/ojs/lib/pkp/classes/core/PKPPageRouter.php(278): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #14 /var/www/ojs/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route() #15 /var/www/ojs/lib/pkp/classes/core/PKPApplication.php(395): PKP\core\Dispatcher->dispatch() #16 /var/www/ojs/index.php(21): PKP\core\PKPApplication->execute() #17 {main} thrown in /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760