Hi everybody, today i am gonna tell you how you can easily fix the access denied issue which you get after fresh installation or after migration.
When you try to open pages in Back Office then you should be getting error “Access denied” ( in many pages similar to given below ):
- Orders > Orders
- Customers > Customers
- Stats
- Shipping > Preferences
- International > Localization > Localization
- Shop Parameters > Order Settings > Order Settings
- Shop Parameters > Customer Settings > Titles
- Shop Parameters > Contact > Stores
Resolution
- Open Phpmyadmin
As in my local setup i have to go to “http://localhost/phpmyadmin/”
2. Click on Prestashop Database
As in my case it is “ps1765"
3. Click on SQL Tab and enter below query to empty the table ps_access
TRUNCATE ps_access;
4. Again Click on SQL Tab and enter below query to add data in the table ps_access
INSERT into ps_access (id_profile, id_authorization_role)
SELECT 1, par.id_authorization_role
FROM ps_authorization_role par
WHERE par.id_authorization_role NOT IN (
SELECT pa.id_authorization_role FROM ps_access pa
WHERE pa.id_profile = 1
)
Your problem should be solved now. Again check with all the pages in the websites.
Thanks for staying with us.
