Laravel delete data - SQLSTATE[42S22]: Column not found: 1054 Unknown column

Question

How to fix problem with forein keys names in laravel while deleting data from database. I changed names in relationships in class file but still does not work. Where do i need make changes? "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'kontakt.id' in 'where clause' (SQL: select * from kontakt where kontakt.id = 1 limit 1)"

class User extends Model
{
    public $table = "user";
    public function kontakt(){

     return $this->hasMany('App\kontakt');
    }
}


class kontakt extends Model
{
    public $table = "kontakt";
    public function user(){

        return $this->belongsTo('App\User','id_user','id_kontakt');
    }
}
Schema::create('user', function (Blueprint $table) {
            $table->bigIncrements('id_user');
            $table->string('imie_user');
            $table->string('nazwisko_user');
            $table->string('haslo_user');
            $table->string('email')->unique();
}
Schema::create('kontakt', function (Blueprint $table) {
            $table->bigIncrements('id_kontakt');
            $table->string('imie_kontakt');
            $table->string('nazwisko_kontakt');
            $table->string('opis_kontakt');
            $table->string('miasto_kontakt');
            $table->string('ulica_kontakt');
            $table->string('nr_bloku_kontakt');
            $table->string('nr_mieszkania_kontakt');
            $table->string('telefon_kontakt');
            $table->string('nr_konta_kontakt');
            $table->string('nip_kontakt');
            $table->unsignedBigInteger('id_user');
            $table->foreign('id_user')->references('id_user')->on('user');
        })


 public function deletekontakt($id_kontakt){

    $kontakt = kontakt::find($id_kontakt);
    $kontakt->delete();
    return redirect('kontakty');
}

Yasin Patel · Accepted Answer · 2019-11-04 10:05:47Z

4

Eloquent will also assume that each table has a primary key column named id. You may define a $primaryKey property to override this convention.

in your kontakt model define primary key:

class kontakt extends Model
{
    public $table = "kontakt";
    protected $primaryKey = 'id_kontakt';

    public function user(){

        return $this->belongsTo('App\User','id_user','id_kontakt');
    }
}

also in User model .

protected $primaryKey = 'id_user';

And for delete, you can also use destroy() method.

kontakt::destroy($id_kontakt);

edited Nov 4, 2019 at 10:05

answered Nov 4, 2019 at 9:58

Yasin Patel

5,7818 gold badges37 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yasin Patel Over a year ago

Yeah :) and you can directly delete reocrd.

Collectives™ on Stack Overflow

Laravel delete data - SQLSTATE[42S22]: Column not found: 1054 Unknown column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related