Level 50
what does your laravel log file say?
Jan 27, 2019
16
Level 1
DataTables warning: table id=student_table - Ajax error. http://datatables.net/tn/7 with Yajra Laravel
I just used Yajra (datatable "yajra/laravel-datatables": "^1.0" ) on laravel (5.4.16), PHP version 7.1 .
I got this error while loading :
DataTables warning: table id=student_table - Ajax error. For more information about this error, please see http://datatables.net/tn/7
and on inspect:
jquery.js:8526 GET http://127.0.0.1:8000/leads/testing?draw=2&columns%5B0%5D%5 500 (Internal Server Error)
this is my app.php:
Yajra\DataTables\DataTablesServiceProvider::class,
AND
'DataTables' => Yajra\DataTables\Facades\DataTables::class
and I tried to make the ' Y ' small letter but still have the same error.
My controller :
use DataTables;
class LeadsController extends Controller
{
public function gettesting()
{
return view('testing');
}
public function testing()
{
$students = Meeting::select('name', 'details');
return DataTables::of($students)->make(true);
}
}
my route is as follows:
Route::get('testing', 'LeadsController@gettesting');
Route::get('leads/testing', 'LeadsController@testing')->name('leads.testing');
My view 'testing' :
<!DOCTYPE html>
<html>
<head>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet">
<link href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css" rel="stylesheet">
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
<script src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
</head>
<body>
<div class="container">
<br/>
<br/>
<div align="right">
<button type="button" name="add" id="add_data" class="btn btn-success btn-sm">Add</button>
</div>
<br/>
<table id="student_table" class="table table-bordered" style="width:100%">
<thead>
<tr>
<th>name</th>
<th>details</th>
</tr>
</thead>
</table>
</div>
<script>
$(document).ready(function () {
$('#student_table').DataTable({
"processing": true,
"serverSide": true,
"ajax": "{{ url('leads/testing') }}",
"method": "GET",
"columns": [
{"data": "name"},
{"data": "details"}
]
});
});
</script>
</body>
</html>
Please help me to solve it
Level 14
@lyiub U already have config/datatables.php file?
Level 1
Config file have error not related to this issue of datatable line .. this is the error in Line 333: [2019-01-28 14:58:44] local.ERROR: ErrorException: Trying to get property of non-object in /Applications/XAMPP/xamppfiles/htdocs/project/app/Http/Controllers/LeadsController.php:333
However, testing function in line 1647, and no error showing at this function.
Level 1
@YEZAWHEIN - Actually, yesterday I tried to download many versions, at the end of the day, I just deleted datatables.php from config, and I copied it from previous version of my project and paste it again .
Level 14
@lyiub Delete this file and run
php artisan vendor:publish --provider="Yajra\DataTables\DataTablesServiceProvider"
Then
composer dump-autoload
Level 1
@YEZAWHEIN - which file u mean, datatables.php ?
Level 14
Yes
Level 1
still have the same error
Level 14
What package version use in composer.json? If u use laravel5.4 , u should at least version 7 for this package.
Level 1
@YEZAWHEIN - "yajra/laravel-datatables": "^1.0"
1 like
Level 1
I upgrade it to 8 now, but still the same error
Level 14
I think u forgot to use
use Yajra\Datatables\Datatables;
2 likes
Level 1
I just got this error now in Log file:
local.ERROR: ErrorException: call_user_func_array() expects parameter 1 to be a valid callback, class 'Yajra\Datatables\Engines\EloquentEngine' not found in /Applications/XAMPP/xamppfiles/htdocs/sbi-crm/vendor/yajra/laravel-datatables-oracle/src/DataTables.php:53 Stack trace:
Level 1
I solve it by changing my code to another Controller, I think this Controller have an issue to implement Yajra code.
Thanks you all .
Level 14
php artisan config:cache
Level 6
I got the same error, and solved it with
php artisan vendor:publish --tag=datatables --force
3 likes
Please or to participate in this conversation.