Datatables error when viewing contact multiple record custom field tab containing a file field (#1186) · Issues · Development / Core

Datatables error when viewing contact multiple record custom field tab containing a file field

When clicking on a tab for a contact custom field group (multiple record, tab with table) if the custom group contains a file field and a record exists with a file attached, the following error is displayed and the DataTable does not display: DataTables warning: table id=records-6 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

I am on CiviCRM 5.16.1 on Joomla 3.9.11. This is reproducible on dmaster. I am pretty sure that this was working recently, no more than 1-2 months ago.

Steps to reproduce:

Create a custom group for contacts, multiple records, tab with table
Add fields to the new group:
- Field1 Alphanumeric - text
- Field2 Integer - text
- File File - select
Go to a contact and open the tab for the custom field group
Add a record, enter "asdf", "123" and upload a file.
Error will be seen: DataTables warning: table id=records-6 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

Firefox Network Monitor shows 500 Internal Server Error:

Request URL:https://dmaster.demo.civicrm.org/civicrm/ajax/multirecordfieldlist?snippet=4&cid=59&cgid=8&draw=1&columns%5B0%5D%5Bdata%5D=field1_14&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=field2_15&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=record_type_16&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=file_19&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=action&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=false&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&start=0&length=25&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1565849608494
Request method:GET
Remote address:192.95.2.129:443
Status code:
500
Version:HTTP/1.1
Referrer Policy:no-referrer-when-downgrade

When clicking on a tab for a contact custom field group (multiple record, tab with table) if the custom group contains a file field and a record exists with a file attached, the following error is displayed and the DataTable does not display:
`DataTables warning: table id=records-6 - Ajax error. For more information about this error, please see http://datatables.net/tn/7`

I am on CiviCRM 5.16.1 on Joomla 3.9.11. This is reproducible on dmaster. I am pretty sure that this was working recently, no more than 1-2 months ago.

Steps to reproduce:
1. Create a custom group for contacts, multiple records, tab with table
2. Add fields to the new group:
    - Field1  Alphanumeric - text
    - Field2  Integer - text
    - File    File - select
3. Go to a contact and open the tab for the custom field group
4. Add a record, enter "asdf", "123" and upload a file.
5. Error will be seen: `DataTables warning: table id=records-6 - Ajax error. For more information about this error, please see http://datatables.net/tn/7`

Firefox Network Monitor shows 500 Internal Server Error:
```
Request URL:https://dmaster.demo.civicrm.org/civicrm/ajax/multirecordfieldlist?snippet=4&cid=59&cgid=8&draw=1&columns%5B0%5D%5Bdata%5D=field1_14&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=field2_15&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=record_type_16&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=file_19&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=action&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=false&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&start=0&length=25&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1565849608494
Request method:GET
Remote address:192.95.2.129:443
Status code:
500
Version:HTTP/1.1
Referrer Policy:no-referrer-when-downgrade
```

Edited Aug 15, 2019 by andrewpthompson

To upload designs, you'll need to enable LFS. More information