No Error Handling if duplicate Invoice ID is entered

I mistakenly entered an invoice ID that was already associated with another contribution for another contact. The error below occurs. I recreated the error multiple times by entering a non-unique Invoice ID.

Sorry. A non-recoverable error has occurred.

--------------------------------------------------------------------------------

DB Error: syntax error

Database Error Code: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 13, 1064

Return to home page.

Error Details:

Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)

[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] =>
SELECT c.id as contribution_id,
mp.membership_id as membership_id,
m.membership_type_id as membership_type_id,
pp.participant_id as participant_id,
p.event_id as event_id,
pgp.id as pledge_payment_id
FROM civicrm_contribution c
LEFT JOIN civicrm_membership_payment mp ON mp.contribution_id = c.id
LEFT JOIN civicrm_participant_payment pp ON pp.contribution_id = c.id
LEFT JOIN civicrm_participant p ON pp.participant_id = p.id
LEFT JOIN civicrm_membership m ON m.id = mp.membership_id
LEFT JOIN civicrm_pledge_payment pgp ON pgp.contribution_id = c.id
WHERE c.id = [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 13]
[type] => DB_Error
[user_info] =>
SELECT c.id as contribution_id,
mp.membership_id as membership_id,
m.membership_type_id as membership_type_id,
pp.participant_id as participant_id,
p.event_id as event_id,
pgp.id as pledge_payment_id
FROM civicrm_contribution c
LEFT JOIN civicrm_membership_payment mp ON mp.contribution_id = c.id
LEFT JOIN civicrm_participant_payment pp ON pp.contribution_id = c.id
LEFT JOIN civicrm_participant p ON pp.participant_id = p.id
LEFT JOIN civicrm_membership m ON m.id = mp.membership_id
LEFT JOIN civicrm_pledge_payment pgp ON pgp.contribution_id = c.id
WHERE c.id = [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 13]
[to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT c.id as contribution_id,
mp.membership_id as membership_id,
m.membership_type_id as membership_type_id,
pp.participant_id as participant_id,
p.event_id as event_id,
pgp.id as pledge_payment_id
FROM civicrm_contribution c
LEFT JOIN civicrm_membership_payment mp ON mp.contribution_id = c.id
LEFT JOIN civicrm_participant_payment pp ON pp.contribution_id = c.id
LEFT JOIN civicrm_participant p ON pp.participant_id = p.id
LEFT JOIN civicrm_membership m ON m.id = mp.membership_id
LEFT JOIN civicrm_pledge_payment pgp ON pgp.contribution_id = c.id
WHERE c.id = [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 13]"]
)