No access to payment in backoffice

[flem24]

Hello I get an error when I try to access the "pament" in my back office please look at the attachment. Any ideas?

[El Patron]

you do not have access like this when your login is in a group that restricts access to various parts of the back office. Please check the group you are assigned to, if it's administrator then you do indeed have an issue.

[bellini13]

if it is administrator, you will need to manually add back the record to the ps_access table.

 

first access the ps_profile_lang table, and query for the profile named "Administrator". take note of the id_profile, it is most likely 1.

	SELECT id_profile FROM `ps_profile_lang` WHERE `name` LIKE 'Administrator'

 

second, perform this query to locate the id_tab value for the payment section. for me the value is 4

	SELECT id_tab FROM `ps_tab_lang` WHERE `name` LIKE 'payment'

 

third, locate the access permission in the ps_access table, where the id_profile=1 and id_tab=4. if your values are different, be sure to use your values.

	SELECT * FROM `ps_access` WHERE `id_profile` =1	AND `id_tab` =4

 

now you either do not have this entry or your values are no longer set to 1 for view, add, edit and delete

so you either have to update your values so they are 1, or you have to add an entry for the id_profile/id_tab combination.