Editor throwing error - A system error has occurred

Shivani Vyas

Hello,

I am trying to submit data using editor which is throwing generic error - A system error has occurred. I already followed instruction on the page and also check Json response, everything is correct. Even when I click update button in editor window.. its updating data as well, but editor window stayed open with the error - 'A system error has occurred'.

My Editor

// Reserved Editor
var editorRES = new $.fn.dataTable.Editor( {
    ajax: "../ajax/at/lrvCheckout1.php",
    table: "#assyntCx_Table",
    fields: [
        {
            label: 'Reserved to:',
            name: 'Reserved',
            type: 'select',
            placeholderDisabled: false,
            placeholder: "Choose Reserved Entity",
       },
       {
            label: 'Reserved Start',
            name: 'ResStart',
            type: 'hidden',

       },

    ]


} );   

editorRES.on('submitComplete', function (e, json, data, action)
{
    $('#assyntCx_Table').DataTable().ajax.reload(null, false);

});

Server side is OFF too. Not sure why its causing this issue.

<?php
//SESSION START
if(!isset($_SESSION)) { 
    session_start(); 
  }

if(isset($_SESSION['userID'])) {
    $userID = $_SESSION['userID'];

} else {
    $userID = null;

} 



include("../lib/DataTables.php");

use
    DataTables\Editor,
    DataTables\Editor\Field,
    DataTables\Editor\Format,
    DataTables\Editor\Mjoin,
    DataTables\Editor\Options,
    DataTables\Editor\Upload,
    DataTables\Editor\Validate,
    DataTables\Editor\ValidateOptions;

//$update = 'd M Y';

Editor::inst( $db, 'lrv_list L')
    ->fields(

        Field::inst( 'L.id', 'id' ),

        Field::inst( 'L.reserved_entity', 'Reserved' )
            ->options( Options::inst()
                ->table('lrv_reserved_entity')
                ->value('id')
                ->label('entityName')
                ->order('id')
            )
        ->validator( Validate::notEmpty( ValidateOptions::inst()
                ->message( 'Which entity is Reserving this LRV?' )
        ) ),

        Field::inst( 'E1.entityName', 'ResEntity'),

        Field::inst( 'L.reserved_start', 'ResStart'),

        Field::inst( 'L.reserved_end', 'ResEnd')
        ->setFormatter( Format::ifEmpty( null ) ),



    )
    ->on('preEdit', function ($editor, $id, &$values) {


        if(($values['Reserved'] > 0))
        {

            $editor
                ->field('ResStart')
                ->setValue(date("Y-m-d H:i:s"));
        }


    }) 


->leftJoin( 'lrv_reserved_entity E1', 'E1.id', '=', 'L.reserve
->debug(true)
->process( $_POST )
->json();



?>

allan

It means that the response from the server is not valid JSON. Try clicking the "Response" tab in your network inspector. It might show what the error is. Sometimes the JSON parser for the "Preview" can strip out error messages that are not JSON if most of the response is JSON.

Allan