Announcement

Collapse
No announcement yet.

500 while searching, v.6.0.2

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

  • 500 while searching, v.6.0.2

    entitydefs: Account.json

    Code:
    "accountCategories": {
    "type": "linkMultiple",
    "layoutDetailDisabled": true,
    "layoutMassUpdateDisabled": true,
    "importDisabled": true,
    "noLoad": true,
    "isCustom": true
    },
    "fullInfo": {
    "name": "fullInfo",
    "label": "Полная информация",
    "type": "jsonObject",
    "dynamicLogicVisible": null,
    "dynamicLogicReadOnly": null,
    "inlineEditDisabled": true,
    "tooltip": false,
    "isCustom": true
    },
    AccountCategory,json :

    Code:
    "fullInfo": {
    "name": "fullInfo",
    "label": "Полная информация",
    "type": "jsonObject",
    "dynamicLogicVisible": null,
    "dynamicLogicReadOnly": null,
    "inlineEditDisabled": true,
    "tooltip": false,
    "isCustom": true
    },
    Search by accountCategory: any of "category"

    Error log:
    [2020-10-27 16:04:02] Espo.ERROR: (23000) SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'full_info' in field list is ambiguous; GET /Account; line: 93, file: /public_html/application/Espo/ORM/SthCollection.php [] []

    I assume that the table name is not substituted into the query

  • #2
    Debugged. Closed.
    Problem with another field with select without table name.

    Code:
    "select": "CAST(JSON_VALUE(account.full_info, '$.ratingData.ratingValue') AS DECIMAL(5,2))",

    Comment

    Working...
    X