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

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

oopsleonoopsleon Posts: 9Questions: 4Answers: 0

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!

Answers

  • oopsleonoopsleon Posts: 9Questions: 4Answers: 0

    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}

  • allanallan Posts: 63,602Questions: 1Answers: 10,486 Site admin

    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

  • oopsleonoopsleon Posts: 9Questions: 4Answers: 0

    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

  • allanallan Posts: 63,602Questions: 1Answers: 10,486 Site admin

    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

Sign In or Register to comment.