• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Catching database errors?

#1
[eluser]Tim Stackhouse[/eluser]
I'm trying to figure out how to catch and respond to database constraint errors, here's the deal:

I have a table 'role' it has a primary key of 'id'.
I have another table 'user_role' it has a 'FOREIGN KEY (role_id) REFERENCES role(id) ON DELETE RESTRICT'

This is the behaviour I want, I don't want to be able to delete a role if I have users assigned that role, however it's producing this wonderfully ugly database error, how can I trap that error and handle it more gracefully?

#2
[eluser]Tim Stackhouse[/eluser]
No thoughts on this? Is there no way to catch this in CI?

#3
[eluser]TheFuzzy0ne[/eluser]
I don't think it's possible without overriding the display_error() method in the DB_driver class. http://codeigniter.com/wiki/Extending_Database_Drivers/

#4
[eluser]Tim Stackhouse[/eluser]
I did some searching and found this thread: http://ellislab.com/forums/viewthread/79950/ and that will work nicely, it's because I'm in development mode.

#5
[eluser]TheFuzzy0ne[/eluser]
Sorry, I didn't realise you wanted to just hide the errors, I thought you wanted to "trap that error and handle it more gracefully". Smile

#6
[eluser]Tim Stackhouse[/eluser]
Well, it's a combination of the two, I can suppress the error by turning off debugging and handle the error internally, either showing a message that they can't do it because of the foreign key or if it's a more serious error, blowing up more gracefully.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.