Datatables or postgresql bug?

Datatables or postgresql bug?

esmurfesmurf Posts: 29Questions: 4Answers: 0

Hi y'all,
This might not be a Datatables/Editor problem, but hopefully someone had the same problem..

My project worked perfectly, but after I updated my computer (using linux parrot), something went wrong...
I'm getting invalid Jsom error, with the following output:

I've tried to solve it, but have no clue what so ever..
I do have a hunch that it might have something to do with Postgresql, which I'm using in my project.
If i disable my ajax call, which is also serversided, then it works but with no data ...

Does any1 know how to fix this?
Regarding the error line in /var/www/html/ReGen2.0/Editor-PHP-1.7.4/php/Database/Driver/Postgres/Result.php on line 58, is the following:

It does say "Method 'fetch' not found..." but I haven't done anything to any of the default Datatables/Editor files.....
It overrides the following method, if it helps

I truly hope someone can help.... I'm loosing my mind..

Kind regards Esmurf!

Replies

  • allanallan Posts: 63,488Questions: 1Answers: 10,467 Site admin

    The _stmt variable is a PDO instance. The fact that it doesn't have a fetch() method suggests that perhaps it is null. That in turn suggests that the SQL generated is causing an error - can you add ->debug(true) before the ->process(...) call and see if that returns anything useful in the JSON?

    Allan

  • esmurfesmurf Posts: 29Questions: 4Answers: 0

    It gives med the following

    It lookes fine for me with the different queries and all, or am I missing something?

  • allanallan Posts: 63,488Questions: 1Answers: 10,467 Site admin

    What version of Editor's PHP libraries are you using? line 900 in the current release of Editor.php is a comment (4 in the call stack). If not 1.8.1 could you update to that please?

    Allan

  • esmurfesmurf Posts: 29Questions: 4Answers: 0

    I was using editor 1.7.4 and I've updated it now.

    It gave me the following error at first.

    But then after a restart, it gave me the following.

    It seems to load the data but gives error anyway???
    I honestly don't know... I sure hope that you might have a clue about this :sweat_smile:

    Have a great day.
    Kind regards,
    Esmurf

  • allanallan Posts: 63,488Questions: 1Answers: 10,467 Site admin

    Its an odd one for certain! Could you show me your full PHP code please?

    Allan

  • esmurfesmurf Posts: 29Questions: 4Answers: 0

    @allan were you thinking of this?

  • esmurfesmurf Posts: 29Questions: 4Answers: 0

    I've just tested it on another computer and it works.........
    It was somehow the lastest update which screw up my computer....

    Do you have any idea what could cause this??

    But anyway, ty for helping me anyways! @allan

This discussion has been closed.