No announcement yet.

Error 500 in Users

  • Filter
  • Time
  • Show
Clear All
new posts

  • Error 500 in Users

    EspoCRM: v8.0.5

    Error Logs:
    [2023-11-18] ERROR: (42000) SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'emailUser'; GET /User/1/emails; line: 76, file: /home/website/domains/
    Browser Console error:
    XMLHttpRequest { errorIsHandled: false, readyState: 4, timeout: 60000, withCredentials: false, upload: XMLHttpRequestUpload, responseURL: "[URL="https://website"] %2CpersonStringData&maxSize=20&offset=0&orderBy=da teSent&order=desc[/URL]", status: 500, statusText: "", responseType: "", response: "" }​
    Just want to reduce my Error logs, I notice this error even before v8 but haven't investigate it. Anyone else ever see this error in their logs? It happen when you access a details views of users, for example:

    Trying to see if I can track down a fix:

    EspoCRM did seem to have any issue though, I can access all field/view. Looking through my database don't see the column:
    Click image for larger version  Name:	image.png Views:	0 Size:	87.2 KB ID:	99863
    Trying to track down the column:
    Click image for larger version

Name:	image.png
Views:	45
Size:	38.6 KB
ID:	99864
    Last edited by espcrm; 11-18-2023, 05:08 AM.

  • #2
    Does the user has 'team' level access for Email?


    • #3
      This is User #1 (admin) so it should have everything. I will double check Email team access and reply. Thank you for the hint.


      • item
        item commented
        Editing a comment
        Another hint :
        if you see in your phpMyAdmin :

        {entityType}_id => it's a link (belongTo ?)

        {entityType}{entityType} => it's a middleTable, it's a many-to-many table.

        In your case : emailUser =>
        email entity
        user entity
        so the middle table is : email_user
        there are no field emailUser