Skip to content

Instantly share code, notes, and snippets.

@d70rr3s

d70rr3s/fix_access_tabs_prestashop.sql

Created May 15, 2021 05:59
Show Gist options
  • Save d70rr3s/7b413f818b51f0d432bed87f42aba217 to your computer and use it in GitHub Desktop.
Save d70rr3s/7b413f818b51f0d432bed87f42aba217 to your computer and use it in GitHub Desktop.
Download ZIP
Fix permissions on tabs for employees in PS (credits https://github.com/PrestaShop/PrestaShop/issues/12058#issuecomment-710111052)
Raw
fix_access_tabs_prestashop.sql
INSERT INTO ps_access 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 AND a.id_profile = 1)
WHERE a.id_profile IS NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment