Failed Ajax request or invalid JSON on OJS 3.3.07 After Update From OJS 3.2

Fauji_Nurdin · August 11, 2021, 7:56am

hai everyone i have a problem when adding Reviewer after Upgrade to OJS 3.3.0.7

Screen Shot 2021-08-11 at 15.51.33

this is the error log
[11-Aug-2021 07:39:57 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION alqolama_ojs33f.DATE_PART does not exist in /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare(‘select u., C…’, Array)
#1 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare(Object(Illuminate\Database\Query\Expression))
#2 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\Query\Expression), Array)
#3 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->ru in /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[11-Aug-2021 07:42:32 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION alqolama_ojs33f.DATE_PART does not exist in /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare('select u., C…’, Array)
#1 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare(Object(Illuminate\Database\Query\Expression))
#2 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\Query\Expression), Array)
#3 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->ru in /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[11-Aug-2021 07:45:20 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION alqolama_ojs33f.DATE_PART does not exist in /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare(‘select u., C…’, Array)
#1 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare(Object(Illuminate\Database\Query\Expression))
#2 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\Query\Expression), Array)
#3 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->ru in /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[11-Aug-2021 07:46:42 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION alqolama_ojs33f.DATE_PART does not exist in /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare('select u., C…’, Array)
#1 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare(Object(Illuminate\Database\Query\Expression))
#2 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\Query\Expression), Array)
#3 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->ru in /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[11-Aug-2021 07:47:04 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION alqolama_ojs33f.DATE_PART does not exist in /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare(‘select u., C…’, Array)
#1 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare(Object(Illuminate\Database\Query\Expression))
#2 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\Query\Expression), Array)
#3 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->ru in /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[11-Aug-2021 07:51:29 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION alqolama_ojs33f.DATE_PART does not exist in /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare('select u., C…’, Array)
#1 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare(Object(Illuminate\Database\Query\Expression))
#2 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\Query\Expression), Array)
#3 /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->ru in /home/alqolama/public_html/ejournal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671

Application Version - OJS 3.3.00.7

all table on database using innoDB

this is information from chrome developer tools

jquery.min.js?v=3.3.0.7:2 GET https://ejournal.alqolam.ac.id/index.php/studipesantren/$$$call$$$/grid/use…bmissionId=508&stageId=3&reviewRoundId=163&selectionType=1&_=1628751960233 500

send	@	jquery.min.js?v=3.3.0.7:2
ajax	@	jquery.min.js?v=3.3.0.7:2
a.fn.pkpAjaxHtml	@	pkp.min.js?v=3.3.0.7:392
a.pkp.controllers.modal.AjaxModalHandler.modalOpen	@	pkp.min.js?v=3.3.0.7:290
a.pkp.controllers.modal.ModalHandler	@	pkp.min.js?v=3.3.0.7:276
a.pkp.classes.ObjectProxy.parent	@	pkp.min.js?v=3.3.0.7:93
a.pkp.controllers.modal.AjaxModalHandler	@	pkp.min.js?v=3.3.0.7:289
a.pkp.classes.ObjectProxy.parent	@	pkp.min.js?v=3.3.0.7:93
b	@	pkp.min.js?v=3.3.0.7:91
a.pkp.classes.Helper.objectFactory	@	pkp.min.js?v=3.3.0.7:89
(anonymous)	@	pkp.min.js?v=3.3.0.7:392
each	@	jquery.min.js?v=3.3.0.7:2
each	@	jquery.min.js?v=3.3.0.7:2
a.fn.pkpHandler	@	pkp.min.js?v=3.3.0.7:392
a.pkp.classes.linkAction.ModalRequest.activate	@	pkp.min.js?v=3.3.0.7:116
a.pkp.controllers.linkAction.LinkActionHandler.activateAction	@	pkp.min.js?v=3.3.0.7:299
a.pkp.classes.Handler.handleEvent	@	pkp.min.js?v=3.3.0.7:98
dispatch	@	jquery.min.js?v=3.3.0.7:2
v.handle

please Help @NateWr @asmecher

gregorio.pellegrino · December 10, 2021, 1:48pm

Same error here. How did you solve?

gregorio.pellegrino · December 10, 2021, 1:57pm

Done. There was an error in the config.inc.php in the driver line

BengYong · March 6, 2022, 3:07am

Hi Gregorio,

I am facing the same problem. Can you please tell me more?

My currrent driver line is set as

driver = mysql

mohd_arshad · March 6, 2022, 6:55am

Just change mysql to mysqli

gregorio.pellegrino · March 7, 2022, 7:22am

Right, I’ve set

driver = mysqli

BengYong · March 7, 2022, 10:57am

I have changed

driver = mysqli

and restart my Apache Web server.

driver_Capture

But it does NOT solve my “Failed Ajax request or invalid JSON returned.” problem

I have also tried some of the suggestions I found online, they could NOT help too

debug_Capture

gettext_author_Capture

I am still getting the “Failed Ajax request or invalid JSON returned.” problem.

I am using Windows + XAMPP platform

mohd_arshad · March 7, 2022, 11:56am

try using php 7.4… php 8 is not compatible with ojs 3.3. only later according to the developer php 8 support on ojs 3.4

asmecher · March 7, 2022, 3:48pm

Hi all,

Just to clarify – OJS 3.3.x is compatible with PHP 8.0. It is not yet compatible with 8.1 (as of OJS 3.3.0-9), but we’ll likely be extending that compatibility in a later build.

Newer releases of PHP tend to change things that were previously warnings into errors, so you may need to correct some data issues with PHP8 that you were previously able to ignore. But that’s a different subject.

@BengYong, I’d suggest checking your PHP error log for details.

Regards,
Alec Smecher
Public Knowledge Project Team

BengYong · March 14, 2022, 12:22pm

Hi asmecher,

I am so happy to hear from you. I am currently using PHP8.0.12

The PHP error that I got is

[Mon Mar 14 20:20:21.765874 2022] [php:error] [pid 3996:tid 1808] [client 10.0.31.50:29770] PHP Fatal error: Declaration of ManageCopyeditFilesForm::execute($stageSubmissionFiles, $fileStage = null) must be compatible with ManageSubmissionFilesForm::execute($stageSubmissionFiles = null, $fileStage = null, …$functionArgs) in C:\xampp\htdocs\lib\pkp\controllers\grid\files\copyedit\form\ManageCopyeditFilesForm.inc.php on line 33, referer: https:///index.php/jsst/workflow/index/21/5

asmecher · March 14, 2022, 6:37pm

Hi @BengYong,

I think this has already been solved in more recent releases of OJS 3.3.0:

Regards,
Alec Smecher
Public Knowledge Project Team