Control what your users can access and save time, money, and frustrations. Lock down sensitive data in SugarCRM or SuiteCRM to specific groups or teams. Supports unlimited assigned users, unlimited group assignments to records, custom layouts for each group, login/sudo capabilities and much more.
#23 - Studio > Module > Field & Relationships = "An error has occured" popup
After I installed the 6.5.5 basic security suite a popup error shows when I drill into a field name (stock or custom).
"An error has occured" {"east":{"title":"Edit Field","crumb":"","content":" <\/div>\n\n
Also getting an error when going into relationships
"An error has occured" {"center":{"title":"Accounts Relationships","crumb":"\"\"<\/a> \"\"<\/a> | Studio<\/a> > Accounts<\/a> > Relationships<\/span>
","content":"\n <\/div>\n* relationship created in Studio<\/h3>
I did go through the Admin > Repair Quick Repair and Rebuild Rebuild Relationships Repair Roles
The error still shows, I even went as far as uninstalling the 6.5.5 basic security suite and did the Admin > Repairs again..
Please advise!
-
"Very responsive development team, both in their communication and in having improvements incorporated and issues resolved." - kevin
Read More Reviews
- Most Recent Love from Users
kacsoristvan- damien8105
- anri
- Administrador
- Stefano1
- einkauf2
11 years ago
This happens when you are running a version of SecuritySuite that does not match your version of SugarCRM. The quick solution is to update SecuritySuite to the correct version. The temporary solution is to edit config.php and set securitysuite_version to your SugarCRM version. This will make the error go away, but SecuritySuite will not 100% work as there are many core file changes that will be out of sync. Another temporary solution is to edit modules/SecurityGroups/VersionCheck.php and add the following condition to the is_admin() if statement:
&& empty($_REQUEST['to_pdf']) && empty($_REQUEST['sugar_body_only'])
This checks to see if an ajax request (such as Studio does) and if so then don't return the check.
11 years ago
By the way, this specific issue that happens when versions do not match, and only for administrator users, has been fixed in 6.5.8.
11 years ago
Thanks for your prompt reply, This is not the case, we are on 6.5.5 CRM and the same for SecuritySuite.
I uninstalled SecuritySuite again, and checked the config file. There is no longer a reference to securitySuite in the config.php file. Here are the securitysuite config parameters before I uninstalled.
'securitysuite_additive' => true, 'securitysuite_filter_user_list' => false, 'securitysuite_inherit_assigned' => true, 'securitysuite_inherit_creator' => true, 'securitysuite_inherit_parent' => true, 'securitysuite_popup_select' => false, 'securitysuite_strict_rights' => false, 'securitysuite_user_popup' => true, 'securitysuite_user_role_precedence' => true, 'securitysuite_version' => '6.5.5',
11 years ago
It is working on a 6.5.5 install here so I think it is still related to the same ajax issue. Can you check custom/modules/logic_hooks.php and remove any "SecurityGroups" logic hooks (comment out or delete)? Not sure if the uninstaller gets those removed correctly. Also, can you open up Firebug or another tool and see the whole response? There should be some interesting code at the end of the response that is causing the display to break.
If those do not exist then there is something wonky with the Sugar install. If it gets to that point, most of the time (like 99%) it is due to file permission issues.
11 years ago
custom/modules/logic_hooks.php DID NOT have any reference of SecurityGroups
Here is the firebug results: {"east":{"title":"Edit Field","crumb":"","content":"
<
div id=\"overDiv\" style=\"position:absolute; visibility:hidden; z-index:1000\"><\/div>\n\n\naddForm('popup_form');\n<\/script>\n\n\n
<
form name='popup_form' id='popup_form_id' onsubmit='return false;'>\n\n\n\n\n\n\n\t\t \n\t \n\t \n\t \t\n\t
\n\n
<
table width=\"400px\" >\n
\n Data Type:<\/td>\n11 years ago
trying again
{"east":{"title":"Edit Field","crumb":"","content":"<\/div>\n\n\naddForm('popup_form');\n<\/script>\n\n\n\n\n\n\n\n\n\n\t\t \n\t \n\t \n\t \t\n\t\n\n\n\n Data Type:<\/td>\n11 years ago
Nothing obviously wrong at the end of that json that was returned. Could it be a custom field/relationship with a quote or some other special char in the name? Since SecuritySuite is uninstalled and it still has errors I can't pin point this to SecuritySuite. Works just fine in the test environments and in all the other 6.5.5 installs out there. Any errors that you can find in the console or sugarcrm.log? I'd like to help you get this sorted out.
11 years ago
Ok, I don't see any quote or special characters in any fields or custom fields or relationships. There is another console error when I go to Admin> Studio> Accounts>Relationships As well as two 404's referencing
https://mycrmdomain.com/%5C%22themes%5C/Sugar5%5C/images%5C/icon_back.gif?v=CQYT1nqdH2TFCyUVyLvIaA\%22
https://mycrmdomain.com/%5C%22themes%5C/Sugar5%5C/images%5C/icon_home.gif?v=CQYT1nqdH2TFCyUVyLvIaA\%22
{"center":{"title":"Accounts Relationships","crumb":"
<\/a> 
<\/a> | Studio<\/a> > Accounts<\/a> > Relationships<\/span>
","content":"\n
<
div id='relGrid'><\/div>\n* relationship created in Studio<\/h3>\n\n\/\/Workaround for YUI bug 2527707: http:\/\/yuilibrary.com\/projects\/yui2\/ticket\/913efafad48ce433199f3e72e4847b18, should be removed when YUI 2.8+ is used\nYAHOO.widget.DataTable.prototype.getColumn = function(column) {\n var oColumn = this._oColumnSet.getColumn(column);\n\n if(!oColumn) {\n \/\/ Validate TD element\n var elCell = column.nodeName.toLowerCase() != \"th\" ? this.getTdEl(column) : false;\n if(elCell) {\n oColumn = this._oColumnSet.getColumn(elCell.cellIndex);\n }\n \/\/ Validate TH element\n else {\n elCell = this.getThEl(column);\n if(elCell) {\n \/\/ Find by TH el ID\n var allColumns = this._oColumnSet.flat;\n for(var i=0, len=allColumns.length; i<len; i++) {\n if(allColumns[i].getThEl().id === elCell.id) {\n oColumn = allColumns[i];\n } \n }\n }\n }\n }\n if(!oColumn) {\n YAHOO.log(\"Could not get Column for column at \" + column, \"info\", this.toString());\n }\n return oColumn;\n};\n\nvar relationships = {relationships:[{\"id\":\"6296e139-1732-5de1-c3d7-50be3cf24da8\",\"relationship_name\":\"campaign_accounts\",\"lhs_module\":\"Campaigns\",\"lhs_table\":\"campaigns\",\"lhs_key\":\"id\",\"rhs_module\":\"Accounts\",\"rhs_table\":\"accounts\",\"rhs_key\":\"campaign_id\",\"join_table\":null,\"join_key_lhs\":null,\"join_key_rhs\":null,\"relationship_type\":\"One to Many\",\"relationship_role_column\":null,\"relationship_role_column_value\":null,\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":\"default\",\"lhs_subpanel\":null,\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"campaign_accounts\"},{\"id\":\"7956627b-4abd-d290-0ae4-50be3c5c420b\",\"relationship_name\":\"accounts_modified_user\",\"lhs_module\":\"Users\",\"lhs_table\":\"users\",\"lhs_key\":\"id\",\"rhs_module\":\"Accounts\",\"rhs_table\":\"accounts\",\"rhs_key\":\"modified_user_id\",\"join_table\":null,\"join_key_lhs\":null,\"join_key_rhs\":null,\"relationship_type\":\"One to Many\",\"relationship_role_column\":null,\"relationship_role_column_value\":null,\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":null,\"lhs_subpanel\":null,\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"accounts_modified_user\"},{\"id\":\"798bdb58-2625-5e94-c90f-50be3cd16ea1\",\"relationship_name\":\"accounts_created_by\",\"lhs_module\":\"Users\",\"lhs_table\":\"users\",\"lhs_key\":\"id\",\"rhs_module\":\"Accounts\",\"rhs_table\":\"accounts\",\"rhs_key\":\"created_by\",\"join_table\":null,\"join_key_lhs\":null,\"join_key_rhs\":null,\"relationship_type\":\"One to Many\",\"relationship_role_column\":null,\"relationship_role_column_value\":null,\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":null,\"lhs_subpanel\":null,\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"accounts_created_by\"},{\"id\":\"79c1a7a0-9c5b-8f1d-6af6-50be3cc5d973\",\"relationship_name\":\"accounts_assigned_user\",\"lhs_module\":\"Users\",\"lhs_table\":\"users\",\"lhs_key\":\"id\",\"rhs_module\":\"Accounts\",\"rhs_table\":\"accounts\",\"rhs_key\":\"assigned_user_id\",\"join_table\":null,\"join_key_lhs\":null,\"join_key_rhs\":null,\"relationship_type\":\"One to Many\",\"relationship_role_column\":null,\"relationship_role_column_value\":null,\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":null,\"lhs_subpanel\":null,\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"accounts_assigned_user\"},{\"id\":\"7a654658-3892-541f-1a35-50be3c7e112a\",\"relationship_name\":\"member_accounts\",\"lhs_module\":\"Accounts\",\"lhs_table\":\"accounts\",\"lhs_key\":\"id\",\"rhs_module\":\"Accounts\",\"rhs_table\":\"accounts\",\"rhs_key\":\"parent_id\",\"join_table\":null,\"join_key_lhs\":null,\"join_key_rhs\":null,\"relationship_type\":\"One to Many\",\"relationship_role_column\":null,\"relationship_role_column_value\":null,\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":\"default\",\"lhs_subpanel\":\"default\",\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"member_accounts\"},{\"id\":\"7a9a211c-cbd9-e652-551b-50be3cbb503e\",\"relationship_name\":\"account_cases\",\"lhs_module\":\"Accounts\",\"lhs_table\":\"accounts\",\"lhs_key\":\"id\",\"rhs_module\":\"Tickets\",\"rhs_table\":\"cases\",\"rhs_key\":\"account_id\",\"join_table\":null,\"join_key_lhs\":null,\"join_key_rhs\":null,\"relationship_type\":\"One to Many\",\"relationship_role_column\":null,\"relationship_role_column_value\":null,\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":\"ForAccounts\",\"lhs_subpanel\":null,\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"account_cases\"},{\"id\":\"7ad04a20-e7ae-f594-bef1-50be3cd16589\",\"relationship_name\":\"account_tasks\",\"lhs_module\":\"Accounts\",\"lhs_table\":\"accounts\",\"lhs_key\":\"id\",\"rhs_module\":\"Tasks\",\"rhs_table\":\"tasks\",\"rhs_key\":\"parent_id\",\"join_table\":null,\"join_key_lhs\":null,\"join_key_rhs\":null,\"relationship_type\":\"One to Many\",\"relationship_role_column\":\"parent_type\",\"relationship_role_column_value\":\"Accounts\",\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":null,\"lhs_subpanel\":null,\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"account_tasks\"},{\"id\":\"7b06bb8e-c6c0-2d3c-9abc-50be3c743cc3\",\"relationship_name\":\"account_notes\",\"lhs_module\":\"Accounts\",\"lhs_table\":\"accounts\",\"lhs_key\":\"id\",\"rhs_module\":\"Notes\",\"rhs_table\":\"notes\",\"rhs_key\":\"parent_id\",\"join_table\":null,\"join_key_lhs\":null,\"join_key_rhs\":null,\"relationship_type\":\"One to Many\",\"relationship_role_column\":\"parent_type\",\"relationship_role_column_value\":\"Accounts\",\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":null,\"lhs_subpanel\":null,\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"account_notes\"},{\"id\":\"7b3cf241-aee2-aa61-fee2-50be3c6f9e4a\",\"relationship_name\":\"account_meetings\",\"lhs_module\":\"Accounts\",\"lhs_table\":\"accounts\",\"lhs_key\":\"id\",\"rhs_module\":\"Meetings\",\"rhs_table\":\"meetings\",\"rhs_key\":\"parent_id\",\"join_table\":null,\"join_key_lhs\":null,\"join_key_rhs\":null,\"relationship_type\":\"One to Many\",\"relationship_role_column\":\"parent_type\",\"relationship_role_column_value\":\"Accounts\",\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":null,\"lhs_subpanel\":null,\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"account_meetings\"},{\"id\":\"7b73f667-ff3f-1df0-77ff-50be3c9ce6fd\",\"relationship_name\":\"account_calls\",\"lhs_module\":\"Accounts\",\"lhs_table\":\"accounts\",\"lhs_key\":\"id\",\"rhs_module\":\"Calls\",\"rhs_table\":\"calls\",\"rhs_key\":\"parent_id\",\"join_table\":null,\"join_key_lhs\":null,\"join_key_rhs\":null,\"relationship_type\":\"One to Many\",\"relationship_role_column\":\"parent_type\",\"relationship_role_column_value\":\"Accounts\",\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":null,\"lhs_subpanel\":null,\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"account_calls\"},{\"id\":\"7be48310-16c4-39bc-60df-50be3c2a5722\",\"relationship_name\":\"account_leads\",\"lhs_module\":\"Accounts\",\"lhs_table\":\"accounts\",\"lhs_key\":\"id\",\"rhs_module\":\"Leads\",\"rhs_table\":\"leads\",\"rhs_key\":\"account_id\",\"join_table\":null,\"join_key_lhs\":null,\"join_key_rhs\":null,\"relationship_type\":\"One to Many\",\"relationship_role_column\":null,\"relationship_role_column_value\":null,\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":\"default\",\"lhs_subpanel\":null,\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"account_leads\"},{\"id\":\"cb26739e-3e65-7e11-9b19-50be3c2c587f\",\"relationship_name\":\"accounts_bugs\",\"lhs_module\":\"Accounts\",\"lhs_table\":\"accounts\",\"lhs_key\":\"id\",\"rhs_module\":\"Bug Tracker\",\"rhs_table\":\"bugs\",\"rhs_key\":\"id\",\"join_table\":\"accounts_bugs\",\"join_key_lhs\":\"account_id\",\"join_key_rhs\":\"bug_id\",\"relationship_type\":\"Many to Many\",\"relationship_role_column\":null,\"relationship_role_column_value\":null,\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":\"default\",\"lhs_subpanel\":\"default\",\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"accounts_bugs\"},{\"id\":\"cb9d4076-3a50-68f8-de10-50be3cc1bf2a\",\"relationship_name\":\"accounts_contacts\",\"lhs_module\":\"Accounts\",\"lhs_table\":\"accounts\",\"lhs_key\":\"id\",\"rhs_module\":\"Contacts\",\"rhs_table\":\"contacts\",\"rhs_key\":\"id\",\"join_table\":\"accounts_contacts\",\"join_key_lhs\":\"account_id\",\"join_key_rhs\":\"contact_id\",\"relationship_type\":\"Many to Many\",\"relationship_role_column\":null,\"relationship_role_column_value\":null,\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":\"ForAccounts\",\"lhs_subpanel\":null,\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"accounts_contacts\"},{\"id\":\"cbd54958-c419-ff3f-c317-50be3c99c0e8\",\"relationship_name\":\"accounts_opportunities\",\"lhs_module\":\"Accounts\",\"lhs_table\":\"accounts\",\"lhs_key\":\"id\",\"rhs_module\":\"Opportunities\",\"rhs_table\":\"opportunities\",\"rhs_key\":\"id\",\"join_table\":\"accounts_opportunities\",\"join_key_lhs\":\"account_id\",\"join_key_rhs\":\"opportunity_id\",\"relationship_type\":\"Many to Many\",\"relationship_role_column\":null,\"relationship_role_column_value\":null,\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":\"ForAccounts\",\"lhs_subpanel\":null,\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"accounts_opportunities\"},{\"id\":\"d2decfd4-cef5-db8f-56b5-50be3cacf0aa\",\"relationship_name\":\"projects_accounts\",\"lhs_module\":\"Projects\",\"lhs_table\":\"project\",\"lhs_key\":\"id\",\"rhs_module\":\"Accounts\",\"rhs_table\":\"accounts\",\"rhs_key\":\"id\",\"join_table\":\"projects_accounts\",\"join_key_lhs\":\"project_id\",\"join_key_rhs\":\"account_id\",\"relationship_type\":\"Many to Many\",\"relationship_role_column\":null,\"relationship_role_column_value\":null,\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":\"default\",\"lhs_subpanel\":\"default\",\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"projects_accounts\"},{\"id\":\"d475cb21-a521-2291-55c7-50be3c3f7d31\",\"relationship_name\":\"documents_accounts\",\"lhs_module\":\"Documents\",\"lhs_table\":\"documents\",\"lhs_key\":\"id\",\"rhs_module\":\"Accounts\",\"rhs_table\":\"accounts\",\"rhs_key\":\"id\",\"join_table\":\"documents_accounts\",\"join_key_lhs\":\"document_id\",\"join_key_rhs\":\"account_id\",\"relationship_type\":\"Many to Many\",\"relationship_role_column\":null,\"relationship_role_column_value\":null,\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":\"default\",\"lhs_subpanel\":\"default\",\"relationship_only\":false,\"for_activities\":false,\"is_custom\":false,\"from_studio\":false,\"name\":\"documents_accounts\"},{\"id\":\"d58fb2c0-4f7b-3fb2-b416-50be3c97020a\",\"relationship_name\":\"accounts_accounts_1\",\"lhs_module\":\"Accounts\",\"lhs_table\":\"accounts\",\"lhs_key\":\"id\",\"rhs_module\":\"Accounts\",\"rhs_table\":\"accounts\",\"rhs_key\":\"id\",\"join_table\":\"accounts_accounts_1_c\",\"join_key_lhs\":\"accounts_accounts_1accounts_ida\",\"join_key_rhs\":\"accounts_accounts_1accounts_idb\",\"relationship_type\":\"Many to Many\",\"relationship_role_column\":null,\"relationship_role_column_value\":null,\"reverse\":\"0\",\"deleted\":\"0\",\"readonly\":true,\"rhs_subpanel\":\"default\",\"lhs_subpanel\":\"default\",\"from_studio\":true,\"is_custom\":true,\"relationship_only\":false,\"for_activities\":false,\"name\":\"accounts_accounts_1*\"}]};\nvar grid = new YAHOO.widget.ScrollingDataTable('relGrid',\n\t[\n\t {key:'name', label: SUGAR.language.get('ModuleBuilder','LBL_REL_NAME'), width: 200, sortable: true},\n\t {key:'lhs_module', label: SUGAR.language.get('ModuleBuilder','LBL_LHS_MODULE'), width: 120, sortable: true},\n\t {key:'relationship_type', label: SUGAR.language.get('ModuleBuilder','LBL_REL_TYPE'), width: 120, sortable: true},\n\t {key:'rhs_module', label: SUGAR.language.get('ModuleBuilder','LBL_RHS_MODULE'), width: 120, sortable: true}\n\t],\n\tnew YAHOO.util.LocalDataSource(relationships, {\n\t responseSchema: {\n\t\t resultsList : \"relationships\",\n\t\t fields : [{key : \"name\"}, {key: \"lhs_module\"}, {key: \"relationship_type\"}, {key: \"rhs_module\"}]\n\t }\n\t}),\n {MSG_EMPTY: SUGAR.language.get('ModuleBuilder','LBL_NO_RELS'), height:\"auto\"}\n);\ngrid.subscribe(\"rowMouseoverEvent\", grid.onEventHighlightRow); \ngrid.subscribe(\"rowMouseoutEvent\", grid.onEventUnhighlightRow); \ngrid.subscribe(\"rowClickEvent\", function(args){\n var rel = this.getRecord(args.target).getData();\n var editTab = ModuleBuilder.findTabById(\"relEditor\");\n if (editTab) ModuleBuilder.tabPanel.removeTab(editTab);\n var name = rel.name.indexOf(\"*\") > -1 ? rel.name.substring(0, rel.name.length-1) : rel.name;\n ModuleBuilder.moduleLoadRelationship2(name);\n});\ngrid.render();\n\n\nModuleBuilder.module = 'Accounts';\nModuleBuilder.MBpackage = '';\nModuleBuilder.helpRegisterByID('relGrid');\nModuleBuilder.helpSetup('studioWizard','relationshipsHelp');\n<\/script>","action":"activate"},"east":{"title":"","crumb":"","content":"","action":"deactivate"},"east2":{"title":"","crumb":"","content":"","action":"deactivate"}}
11 years ago
Another possibility is that the issue was originally the VersionCheck.php, but now that it has been uninstalled it may not have uninstalled correctly. SugarCRM had some uninstall issues past versions that were fixed recently. 6.5.5 may have been the last bad uninstaller. It wouldn't replace the overwritten files. One way to restore those files is to unzip the SecuritySuite zip and go to install_dir/notupgradesafe directory. Then unzip a fresh, full SugarCRM 6.5.5 install and copy those exact files back into your install.
11 years ago
What I did find were two like folder names in the custom/modules folder. There were these LIKE folders and I deleted the lower case folders and this seemed to resolve my issue Accounts & accounts Cases & cases
After deleting the lower cased folders the problem went away.
Thank you for sticking through this with me!
Side note; do you offer a trial of the SecuritySuite professional?
11 years ago
Wow! Interesting. No problem. Glad you got Studio working again
Yes, it comes with a 30 day trial.