MySQL Duplicate Entry Creates Internal Server Error

Question

In order to avoid a user creating duplicate data I use a UNIQUE constraint on a field. Everything works perfect until a duplicate entry; which immediately gives me an internal server error. I am using CodeIgniter for queries and check database errors using $this->db->_error_message() yet instead of being handled the program seems to exit and the error number is returned on my AJAX call. Is there another way of handling these types of errors or is it something I am doing wrong?

Sounds like an Exception gets thrown, and you neglected to catch it properly. — C3roe
– C3roe, Commented Apr 29, 2014 at 3:45
@CBroe What was it that threw the exception and how do I handle it? — boompow
– boompow, Commented Apr 29, 2014 at 3:48
see if you are getting any error on apache error_log or whatever webserver you are using — k961
– k961, Commented Apr 29, 2014 at 4:02

Aret · Accepted Answer · 2014-04-29 04:35:07Z

0

Inserting a duplicate will throw the exeption.

Try to catch it like this:

try
{
    // insertin the duplicate
}
catch (Exception $e)
{
    echo 'Exeption: '.  $e->getMessage();
}

More about exception handling: http://www.php.net/manual/en/language.exceptions.php

answered Apr 29, 2014 at 4:35

Aret

4753 silver badges10 bronze badges

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

2 Comments

boompow Over a year ago

That did not work. After the duplicate error is fired execution stops completely and the try/catch block does not do anything.

Aret Over a year ago

Maybe this will help: stackoverflow.com/questions/15858372/…

Collectives™ on Stack Overflow

MySQL Duplicate Entry Creates Internal Server Error

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related