FrontAccounting forum — Second company does not create security roles records

Re: Second company does not create security roles records

2019-04-17T08:40:19Z

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.

Re: Second company does not create security roles records

2019-04-16T04:05:41Z

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

2019-04-16T03:53:51Z

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

2019-04-16T01:13:28Z

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

Thanks

Re: Second company does not create security roles records

2019-04-16T00:16:31Z

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

Second company does not create security roles records

2019-04-16T00:00:33Z

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