Missing securitygroups_default table in fresh install of SuiteCRM 7.1.2

SuiteCRM Forum - English Language Installation & Upgrade Help
1

After a fresh install of SuiteCRM 7.1.2 on CenTOS the log showed over one hundred lines complaining that the table securitygroups_default was missing.

The following is a sample log line:

xxxx [21287][-none-][FATAL]  Query Failed: select securitygroups_default.id, securitygroups.name, securitygroups_default.module, securitygroups_default.securitygroup_id from securitygroups_default inner join securitygroups on securitygroups_default.securitygroup_id = securitygroups.id where securitygroups_default.deleted = 0 and securitygroups.deleted = 0: MySQL error 1146: Table 'sc712_test.securitygroups_default' doesn't exist

I solved by adding the table:

CREATE TABLE IF NOT EXISTS `securitygroups_default` (
  `id` char(36) NOT NULL,
  `securitygroup_id` char(36) DEFAULT NULL,
  `module` varchar(50) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

(I found the table in another install where I had upgraded the system, on the same machine)

2

Hi amariussi,

This seems to be related to Security Suite being part of the original installation, which is not intended as it is normally an additional module, hence the db issues.

Thanks,

Will.