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.
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'
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)"
}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);
}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"
}