Admin Panel Access Denied

[gourmandines]

Dear all,

 

I have problem accessing into the website after logging in - access denied. It happened after I tried editing the prices. What is the solution? Any recommendations?

I really need help urgently...

 

 

Thanks.

Edited November 16, 2015 by gourmandines (see edit history)

[NemoPS]

Access denied like error in red? Do you have super admin privileges? Also, are you getting it on all tabs? You might want to try to check you profile role/access in the database. ps_employee to check the firs, ps_access to make sure of the latter

[gourmandines]

Hi Nemo,

 

Yes, red colour. I am not sure whether we have super admin privileges. Nope, I am not getting any tabs except for the catalog tab. I have checked my profile and I am not sure whether it is the correct one coz this is a company website.

 

Admin Panel Link:

http://gourmandines.com/adminq1w2e3r4t5/index.php?controller=AdminLogin&token=cb39acf6487fe13adbdeec5051f002ae

 

Screenshots:

https://gourmandines.sharefile.com/d-sda459da172844f88

 

 

[NemoPS]

Screens are too small to be able to see anything useful

[gourmandines]

You may download it to view in a normal size. I have been trying to log in so many times as I usually does yet it is still the same and I don't understand why...

Edited November 19, 2015 by gourmandines (see edit history)

[NemoPS]

I think you need to check the database, as mentioned above. DId you do that?

[gourmandines]

How do I check my role/access in the database. ps_employee to check the firs, ps_access to make sure of the latter?

 

Screenshot Link: https://gourmandines.sharefile.com/share#/view/sc9b60413c3a48958/fic7809f-9abb-0bf1-bbf7-7f2b6484edb7

Edited November 25, 2015 by gourmandines (see edit history)

[NemoPS]

You need to access your DB via phpmyadmin

[gourmandines]

Hi, everything is fine now. Thanks for your kind help

[mma87]

 I had this problem and I fix it by following those steps. 

upgrade to prestashop 1.7.6.4

backup first!! 
If you are not confident with databases please don't try this guide.

Those are the steps to follow:
0) backup first your database
1) check if ps_access is empty, in my case it was empty after upgrade
2) go to the table ps_authorization_role and export it as csv
3) open this file, if you use microsoft excel select "Data" > "Text to Column"
4) delete the content in column B
5) insert a column before the column A
6) add =1 in the A1 cell
7) copy this function until the end (you can click CTRL + C and then CTRL + SHIFT + arrow down using windows) and save the file as csv
😎 go to ps_authorization_role, click import and upload the file
9) insert in "Columns separated with" ; and press Go
10) check if all works fine now

Note #1: if the table ps_access isn't empty you have to import only the missing roles
Note #2: if you have other active profiles you have to repeat those steps also for the other profiles

you can see also the video tutorial

 

for more details see https://www.kuboweb.it/tutorials/prestashop-access-denied-in-back-office-after-upgrade/