Every time I access the email module, I am seeing tons of these errors in the suitecrm.log.
Sat Jun 10 20:30:30 2023 [2488][1][ERROR] Unable to find relationship emails_email_templates
Sat Jun 10 20:30:30 2023 [2488][1][ERROR] Unable to find relationship emails_email_templates
Sat Jun 10 20:30:30 2023 [2488][1][ERROR] Unable to find relationship emails_email_templates
Sat Jun 10 20:30:30 2023 [2488][1][ERROR] Unable to find relationship emails_email_templates
Sat Jun 10 20:30:30 2023 [2488][1][ERROR] Unable to find relationship emails_email_templates
Sat Jun 10 20:30:30 2023 [2488][1][ERROR] Unable to find relationship emails_email_templates
Sat Jun 10 20:30:30 2023 [2488][1][ERROR] Unable to find relationship emails_email_templates
Sat Jun 10 20:30:30 2023 [2488][1][ERROR] Unable to find relationship emails_email_templates
Sat Jun 10 20:30:30 2023 [2488][1][ERROR] Unable to find relationship emails_email_templates
Not sure if it is related, but when I do Repair > Sync of Inbound, I see the following message:
I’ve had tons of these too. Watching if anyone has ideas.
I tried to troubleshoot once (If my memory serves me correctly) and searched the DB for the ID that was referenced in the error. It referenced a specific email. I deleted the email and the error went away. That’s as far as I got. I still get them, not sure the root cause.
I did this mod initially on v8.3.0 but not as a custom change. It got wiped in V8.3.1 so I am doing the same mod as a custom change. This seems to work for now.
I did a grep search on the files to see where the relationship exists. The relationship definition exists but is missing from the main catalog of relationships so I am adding it here as a custom file.
The missing relationship exists in this file. My server is ubuntu 20.04 LTS, php 8.0, mariadb 10.x
However, at the bottom of that file is a catch-all for custom relationships:
if (file_exists('custom/application/Ext/TableDictionary/tabledictionary.ext.php')) {
include('custom/application/Ext/TableDictionary/tabledictionary.ext.php');
}
then did repairs for general and relationships, checked the logs and the error stopped. I don’t know if the catalog isn’t being built properly but this seems to be a temp fix an error that fills the logs.
If that doesn’t work, you have some double-definition of that relationship somwhere, you probably need to clean-up something from your previous attempts…
I don’t know much about this error, so I am not sure how to help you.
You might want to also look in the fields_metadata table in the DB. Just be careful what you change there, make sure you can revert your changes if necessary.
I have this error spamming my log as well as :
Unable to find relationship projects_contacts_resources
Unable to find relationship am_projecttemplates_contacts_resources
is there any upgrade friendly way of fixing this ? in suitecrm V8.6.2