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

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

Same error here. How did you solve?

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

Hi Gregorio,

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

My currrent driver line is set as

driver = mysql

Just change mysql to mysqli

1 Like

Right, I’ve set

driver = mysqli
1 Like

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 :smiling_face_with_tear:

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

debug_Capture

gettext_Capture

gettext_author_Capture

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

AJX_JSON_Capture

I am using Windows + XAMPP platform

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

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

1 Like

Hi asmecher,

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

Php8.0

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

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