Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8mb3' in /home/u946665550/domains/ijomcr.net/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:453
Stack trace:
#0 /home/u946665550/domains/ijomcr.net/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(453): PDOStatement->execute()
#1 /home/u946665550/domains/ijomcr.net/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /home/u946665550/domains/ijomcr.net/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /home/u946665550/domains/ijomcr.net/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/u946665550/domains/ijomcr.net/public_html/classes/subscription/InstitutionalSubscriptionDAO.php(550): Generator->current()
#6 /home/u946665550/domains/ijomcr.net/public_html/classes/issue/IssueAction.php(153): APP\subscription\InstitutionalSubscriptionDAO->isValidInstitutionalSubscription()
#7 /home/u946665550/domains/ijomcr.net/public_html/pages/issue/IssueHandler.php(394): APP\issue\IssueAction->subscribedDomain()
#8 /home/u946665550/domains/ijomcr.net/public_html/pages/index/IndexHandler.php(80): APP\pages\issue\IssueHandler::_setupIssueTemplate()
#9 [internal function]: APP\pages\index\IndexHandler->index()
#10 /home/u946665550/domains/ijomcr.net/public_html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func()
#11 /home/u946665550/domains/ijomcr.net/public_html/lib/pkp/classes/core/PKPPageRouter.php(278): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest()
#12 /home/u946665550/domains/ijomcr.net/public_html/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route()
#13 /home/u946665550/domains/ijomcr.net/public_html/lib/pkp/classes/core/PKPApplication.php(395): PKP\core\Dispatcher->dispatch()
#14 /home/u946665550/domains/ijomcr.net/public_html/index.php(21): PKP\core\PKPApplication->execute()
#15 {main}
Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8mb3' (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 COLLATE utf8mb4_general_ci, LENGTH(iss.domain)+1, '.'))
IN
UPPER(LPAD(18-97-14-91.crawl.commoncrawl.org COLLATE utf8mb4_general_ci, LENGTH(18-97-14-91.crawl.commoncrawl.org)+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-21' BETWEEN s.date_start AND s.date_end)))
AND (st.format = 1
OR st.format = 17)) in /home/u946665550/domains/ijomcr.net/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /home/u946665550/domains/ijomcr.net/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /home/u946665550/domains/ijomcr.net/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/u946665550/domains/ijomcr.net/public_html/classes/subscription/InstitutionalSubscriptionDAO.php(550): Generator->current()
#4 /home/u946665550/domains/ijomcr.net/public_html/classes/issue/IssueAction.php(153): APP\subscription\InstitutionalSubscriptionDAO->isValidInstitutionalSubscription()
#5 /home/u946665550/domains/ijomcr.net/public_html/pages/issue/IssueHandler.php(394): APP\issue\IssueAction->subscribedDomain()
#6 /home/u946665550/domains/ijomcr.net/public_html/pages/index/IndexHandler.php(80): APP\pages\issue\IssueHandler::_setupIssueTemplate()
#7 [internal function]: APP\pages\index\IndexHandler->index()
#8 /home/u946665550/domains/ijomcr.net/public_html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func()
#9 /home/u946665550/domains/ijomcr.net/public_html/lib/pkp/classes/core/PKPPageRouter.php(278): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest()
#10 /home/u946665550/domains/ijomcr.net/public_html/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route()
#11 /home/u946665550/domains/ijomcr.net/public_html/lib/pkp/classes/core/PKPApplication.php(395): PKP\core\Dispatcher->dispatch()
#12 /home/u946665550/domains/ijomcr.net/public_html/index.php(21): PKP\core\PKPApplication->execute()
#13 {main}
thrown in /home/u946665550/domains/ijomcr.net/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760