Running the seeder generates a withTrashed error

[beejasaurus]

I get this error when I run php artisan db:seed --class="Fbf\LaravelBlog\PostTableFakeSeeder":

[BadMethodCallException]
Call to undefined method Illuminate\Database\Query\Builder::withTrashed()

I believe this is related to the updated softDelete traits. I am running Laravel ver 4.2.3.

[lewisoc]

I'm also getting this error. Any updates?

[mercuryseries]

In order to resolve this issue you have to:

1. First, rollback your previous migration.
2. Then, update the migration file present in this folder vendor\fbf\laravelblog\src\migrations
   just add this line:

$table->dateTime('deleted_at')->nullable();

1. After that run: php artisan migrate --package=fbf/laravel-blog
2. Then in vendor\fbf\laravel-blog\src\models\Post.php
   add this line after the namespace declaration:

use Illuminate\Database\Eloquent\SoftDeletingTrait;

And also in the same file add this two lines like that:

class Post extends \Eloquent {

    use SoftDeletingTrait;
    protected $dates = ['deleted_at'];

    ....

You should now have something like that:

<?php namespace Fbf\LaravelBlog;

use Illuminate\Database\Eloquent\SoftDeletingTrait;

class Post extends \Eloquent {

    use SoftDeletingTrait;
    protected $dates = ['deleted_at'];

    /**
     * Status values for the database
     */
    const DRAFT = 'DRAFT';
    const APPROVED = 'APPROVED';
        ....

Now you can run php artisan db:seed --class="Fbf\LaravelBlog\PostTableFakeSeeder" without problem.

Let me know if that resolve your issue. Thanks

[nevrending]

Was having the same problem
Did the above
It works!

Thanks 👍

[mercuryseries]

You're welcome !

[singhjay]

After doing the above, I'm getting:

[Illuminate\Database\QueryException]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel.fbf_blog
_posts' doesn't exist (SQL: delete from fbf_blog_posts)

[PDOException]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel.fbf_blog
_posts' doesn't exist

[mercuryseries]

@singhjay It seems that you are trying to delete a table that doesn't exists.
Maybe you have manually deleted this table without using migrations.

If possible, run this command php artisan migrate:reset in order to make a reset of your migrations.
After that, you can follow the process described above.

If you still have some issues, you can manually delete all the tables in your database, run php artisan migrate and follow the process described above.

[singhjay]

I didn't create the tables in the first place it seems and I was trying to run the command without noticing. After creating the tables and trying to seed the file, I'm getting:

[BadMethodCallException]
Call to undefined method Illuminate\Database\Query\Builder::withTrashed()

Should I just try everything all over again from scratch?

I'm running Laravel 4.2 by the way on an ec2 instance and when using composer, I used

{
"name": "laravel/laravel",
"description": "The Laravel Framework.",
"keywords": ["framework", "laravel"],
"license": "MIT",
"require": {
"laravel/framework": "4.2.*",
"fbf/laravel-blog": "0.7.0"
},
"autol

....

in composer.json

[mercuryseries]

@singhjay You just have to follow the steps that I have described above if you got this error [BadMethodCallException]
Call to undefined method Illuminate\Database\Query\Builder::withTrashed()

[singhjay]

Thank you for your time, it worked.

[mercuryseries]

@singhjay You're welcome!

[ziazon]

Can we expect to see this fix in a future release? would suck to not be able to update the package because of this...