I have recently moved over to SuiteCRM, I have been using SugarCRM CE for about 3 years, however, although I have all the Data inside the appropriate tables, the relationships do not seem to work. Using Studio and trying to create any type of relationship a message “Database error see SugarCrm.log for details is displayed”. I have checked the log file and there are various missing relationships between different modules.
I removed all the entries in the relationship table using MS Management Studio and ran the Repair utility in SuiteCRM to recreate the entries. These were created in the dbo.relationship table in the database but still when I enter Studio in SuiteCRM under relationships all the modules are showing No relationship.
Anyone has any ideas please?