SecuritySuite - SuiteCRM and CE Teams

Dear Sir, Both of two #1 & #2 not working in this case, it is unchanged. Is there any solution

Interesting. I'm wondering if file permissions/ownership caused both the uninstall to not work correctly and my suggested fixes not to work since if you copied over the files from a clean, blank zip of SuiteCRM it should resolve itself. Perhaps try adjusting permissions and then copy them again along with the /metadata and /custom/metadata if that exists in the SuiteCRM zip. Also be sure to do a Rebuild Relationships.

/metadata solved our issue Many thank for your support

Great! Glad that worked. Thanks for verifying that.

One more thing, these two columns are stiil appeared

Copy /modules/ACLActions/actiondefs.override.php from a clean SuiteCRM zip into your /modules/ACLActions and then run a Repair Roles. That should remove the columns. If you have an opcode cache like APC or Memcache you may also need to restart Apache after doing this.

I remove the security suite with removing table option, then now I can not save the record because this error Kindly help to check

01/24/18 11:07:30 [3528][1][FATAL] Query Failed: INSERT INTO securitygroups_records(id,securitygroup_id,record_id,module,date_modified,deleted) SELECT DISTINCT uuid() ,u.securitygroup_id,'262c4146-da17-a4a9-5801-55e1199eca4e','Accounts',CURDATE(),0 from securitygroups_users u inner join securitygroups g on u.securitygroup_id = g.id and g.deleted = 0 and (g.noninheritable is null or g.noninheritable <> 1) left join securitygroups_records d on d.securitygroup_id = u.securitygroup_id and d.record_id = '262c4146-da17-a4a9-5801-55e1199eca4e' and d.module = 'Accounts' and d.deleted = 0 where d.id is null and u.user_id = '9d599f88-66bb-fd0f-9543-539ba92881b7' and u.deleted = 0 and (u.noninheritable is null or u.noninheritable <> 1): MySQL error 1146: Table 'suitecrm.securitygroups_records' doesn't exist 01/24/18 11:07:30 [3528][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details. 01/24/18 11:07:37 [3528][1][FATAL] Query Failed: INSERT INTO securitygroups_records(id,securitygroup_id,record_id,module,date_modified,deleted) SELECT DISTINCT uuid() ,u.securitygroup_id,'262c4146-da17-a4a9-5801-55e1199eca4e','Accounts',CURDATE(),0 from securitygroups_users u inner join securitygroups g on u.securitygroup_id = g.id and g.deleted = 0 and (g.noninheritable is null or g.noninheritable <> 1) left join securitygroups_records d on d.securitygroup_id = u.securitygroup_id and d.record_id = '262c4146-da17-a4a9-5801-55e1199eca4e' and d.module = 'Accounts' and d.deleted = 0 where d.id is null and u.user_id = '9d599f88-66bb-fd0f-9543-539ba92881b7' and u.deleted = 0 and (u.noninheritable is null or u.noninheritable <> 1): MySQL error 1146: Table 'suitecrm.securitygroups_records' doesn't exist 01/24/18 11:07:37 [3528][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details. 01/24/18 11:07:58 [3528][1][FATAL] Query Failed: INSERT INTO securitygroups_records(id,securitygroup_id,record_id,module,date_modified,deleted) SELECT DISTINCT uuid() ,u.securitygroup_id,'262c4146-da17-a4a9-5801-55e1199eca4e','Accounts',CURDATE(),0 from securitygroups_users u inner join securitygroups g on u.securitygroup_id = g.id and g.deleted = 0 and (g.noninheritable is null or g.noninheritable <> 1) left join securitygroups_records d on d.securitygroup_id = u.securitygroup_id and d.record_id = '262c4146-da17-a4a9-5801-55e1199eca4e' and d.module = 'Accounts' and d.deleted = 0 where d.id is null and u.user_id = '9d599f88-66bb-fd0f-9543-539ba92881b7' and u.deleted = 0 and (u.noninheritable is null or u.noninheritable <> 1): MySQL error 1146: Table 'suitecrm.securitygroups_records' doesn't exist 01/24/18 11:07:58 [3528][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.

If you haven't already, copy these directories over from a clean SuiteCRM install to your SuiteCRM install while making sure the version that you are copying from is the same as your SuiteCRM version:

• /data
• /include
• /modules
• /soap
• /themes

Once done go run a Quick Repair & Rebuild and execute any generated SQL after the page finishes loading. This should create any missing tables, including the securitygroups_records table.

I tried this way and also copy /metadata, but it can not solve my issue. I have to reinstall the security suite => then it solve But I quit the trial, then I have to disable the security enhance version => It seems making us many troubles when uninstall this addon

Sorry for the troubles here. The SuiteCRM uninstaller unfortunately has its limitations and can't always function correctly depending on the environment.

Try this process: 1. Uninstall SecuritySuite 2. Copy those directories over and run the repairs 3. Run this query to recreate that table:

CREATE TABLE securitygroups_records ( id char(36) NOT NULL, securitygroup_id char(36) DEFAULT NULL, record_id char(36) DEFAULT NULL, module varchar(255) DEFAULT NULL, date_modified datetime DEFAULT NULL, modified_user_id char(36) DEFAULT NULL, created_by char(36) DEFAULT NULL, deleted tinyint(1) DEFAULT '0', PRIMARY KEY (id), KEY idx_securitygroups_records_mod (module,deleted,record_id,securitygroup_id), KEY idx_securitygroups_records_del (deleted,record_id,module,securitygroup_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

If you run into any other missing tables please email me at solutions@eggsurplus.com. I can send over these as needed.