Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.issue_id' in 'ON' in /home/phamho/i-jli.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:470 Stack trace: #0 /home/phamho/i-jli.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(470): PDO->prepare('SELECT\n ...') #1 /home/phamho/i-jli.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\Database\Connection->Illuminate\Database\{closure}('SELECT\n ...', Array) #2 /home/phamho/i-jli.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback('SELECT\n ...', Array, Object(Closure)) #3 /home/phamho/i-jli.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(461): Illuminate\Database\Connection->run('SELECT\n ...', Array, Object(Closure)) #4 /home/phamho/i-jli.org/classes/search/ArticleSearchDAO.php(117): Illuminate\Database\Connection->cursor('SELECT\n ...', Array) #5 /home/phamho/i-jli.org/lib/pkp/classes/search/SubmissionSearch.php(223): APP\search\ArticleSearchDAO->getPhraseResults(Object(APP\journal\Journal), Array, NULL, NULL, '', 500) #6 /home/phamho/i-jli.org/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults(Object(APP\journal\Journal), Array, '', NULL, NULL, 500) #7 /home/phamho/i-jli.org/lib/pkp/classes/search/SubmissionSearch.php(220): PKP\search\SubmissionSearch->_getMergedKeywordResults(Object(APP\journal\Journal), Array, '', NULL, NULL, 500) #8 /home/phamho/i-jli.org/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults(Object(APP\journal\Journal), Array, NULL, NULL, NULL, 500) #9 /home/phamho/i-jli.org/lib/pkp/classes/search/SubmissionSearch.php(156): PKP\search\SubmissionSearch->_getMergedKeywordResults(Object(APP\journal\Journal), Array, NULL, NULL, NULL, 500) #10 /home/phamho/i-jli.org/lib/pkp/classes/search/SubmissionSearch.php(291): PKP\search\SubmissionSearch->_getMergedArray(Object(APP\journal\Journal), Array, NULL, NULL) #11 /home/phamho/i-jli.org/pages/search/SearchHandler.php(146): PKP\search\SubmissionSearch->retrieveResults(Object(APP\core\Request), Object(APP\journal\Journal), Array, '', NULL, NULL, Object(PKP\db\DBResultRange)) #12 [internal function]: APP\pages\search\SearchHandler->search(Array, Object(APP\core\Request)) #13 /home/phamho/i-jli.org/lib/pkp/classes/core/PKPRouter.php(327): call_user_func(Array, Array, Object(APP\core\Request)) #14 /home/phamho/i-jli.org/lib/pkp/classes/core/PKPPageRouter.php(249): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(APP\core\Request), Array, false) #15 /home/phamho/i-jli.org/lib/pkp/classes/core/Dispatcher.php(157): PKP\core\PKPPageRouter->route(Object(APP\core\Request)) #16 /home/phamho/i-jli.org/lib/pkp/classes/core/PKPApplication.php(429): PKP\core\Dispatcher->dispatch(Object(APP\core\Request)) #17 /home/phamho/i-jli.org/index.php(24): PKP\core\PKPApplication->execute() #18 {main} Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.issue_id' in 'ON' (Connection: mysql, 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 issues i ON (i.issue_id = p.issue_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 = digital AND i.journal_id = 1 GROUP BY o.submission_id ORDER BY count DESC LIMIT 500) in /home/phamho/i-jli.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825 Stack trace: #0 /home/phamho/i-jli.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback('SELECT\n ...', Array, Object(Closure)) #1 /home/phamho/i-jli.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(461): Illuminate\Database\Connection->run('SELECT\n ...', Array, Object(Closure)) #2 /home/phamho/i-jli.org/classes/search/ArticleSearchDAO.php(117): Illuminate\Database\Connection->cursor('SELECT\n ...', Array) #3 /home/phamho/i-jli.org/lib/pkp/classes/search/SubmissionSearch.php(223): APP\search\ArticleSearchDAO->getPhraseResults(Object(APP\journal\Journal), Array, NULL, NULL, '', 500) #4 /home/phamho/i-jli.org/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults(Object(APP\journal\Journal), Array, '', NULL, NULL, 500) #5 /home/phamho/i-jli.org/lib/pkp/classes/search/SubmissionSearch.php(220): PKP\search\SubmissionSearch->_getMergedKeywordResults(Object(APP\journal\Journal), Array, '', NULL, NULL, 500) #6 /home/phamho/i-jli.org/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults(Object(APP\journal\Journal), Array, NULL, NULL, NULL, 500) #7 /home/phamho/i-jli.org/lib/pkp/classes/search/SubmissionSearch.php(156): PKP\search\SubmissionSearch->_getMergedKeywordResults(Object(APP\journal\Journal), Array, NULL, NULL, NULL, 500) #8 /home/phamho/i-jli.org/lib/pkp/classes/search/SubmissionSearch.php(291): PKP\search\SubmissionSearch->_getMergedArray(Object(APP\journal\Journal), Array, NULL, NULL) #9 /home/phamho/i-jli.org/pages/search/SearchHandler.php(146): PKP\search\SubmissionSearch->retrieveResults(Object(APP\core\Request), Object(APP\journal\Journal), Array, '', NULL, NULL, Object(PKP\db\DBResultRange)) #10 [internal function]: APP\pages\search\SearchHandler->search(Array, Object(APP\core\Request)) #11 /home/phamho/i-jli.org/lib/pkp/classes/core/PKPRouter.php(327): call_user_func(Array, Array, Object(APP\core\Request)) #12 /home/phamho/i-jli.org/lib/pkp/classes/core/PKPPageRouter.php(249): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(APP\core\Request), Array, false) #13 /home/phamho/i-jli.org/lib/pkp/classes/core/Dispatcher.php(157): PKP\core\PKPPageRouter->route(Object(APP\core\Request)) #14 /home/phamho/i-jli.org/lib/pkp/classes/core/PKPApplication.php(429): PKP\core\Dispatcher->dispatch(Object(APP\core\Request)) #15 /home/phamho/i-jli.org/index.php(24): PKP\core\PKPApplication->execute() #16 {main} thrown in /home/phamho/i-jli.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 825