500 Internal Server Error While Scheduling an article for Publication

Software Support
1

Hi Everyone!
For quite some time, an annoying problem is causing us a lot of difficulties. Whenever we try to upload and publish an article using Quick submit plugin, we get 500 Internal Server Error. If we do not schedule it for publication and save the details it saves fine. but when we try to schedule an article for publication, we get 500 internal server error. on using developer tab and inspect element, following error was noted:
Contents of the log file are as below:
> [Wed Sep 23 06:14:39.420700 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #54 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/App.php(392): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
> [Wed Sep 23 06:14:39.420706 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #55 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/App.php(297): Slim\App->process(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
> [Wed Sep 23 06:14:39.420711 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #56 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/core/APIRouter.inc.php(115): Slim\App->run(), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
> [Wed Sep 23 06:14:39.420716 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #57 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/core/Dispatcher.inc.php(143): APIRouter->route(Object(Request)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
> [Wed Sep 23 06:14:39.420722 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #58 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/core/PKPApplication.inc.php(278): Dispatcher->dispatch(Object(Request)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
> [Wed Sep 23 06:14:39.420736 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #59 /var/www/clients/client0/web1/web/journal/index.php(68): PKPApplication->execute(), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
> [Wed Sep 23 06:14:39.420741 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #60 {main}, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
> [Wed Sep 23 06:14:39.420746 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: View in rendered output by enabling the “displayErrorDetails” setting., referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
> [Wed Sep 23 06:15:11.460861 2020] [fcgid:warn] [pid 14408] (32)Broken pipe: [client 185.191.171.2:36934] mod_fcgid: ap_pass_brigade failed in handle_request_ipc function
> [Wed Sep 23 06:15:19.677274 2020] [fcgid:warn] [pid 14358] [client 185.191.171.16:19880] mod_fcgid: stderr: PHP Notice: Undefined property: stdClass::$lastModified in /var/www/clients/client0/web1/web/journal/lib/pkp/classes/db/SchemaDAO.inc.php on line 235
> [Wed Sep 23 06:15:19.677316 2020] [fcgid:warn] [pid 14358] [client 185.191.171.16:19880] mod_fcgid: stderr: PHP Notice: Trying to get property ‘type’ of non-object in /var/www/clients/client0/web1/web/journal/lib/pkp/classes/db/SchemaDAO.inc.php on line 235
> [Wed Sep 23 06:15:51.962795 2020] [fcgid:warn] [pid 14284] (32)Broken pipe: [client 185.191.171.24:22348] mod_fcgid: ap_pass_brigade failed in handle_request_ipc function
> [Wed Sep 23 06:16:04.699505 2020] [fcgid:warn] [pid 14282] [client 114.119.155.115:11872] mod_fcgid: stderr: PHP Notice: Undefined property: stdClass::$lastModified in /var/www/clients/client0/web1/web/journal/lib/pkp/classes/db/SchemaDAO.inc.php on line 235
> [Wed Sep 23 06:16:04.699552 2020] [fcgid:warn] [pid 14282] [client 114.119.155.115:11872] mod_fcgid: stderr: PHP Notice: Trying to get property ‘type’ of non-object in /var/www/clients/client0/web1/web/journal/lib/pkp/classes/db/SchemaDAO.inc.php on line 235
ojs2 ojs1

Please help us in solving this issue because we are far behind our schedule to publish our next issue. I shall be grateful for any prompt helpt and support.
@ajnyga @asmecher @Vitaliy

2

Hi @Farhan_Abbas,

It looks like there’s a long stack trace that you’ve partially quoted, but the top of it (the actual error message) is left out. Can you check again and make sure to grab the top of the fatal error listing that’s associated with the 500 error you’re reporting?

Regards,
Alec Smecher
Public Knowledge Project Team

3

@asmecher
Here is the complete log file.

[Wed Sep 23 06:14:01.745811 2020] [fcgid:warn] [pid 14356] [client 114.119.155.88:50928] mod_fcgid: stderr: PHP Notice: Undefined property: stdClass::$lastModified in /var/www/clients/client0/web1/web/journal/lib/pkp/classes/db/SchemaDAO.inc.php on line 235
[Wed Sep 23 06:14:01.745862 2020] [fcgid:warn] [pid 14356] [client 114.119.155.88:50928] mod_fcgid: stderr: PHP Notice: Trying to get property ‘type’ of non-object in /var/www/clients/client0/web1/web/journal/lib/pkp/classes/db/SchemaDAO.inc.php on line 235
[Wed Sep 23 06:14:39.419833 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: Slim Application Error:, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419872 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: Type: Exception, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419876 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: Message: DB Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’ Query: SELECT\ti., referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419879 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: \t\t\tFROM\tissues i, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419882 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: \t\t\t\tsubmissions a, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419885 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: \t\t\tLEFT JOIN publications p ON (p.publication_id = a.current_publication_id), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419887 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: \t\t\tLEFT JOIN publication_settings ps ON (ps.publication_id = p.publication_id), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419890 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: \t\t\tWHERE\tps.setting_name = ? AND ps.setting_value = CAST(i.issue_id as CHAR) AND, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419893 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: \t\t\t\ta.submission_id = ? AND, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419895 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: \t\t\t\ta.context_id = i.journal_id, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419898 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: File: /var/www/clients/client0/web1/web/journal/lib/pkp/classes/db/DAO.inc.php, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419906 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: Line: 703, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419909 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: Trace: #0 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_mysqli), 'SELECT\ti.\n\t\t\tF…’), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419912 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #1 /var/www/clients/client0/web1/web/journal/classes/issue/IssueDAO.inc.php(569): DAO->retrieve(‘SELECT\ti.*\n\t\t\tF…’, Array), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419914 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #2 /var/www/clients/client0/web1/web/journal/classes/submission/Submission.inc.php(86): IssueDAO->getBySubmissionId(3896), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419917 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #3 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/services/PKPPublicationService.inc.php(572): Submission->_getContextLicenseFieldValue(NULL, 3, Object(Publication)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419920 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #4 /var/www/clients/client0/web1/web/journal/lib/pkp/api/v1/submissions/PKPSubmissionHandler.inc.php(743): PKP\Services\PKPPublicationService->publish(Object(Publication)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419923 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #5 [internal function]: PKPSubmissionHandler->publishPublication(Object(Slim\Http\Request), Object(APIResponse), Array), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419925 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #6 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func(Array, Object(Slim\Http\Request), Object(APIResponse), Array), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419928 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #7 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(281): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Slim\Http\Request), Object(APIResponse), Array), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419931 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #8 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->__invoke(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419934 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #9 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(268): Slim\Route->callMiddlewareStack(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419937 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #10 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/App.php(503): Slim\Route->run(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419943 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #11 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/security/authorization/internal/ApiAuthorizationMiddleware.inc.php(76): Slim\App->__invoke(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419946 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #12 [internal function]: ApiAuthorizationMiddleware->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Slim\App)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419949 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #13 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiAuthorizationMiddleware), Array), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419951 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #14 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Slim\App)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419954 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #15 /var/www/clients/client0/web1/web/journal/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)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419957 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #16 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/security/authorization/internal/ApiCsrfMiddleware.inc.php(46): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419960 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #17 [internal function]: ApiCsrfMiddleware->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419963 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #18 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiCsrfMiddleware), Array), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419965 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #19 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419968 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #20 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419971 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #21 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/security/authorization/internal/ApiTokenDecodingMiddleware.inc.php(82): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419977 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #22 [internal function]: ApiTokenDecodingMiddleware->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419980 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #23 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiTokenDecodingMiddleware), Array), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419982 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #24 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419985 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #25 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419988 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #26 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/handler/APIHandler.inc.php(68): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419991 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #27 [internal function]: APIHandler->{closure}(Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419993 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #28 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419996 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #29 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.419999 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #30 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420002 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #31 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/handler/APIHandler.inc.php(127): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420004 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #32 [internal function]: APIHandler->{closure}(Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420007 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #33 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420013 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #34 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420015 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #35 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420018 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #36 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/handler/APIHandler.inc.php(132): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420021 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #37 [internal function]: APIHandler->{closure}(Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420024 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #38 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420026 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #39 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420029 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #40 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420032 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #41 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420035 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #42 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/App.php(392): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420038 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #43 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/handler/APIHandler.inc.php(124): Slim\App->process(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420040 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #44 [internal function]: APIHandler->{closure}(Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420043 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #45 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closur, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420628 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: p/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420664 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #48 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/handler/APIHandler.inc.php(132): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420671 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #49 [internal function]: APIHandler->{closure}(Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420677 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #50 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420682 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #51 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420688 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #52 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Closure)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420694 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #53 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420700 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #54 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/App.php(392): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420706 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #55 /var/www/clients/client0/web1/web/journal/lib/pkp/lib/vendor/slim/slim/Slim/App.php(297): Slim\App->process(Object(Slim\Http\Request), Object(APIResponse)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420711 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #56 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/core/APIRouter.inc.php(115): Slim\App->run(), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420716 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #57 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/core/Dispatcher.inc.php(143): APIRouter->route(Object(Request)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420722 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #58 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/core/PKPApplication.inc.php(278): Dispatcher->dispatch(Object(Request)), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420736 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #59 /var/www/clients/client0/web1/web/journal/index.php(68): PKPApplication->execute(), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420741 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: #60 {main}, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:14:39.420746 2020] [fcgid:warn] [pid 14358] [client 103.4.94.173:4290] mod_fcgid: stderr: View in rendered output by enabling the “displayErrorDetails” setting., referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Wed Sep 23 06:15:11.460861 2020] [fcgid:warn] [pid 14408] (32)Broken pipe: [client 185.191.171.2:36934] mod_fcgid: ap_pass_brigade failed in handle_request_ipc function
[Wed Sep 23 06:15:19.677274 2020] [fcgid:warn] [pid 14358] [client 185.191.171.16:19880] mod_fcgid: stderr: PHP Notice: Undefined property: stdClass::$lastModified in /var/www/clients/client0/web1/web/journal/lib/pkp/classes/db/SchemaDAO.inc.php on line 235
[Wed Sep 23 06:15:19.677316 2020] [fcgid:warn] [pid 14358] [client 185.191.171.16:19880] mod_fcgid: stderr: PHP Notice: Trying to get property ‘type’ of non-object in /var/www/clients/client0/web1/web/journal/lib/pkp/classes/db/SchemaDAO.inc.php on line 235
[Wed Sep 23 06:15:51.962795 2020] [fcgid:warn] [pid 14284] (32)Broken pipe: [client 185.191.171.24:22348] mod_fcgid: ap_pass_brigade failed in handle_request_ipc function

4

Hi @Farhan_Abbas,

The relevant error message looks to be…

DB Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’

There are a few threads discussing this, with advice; I’d suggest checking those out.

Regards,
Alec Smecher
Public Knowledge Project Team

5

Ok, can you please provide any useful links in this regard? As I am badly stuck and there is a lot of pressure from administration due to delayed publications…
Regards,

6

Dear @asmecher !
As per your indication, I checked and fixed the collation problem and unified all of them. But the error/Problem is still there… and perhaps you ignored something important in my details that I keep on receiving “{“error”:“api.404.endpointNotFound”,“errorMessage”:“The requested URL was not recognized.”}” when I check Console/Network component and click on the Internal Server Error. Please look into this and guide accordingly…
Regards,

7

Dear @asmecher waiting for any help in this regard… :frowning:
Regards,
Farhan Abbas

8

Hi @Farhan_Abbas,

Are you still seeing the collations error in the PHP error log? Is something else appearing there instead?

Regards,
Alec Smecher
Public Knowledge Project Team

9

Surprisingly enough, yes I am still getting DB collation error in my log file although I have updated the collations of all tables to same ut8_unicode_ci… I do not know why I am still getting this error:
[Mon Sep 28 00:13:40.132308 2020] [fcgid:warn] [pid 21859] [client 103.4.94.173:4194] mod_fcgid: stderr: Slim Application Error:, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Mon Sep 28 00:13:40.132356 2020] [fcgid:warn] [pid 21859] [client 103.4.94.173:4194] mod_fcgid: stderr: Type: Exception, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Mon Sep 28 00:13:40.132362 2020] [fcgid:warn] [pid 21859] [client 103.4.94.173:4194] mod_fcgid: stderr: Message: DB Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’ Query: SELECT\ti., referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Mon Sep 28 00:13:40.132367 2020] [fcgid:warn] [pid 21859] [client 103.4.94.173:4194] mod_fcgid: stderr: \t\t\tFROM\tissues i, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Mon Sep 28 00:13:40.132372 2020] [fcgid:warn] [pid 21859] [client 103.4.94.173:4194] mod_fcgid: stderr: \t\t\t\tsubmissions a, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Mon Sep 28 00:13:40.132376 2020] [fcgid:warn] [pid 21859] [client 103.4.94.173:4194] mod_fcgid: stderr: \t\t\tLEFT JOIN publications p ON (p.publication_id = a.current_publication_id), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Mon Sep 28 00:13:40.132381 2020] [fcgid:warn] [pid 21859] [client 103.4.94.173:4194] mod_fcgid: stderr: \t\t\tLEFT JOIN publication_settings ps ON (ps.publication_id = p.publication_id), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Mon Sep 28 00:13:40.132385 2020] [fcgid:warn] [pid 21859] [client 103.4.94.173:4194] mod_fcgid: stderr: \t\t\tWHERE\tps.setting_name = ? AND ps.setting_value = CAST(i.issue_id as CHAR) AND, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Mon Sep 28 00:13:40.132389 2020] [fcgid:warn] [pid 21859] [client 103.4.94.173:4194] mod_fcgid: stderr: \t\t\t\ta.submission_id = ? AND, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Mon Sep 28 00:13:40.132393 2020] [fcgid:warn] [pid 21859] [client 103.4.94.173:4194] mod_fcgid: stderr: \t\t\t\ta.context_id = i.journal_id, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Mon Sep 28 00:13:40.132397 2020] [fcgid:warn] [pid 21859] [client 103.4.94.173:4194] mod_fcgid: stderr: File: /var/www/clients/client0/web1/web/journal/lib/pkp/classes/db/DAO.inc.php, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Mon Sep 28 00:13:40.132401 2020] [fcgid:warn] [pid 21859] [client 103.4.94.173:4194] mod_fcgid: stderr: Line: 703, referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Mon Sep 28 00:13:40.132405 2020] [fcgid:warn] [pid 21859] [client 103.4.94.173:4194] mod_fcgid: stderr: Trace: #0 /var/www/clients/client0/web1/web/journal/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_mysqli), 'SELECT\ti.\n\t\t\tF…’), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5
[Mon Sep 28 00:13:40.132411 2020] [fcgid:warn] [pid 21859] [client 103.4.94.173:4194] mod_fcgid: stderr: #1 /var/www/clients/client0/web1/web/journal/classes/issue/IssueDAO.inc.php(569): DAO->retrieve(‘SELECT\ti.*\n\t\t\tF…’, Array), referer: https://www.annalskemu.org/journal/index.php/annals/workflow/index/3896/5

10

@asmecher Please let me know how can I proceed further to get rid of this error…
I shall be grateful.
Regards,
Farhan

11

Dear @asmecher This is to inform you that I have successfully resolved the “Schedule for publication” issue. I was searching the internet for the fixation of Illegal mix of collation and I came across one of your threads Database error: Illegal mix of collations · Issue #6045 · pkp/pkp-lib · GitHub. From there I got a clue. First I applied your suggestion but it did not work then I switched the things other way round. I updated the collation of every table in ojs database to utf8_general_ci and Baaaammmm… article was successfully published…
Thank you so much for your support and help.

Kind Regards,
Farhan

1 Like
12

Hi @Farhan_Abbas,

Glad to hear it’s working, and thanks for documenting your resolution – it should be helpful to others!

Regards,
Alec Smecher
Public Knowledge Project Team