Announcement

Collapse
No announcement yet.

Custom Fields not showing up in Layout Manager

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

  • Custom Fields not showing up in Layout Manager

    I'm having a sudden issue with the Layout Manager. Custom fields (Entity: Leads) are not showing up in the Available Fields column anymore. Well, they are for the List layout, but not for Detail (small), and Detail. The odd thing is that this all worked yesterday. When they stopped showing up in Detail (small), I checked Detail and they were there, but after a couple updates, they stopped showing up there as well.

    I have been making a lot of changes to layouts and fields, and I'm wondering if it's caused some debris to build up in the database or something?

    First image is List view, with all fields available for use.

    Second is Detail view, with only the default fields available. Weird thing I just noticed: the custom fields that are already in the layout can not be dragged back into the Available Fieldscolumn.

    Click image for larger version

Name:	image.png
Views:	292
Size:	60.1 KB
ID:	89875Click image for larger version

Name:	image.png
Views:	183
Size:	65.5 KB
ID:	89876

    I'm running EspoCRM 7.3.4. PHP version is 8.1.17, and MySQL version 8.0.32. This was all setup using the official Docker container within the last couple days.

    No JS console errors. My recent /var/logs are as follows:

    Code:
    [2023-03-23 17:21:06] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:06] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:06] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:06] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:06] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:06] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:07] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:07] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:07] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:07] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:07] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:07] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:07] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:07] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:07] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:07] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:07] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:07] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:08] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:08] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:08] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:08] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:08] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:08] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:08] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:09] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:09] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:09] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:09] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:09] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:09] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:09] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:10] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:10] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:10] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:10] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:18] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:18] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:18] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /PopupNotification/action/grouped; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:18] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:18] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:18] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    [2023-03-23 17:21:19] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/html/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
    
    ​

  • #2
    You don`t have connection to your database. Check credentials in data/config-internal.php

    Comment


    • #3
      While I do find the constant errors in the log file concerning, I ended up solving it by removing the sidebar from the offending layouts. Suddenly, the rest of the fields were available again. Aside from that, everything is functioning, so I must be connected.

      Comment

      Working...
      X