Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1116 Too many tables; MariaDB can only use 61 tables in a join in /home/symposiu/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:444
Stack trace:
#0 /home/symposiu/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(444): PDO->prepare()
#1 /home/symposiu/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /home/symposiu/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /home/symposiu/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(456): Illuminate\Database\Connection->run()
#4 /home/symposiu/public_html/classes/search/ArticleSearchDAO.php(113): Illuminate\Database\Connection->cursor()
#5 /home/symposiu/public_html/lib/pkp/classes/search/SubmissionSearch.php(224): APP\search\ArticleSearchDAO->getPhraseResults()
#6 /home/symposiu/public_html/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults()
#7 /home/symposiu/public_html/lib/pkp/classes/search/SubmissionSearch.php(220): PKP\search\SubmissionSearch->_getMergedKeywordResults()
#8 /home/symposiu/public_html/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults()
#9 /home/symposiu/public_html/lib/pkp/classes/search/SubmissionSearch.php(156): PKP\search\SubmissionSearch->_getMergedKeywordResults()
#10 /home/symposiu/public_html/lib/pkp/classes/search/SubmissionSearch.php(289): PKP\search\SubmissionSearch->_getMergedArray()
#11 /home/symposiu/public_html/pages/search/SearchHandler.php(150): PKP\search\SubmissionSearch->retrieveResults()
#12 /home/symposiu/public_html/pages/search/SearchHandler.php(53): APP\pages\search\SearchHandler->search()
#13 [internal function]: APP\pages\search\SearchHandler->index()
#14 /home/symposiu/public_html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func()
#15 /home/symposiu/public_html/lib/pkp/classes/core/PKPPageRouter.php(278): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest()
#16 /home/symposiu/public_html/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route()
#17 /home/symposiu/public_html/lib/pkp/classes/core/PKPApplication.php(395): PKP\core\Dispatcher->dispatch()
#18 /home/symposiu/public_html/index.php(21): PKP\core\PKPApplication->execute()
#19 {main}
Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1116 Too many tables; MariaDB can only use 61 tables in a join (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, submission_search_object_keywords o1 NATURAL JOIN submission_search_keyword_list k1, submission_search_object_keywords o2 NATURAL JOIN submission_search_keyword_list k2, submission_search_object_keywords o3 NATURAL JOIN submission_search_keyword_list k3, submission_search_object_keywords o4 NATURAL JOIN submission_search_keyword_list k4, submission_search_object_keywords o5 NATURAL JOIN submission_search_keyword_list k5, submission_search_object_keywords o6 NATURAL JOIN submission_search_keyword_list k6, submission_search_object_keywords o7 NATURAL JOIN submission_search_keyword_list k7, submission_search_object_keywords o8 NATURAL JOIN submission_search_keyword_list k8, submission_search_object_keywords o9 NATURAL JOIN submission_search_keyword_list k9, submission_search_object_keywords o10 NATURAL JOIN submission_search_keyword_list k10, submission_search_object_keywords o11 NATURAL JOIN submission_search_keyword_list k11, submission_search_object_keywords o12 NATURAL JOIN submission_search_keyword_list k12, submission_search_object_keywords o13 NATURAL JOIN submission_search_keyword_list k13, submission_search_object_keywords o14 NATURAL JOIN submission_search_keyword_list k14, submission_search_object_keywords o15 NATURAL JOIN submission_search_keyword_list k15, submission_search_object_keywords o16 NATURAL JOIN submission_search_keyword_list k16, submission_search_object_keywords o17 NATURAL JOIN submission_search_keyword_list k17, submission_search_object_keywords o18 NATURAL JOIN submission_search_keyword_list k18, submission_search_object_keywords o19 NATURAL JOIN submission_search_keyword_list k19, submission_search_object_keywords o20 NATURAL JOIN submission_search_keyword_list k20, submission_search_object_keywords o21 NATURAL JOIN submission_search_keyword_list k21, submission_search_object_keywords o22 NATURAL JOIN submission_search_keyword_list k22, submission_search_object_keywords o23 NATURAL JOIN submission_search_keyword_list k23, submission_search_object_keywords o24 NATURAL JOIN submission_search_keyword_list k24, submission_search_object_keywords o25 NATURAL JOIN submission_search_keyword_list k25, submission_search_object_keywords o26 NATURAL JOIN submission_search_keyword_list k26, submission_search_object_keywords o27 NATURAL JOIN submission_search_keyword_list k27, submission_search_object_keywords o28 NATURAL JOIN submission_search_keyword_list k28, submission_search_object_keywords o29 NATURAL JOIN submission_search_keyword_list k29, submission_search_object_keywords o30 NATURAL JOIN submission_search_keyword_list k30, submission_search_object_keywords o31 NATURAL JOIN submission_search_keyword_list k31, submission_search_object_keywords o32 NATURAL JOIN submission_search_keyword_list k32, submission_search_object_keywords o33 NATURAL JOIN submission_search_keyword_list k33, submission_search_object_keywords o34 NATURAL JOIN submission_search_keyword_list k34, submission_search_object_keywords o35 NATURAL JOIN submission_search_keyword_list k35, submission_search_object_keywords o36 NATURAL JOIN submission_search_keyword_list k36, submission_search_object_keywords o37 NATURAL JOIN submission_search_keyword_list k37, submission_search_object_keywords o38 NATURAL JOIN submission_search_keyword_list k38, submission_search_object_keywords o39 NATURAL JOIN submission_search_keyword_list k39, submission_search_object_keywords o40 NATURAL JOIN submission_search_keyword_list k40, submission_search_object_keywords o41 NATURAL JOIN submission_search_keyword_list k41, submission_search_object_keywords o42 NATURAL JOIN submission_search_keyword_list k42, submission_search_object_keywords o43 NATURAL JOIN submission_search_keyword_list k43, submission_search_object_keywords o44 NATURAL JOIN submission_search_keyword_list k44, submission_search_object_keywords o45 NATURAL JOIN submission_search_keyword_list k45, submission_search_object_keywords o46 NATURAL JOIN submission_search_keyword_list k46, submission_search_object_keywords o47 NATURAL JOIN submission_search_keyword_list k47, submission_search_object_keywords o48 NATURAL JOIN submission_search_keyword_list k48, submission_search_object_keywords o49 NATURAL JOIN submission_search_keyword_list k49, submission_search_object_keywords o50 NATURAL JOIN submission_search_keyword_list k50, submission_search_object_keywords o51 NATURAL JOIN submission_search_keyword_list k51, submission_search_object_keywords o52 NATURAL JOIN submission_search_keyword_list k52, submission_search_object_keywords o53 NATURAL JOIN submission_search_keyword_list k53, submission_search_object_keywords o54 NATURAL JOIN submission_search_keyword_list k54, submission_search_object_keywords o55 NATURAL JOIN submission_search_keyword_list k55, submission_search_object_keywords o56 NATURAL JOIN submission_search_keyword_list k56, submission_search_object_keywords o57 NATURAL JOIN submission_search_keyword_list k57, submission_search_object_keywords o58 NATURAL JOIN submission_search_keyword_list k58, submission_search_object_keywords o59 NATURAL JOIN submission_search_keyword_list k59, submission_search_object_keywords o60 NATURAL JOIN submission_search_keyword_list k60, submission_search_object_keywords o61 NATURAL JOIN submission_search_keyword_list k61, submission_search_object_keywords o62 NATURAL JOIN submission_search_keyword_list k62
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 = endülüs AND k1.keyword_text = query AND o0.object_id = o1.object_id AND o0.pos+1 = o1.pos AND k2.keyword_text = endülüs AND o0.object_id = o2.object_id AND o0.pos+2 = o2.pos AND k3.keyword_text = query AND o0.object_id = o3.object_id AND o0.pos+3 = o3.pos AND k4.keyword_text = endülüs AND o0.object_id = o4.object_id AND o0.pos+4 = o4.pos AND k5.keyword_text = query AND o0.object_id = o5.object_id AND o0.pos+5 = o5.pos AND k6.keyword_text = endülüs AND o0.object_id = o6.object_id AND o0.pos+6 = o6.pos AND k7.keyword_text = query AND o0.object_id = o7.object_id AND o0.pos+7 = o7.pos AND k8.keyword_text = endülüs AND o0.object_id = o8.object_id AND o0.pos+8 = o8.pos AND k9.keyword_text = query AND o0.object_id = o9.object_id AND o0.pos+9 = o9.pos AND k10.keyword_text = endülüs AND o0.object_id = o10.object_id AND o0.pos+10 = o10.pos AND k11.keyword_text = query AND o0.object_id = o11.object_id AND o0.pos+11 = o11.pos AND k12.keyword_text = endülüs AND o0.object_id = o12.object_id AND o0.pos+12 = o12.pos AND k13.keyword_text = query AND o0.object_id = o13.object_id AND o0.pos+13 = o13.pos AND k14.keyword_text = endülüs AND o0.object_id = o14.object_id AND o0.pos+14 = o14.pos AND k15.keyword_text = query AND o0.object_id = o15.object_id AND o0.pos+15 = o15.pos AND k16.keyword_text = endülüs AND o0.object_id = o16.object_id AND o0.pos+16 = o16.pos AND k17.keyword_text = query AND o0.object_id = o17.object_id AND o0.pos+17 = o17.pos AND k18.keyword_text = endülüs AND o0.object_id = o18.object_id AND o0.pos+18 = o18.pos AND k19.keyword_text = query AND o0.object_id = o19.object_id AND o0.pos+19 = o19.pos AND k20.keyword_text = endülüs AND o0.object_id = o20.object_id AND o0.pos+20 = o20.pos AND k21.keyword_text = query AND o0.object_id = o21.object_id AND o0.pos+21 = o21.pos AND k22.keyword_text = endülüs AND o0.object_id = o22.object_id AND o0.pos+22 = o22.pos AND k23.keyword_text = query AND o0.object_id = o23.object_id AND o0.pos+23 = o23.pos AND k24.keyword_text = endülüs AND o0.object_id = o24.object_id AND o0.pos+24 = o24.pos AND k25.keyword_text = query AND o0.object_id = o25.object_id AND o0.pos+25 = o25.pos AND k26.keyword_text = endülüs AND o0.object_id = o26.object_id AND o0.pos+26 = o26.pos AND k27.keyword_text = query AND o0.object_id = o27.object_id AND o0.pos+27 = o27.pos AND k28.keyword_text = endülüs AND o0.object_id = o28.object_id AND o0.pos+28 = o28.pos AND k29.keyword_text = query AND o0.object_id = o29.object_id AND o0.pos+29 = o29.pos AND k30.keyword_text = endülüs AND o0.object_id = o30.object_id AND o0.pos+30 = o30.pos AND k31.keyword_text = query AND o0.object_id = o31.object_id AND o0.pos+31 = o31.pos AND k32.keyword_text = endülüs AND o0.object_id = o32.object_id AND o0.pos+32 = o32.pos AND k33.keyword_text = query AND o0.object_id = o33.object_id AND o0.pos+33 = o33.pos AND k34.keyword_text = endülüs AND o0.object_id = o34.object_id AND o0.pos+34 = o34.pos AND k35.keyword_text = query AND o0.object_id = o35.object_id AND o0.pos+35 = o35.pos AND k36.keyword_text = endülüs AND o0.object_id = o36.object_id AND o0.pos+36 = o36.pos AND k37.keyword_text = query AND o0.object_id = o37.object_id AND o0.pos+37 = o37.pos AND k38.keyword_text = endülüs AND o0.object_id = o38.object_id AND o0.pos+38 = o38.pos AND k39.keyword_text = query AND o0.object_id = o39.object_id AND o0.pos+39 = o39.pos AND k40.keyword_text = endülüs AND o0.object_id = o40.object_id AND o0.pos+40 = o40.pos AND k41.keyword_text = query AND o0.object_id = o41.object_id AND o0.pos+41 = o41.pos AND k42.keyword_text = endülüs AND o0.object_id = o42.object_id AND o0.pos+42 = o42.pos AND k43.keyword_text = query AND o0.object_id = o43.object_id AND o0.pos+43 = o43.pos AND k44.keyword_text = endülüs AND o0.object_id = o44.object_id AND o0.pos+44 = o44.pos AND k45.keyword_text = query AND o0.object_id = o45.object_id AND o0.pos+45 = o45.pos AND k46.keyword_text = endülüs AND o0.object_id = o46.object_id AND o0.pos+46 = o46.pos AND k47.keyword_text = query AND o0.object_id = o47.object_id AND o0.pos+47 = o47.pos AND k48.keyword_text = endülüs AND o0.object_id = o48.object_id AND o0.pos+48 = o48.pos AND k49.keyword_text = query AND o0.object_id = o49.object_id AND o0.pos+49 = o49.pos AND k50.keyword_text = endülüs AND o0.object_id = o50.object_id AND o0.pos+50 = o50.pos AND k51.keyword_text = query AND o0.object_id = o51.object_id AND o0.pos+51 = o51.pos AND k52.keyword_text = endülüs AND o0.object_id = o52.object_id AND o0.pos+52 = o52.pos AND k53.keyword_text = query AND o0.object_id = o53.object_id AND o0.pos+53 = o53.pos AND k54.keyword_text = endülüs AND o0.object_id = o54.object_id AND o0.pos+54 = o54.pos AND k55.keyword_text = query AND o0.object_id = o55.object_id AND o0.pos+55 = o55.pos AND k56.keyword_text = endülüs AND o0.object_id = o56.object_id AND o0.pos+56 = o56.pos AND k57.keyword_text = query AND o0.object_id = o57.object_id AND o0.pos+57 = o57.pos AND k58.keyword_text = endülüs AND o0.object_id = o58.object_id AND o0.pos+58 = o58.pos AND k59.keyword_text = query AND o0.object_id = o59.object_id AND o0.pos+59 = o59.pos AND k60.keyword_text = endülüs AND o0.object_id = o60.object_id AND o0.pos+60 = o60.pos AND k61.keyword_text = query AND o0.object_id = o61.object_id AND o0.pos+61 = o61.pos AND k62.keyword_text = endülüs AND o0.object_id = o62.object_id AND o0.pos+62 = o62.pos AND i.journal_id = 6
GROUP BY o.submission_id
ORDER BY count DESC
LIMIT 500) in /home/symposiu/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /home/symposiu/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /home/symposiu/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(456): Illuminate\Database\Connection->run()
#2 /home/symposiu/public_html/classes/search/ArticleSearchDAO.php(113): Illuminate\Database\Connection->cursor()
#3 /home/symposiu/public_html/lib/pkp/classes/search/SubmissionSearch.php(224): APP\search\ArticleSearchDAO->getPhraseResults()
#4 /home/symposiu/public_html/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults()
#5 /home/symposiu/public_html/lib/pkp/classes/search/SubmissionSearch.php(220): PKP\search\SubmissionSearch->_getMergedKeywordResults()
#6 /home/symposiu/public_html/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults()
#7 /home/symposiu/public_html/lib/pkp/classes/search/SubmissionSearch.php(156): PKP\search\SubmissionSearch->_getMergedKeywordResults()
#8 /home/symposiu/public_html/lib/pkp/classes/search/SubmissionSearch.php(289): PKP\search\SubmissionSearch->_getMergedArray()
#9 /home/symposiu/public_html/pages/search/SearchHandler.php(150): PKP\search\SubmissionSearch->retrieveResults()
#10 /home/symposiu/public_html/pages/search/SearchHandler.php(53): APP\pages\search\SearchHandler->search()
#11 [internal function]: APP\pages\search\SearchHandler->index()
#12 /home/symposiu/public_html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func()
#13 /home/symposiu/public_html/lib/pkp/classes/core/PKPPageRouter.php(278): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest()
#14 /home/symposiu/public_html/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route()
#15 /home/symposiu/public_html/lib/pkp/classes/core/PKPApplication.php(395): PKP\core\Dispatcher->dispatch()
#16 /home/symposiu/public_html/index.php(21): PKP\core\PKPApplication->execute()
#17 {main}
thrown in /home/symposiu/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760