FrontAccounting forum — Second company does not create security roles records

Re: Second company does not create security roles records

null@example.com (apmuthu) — Wed, 17 Apr 2019 08:40:19 +0000

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

null@example.com (lostwf) — Tue, 16 Apr 2019 04:05:41 +0000

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

null@example.com (apmuthu) — Tue, 16 Apr 2019 03:53:51 +0000

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

null@example.com (lostwf) — Tue, 16 Apr 2019 01:13:28 +0000

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

Thanks

Re: Second company does not create security roles records

null@example.com (kvvaradha) — Tue, 16 Apr 2019 00:16:31 +0000

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

null@example.com (lostwf) — Tue, 16 Apr 2019 00:00:33 +0000

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