How to catch QueryException?

I'm trying to do this:

try {
    $model_class::destroy($id);
} catch ( Illuminate\Database\QueryException $e) {
    var_dump($e->errorInfo);
}

But when I run this code to force an Exception (Integrity constraint violation), I still getting an debug screen, when the exeption should be catch.

The debug shows me two exceptions:

Illuminate\Database\QueryException and PDOException

If I catch the PDOException, it works. But if I catch QueryException, it does not works.

Why?

BTW, is there any way better to catch Integrity constraint violation exceptions when deleting a row?

dancourse

10 years ago

Level 1

Any news on this one? I can't seem to catch mine either in Laravel 5.0

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

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

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

1 like

itwonders

10 years ago

Level 1

probably is namespace issue

try

catch (\Illuminate\Database\QueryException $e)

10 likes

javipedrera

10 years ago

Level 3

yes, that was the solution for me @itwonders, Thanks

1 like

faruqisan

9 years ago

Level 1

i've trying to use the correct namespace but still cant catch the exception any help?

Patryk1098

9 years ago

Level 1

@faruqisan You've probably solved this, but make sure you have a \ prefixed to your namespace path for the QueryException class.

2 likes

MisterX25

6 years ago

Level 1

This is quite an old thread, but still... it describes EXACTLY the problem I'm facing now and I can't figure it out.

use Illuminate\Database\QueryException;

try {
    $newuser = new User();
    $newuser->save();
    return response()->json(null, 200);
} catch (QueryException $e) {
    $message = "Error";
    return response()->json($message, 500);
}

I get :

{
  "message": "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'last_name' cannot be null (SQL: insert into `users` ... ",
  "exception": "Illuminate\Database\QueryException",
...
}

btw: catch (Exception $e) also doesn't work

i.e: the exception isn't caught.

It's driving me nuts, help please !