Announcement

Collapse
No announcement yet.

Account when remove shows ERROR 500

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Account when remove shows ERROR 500

    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.

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

    Also check server error log, please
    Job Offers and Requests

    Find Developer
    Find Customer

    Comment


    • #3
      "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
      },

      Comment


      • #4
        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
        Job Offers and Requests

        Find Developer
        Find Customer

        Comment


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

          Please suggest me the solutions, Please.

          Comment


          • #6
            No idea, we don't support old versions...
            Job Offers and Requests

            Find Developer
            Find Customer

            Comment

            Working...
            X