Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_bin,NONE) and (utf8mb3_general_ci,IMPLICIT) for operation 'locate' in /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:453 Stack trace: #0 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(453): PDOStatement->execute() #1 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #3 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(456): Illuminate\Database\Connection->run() #4 [internal function]: Illuminate\Database\Connection->cursor() #5 /home/u509201790/domains/irjaeh.com/public_html/classes/subscription/InstitutionalSubscriptionDAO.php(515): Generator->current() #6 /home/u509201790/domains/irjaeh.com/public_html/classes/issue/IssueAction.php(153): APP\subscription\InstitutionalSubscriptionDAO->isValidInstitutionalSubscription() #7 /home/u509201790/domains/irjaeh.com/public_html/pages/article/ArticleHandler.php(541): APP\issue\IssueAction->subscribedDomain() #8 /home/u509201790/domains/irjaeh.com/public_html/pages/article/ArticleHandler.php(241): APP\pages\article\ArticleHandler->userCanViewGalley() #9 [internal function]: APP\pages\article\ArticleHandler->view() #10 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func() #11 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/PKPPageRouter.php(277): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #12 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route() #13 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/PKPApplication.php(388): PKP\core\Dispatcher->dispatch() #14 /home/u509201790/domains/irjaeh.com/public_html/index.php(21): PKP\core\PKPApplication->execute() #15 {main} Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_bin,NONE) and (utf8mb3_general_ci,IMPLICIT) for operation 'locate' (SQL: SELECT iss.subscription_id FROM institutional_subscriptions iss JOIN subscriptions s ON (iss.subscription_id = s.subscription_id) JOIN subscription_types st ON (s.type_id = st.type_id) WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD(ec2-3-146-37-183.us-east-2.compute.amazonaws.com, LENGTH(ec2-3-146-37-183.us-east-2.compute.amazonaws.com)+1, '.'))) != 0 AND iss.domain != '' AND s.journal_id = 1 AND s.status = 1 AND st.institutional = 1 AND ((st.duration IS NULL) OR (st.duration IS NOT NULL AND ('2025-04-29' BETWEEN s.date_start AND s.date_end))) AND (st.format = 1 OR st.format = 17)) in /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760 Stack trace: #0 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #1 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(456): Illuminate\Database\Connection->run() #2 [internal function]: Illuminate\Database\Connection->cursor() #3 /home/u509201790/domains/irjaeh.com/public_html/classes/subscription/InstitutionalSubscriptionDAO.php(515): Generator->current() #4 /home/u509201790/domains/irjaeh.com/public_html/classes/issue/IssueAction.php(153): APP\subscription\InstitutionalSubscriptionDAO->isValidInstitutionalSubscription() #5 /home/u509201790/domains/irjaeh.com/public_html/pages/article/ArticleHandler.php(541): APP\issue\IssueAction->subscribedDomain() #6 /home/u509201790/domains/irjaeh.com/public_html/pages/article/ArticleHandler.php(241): APP\pages\article\ArticleHandler->userCanViewGalley() #7 [internal function]: APP\pages\article\ArticleHandler->view() #8 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func() #9 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/PKPPageRouter.php(277): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #10 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route() #11 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/PKPApplication.php(388): PKP\core\Dispatcher->dispatch() #12 /home/u509201790/domains/irjaeh.com/public_html/index.php(21): PKP\core\PKPApplication->execute() #13 {main} thrown in /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760