Account when remove shows ERROR 500

[VigneshChinnaiyan]

Hello,

This is the ERROR LOG is added when i try to delete the account.

[2018-06-26 03:45:24] Espo.ERROR: API [PATCH]:/:controller/:id, Params:Array ( [controller] => Account [id] => 5b31b6cc60dcd8860 ) , InputData: {"purposeOfTheUnitbiz":["Accomodation and Food Service Activities","Administrative and Support Service Activities","Activities of Households as Employers of Domestic Personnel","Activities Not Adequately Defined"]} - SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `purpose_of_the_unitbiz` = '["Accomodation and Food Service Activities","Adm' at line 1 [] []

[2018-06-26 03:45:24] Espo.ERROR: Display Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `purpose_of_the_unitbiz` = '["Accomodation and Food Service Activities","Adm' at line 1, Code: 42000 URL: /slp/api/v1/Account/5b31b6cc60dcd8860 [] []

This says that the purpose_of_the_unitbiz (Multi-Enum) have some issue. I cannot find any issue with this field, Can you help me to fix this.

Thanks.

[tanya]

Hi,
could you share entityDefs of this field?
(custom/Espo/Custom/Resources/metadata/entityDefs/Account.json)

Also check server error log, please

[VigneshChinnaiyan]

"purposeOfTheUnitbiz": {
"type": "multiEnum",
"required": true,
"options": [
"",
"Activities of Extra-Territorial Organisations and Bodies",
"Accomodation and Food Service Activities",
"Activities of Households as Employers of Domestic Personnel",
"Activities Not Adequately Defined",
"Administrative and Support Service Activities",
"Agriculture and Fishing",
"Arts, Entertainment and Recreation",
"Construction",
"Education",
"Electricity, Gas, Steam and Air-Conditioning Supply",
"Financial and Insurance Activities",
"Health and Social Services",
"Information and Communications",
"Manufacturing",
"Mining and Quarrying",
"Professional, Scientific and Technical Activities",
"Public Administration and Defence",
"Real Estate Activities",
"Transportation and Storage",
"Water Supply, Sewerage, Waste Management and Remediation Activities",
"Wholesale and Retail Trade",
"Other Service Activities"
],
"tooltipText": "Select Minimum 1 and Maximum 3",
"isSorted": false,
"audited": false,
"readOnly": false,
"tooltip": true,
"isCustom": true,
"noEmptyString": false
},

[tanya]

Hello again.
Just tested, works well on my instance. Creating, editing, removing - no issues.

EspoCRM 5.2.5
MySQL 5.5.6
PHP 7.2

[VigneshChinnaiyan]

My version of EspoCRM is old 4.8, Is that a problem?

Please suggest me the solutions, Please.

[tanya]

No idea, we don't support old versions...