Reports - 400: Bad request or Bad server response

[thanassos]

Hi,
I have an issue since about 2 months (without updates or anything done on ESPO)
when I want to acces a report or export any reports I have some 400: Bad request or Bad server response

Here are the logs :

[2021-09-06 07:17:51] Espo.ERROR: Uncaught Exception Error: "Call to a member function translate() on null" at /var/www/vhosts/espo.etsprotection.fr/httpdocs/application/Espo/Modules/Advanced/Services/Report.php line 840 {"exception":"[object] (Error(code: 0): Call to a member function translate() on null at /var/www/vhosts/espo.etsprotection.fr/httpdocs/application/Espo/Modules/Advanced/Services/Report.php:840)"} []
[2021-09-06 07:17:56] Espo.WARNING: E_WARNING: in_array() expects parameter 2 to be array, string given {"code":2,"message":"in_array() expects parameter 2 to be array, string given","file":"/var/www/vhosts/espo.etsprotection.fr/httpdocs/application/Espo/Modules/Advanced/Services/Report.php","line":429,"context":{"columns":["name","firstName","account","emailAddress","a ssig nedUser"],"entityType":"Contact","params":{"joins":[],"leftJoins":["account"],"whereClause":[],"customJoin":"","additionalSelectColumns":[],"joinConditions":[],"offset":0,"limit":20,"select":["name","firstName"]},"linkColumns":[],"item":"account"}} []
[2021-09-06 07:17:56] Espo.WARNING: E_WARNING: in_array() expects parameter 2 to be array, string given {"code":2,"message":"in_array() expects parameter 2 to be array, string given","file":"/var/www/vhosts/espo.etsprotection.fr/httpdocs/application/Espo/Modules/Advanced/Services/Report.php","line":432,"context":{"columns":["name","firstName","account","emailAddress","a ssig nedUser"],"entityType":"Contact","params":{"joins":[],"leftJoins":["account"],"whereClause":[],"customJoin":"","additionalSelectColumns":[],"joinConditions":[],"offset":0,"limit":20,"select":["name","firstName","accountName"]},"linkColumns":[],"item":"account"}} []
[2021-09-06 07:17:56] Espo.WARNING: E_WARNING: in_array() expects parameter 2 to be array, string given {"code":2,"message":"in_array() expects parameter 2 to be array, string given","file":"/var/www/vhosts/espo.etsprotection.fr/httpdocs/application/Espo/Modules/Advanced/Services/Report.php","line":429,"context":{"columns":["name","firstName","account","emailAddress","a ssig nedUser"],"entityType":"Contact","params":{"joins":[],"leftJoins":["account","assignedUser"],"whereClause":[],"customJoin":"","additionalSelectColumns":[],"joinConditions":[],"offset":0,"limit":20,"select":["name","firstName","accountName","accountId"," emai lAddress"]},"linkColumns":["account"],"item":"assignedUser"}} []
[2021-09-06 07:17:56] Espo.WARNING: E_WARNING: in_array() expects parameter 2 to be array, string given {"code":2,"message":"in_array() expects parameter 2 to be array, string given","file":"/var/www/vhosts/espo.etsprotection.fr/httpdocs/application/Espo/Modules/Advanced/Services/Report.php","line":432,"context":{"columns":["name","firstName","account","emailAddress","a ssig nedUser"],"entityType":"Contact","params":{"joins":[],"leftJoins":["account","assignedUser"],"whereClause":[],"customJoin":"","additionalSelectColumns":[],"joinConditions":[],"offset":0,"limit":20,"select":["name","firstName","accountName","accountId"," emai lAddress","assignedUserName"]},"linkColumns":["account"],"item":"assignedUser"}} []
[2021-09-06 07:18:00] Espo.DEBUG: API (400) GET /api/v1/Contact/action/export?ids%5B%5D=595f7aa2ab11e0354&ids%5B%5D=595f7 aa25fb961218&ids%5B%5D=595f7a8c1c1145e7a&ids%5B%5D =595f7a763d1d3415a&ids%5B%5D=595f7a6907ddafa1d&ids %5B%5D=595f7aa9aa1af4019&ids%5B%5D=595f7aaa5cef5df 4b&ids%5B%5D=596f337a45d79d178&ids%5B%5D=597efce8 7 cb03d5e1&ids%5B%5D=59969d445f279d0de&ids%5B%5D=599 6e1d38af645a9a&ids%5B%5D=59c3c767448b9e66e&ids%5B% 5D=59c3c9543cec64ab8&ids%5B%5D=59d7589aca532275b&i ds%5B%5D=59d758be3a6a3cf57&ids%5B%5D=59e84863c04b8 9399&ids%5B%5D=5a0f0d1877195566e&ids%5B%5D=5a15b49 a855cf3130&ids%5B%5D=5a1ef324ec0122207&ids%5B%5D=5 a33d58ecd1342216; Route pattern: /:controller/action/:action; Route params: Array ( [controller] => Contact [action] => export ) [] []
[2021-09-06 07:18:00] Espo.ERROR: (400) GET /api/v1/Contact/action/export?ids%5B%5D=595f7aa2ab11e0354&ids%5B%5D=595f7 aa25fb961218&ids%5B%5D=595f7a8c1c1145e7a&ids%5B%5D =595f7a763d1d3415a&ids%5B%5D=595f7a6907ddafa1d&ids %5B%5D=595f7aa9aa1af4019&ids%5B%5D=595f7aaa5cef5df 4b&ids%5B%5D=596f337a45d79d178&ids%5B%5D=597efce8 7 cb03d5e1&ids%5B%5D=59969d445f279d0de&ids%5B%5D=599 6e1d38af645a9a&ids%5B%5D=59c3c767448b9e66e&ids%5B% 5D=59c3c9543cec64ab8&ids%5B%5D=59d7589aca532275b&i ds%5B%5D=59d758be3a6a3cf57&ids%5B%5D=59e84863c04b8 9399&ids%5B%5D=5a0f0d1877195566e&ids%5B%5D=5a15b49 a855cf3130&ids%5B%5D=5a1ef324ec0122207&ids%5B%5D=5 a33d58ecd1342216; line: 235, file: /var/www/vhosts/espo.etsprotection.fr/httpdocs/application/Espo/Core/Controllers/Record.php [] []

ESPO Version : 5.9.4

[Vadym]

Hi thanassos,

Try to upgrade your EspoCRM instance:

https://docs.espocrm.com/administration/upgrading/#upgrade-from-cli

[thanassos]

After upgrading to the latest version, everything is broken errors 500 everywhere

2021-09-10 13:06:06 Error 500 GET /api/v1/Activities/action/popupNotifications HTTP/1.0 https://---------------------/ Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.159 Safari/537.36 442 Apache SSL/TLS access
2021-09-10 13:06:08 Error 500 GET /api/v1/Activities/action/popupNotifications HTTP/1.0 https://---------------------/ Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:92.0) Gecko/20100101 Firefox/92.0 442 Apache SSL/TLS access
2021-09-10 13:06:09 Error 500 GET /api/v1/Notification/action/notReadCount HTTP/1.0 https://---------------------/ Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:92.0) Gecko/20100101 Firefox/92.0 442 Apache SSL/TLS access
2021-09-10 13:06:11 Error 500 GET /api/v1/Activities/action/popupNotifications HTTP/1.0 https://---------------------/ Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:92.0) Gecko/20100101 Firefox/92.0 442 Apache SSL/TLS access
2021-09-10 13:06:11 Error 500 GET /api/v1/Notification/action/notReadCount HTTP/1.0 https://---------------------/ Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.159 Safari/537.36 442 Apache SSL/TLS access
2021-09-10 13:06:12 Error 500 GET /api/v1/Notification/action/notReadCount HTTP/1.0 https://---------------------/ Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:92.0) Gecko/20100101 Firefox/92.0 442 Apache SSL/TLS access
2021-09-10 13:06:17 Error 500 GET /api/v1/Notification/action/notReadCount HTTP/1.0 https://---------------------/ Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36 442 Apache SSL/TLS access
2021-09-10 13:06:19 Error 500 GET /api/v1/Notification/action/notReadCount HTTP/1.0 https://---------------------/ Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:92.0) Gecko/20100101 Firefox/92.0 442 Apache SSL/TLS access
2021-09-10 13:06:19 Error 500 GET /api/v1/Activities/action/popupNotifications HTTP/1.0

[Vadym]

Hi thanassos,

Try to enable .htaccess support & restart Apache:

https://docs.espocrm.com/administration/apache-server-configuration/#2-enable-htaccess-support