Unable to Save a Report Containing Multiple Summary Columns.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • PavelZ
    Member
    • Jan 2023
    • 58

    #1

    Unable to Save a Report Containing Multiple Summary Columns.

    Reports
    EspoCRM 9.3.8
    PHP 8.4.18
    MySQL 8.4.8

    I need this bug description translated into English:

    If I create a report with one column of type summary and the formula SUM : ( duration ), everything saves correctly and works as expected.

    If I create another report with one column of type summary and the formula DIV : ( MOD : ( ( SUM : duration ), 3600 ), 60 ), everything is also OK.

    However, when I create a report with two summary columns, where one column uses SUM : ( duration ) and the second uses DIV : ( MOD : ( ( SUM : duration ), 3600 ), 60 ), the report cannot be saved and an error message is shown.

    As soon as a report contains more than one summary column, the report cannot be saved.

    Error message: Internal server error.



    Click image for larger version

Name:	image.png
Views:	0
Size:	37.6 KB
ID:	126781
  • yuri
    EspoCRM product developer
    • Mar 2014
    • 9858

    #2
    Knowing the error message from the log would be helpful.

    I could not reproduce.

    Comment


    • PavelZ
      PavelZ commented
      Editing a comment
      Hi, [2026-06-14 18:30:07] CRITICAL: (22001) SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'chart_color' at row 1 :: PUT /Repor
      t/6a2bf221841a8b8ee :: /var/www/html/application/Espo/ORM/Executor/DefaultSqlExecutor.php(77)
  • PavelZ
    Member
    • Jan 2023
    • 58

    #3

    Hi, I've found out that this is related to the Ebla Theme extension. I'll get in touch with them. Thank you

    Comment

    Working...