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/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115 Stack trace: #0 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute() #1 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(370): Doctrine\DBAL\Driver\PDOStatement->execute() #2 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}() #3 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback() #4 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run() #5 [internal function]: Illuminate\Database\Connection->cursor() #6 /home/u115216531/domains/ijmrr.online/public_html/classes/subscription/InstitutionalSubscriptionDAO.inc.php(487): Generator->current() #7 /home/u115216531/domains/ijmrr.online/public_html/classes/issue/IssueAction.inc.php(138): InstitutionalSubscriptionDAO->isValidInstitutionalSubscription() #8 /home/u115216531/domains/ijmrr.online/public_html/pages/article/ArticleHandler.inc.php(295): IssueAction->subscribedDomain() #9 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/classes/core/PKPRouter.inc.php(395): ArticleHandler->view() #10 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest() #11 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route() #12 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch() #13 /home/u115216531/domains/ijmrr.online/public_html/index.php(68): PKPApplication->execute() #14 {main} Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_bin,NONE) and (utf8mb3_general_ci,IMPLICIT) for operation 'locate' in /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: #0 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): Doctrine\DBAL\Driver\PDO\Exception::new() #1 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(370): Doctrine\DBAL\Driver\PDOStatement->execute() #2 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}() #3 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback() #4 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run() #5 [internal function]: Illuminate\Database\Connection->cursor() #6 /home/u115216531/domains/ijmrr.online/public_html/classes/subscription/InstitutionalSubscriptionDAO.inc.php(487): Generator->current() #7 /home/u115216531/domains/ijmrr.online/public_html/classes/issue/IssueAction.inc.php(138): InstitutionalSubscriptionDAO->isValidInstitutionalSubscription() #8 /home/u115216531/domains/ijmrr.online/public_html/pages/article/ArticleHandler.inc.php(295): IssueAction->subscribedDomain() #9 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/classes/core/PKPRouter.inc.php(395): ArticleHandler->view() #10 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest() #11 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route() #12 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch() #13 /home/u115216531/domains/ijmrr.online/public_html/index.php(68): PKPApplication->execute() #14 {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-18-222-21-222.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-21-222.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.non_expiring = 1) OR (st.non_expiring = 0 AND ('2025-04-19' >= s.date_start AND '2025-04-19' <= s.date_end))) AND (st.format = 1 OR st.format = 17)) in /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671 Stack trace: #0 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback() #1 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run() #2 [internal function]: Illuminate\Database\Connection->cursor() #3 /home/u115216531/domains/ijmrr.online/public_html/classes/subscription/InstitutionalSubscriptionDAO.inc.php(487): Generator->current() #4 /home/u115216531/domains/ijmrr.online/public_html/classes/issue/IssueAction.inc.php(138): InstitutionalSubscriptionDAO->isValidInstitutionalSubscription() #5 /home/u115216531/domains/ijmrr.online/public_html/pages/article/ArticleHandler.inc.php(295): IssueAction->subscribedDomain() #6 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/classes/core/PKPRouter.inc.php(395): ArticleHandler->view() #7 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest() #8 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route() #9 /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch() #10 /home/u115216531/domains/ijmrr.online/public_html/index.php(68): PKPApplication->execute() #11 {main} thrown in /home/u115216531/domains/ijmrr.online/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671