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
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
Comment