Announcement

Collapse
No announcement yet.

Help with a critical error

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

  • Help with a critical error

    [2024-10-31 16:42:18] DEBUG: API (42S22) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contact.id' in 'where clause'; GET /669fb972c32728a78/CMarocmission; Route pattern: /{portalId}/{controller}; Route params: Array ( [controller] => CMarocmission [action] => index [portalId] => 669fb972c32728a78 )
    [2024-10-31 16:42:18] CRITICAL: (42S22) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contact.id' in 'where clause' :: GET /669fb972c32728a78/CMarocmission :: /var/www/html/dev/application/Espo/ORM/Executor/DefaultSqlExecutor.php(77)

  • #2

    Too little information to understand:

    - Which version of EspoCRM is used?
    - Under what circumstances does this error occur?
    ​- What actions in the settings through the UI or in the Espo files preceded this error?​
    - Did you try Rebuild or Hard Rebuild before creating this theme?​​

    Click image for larger version

Name:	image.png
Views:	36
Size:	44.4 KB
ID:	111937

    Comment


    • #3
      Espo 8.4.1,
      This issue occurs only when accessing the custom entity called CMarocmission via the portal and not through the standard interface. I also noticed that this problem appears when I assign the role for this entity to Contact. However, when I change the role to All, the issue disappears. I think it’s a relationship problem.


      Comment


      • victor
        victor commented
        Editing a comment
        Did you try to make Rebuild or Hard Rebuild?

    • #4
      I've already tried this command, but I still get the same error. Here is the browser console
      Click image for larger version

Name:	image.png
Views:	23
Size:	7.5 KB
ID:	111960​​

      Comment


      • victor
        victor commented
        Editing a comment
        It seems that when you enter the Portal as a user with "contact" rights, you get an error because you do not have a relationship between Contact and CMarocmission entities. Or that a similar relation once existed, and then it was deleted.

        That is, you should check the presence of a relay and create it (if there is none) between the above-mentioned entities or not use "contact" rights.
        Last edited by victor; 11-01-2024, 01:34 PM.

    • #5
      victor Hello, the relationship between the two entities already exists. Additionally, it is essential to access with contact rights, as this is a portal user, and I want them to be able to view only their own records.

      Comment

      Working...
      X