Help with a critical error

[BigBoss]

[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)

[victor]

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?

[BigBoss]

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.

[victor]

Did you try to make Rebuild or Hard Rebuild?

[BigBoss]

I've already tried this command, but I still get the same error. Here is the browser console

[victor]

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.

[BigBoss]

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.