handling MySql errors
Hi, I am wondering how to handle and recognize MySQL type of errors...in cake. For EXAMPLE.. I have integrity checks (ON DELETE) designed on DB server - when I do delete on some item who has its childs...it is not allowed by DBso in debug mode in cake i get following.. SQL Error: 1451: Cannot delete or update a parent row: a foreign key constraint fails if i turn off debug mode, i get only 404 Not Found page. is cake able to recognize that error and display nice message like using setFlash?? I would rather tell user than he cannot delete item because it has childs connected to it instead of showing 404 page... which is more confusing... Thanks for help. Tomas --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: handling MySql errors
Hi - IMO, the best approach is to check for child records before you attempt to delete the parent data. I would even go as far as doing this before even rendering the delete link, preventing your end user trying to do something they can't in the first place. For what its worth, I personally preferring to validate actions before they happen, rather than responding to errors as I've generally found this approach saves me time in the long run. I do however, still use constraints like this as a last-line of defense to protect against database corruption, just in case :) Hope this helps, Richard On Mon, Jun 22, 2009 at 1:35 PM, toka...@gmail.com toka...@gmail.comwrote: Hi, I am wondering how to handle and recognize MySQL type of errors...in cake. For EXAMPLE.. I have integrity checks (ON DELETE) designed on DB server - when I do delete on some item who has its childs...it is not allowed by DBso in debug mode in cake i get following.. SQL Error: 1451: Cannot delete or update a parent row: a foreign key constraint fails if i turn off debug mode, i get only 404 Not Found page. is cake able to recognize that error and display nice message like using setFlash?? I would rather tell user than he cannot delete item because it has childs connected to it instead of showing 404 page... which is more confusing... Thanks for help. Tomas --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: handling MySql errors
Hi Richard, thanks for your post. Now I realize that it may be more user friendly to not display that button and it will avoid all that stuff. Thanks Tomas On Jun 22, 3:04 pm, Richard rclay...@gmail.com wrote: Hi - IMO, the best approach is to check for child records before you attempt to delete the parent data. I would even go as far as doing this before even rendering the delete link, preventing your end user trying to do something they can't in the first place. For what its worth, I personally preferring to validate actions before they happen, rather than responding to errors as I've generally found this approach saves me time in the long run. I do however, still use constraints like this as a last-line of defense to protect against database corruption, just in case :) Hope this helps, Richard On Mon, Jun 22, 2009 at 1:35 PM, toka...@gmail.com toka...@gmail.comwrote: Hi, I am wondering how to handle and recognize MySQL type of errors...in cake. For EXAMPLE.. I have integrity checks (ON DELETE) designed on DB server - when I do delete on some item who has its childs...it is not allowed by DBso in debug mode in cake i get following.. SQL Error: 1451: Cannot delete or update a parent row: a foreign key constraint fails if i turn off debug mode, i get only 404 Not Found page. is cake able to recognize that error and display nice message like using setFlash?? I would rather tell user than he cannot delete item because it has childs connected to it instead of showing 404 page... which is more confusing... Thanks for help. Tomas --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
