Error Handler

Laravel DataTables allows you to configure how you want to handle server-side errors when processing your request. Below are the options available for error handling.

ERROR CONFIGURATIONS

Configuration is located at config/datatables.php under error key. You can also configure via env by setting DATATABLES_ERROR key appropriately.

The default configuration is env('DATATABLES_ERROR', null).

• NULL : 'error' => null
• THROW : 'error' => 'throw'
• CUSTOM MESSAGE : 'error' => 'Any custom friendly message'
• TRANSLATION : 'error' => 'translation.key'

NULL Error

If set to null, the actual exception message will be used on error response.

{
    "draw": 24,
    "recordsTotal": 200,
    "recordsFiltered": 0,
    "data": [],
    "error": "Exception Message:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'xxx' in 'order clause' (SQL: select * from `users` where `users`.`deleted_at` is null order by `xxx` asc limit 10 offset 0)"
}

THROW Error

If set to 'throw', the package will throw a \Yajra\DataTables\Exception. You can then use your custom error handler if needed.

Example Error Handler

Update app\Exceptions\Handler.php and register dataTables error exception handler.

/**
 * Render an exception into an HTTP response.
 *
 * @param  \Illuminate\Http\Request  $request
 * @param  \Exception  $exception
 * @return \Illuminate\Http\Response
 */
public function render($request, Exception $exception)
{
    if ($exception instanceof \Yajra\DataTables\Exception) {
        return response([
            'draw'            => 0,
            'recordsTotal'    => 0,
            'recordsFiltered' => 0,
            'data'            => [],
            'error'           => 'Laravel Error Handler',
        ]);
    }
 
    return parent::render($request, $exception);
}

Custom Message

If set to 'any custom message' or 'translation.key', this message will be used when an error occurs when processing the request.

{
    "draw": 24,
    "recordsTotal": 200,
    "recordsFiltered": 0,
    "data": [],
    "error": "any custom message"
}