Announcement

Collapse
No announcement yet.

Odd error when running report

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

  • Odd error when running report

    I'm on all the latest version 6.1.4, Advanced Reporting 2.7.1, voip 1.6.1. When running a report all users receive a 500 error and this is in the log:

    [2021-03-03 23:28:16] DEBUG: API (42S22) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'assignedUser.voip_test_connection' in 'field list'; GET /Report/action/runList; Route pattern: /{controller}/action/{action}; Route params: Array ( [controller] => Report [action] => runList ) [] []
    [2021-03-03 23:28:16] ERROR: (42S22) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'assignedUser.voip_test_connection' in 'field list'; GET /Report/action/runList; line: 1641, file: /var/www/html/application/Espo/Modules/Advanced/Services/Report.php [] []

    How do I get to the bottom of this?

  • #2
    Hello,
    Please provide the screenshot of your Report configs.

    Comment


    • #3

      Comment


      • #4
        I see. Please remove the 'Assigned User. ' column from the Columns filed.

        Comment

        Working...
        X