Topic: Second company does not create security roles records

Hi

After some troubleshooting I found that the 1_security_roles table was blank and I copied all the contents from 0_security_roles to 1_security_roles

INSERT INTO 1_security_roles
SELECT *
FROM 0_security_roles

I am able to login to the second company(us 5 with educational data)

I am not sure if this is kept in the company script or in FA

thanks
Wayne

Re: Second company does not create security roles records

It depends on the COA . Which COA did you choose while creating new company. Based in that the issue can be fixed

Re: Second company does not create security roles records

hi

I used the "5 Digit American coa with education Data"

Thanks

Re: Second company does not create security roles records

Refer my chart repo for any changes from the official package.

There is no data for the 0_security_roles table in it.
Refer my commit.

@joe: can correct it in the official package.

Re: Second company does not create security roles records

Hi

Why are you dropping my company data that is defined as company 0_?

DROP TABLE IF EXISTS `0_security_roles`;

CREATE TABLE `0_security_roles` (

Thanks
Wayne

Re: Second company does not create security roles records

Have a look at the other charts - this is so for a new table with the new structure to be created should one already exist with possibly a different structure.