Working all right on server, but not working in local development environement.

oopsleon

Hi team,

I have a old project needed to be updated.
The web app is working all right and the users are still using it as normal.
But when I pull the codes down to my local, it keep showing an error:
"DataTables warning: table id=js-dataTable-operatorJobs - Invalid JSON response. "
Is this because of different PHP version? I have tried change PHP 8 to PHP 7 but it does not help.
Could you please advise?

Thank you very much!

oopsleon

The data responding in Chrome dev tool is:
<br />
<b>Notice</b>: Undefined property: DataTables\Database::$type in <b>C:\MyWebsites\spindle.jaxxon\inc\backend\editor\Database\Query.php</b> on line <b>1185</b><br />
<br />
<b>Notice</b>: Undefined property: DataTables\Database::$type in <b>C:\MyWebsites\spindle.jaxxon\inc\backend\editor\Database\Query.php</b> on line <b>1185</b><br />
<br />
<b>Notice</b>: Undefined property: DataTables\Database::$type in <b>C:\MyWebsites\spindle.jaxxon\inc\backend\editor\Database\Query.php</b> on line <b>1185</b><br />
{right data}

allan

A PHP version difference or Editor PHP library version difference sounds like the most likely explanation. What version of the Editor libraries are you using? The line indicated there is a comment in the latest version.

Allan

oopsleon

Hi Allan,

In the dataTables.editor.js file, it say DataTables Editor v2.0.6.
Thank you I'll have a look at the link you sent.

Best regards,
Ethan

allan

Hi Ethan,

In 2.0.6's PHP, this is the line in question.

That suggests to me that the type property in the $sql_details array, in the config.php is not set.

Can you show me what you have in your config.php (with the user / pass / host obfuscated!)?

Allan