We have these errors in logs/legacylog_crm.log log file
Tue Feb 18 2025 at 10:35:14 [184516][9837b95d-d18b-255e-d81c-543f89aa6bdc][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Feb 18 2025 at 10:35:14 [184516][9837b95d-d18b-255e-d81c-543f89aa6bdc][ERROR] Unable to find relationship am_projecttemplates_users_resources
we do not use (and not even have installed) that module but in Studio we see the relationship on User and Contacts
In general we see a lot of errors like “[ERROR] Unable to find relationship” and each error is repeated for every bean shown, so 100 beans (contacts) for us means about 6 errors each, total 600 errors
Ho to remove relationships we do not use? We’ve tried in Studio, but apparently we cannot remove relationships
You could try a “Find in files” looking for am_projecttemplates under custom directory to find any left-overs.
There is also the fields_meta_data table in the database, look there.
Be careful before making any changes, have your backups ready or do a VM snapshot before starting.
you mean search a for files in that directory with content am_projecttemplates ?
yes, this is what I see
[root@crm crm.bwlocal.it]# grep -r am_projecttemplates public/legacy/custom/
public/legacy/custom/modules/Project/metadata/editviewdefs.php.suback.php: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/modules/Project/metadata/editviewdefs.php: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1613601600: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615006371: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1613601004: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615006298: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615004920: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1616452118: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615006051: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615004895: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1613600735: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1613169845: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615005405: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615006215: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615005334: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615006185: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615005867: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615006482: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615004734: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1613601375: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615006499: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1590921915: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615006091: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615006002: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615006291: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615004869: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1613600934: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615006112: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615005302: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615005672: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1609867833: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1590922378: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1590924349: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615005476: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1613601318: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1690900256: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1613600983: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615006412: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615004716: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615006913: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615006923: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615006859: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615005118: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1686556560: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1613600456: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615005623: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615005623: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1613600456: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615005118: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615006913: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615006923: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615006859: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615004716: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615006412: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1616452217: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1616452227: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1613601318: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1613600983: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1590922378: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1637861667: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1609867833: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615005476: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1590924349: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615005302: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615005672: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615006112: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1613600934: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615004869: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1613169797: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615006291: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615006091: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615006002: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1590921915: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615006499: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615004734: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1613601375: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615006185: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615005867: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615006482: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615006215: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615005334: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615005405: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1613169845: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615004895: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1613600735: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1616452118: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1615006051: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615004920: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615006371: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/detailviewdefs.php_1613601004: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1615006298: 'name' => 'am_projecttemplates_project_1_name',
public/legacy/custom/history/modules/Project/metadata/editviewdefs.php_1613601600: 'name' => 'am_projecttemplates_project_1_name',
we’ve tried (in dev) to remove references to am_projecttemplatess in /public/legacy/modules/*/vardefs.php files, and after a repair error disappears … so somehow we removed relationships that cannot be found removing them from those files, but I guess this is not the way to go.
Should we be able to operate with Studio in Suite8.8? should we be allowed to remove relationships between beans there? cause apparently we are not
Did you check fields_meta_data table in the DB?
I wouldn’t worry too much for deleting references to relationships that cause errors, and that you don’t use.
The UI tools such as Studio and Module Builder are not perfect, and the sheer complexity of the evolution of a real-world SuiteCRM system, sometimes causes left-overs and things that need cleaning up. All of the upgrades you made, all the add-ons turned on and off, all the Studio changes… there are corner cases that can be buggy, and it’s ok to clean up manually if you know there are no significant consequences (due to not using the modules, or just because you tested).