There is a issue on soft deleting .

[01Tuner]

customer model

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Customer extends Model
{
    use SoftDeletes;

    protected $fillable  = ['name','place','address'];

    protected $dates = ['deleted_at','created_at','updated_at','amc_date'];

    protected $appends = ['amc_or_not','active_or_not','voice_or_not'];


    public function User()
    {
        return $this->hasMany('User');
    }    

    public function Student()
    {
        return $this->hasManyThrough('Student','User');
    }

user model

use Illuminate\Auth\Authenticatable;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Auth\Passwords\CanResetPassword;
use Illuminate\Contracts\Auth\Authenticatable as AuthenticatableContract;
use Illuminate\Contracts\Auth\CanResetPassword as CanResetPasswordContract;
use Illuminate\Database\Eloquent\SoftDeletes;

class User extends Model implements AuthenticatableContract, CanResetPasswordContract
{
    use Authenticatable, CanResetPassword;

    use SoftDeletes;

    protected $table = 'users';


    protected $fillable = ['name', 'email', 'password','mobno','type','active'];

    protected $hidden = ['password', 'remember_token'];

    protected $dates = ['deleted_at'];

    protected $appends = ['usertype'];

    public function Customer()
    {
        return $this->belongsTo('SmSPortal\Customer');
    }

student model

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Student extends Model
{
    use SoftDeletes;

    protected $table = 'studentsdata';

    protected $dates = ['deleted_at','created_at','updated_at'];

    protected $fillable = ['admno','name','mobno'];
}

when i perform this query

$delete = Customer::find($this->customer_id)->Student()->delete();

i get the following error

QueryException in Connection.php line 636:
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'updated_at' in field list is ambiguous (SQL: update `studentsdata` inner join `users` on `users`.`id` = `studentsdata`.`user_id` set `studentsdata`.`deleted_at` = 2015-10-05 10:46:56, `updated_at` = 2015-10-05 10:46:56 where `studentsdata`.`deleted_at` is null and `users`.`deleted_at` is null and `users`.`customer_id` = 2)

[safoorsafdar]

It's look like, query get confuse to select specific table column update_at, all table contain this column, so you have to define table name if we talk about custom query tableName.update_at
I also face this issue already.

[01Tuner]

this is not a solution .its a bug of laravel eloquent.
can say how to fix it ??

[baoanhng]

@GrahamCampbell Isn't this a bug, but you just closed it without providing some reasons, Are there other ways around?

[themsaid]

@trandaihung check #13909 it's a duplicate.

[joseevillasmil]

use the functions has, withHas and doestnhave, these functions are used to join with the propeties of the models.

https://laraveldaily.com/eloquent-doesnthave-get-rows-children/

https://laravel.com/docs/5.8/eloquent-relationships#querying-relationship-existence