laravel-datatables Invalid argument supplied for foreach() in Datatables.php (line 57)

Summary of problem or feature request

getting error when call anyData Route. through the network inspector, I cleared php artisan cache.

ErrorException Invalid argument supplied for foreach()

in Datatables.php (line 57)

Code snippet of problem

Routes:

Route::get('/datatable','DatatablesController@getIndex');
Route::get('/anyData','DatatablesController@anyData')->name('datatables.data');

<?php

namespace App\Http\Controllers;


use Yajra\Datatables\Datatables;
use Illuminate\Support\Facades\DB;

class DatatablesController extends Controller
{
    /**
     * Displays datatables front end view
     *
     * @return \Illuminate\View\View
     */
    public function getIndex()
    {
        return view('reports.testdatatable');
    }

    /**
     * Process datatables ajax request.
     *
     * @return \Illuminate\Http\JsonResponse
     */
    public function anyData()
    {
       return Datatables::of(User::query())->make(true);
    }
    
}

System details

Operating System MAC OS 10.11
PHP Version 7.2
Laravel Version 5.4
Laravel-Datatables Version 7.3

Apr 17 '18 16:04 dflow

Your code looks fine. However, it seems like your version may not be updated? Datatables.php is for v6.0 below afaik? Please double check that you have the correct version?

Apr 28 '18 02:04 yajra

Im facing same issue.

I've just upgraded to version 8, with: composer require yajra/laravel-datatables-oracle:8.* php artisan vendor:publish --tag=datatables --force

but Im still getting the error:

ErrorException in DataTables.php line 51: Invalid argument supplied for foreach()

Please advise

Jun 13 '18 21:06 painter10

@painter10 base on error log line 51, the new datatables.php config might not be overwritten. Maybe try deleting the config manually then publish again.

$builders = config('datatables.builders');
...
foreach ($builders as $class => $engine) {...

Also see https://yajrabox.com/docs/laravel-datatables/master/upgrade if you haven't checked it yet.

Jun 13 '18 23:06 yajra

Thanks for suggestion. I think the problem was that I followed the Quick Start tutorial literally, so it was necessary to modify the setup, namely: I had to delete config.php file in Bootstrap/cache, then in the config/app.php I changed from: Yajra\Datatables\DataTablesServiceProvider::class, to: Yajra\DataTables\DataTablesServiceProvider::class, and now anyData() seems to work. However, Im still struggling to display records in the datatable. Only headers are visible.

Jun 14 '18 17:06 painter10

just clear config cache of laravel. php artisan config:cache