Jump to content

Edit History

Chill_user

Chill_user

Hello to all,

Have same issue with carrier page - no acess for the carriers.

What I have done:

1. Tried "Fresh" 'ps_access' table

2. Tried to add all missing values from 'ps_authorization_role' to 'ps_access' with folowing code:

INSERT INTO ps_access (id_profile, id_authorization_role) SELECT '1', ar.id_authorization_role FROM ps_authorization_role ar 
  LEFT JOIN ps_access a ON ar.id_authorization_role = a.id_authorization_role 
  WHERE a.id_authorization_role IS NULL

3. Inspected 'ps_authorization_role table' - roles for carriers to modify, delete etc have next ids: 617,618,619,620. All this ids I have in my 'ps_access' table.

All this actions are unseccessfull.

Any ideas or solutions?

Solved:

I had missing values and ids in 'ps_authorization_role' table, for example, ids: 33,34,35,36

Chill_user

Chill_user

Hello to all,

Have same issue with carrier page - no acess for the carriers.

What I have done:

1. Tried "Fresh" 'ps_access' table

2. Tried to add all missing values from 'ps_authorization_role' to 'ps_access' with folowing code:

INSERT INTO ps_access (id_profile, id_authorization_role) SELECT '1', ar.id_authorization_role FROM ps_authorization_role ar 
  LEFT JOIN ps_access a ON ar.id_authorization_role = a.id_authorization_role 
  WHERE a.id_authorization_role IS NULL

3. Inspected 'ps_authorization_role table' - roles for carriers to modify, delete etc have next ids: 617,618,619,620. All this ids I have in my 'ps_access' table.

All this actions are unseccessfull.

Any ideas or solutions?

×
×
  • Create New...