Hi @Dulip_Withanage, @asmecher , @NateWr
I thought it is all ok. Today, when i try to publish an article, it gives me the error message “unexpected error occurred. you might have been logged out. please try again later. …”
So, i checked my PHP error log. and found the following ( Change in database charset has created problem. please suggest what to do now.
[06-Apr-2020 18:26:37 UTC] PHP Deprecated: Non-static method PKPApplication::getRequest() should not be called statically in /home/seisense/journal.seisense.com/plugins/generic/customHeader/CustomHeaderPlugin.inc.php on line 112
[06-Apr-2020 18:27:09 UTC] PHP Deprecated: Non-static method PKPApplication::getRequest() should not be called statically in /home/seisense/journal.seisense.com/plugins/generic/customHeader/CustomHeaderPlugin.inc.php on line 112
[06-Apr-2020 18:27:10 UTC] PHP Fatal error: Uncaught Error: Call to a member function getPublished() on null in /home/seisense/journal.seisense.com/classes/search/ArticleSearch.inc.php:278
Stack trace:
#0 /home/seisense/journal.seisense.com/plugins/generic/recommendByAuthor/RecommendByAuthorPlugin.inc.php(137): ArticleSearch->formatResults(Array)
#1 /home/seisense/journal.seisense.com/lib/pkp/classes/plugins/HookRegistry.inc.php(107): RecommendByAuthorPlugin->callbackTemplateArticlePageFooter(‘Templates::Arti…’, Array)
#2 /home/seisense/journal.seisense.com/lib/pkp/classes/template/PKPTemplateManager.inc.php(1237): HookRegistry::call(‘Templates::Arti…’, Array)
#3 /home/seisense/journal.seisense.com/cache/t_compile/d184190238979e9322d6f49b1b393713c9f3c084^1c372c95cd85572e0fbc9a53d0323a0b229cfc78_0.app.frontendpagesarticle.tpl.php(43): PKPTemplateManager->smartyCallHook(Array, Object(Smarty_Internal_Template))
#4 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_5e8b19 in /home/seisense/journal.seisense.com/classes/search/ArticleSearch.inc.php on line 278
[06-Apr-2020 18:27:36 UTC] Slim Application Error:
Type: Exception
Message: DB Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’ Query: SELECT i.*
FROM issues i,
submissions a
LEFT JOIN publications p ON (p.publication_id = a.current_publication_id)
LEFT JOIN publication_settings ps ON (ps.publication_id = p.publication_id)
WHERE ps.setting_name = ? AND ps.setting_value = CAST(i.issue_id as CHAR) AND
a.submission_id = ? AND
a.context_id = i.journal_id
File: /home/seisense/journal.seisense.com/lib/pkp/classes/db/DAO.inc.php
Line: 703
Trace: #0 /home/seisense/journal.seisense.com/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_mysqli), ‘SELECT\ti.\n\t\t\tF…’)
#1 /home/seisense/journal.seisense.com/classes/issue/IssueDAO.inc.php(569): DAO->retrieve('SELECT\ti.\n\t\t\tF…’, Array)
#2 /home/seisense/journal.seisense.com/classes/submission/Submission.inc.php(86): IssueDAO->getBySubmissionId(343)
#3 /home/seisense/journal.seisense.com/lib/pkp/classes/services/PKPPublicationService.inc.php(572): Submission->_getContextLicenseFieldValue(NULL, 3, Object(Publication))
#4 /home/seisense/journal.seisense.com/lib/pkp/api/v1/submissions/PKPSubmissionHandler.inc.php(743): PKP\Services\PKPPublicationService->publish(Object(Publication))
#5 [internal function]: PKPSubmissionHandler->publishPublication(Object(Slim\Http\Request), Object(APIResponse), Array)
#6 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func(Array, Object(Slim\Http\Request), Object(APIResponse), Array)
#7 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(281): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Slim\Http\Request), Object(APIResponse), Array)
#8 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->__invoke(Object(Slim\Http\Request), Object(APIResponse))
#9 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(268): Slim\Route->callMiddlewareStack(Object(Slim\Http\Request), Object(APIResponse))
#10 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/App.php(503): Slim\Route->run(Object(Slim\Http\Request), Object(APIResponse))
#11 /home/seisense/journal.seisense.com/lib/pkp/classes/security/authorization/internal/ApiAuthorizationMiddleware.inc.php(76): Slim\App->__invoke(Object(Slim\Http\Request), Object(APIResponse))
#12 [internal function]: ApiAuthorizationMiddleware->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Slim\App))
#13 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiAuthorizationMiddleware), Array)
#14 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Slim\App))
#15 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Slim\App))
#16 /home/seisense/journal.seisense.com/lib/pkp/classes/security/authorization/internal/ApiCsrfMiddleware.inc.php(46): Slim\App->Slim{closure}(Object(Slim\Http\Request), Object(APIResponse))
#17 [internal function]: ApiCsrfMiddleware->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#18 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiCsrfMiddleware), Array)
#19 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#20 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#21 /home/seisense/journal.seisense.com/lib/pkp/classes/security/authorization/internal/ApiTokenDecodingMiddleware.inc.php(82): Slim\App->Slim{closure}(Object(Slim\Http\Request), Object(APIResponse))
#22 [internal function]: ApiTokenDecodingMiddleware->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#23 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiTokenDecodingMiddleware), Array)
#24 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#25 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#26 /home/seisense/journal.seisense.com/lib/pkp/classes/handler/APIHandler.inc.php(68): Slim\App->Slim{closure}(Object(Slim\Http\Request), Object(APIResponse))
#27 [internal function]: APIHandler->{closure}(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#28 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#29 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#30 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#31 /home/seisense/journal.seisense.com/lib/pkp/classes/handler/APIHandler.inc.php(127): Slim\App->Slim{closure}(Object(Slim\Http\Request), Object(APIResponse))
#32 [internal function]: APIHandler->{closure}(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#33 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#34 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#35 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#36 /home/seisense/journal.seisense.com/lib/pkp/classes/handler/APIHandler.inc.php(132): Slim\App->Slim{closure}(Object(Slim\Http\Request), Object(APIResponse))
#37 [internal function]: APIHandler->{closure}(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#38 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#39 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#40 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#41 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim{closure}(Object(Slim\Http\Request), Object(APIResponse))
#42 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/App.php(392): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(APIResponse))
#43 /home/seisense/journal.seisense.com/lib/pkp/classes/handler/APIHandler.inc.php(124): Slim\App->process(Object(Slim\Http\Request), Object(APIResponse))
#44 [internal function]: APIHandler->{closure}(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#45 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#46 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#47 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#48 /home/seisense/journal.seisense.com/lib/pkp/classes/handler/APIHandler.inc.php(132): Slim\App->Slim{closure}(Object(Slim\Http\Request), Object(APIResponse))
#49 [internal function]: APIHandler->{closure}(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#50 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)
#51 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#52 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Closure))
#53 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim{closure}(Object(Slim\Http\Request), Object(APIResponse))
#54 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/App.php(392): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(APIResponse))
#55 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/slim/slim/Slim/App.php(297): Slim\App->process(Object(Slim\Http\Request), Object(APIResponse))
#56 /home/seisense/journal.seisense.com/lib/pkp/classes/core/APIRouter.inc.php(115): Slim\App->run()
#57 /home/seisense/journal.seisense.com/lib/pkp/classes/core/Dispatcher.inc.php(143): APIRouter->route(Object(Request))
#58 /home/seisense/journal.seisense.com/lib/pkp/classes/core/PKPApplication.inc.php(278): Dispatcher->dispatch(Object(Request))
#59 /home/seisense/journal.seisense.com/index.php(68): PKPApplication->execute()
#60 {main}
View in rendered output by enabling the “displayErrorDetails” setting.
Thanks