Laravel Query Exception

Question

When I tried to delete a row which ID related to another table I got this error

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row

How can I show this error. I've tried with try catch (\Illuminate\Database\QueryException $e) But it not work Can I have your help!

Imtiaz Pabel · Accepted Answer · 2016-04-11 07:50:34Z

1

Please try with PDO exception

    try {
            $this->model->create($data);

        } catch (Illuminate\Database\QueryException $e) {
            dd($e);

        } catch (PDOException $e) {
            dd($e);
        }

answered Apr 11, 2016 at 7:50

Imtiaz Pabel

5,4451 gold badge21 silver badges24 bronze badges

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

2 Comments

Sang Trần Over a year ago

I use your code with try { $brand->delete() }..... But I still got it error. I think I wrong somewhere so It can not catch.

Imtiaz Pabel Over a year ago

@SangTrần di you try both query and pdo exception?

Collectives™ on Stack Overflow

Laravel Query Exception

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related