Error 500 on cloning/duplicating a record

[shalmaxb]

When I try to clone/duplicate an existing record I get an Error 500 with the following in log-file:

[2024-12-06 07:04:36] DEBUG: API (0) Relation 'werke' does not exist.; POST /Werke/action/getDuplicateAttributes; Input data: {"id":"6639bce945dc8d254"}; Route pattern: /{controller}/action/{action}; Route params: Array ( [controller] => Werke [action] => getDuplicateAttributes )
[2024-12-06 07:04:36] CRITICAL: (0) Relation 'werke' does not exist. :: POST /Werke/action/getDuplicateAttributes :: /var/www/vhosts/xxxx.de/werkverzeichnis.xxxx.de/application/Espo/ORM/Defs/EntityDefs.php(246)

I see, that there is some relationship link missing, but I don`t find, in which other entity this is happening. The mentioned relation "werke" must be in another entity, because the entity, where I have the duplication problem itself is "Werke" and I did not link it to itself.

[lazovic]

Hi shalmaxb,

Could you please share the {ESPO_DIR/custom/Espo/Custom folder so that we can reproduce this issue and find a solution? You could also try searching the files in that folder to see if there is any extra relationship left.

[shalmaxb]

Hi lazovic, thank you for your suggestion. I have a few identical installations of the same (my) app. So I compared the downloaded custom folder of a working installation without that error with the one producing the error. I did not find any left or missing relationship, though.

The error log does not tell me or point me to, in which entity the relation "werke" does not exist. The entity, where the error happens is the entity "Werke", which has some relationships with other entities (11 in total), which I checked all.

I do not know, if it has to do with the duplicate check. Before duplicate check had been integrated in the admin GUI, I had some duplicate checks coded according to the documentation for this entity. Although, I deactivated all these "old" duplicate checks, which I thought could be the culprit, the error persisted.

Before I send my custom folder to you, let me one more time check these places. Perhaps I missed anything.
Thank you for your help.

[shalmaxb]

lazovic
Hi, I managed to solve this issue in my app. It was not possible due to so many files to search in the file content, where the culprit could be found. So I managed to solve it by another approach. Perhaps this would be helpful for others, who also have more than one identical app installation.

I used a program to synchronize files, which you can find here: https://freefilesync.org/download.php
It is free but there is a donation version, which has some more features.

That program is able to compare whole folder structures as the custom folders in espoCRM. As I had a working installation without the error, I succeded in repairing the installations with the errors by exchanging files in the not working installaition by comparing and modifying, which all was made by that program automatically by the right configuration.
The only thing I could still complain is, that I did not manage to know, from where the error happened.