Call to undefined method Illuminate\Database\Query\Builder::lists() when seeding after updating to Laravel 5.3

Question

I'm updating to laravel 5.3, and I get this message:

[2016-08-23 23:12:39] local.ERROR: BadMethodCallException: Call to undefined method Illuminate\Database\Query\Builder::lists() in /home/vagrant/Code/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2431
Stack trace:
#0 [internal function]: Illuminate\Database\Query\Builder->__call('lists', Array)
#1 /home/vagrant/Code/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1423): call_user_func_array(Array, Array)
#2 /home/vagrant/Code/vendor/cviebrock/eloquent-sluggable/src/SluggableTrait.php(254): Illuminate\Database\Eloquent\Builder->__call('lists', Array)
#3 /home/vagrant/Code/vendor/cviebrock/eloquent-sluggable/src/SluggableTrait.php(170): App\User->getExistingSlugs('nouseratnouser-...')
#4 /home/vagrant/Code/vendor/cviebrock/eloquent-sluggable/src/SluggableTrait.php(312): App\User->makeSlugUnique('nouseratnouser-...')
#5 /home/vagrant/Code/vendor/cviebrock/eloquent-sluggable/src/SluggableServiceProvider.php(72): App\User->sluggify()
#6 [internal function]: Cviebrock\EloquentSluggable\SluggableServiceProvider->Cviebrock\EloquentSluggable\{closure}(Object(App\User))
#7 /home/vagrant/Code/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(221): call_user_func_array(Object(Closure), Array)
#8 /home/vagrant/Code/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(164): Illuminate\Events\Dispatcher->fire('eloquent.saving...', Array, true)
#9 /home/vagrant/Code/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1664): Illuminate\Events\Dispatcher->until('eloquent.saving...', Object(App\User))
#10 /home/vagrant/Code/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1456): Illuminate\Database\Eloquent\Model->fireModelEvent('eloquent.saving...')
#11 /home/vagrant/Code/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(562): Illuminate\Database\Eloquent\Model->save()
#12 /home/vagrant/Code/database/seeds/UserSeeder.php(34): Illuminate\Database\Eloquent\Model::create(Array)
#13 /home/vagrant/Code/vendor/laravel/framework/src/Illuminate/Database/Seeder.php(39): UserSeeder->run()
#14 /home/vagrant/Code/database/seeds/DatabaseSeeder.php(37): Illuminate\Database\Seeder->call('UserSeeder')
#15 /home/vagrant/Code/vendor/laravel/framework/src/Illuminate/Database/Console/Seeds/SeedCommand.php(63): DatabaseSeeder->run()
#16 /home/vagrant/Code/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2279): Illuminate\Database\Console\Seeds\SeedCommand->Illuminate\Database\Console\Seeds\{closure}()
#17 /home/vagrant/Code/vendor/laravel/framework/src/Illuminate/Database/Console/Seeds/SeedCommand.php(64): Illuminate\Database\Eloquent\Model::unguarded(Object(Closure))
#18 [internal function]: Illuminate\Database\Console\Seeds\SeedCommand->fire()
#19 /home/vagrant/Code/vendor/laravel/framework/src/Illuminate/Container/Container.php(507): call_user_func_array(Array, Array)
#20 /home/vagrant/Code/vendor/laravel/framework/src/Illuminate/Console/Command.php(169): Illuminate\Container\Container->call(Array)
#21 /home/vagrant/Code/vendor/symfony/console/Command/Command.php(256): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#22 /home/vagrant/Code/vendor/laravel/framework/src/Illuminate/Console/Command.php(155): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#23 /home/vagrant/Code/vendor/symfony/console/Application.php(818): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#24 /home/vagrant/Code/vendor/symfony/console/Application.php(186): Symfony\Component\Console\Application->doRunCommand(Object(Illuminate\Database\Console\Seeds\SeedCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#25 /home/vagrant/Code/vendor/symfony/console/Application.php(117): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#26 /home/vagrant/Code/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(111): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#27 /home/vagrant/Code/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#28 {main}

I checked the code that cause it:

        User::create([
        'name' => 'No User',
        'email' => 'nouser@nouser.com',
        'password' => bcrypt('0'),
        'provider' => '0',
    ]);

I don't understand why.

If I comment it, I get the same problem in another file:

        Tournament::create([
        'user_id' => 1,
        'name' => "name",
        'dateIni' =>  $dateIni,
        'dateFin' =>  $dateIni,
    ]);

I've made a global search of "lists" without success...

Any idea why is it happening???

Using a service like Laravel Shift is a great way to ensure your Laravel application is fully upgraded, including deprecation gotchas like this. — Jason McCreary, Aug 24 '16 at 4:33

Sang Nguyen · Accepted Answer · 2019-05-08 10:02:28Z

76

You can use method pluck. Method lists is removed in Laravel 5.3. I changed

lists('key')->all() to pluck('key')->all()

( 加上->all() ( 或者->toArray() )结果就是数组了,就不是 collections 了) and it's working now.

edited May 8 '19 at 10:02

answered Aug 24 '16 at 11:18

Sang Nguyen

1,2469 silver badges13 bronze badges

Hello Sang Where you replaced pluck with lists, I am having same problem with create method of eloquent class but don't understand where exactly I have to replace pluck with lists – Junaid Ali Jan 9 '17 at 13:59
Hi Junaid, You need to replace where you use lists method. – Sang Nguyen Jan 11 '17 at 2:47
thanks for your reply I actually fixed my problem by upgrading eloquent-sluggable library – Junaid Ali Jan 11 '17 at 7:35

add a comment

Mahbub · Answer 2 · 2016-08-25 14:27:52Z

Laravel 5.3, the lists() method is removed in favour of the pluck() method. For Example:

正确答案

加上 ->all() ( 或者->toArray() ) 就变成了数组 ,不加上就是collections 集合

$roles = Role::pluck('name','id');
dd($roles);

//结果如下

代码 
$roles = Role::pluck('name','id')->all();
dd($roles);

结果

代码
$roles = Role::pluck('id');
dd($roles);

结果

代码  
$roles = Role::pluck('id')->all();
dd($roles);
结果

$userList = App\User::pluck('name', 'id');

It seems you master laravel. I need you help. Look here : stackoverflow.com/questions/41047583/… — moses toh, Dec 9 '16 at 3:06

Alexey Mezenin · Answer 3 · 2016-08-24 04:11:26Z

6

lists() was deprecated. Use pluck() instead.

The lists method on the Collection, query builder and Eloquent query builder objects has been renamed to pluck. The method signature remains the same.

https://laravel.com/docs/5.3/upgrade#upgrade-5.3.0

answered Aug 24 '16 at 4:11

Alexey Mezenin

110k11 gold badges164 silver badges177 bronze badges

I need you help. Look here : stackoverflow.com/questions/41887504/… – moses toh Jan 27 '17 at 6:42
It is amazing to see how you're finding a solution to OP's problem and getting 0 (zero!) upvotes. And two guys who post exactly the same in 5 and 30 hours and they get 27 and 12 upvotes. – Alexey Mezenin Jan 27 '17 at 6:56
I also do not know. Why did it happen? Maybe my English is not good and my question is not so good – moses toh Jan 27 '17 at 10:39
lol @AlexeyMezenin they love copy and past you should always past an example ^^ – Charif DZ May 13 '17 at 10:27

add a comment

jual ahmed · Answer 4 · 2018-05-17 17:34:58Z

yeah i just found it, but the funny thing its mentiond under https://laravel.com/docs/5.3/upgrade#upgrade-5.2.0 which it not correct as it was working until i upgraded to v5.3

P. Ellul · Answer 5 · 2019-04-25 08:26:02Z

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
class ApiController extends Controller
{
    public function data()
    {
        $data = team::all();
        return $data;    
    }
}

Thanks for trying to help, can you try to provide any explanation so that users can understand better how this is a good answer to you? — P. Ellul, Apr 25 '19 at 6:53

You are here

Call to undefined method Illuminate\Database\Query\Builder::lists() when seeding after updating to Laravel 5.3 pluck lists 有大用有大大用

Call to undefined method Illuminate\Database\Query\Builder::lists() when seeding after updating to Laravel 5.3

5 Answers 正确答案

正确答案

来自 https://stackoverflow.com/questions/39114249/call-to-undefined-method-illuminate-database-query-builderlists-when-seeding

友情链接

搜索表单

用户登录

You are here

Call to undefined method Illuminate\Database\Query\Builder::lists() when seeding after updating to Laravel 5.3 pluck lists 有大用 有大大用

Call to undefined method Illuminate\Database\Query\Builder::lists() when seeding after updating to Laravel 5.3

5 Answers 正确答案

正确答案

来自 https://stackoverflow.com/questions/39114249/call-to-undefined-method-illuminate-database-query-builderlists-when-seeding

友情链接

Call to undefined method Illuminate\Database\Query\Builder::lists() when seeding after updating to Laravel 5.3 pluck lists 有大用有大大用