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/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119
Stack trace:
#0 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): PDOStatement->execute()
#1 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(370): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(352): Illuminate\Database\Connection->run()
#5 [internal function]: Illuminate\Database\Connection->cursor()
#6 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/classes/subscription/InstitutionalSubscriptionDAO.inc.php(487): Generator->current()
#7 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/classes/issue/IssueAction.inc.php(138): InstitutionalSubscriptionDAO->isValidInstitutionalSubscription()
#8 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/pages/article/ArticleHandler.inc.php(473): IssueAction->subscribedDomain()
#9 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/pages/article/ArticleHandler.inc.php(212): ArticleHandler->userCanViewGalley()
#10 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/classes/core/PKPRouter.inc.php(397): ArticleHandler->view()
#11 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest()
#12 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route()
#13 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/classes/core/PKPApplication.inc.php(360): Dispatcher->dispatch()
#14 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/index.php(68): PKPApplication->execute()
#15 {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/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(121): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(370): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(352): Illuminate\Database\Connection->run()
#5 [internal function]: Illuminate\Database\Connection->cursor()
#6 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/classes/subscription/InstitutionalSubscriptionDAO.inc.php(487): Generator->current()
#7 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/classes/issue/IssueAction.inc.php(138): InstitutionalSubscriptionDAO->isValidInstitutionalSubscription()
#8 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/pages/article/ArticleHandler.inc.php(473): IssueAction->subscribedDomain()
#9 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/pages/article/ArticleHandler.inc.php(212): ArticleHandler->userCanViewGalley()
#10 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/classes/core/PKPRouter.inc.php(397): ArticleHandler->view()
#11 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest()
#12 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route()
#13 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/classes/core/PKPApplication.inc.php(360): Dispatcher->dispatch()
#14 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/index.php(68): 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-18-227-21-218.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-227-21-218.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 ('2025-04-26' >= s.date_start AND '2025-04-26' <= s.date_end))
AND (st.format = 1
OR st.format = 17)) in /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
Stack trace:
#0 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#1 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(352): Illuminate\Database\Connection->run()
#2 [internal function]: Illuminate\Database\Connection->cursor()
#3 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/classes/subscription/InstitutionalSubscriptionDAO.inc.php(487): Generator->current()
#4 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/classes/issue/IssueAction.inc.php(138): InstitutionalSubscriptionDAO->isValidInstitutionalSubscription()
#5 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/pages/article/ArticleHandler.inc.php(473): IssueAction->subscribedDomain()
#6 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/pages/article/ArticleHandler.inc.php(212): ArticleHandler->userCanViewGalley()
#7 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/classes/core/PKPRouter.inc.php(397): ArticleHandler->view()
#8 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest()
#9 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route()
#10 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/classes/core/PKPApplication.inc.php(360): Dispatcher->dispatch()
#11 /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/index.php(68): PKPApplication->execute()
#12 {main}
thrown in /home/u615763688/domains/sennosbiotech.com/public_html/JIMP/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671