OJS 3.3.0-11 error: Failed Ajax request or invalid JSON returned


Same as OJS 3.2.1-1 error: Failed Ajax request or invalid JSON returned - #2 by juanf.csic

I get the error " Failed Ajax request or invalid JSON returned" when I try to assign an editor.

My OJS version is 3.3.0-11 and PHP 7.4.30

For this case, we see this in config.inc.php:

show_stacktrace = Off
display_errors = Off

Hi @pachadotdev , can you check your php error log file and see what error associated with it and provide the details ?

PKP Team

1 Like

thx! I deleted all logs and rebooted the server, created the error again, and I see this

in /var/log/apache2/ojs.lenguasradicales.cl_error.log

[Thu Nov 10 16:05:07.687734 2022] [negotiation:error] [pid 1055] [client] AH00687: Negotiation: discove$
[Thu Nov 10 16:31:10.993621 2022] [php7:error] [pid 1055] [client] PHP Fatal error:  Uncaught PDOExcepti$

in /var/log/apache2/error.log

[Thu Nov 10 15:35:37.431158 2022] [mpm_prefork:notice] [pid 1005] AH00163: Apache/2.4.29 (Ubuntu) OpenSSL/1.1.1 configured -- resuming normal operations
[Thu Nov 10 15:35:37.431328 2022] [core:notice] [pid 1005] AH00094: Command line: '/usr/sbin/apache2'

@pachadotdev it’s very hard to guess what is the real issue just from those few lines from the error log. A full error trace may help us to understand it better.

PKP Team

which php files in specific do you need from me?

Hi @pachadotdev the full error/exception trace form the server php error log file .

that’s all I have
from the browser I see this, and indeed that file doesn’t exist

The missing part of the error is this one: “PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘etd.stage_id’ in ‘field list’”

Any ideas how to fix it?
Thanks in advance.

The above error point out that it can not find a DB column during a DB query . A quick check in the code base point out that etd used as a shorter name of table email_templates_default. can you check that table and see if the column stage_id is set and present there ? Also did you run a fresh install or upgrade form the previous version ?

PKP Team