SoftDelete doesn't work when I change primary key in Laravel

Question

I have changed the primary key in a table from id to pr_id and mobile.


$table->primary(['pr_id' , 'mobile']);

also I added SoftDelete Trait in model. but when I want to delete a record it doesn't work.

Try specifying your primary key in model. protected $primaryKey = 'your_key_name'; — Kamal Paliwal, Mar 06 '19 at 05:29
my primary keys are pr_id and mobile . i wrote protected $primaryKey=['pr_id','mobile']. but i goft other errors — ali Falahati, Mar 06 '19 at 05:33

Ayaz Ali Shah · Answer 1 · 2019-03-06T05:35:28.700

3

I believe this is because of not mentioning primary key into model, and your model still consider primary key is id however you have changed it. So you just to add following script into relevant model,

class YourModelClass extends Model
{
     protected $primaryKey = 'pr_id';
}

This in way model won't consider primary key as id.

edited Mar 06 '19 at 05:35

answered Mar 06 '19 at 05:32

Ayaz Ali Shah

3,453
9
36
68

my primary keys are pr_id and mobile . i wrote protected $primaryKey=['pr_id','mobile']. but i goft other errors – ali Falahati Mar 06 '19 at 05:34
@aliFalahati can you show the errors that you are getting after mentioning key? – Ayaz Ali Shah Mar 06 '19 at 05:36
array_key_exists(): The first argument should be either a string or an integer – ali Falahati Mar 06 '19 at 05:45

score 1 · Answer 2 · answered Mar 06 '19 at 05:41

You need to override few methods also like getKeyForSaveQuery, setKeysForSaveQuery with defining the primary key in model. For soft delete you need to override one more method runSoftDelete.

Reference links

SoftDelete doesn't work when I change primary key in Laravel

2 Answers2