Upgrade error from 3.1.2.1 to 3.2.0-1

Hi all and @asmecher
While upgrading to ojs lates version, I received failed message:

An error occurred during the installation

A database error has occurred: incorrect string value: “\Xd8\xaa\xd9\x82\xd8\daf…”for column “database name. email_templates_settings. Setting value at row 13

Current version ojs: 3.1.2.1

Server Information

Setting Name Setting Value
OS platform Linux
PHP version 7.2.29
Apache version Apache
Database driver mysqli
Database server version 10.3.22-MariaDB
database
driver mysqli
host localhost
i18n
locale en_US
client_charset utf-8
connection_charset utf8
database_charset utf8
security
force_ssl On
force_login_ssl On
session_check_ip On
encryption sha1

I have rolled back my installation from the backup. The front end I don’t see any problem, yet in the editor dashboard, when I click on any submission it shows the following message in bold at the top

##publication.status.published## ##publication.status.scheduled## Declined {{ submission.id }} / {{ currentPublication.authorsStringShort }} / {{ localizeSubmission(currentPublication.fullTitle, currentPublication.locale) }}

and the wheel is spinning. Please help me to restore. It is urgent.
Thanks and look forward to your help.
Capture

In my current version of OJS 3.1.2.1 (which I rolled back after failed upgrade)
I could not find the table name " email_templates_settings" but
I did a fresh installation of ojs 3.2.0-1 on another test domain which is successful. And I found “email_templates_settings” table in the database as well.
Please help me… thanks

I have searched the forum and tried all suggestions
1- Hard refresh the browser suggested here: No Vue of the type WorkflowContainer could be found - #3 by orangedev
Looking for help…

Hi
@asmecher @astevens @NateWr

Although, I am not getting any response from the forum, yet I am searching the forum for possible solutions and lead. I Once again found a lead from this thread Update OMP and OJS database using tools/update.php
and came with the following findings:

In my config.inc.php, following are my settings:
[i18n]

; Default locale
locale = en_US

; Client output/input character set
client_charset = utf-8

; Database connection character set
; Must be set to “Off” if not supported by the database server
; If enabled, must be the same character set as “client_charset”
; (although the actual name may differ slightly depending on the server)
connection_charset = utf8

; Database storage character set
; Must be set to “Off” if not supported by the database server
database_charset = utf8

But when I run the following query in mysql ojs database:
SELECT default_character_set_name FROM information_schema.SCHEMATA WHERE schema_name = “seisense”
default_character_set_name: latin1

SELECT character_set_name FROM information_schema.columns WHERE table_schema=‘seisense’ AND table_name=‘email_templates_default_data’ AND column_name=‘subject’
character_set_name: utf8

SELECT @@character_set_database, @@collation_database
@@character_set_database @@collation_database
utf8 utf8_general_ci

What does that mean? Is this the reason, my upgrade was failed and throw the following error:
A database error has occurred: incorrect string value: “\Xd8\xaa\xd9\x82\xd8\daf…”for column “database name. email_templates_settings. Setting value at row 13

Sorry for my little knowledge of programming and databases. So, I asked you to help me out…
Waiting for your reply.

Hi @seisense,

SELECT default_character_set_name FROM information_schema.SCHEMATA WHERE schema_name = “seisense”
**default_character_set_name: latin1**

This shows that you have the database in latin encoding, although your explicit table is in utf-8

Have you tried this script, after you did a mysql backup using mysqldump ?

Let us know, if the problem still persists after a conversion?

2 Likes

Thanks @Dulip_Withanage. After running the script, ojs is successfuly updated without any error.

1 Like

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

Hi @seisense,

For now, disable the “Recommend By Author” plugin. See Fatal error in RecommendByAuthor plugin · Issue #5683 · pkp/pkp-lib · GitHub for details. This will be fixed in the OJS 3.2.0-2 release (coming soon).

Regards,
Alec Smecher
Public Knowledge Project Team

Thanks @asmecher for prompt reply.
I have disabled the Recommend by author plugin yet I am not able to schedule publication. Now php code is as below:

[06-Apr-2020 19:31:27 UTC] PHP Warning: Declaration of JatsTemplatePlugin::register($category, $path) should be compatible with LazyLoadPlugin::register($category, $path, $mainContextId = NULL) in /home/seisense/journal.seisense.com/plugins/generic/jatsTemplate/JatsTemplatePlugin.inc.php on line 0
[06-Apr-2020 19:31:27 UTC] PHP Warning: Declaration of TexturePlugin::register($category, $path) should be compatible with LazyLoadPlugin::register($category, $path, $mainContextId = NULL) in /home/seisense/journal.seisense.com/plugins/generic/texture/TexturePlugin.inc.php on line 0
[06-Apr-2020 19:31:28 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.

Hi @seisense,

See DB Error in OJS 3.2.0.0 - illegal mix of collations. We try to use this forum to build a knowledge base for users who encounter similar problems, so it’s best to post multiple questions under their own topics – searching first to make sure they aren’t answered elsewhere.

Thanks,
Alec Smecher
Public Knowledge Project Team

1 Like

@asmecher Sorry for posting an illegal mix of collations question here. But firstly,
I started implementing the solution offered in this post by @Dulip_Withanage, so as a follow up I continued with the same thread to update on what happened after the solution implemented.

Your quick reply and lead ( DB Error in OJS 3.2.0.0 - an illegal mix of collations) helped me to solve my database issue. I have changed database, tables /columns collation to chf8_general_ci and I can schedule the publication now.

I have another question but I 'll post it in another post.
Thanks once again for your support.

1 Like

We had a similar issue to this. Upgraded - no error message but site disappeared (rather disconcerting) until used the Restore option. Seemed to be fine but now get the same problem as seisense in the editor dashboard when clicking on any submission ie get this message:

##publication.status.published## ##publication.status.scheduled## Declined {{ submission.id }} / {{ currentPublication.authorsStringShort }} / {{ localizeSubmission(currentPublication.fullTitle, currentPublication.locale) }}

What is this error message pointing to as the problem?

Is PHP version important? As part of the upgrade it said you could upgrade to 7.2 (from memory) The error log has many PHP Deprecated entries

Dulip - do you think that script you mentioned would be relevant here as didn’t get the same error message as seisense?

We are also very keen to solve this as have a publication deadline so help very much appreciated thanks