Datatables or postgresql bug?
Datatables or postgresql bug?
![esmurf](https://secure.gravatar.com/avatar/ce96d48ac875cdc575a5a29ddb359a52/?default=https%3A%2F%2Fvanillicon.com%2Fce96d48ac875cdc575a5a29ddb359a52_200.png&rating=g&size=120)
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
The
_stmt
variable is a PDO instance. The fact that it doesn't have afetch()
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
It gives med the following
![](https://datatables.net/forums/uploads/editor/ci/u5tscbwe9nfe.png)
It lookes fine for me with the different queries and all, or am I missing something?
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
I was using editor 1.7.4 and I've updated it now.
It gave me the following error at first.
![](https://datatables.net/forums/uploads/editor/72/hygi4nlry1up.png)
But then after a restart, it gave me the following.
![](https://datatables.net/forums/uploads/editor/3m/jf35i0odqsot.png)
It seems to load the data but gives error anyway???![:sweat_smile: :sweat_smile:](https://datatables.net/forums/resources/emoji/sweat_smile.png)
I honestly don't know... I sure hope that you might have a clue about this
Have a great day.
Kind regards,
Esmurf
Its an odd one for certain! Could you show me your full PHP code please?
Allan
@allan were you thinking of this?
![](https://datatables.net/forums/uploads/editor/4y/g1lj8isw40we.png)
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