Invalid JSON response when upgrade from 1.6.1 to 1.6.5

bpitoni

Response body in console shows
"Undefined variable key in Editor-1.6.5/php/Database/Query.php on line 661"

I believe it is objecting to this 'where' clause in my code (best guess):

        ->where( function ($q) use($now) {
            $q->where_group( function ($r) use ($now) {
                $r
                ->where('in_effect_end', null)
                ->where( function($s) {
                    $s->where('in_effect_start', 'DATE_ADD( NOW(), INTERVAL -1 DAY )', '>=', false);            
                  } )   
                ->or_where('in_effect_end', $now, '>=');                
             } );
        } ) 

The only change I've made is to replace Editor 1.6.1 with 1.6.5 (due to datepicker issues).

On the test page, the shutdowns_extended table works fine (that table is still using Editor 1.6.1 on query page).

https://facilities.rochester.edu/protected/csc_dashboard/shutdowns_test.php

Any help would be appreciated.

Thanks.

bpitoni

Was not the 'where' clause.

Used suggested fix from this forum discussion:
https://datatables.net/forums/discussion/comment/121093/#Comment_121093

Changed line 661 in Query.php to:

if ( is_callable($inOut) && is_object($inOut) ) {

Seems to have worked. Hope this helps someone.

allan

Yes, the fix for that is in 1.7.0 (current release is 1.7.2).

Allan