error when adding/editing data in a view

error when adding/editing data in a view

I have an application with a Customers form, a Contacts form and a Customers_Contacts associative (many-to-many) form.

I added some rows to the Customers_Contacts form today and one of the rows was showing the Contact field as being empty in the view, even though I had, of course, selected both a customer and a contact when adding the row.

I then tried to edit the row to add the contact, but each time I tried this it was generating an internal server error (500).

The problem seems to be specific to a particular contact with an apostrophe in their surname ("D'Mello"). I wonder if the apostrophe is causing some trouble here?

Anyway, I would be grateful for any assistance. I have already shared this app. ("Customer Billing") with support@zohocreator.com.

Thanks,
Anton