• From: Australia
  • Registered: 02/13/2019
  • Posts: 10

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

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,181

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

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • From: Australia
  • Registered: 02/13/2019
  • Posts: 10

Re: Second company does not create security roles records

hi

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

Thanks

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

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.

apmuthu's Website

  • From: Australia
  • Registered: 02/13/2019
  • Posts: 10

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

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

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.

apmuthu's Website