CakePHP 2.0 - customize database error message

1
votes

I have a CakePHP 2.0 application with a MySQL database. Two database tables are connected with a 1:n relation and a foreign key constraint. So if I want to delete an entry which is connected in the other database table, I get the error:

Error: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a forein key constraint fails (...)
SQL Query: DELETE 'Test' FROM 'tests' AS 'Test' WHERE 'Test'.'id' = 10

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

But what I want to do is to handle the error message! I read something about 'onError' but putting it into the 'AppModel' it seems not to be called (maybe it works only with CakePHP 1.3?):

class Test extends AppModel {
     function onError() {
         echo "TESTTESTTEST";
         $db = ConnectionManager::getDataSource('default');
         $err = $db->lastError();
         $this->log($err);
         $this->log($this->data);
     }
}

So what can I do? I want to remain on this page, and I want to show only an error message (not a stack trace and this kind of stuff).

Anyone an idea?

2
databasecakephperror-handlingcakephp-2.0

2 Answers

1
votes

What about using the .ctp?

If you want to customize this error message, create app/View/Errors/pdo_error.ctp

The one that's being used is in the Cake directory, you could just copy that to your app/View/Errors directory and remove the stack trace from that if you like.

There's also the beforeDelete() Model callback function you could use to set a flashMessage.

0
votes

Data base error normally give 500 error so cakephp handle 500 exception by using View/Errors/error500.ctp or app/View/Errors/pdo_error.ctp only and customize this page

and add this function bellow in AppController.php

 function beforeRender() {
    if($this->name == 'CakeError') {
        $this->set('title','Internal error occurs');
        $this->layout = 'frontend';
    }
    }