SQL error during creation of entry not handled properly

[dreerr]

Describe the Bug

I have a SQL table with a unique index which was generated with the command CREATE UNIQUE INDEX unique_names ON Akteure(lastName,firstName);

When trying to enter a duplicate item the Directus backend properly replies with at 400 error on the POST

In the frontend this error is not reflected, the form is stuck and the following is logged in the browser

To Reproduce

• Create an unique index on one or more fields
• Try to input duplicate data

Errors Shown

No response

What version of Directus are you using?

9.18.0

What version of Node.js are you using?

16.13.1

What database are you using?

10.5.12-MariaDB

What browser are you using?

Safari 15.6

How are you deploying Directus?

locally

[azrikahar]

Seems like this is the same issue as #15033, where the error from MySQL/MariaDB doesn't return the corresponding field causing said error, hence the app isn't "recognizing" the error in order to show it, as mentioned by this comment: #15033 (comment)

Closing this as duplicate of #15033, feel free to subscribe to it for future updates 👍

[azrikahar]

Just to add on a potential workaround in the meantime, you can refer to this comment here: #15063 (comment)

[dreerr]

Great that workaround works, sorry for not having found the duplicated issue!