A 500 error occurs when selecting multiple leads in the Target List.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lj4353
    Senior Member
    • Nov 2023
    • 154

    #1

    A 500 error occurs when selecting multiple leads in the Target List.

    We are currently experiencing an issue with the Target List module. When selecting a large number of leads, the system returns a 500 Internal Server Error. Selecting a smaller number of leads works without any problems.
    Click image for larger version

Name:	image.png
Views:	13
Size:	81.4 KB
ID:	118566
  • yuri
    Member
    • Mar 2014
    • 9050

    #2
    What error is printed in espo log?

    There can be also an error in the webserver log (if it's caused by a too large GET request).

    Note that you can also select all result rather than selecting many checkboxes.
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment


    • lj4353
      lj4353 commented
      Editing a comment
      [2025-06-10 07:34:13] CRITICAL: (42S22) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lead_target_list.api' in 'field list' :: POST /TargetList/684658ae6ee616dd0/leads :: /application/Espo/ORM/Executor/DefaultSqlExecutor.php(77)

      I found that the item "api" does not exist in my table. Is this necessary? I select all the results.
  • yuri
    Member
    • Mar 2014
    • 9050

    #3
    I really don't know what is origin of this error. It looks unfamiliar to me. Maybe some customization?

    Note that creating columns manually is never an option. The system is supposed to create all necessary columns automatically on rebuild.
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    Working...