Custom Fields not showing up in Layout Manager

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • GordonZed
    Junior Member
    • Mar 2023
    • 8

    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:	414
Size:	60.1 KB
ID:	89875Click image for larger version

Name:	image.png
Views:	289
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 [] []
    
    ​
  • shalmaxb
    Senior Member
    • Mar 2015
    • 1606

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

    Comment

    • GordonZed
      Junior Member
      • Mar 2023
      • 8

      #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...