I am a new user of open cart. I just install opencart 3.0.3.7 in my domain. Its works well. But suddenly when I tried to install a new plugin I lost my admin user permission. As now in my website dashboard there is no left side active navigation menu. When I click it shows me, "You do not have permission to access this page, please refer to your system administrator." Like the attached photo.
Can any one please kindly help me to solve this issue. Once again I am a very new user...
Attachments
Admin Permission denied.png (74.23 KiB) Viewed 5983 times
And which??globalmahi wrote: ↑Tue Sep 14, 2021 1:24 pmBut suddenly when I tried to install a new plugin I lost my admin user permission.
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
The dashboard didn't show any navigations icons and I have no access of my dashboard as well as can not do anything in admin side.OSWorX wrote: ↑Tue Sep 14, 2021 2:27 pmAnd which??globalmahi wrote: ↑Tue Sep 14, 2021 1:24 pmBut suddenly when I tried to install a new plugin I lost my admin user permission.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
ADD Creative wrote: ↑Tue Sep 14, 2021 4:38 pmYou could try restoring the user_group table from a backup or clean install.
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
Thank you for your reply. Can you please explain me in a bit details, how can I do that? I am sorry as explain, I am really a novice user.. Please kindly help me..xxvirusxx wrote: ↑Tue Sep 14, 2021 5:14 pmADD Creative wrote: ↑Tue Sep 14, 2021 4:38 pmYou could try restoring the user_group table from a backup or clean install.
You could either look for an extension on the Marketplace or create a new service request in the Commercial Support section of the forum to get this done as a custom job.globalmahi wrote: ↑Tue Sep 14, 2021 5:16 pmThank you for your reply. Can you please explain me in a bit details, how can I do that? I am sorry as explain, I am really a novice user.. Please kindly help me..xxvirusxx wrote: ↑Tue Sep 14, 2021 5:14 pmADD Creative wrote: ↑Tue Sep 14, 2021 4:38 pmYou could try restoring the user_group table from a backup or clean install.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
- Go to phpmyadmin
- Locate the 'user' table (it will have a db prefix, so could be something like 'oc_user' or similar)
- Find your username in the username field, and take note of the user_group_id in the same row
- Locate the user_group table (it will have the same prefix as the user table)
- Find the row with the user_group_id you noted down in step 3
- Click on edit
- Replace whatever is in the permissions field with the following:
Code: Select all
{"access":["user\/user","user\/user_permission"],"modify":["user\/user","user\/user_permission"]}
- Log in to the admin panel
- Go to System>Users>User Groups>Name of User Group, and give yourself all the other required permissions
Not a suggested way as a workaround. Better to do it with converted arrays by queries than directly playing with JSON strings.Gergely wrote: ↑Tue Sep 14, 2021 5:39 pm(That is considering you have phpmyadmin. Depending on how your opencart was ported onto aws, this might not be the case. But anyway, you should probably get in touch with whoever migrated your site to help you with this.)
- Go to phpmyadmin
- Locate the 'user' table (it will have a db prefix, so could be something like 'oc_user' or similar)
- Find your username in the username field, and take note of the user_group_id in the same row
- Locate the user_group table (it will have the same prefix as the user table)
- Find the row with the user_group_id you noted down in step 3
- Click on edit
- Replace whatever is in the permissions field with the following:
Code: Select all
{"access":["user\/user","user\/user_permission"],"modify":["user\/user","user\/user_permission"]}
- Log in to the admin panel
- Go to System>Users>User Groups>Name of User Group, and give yourself all the other required permissions
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Its solved...thank your so much...I highly appreciate your kind support.Gergely wrote: ↑Tue Sep 14, 2021 5:39 pm
- Go to phpmyadmin
- Locate the 'user' table (it will have a db prefix, so could be something like 'oc_user' or similar)
- Find your username in the username field, and take note of the user_group_id in the same row
- Locate the user_group table (it will have the same prefix as the user table)
- Find the row with the user_group_id you noted down in step 3
- Click on edit
- Replace whatever is in the permissions field with the following:
Code: Select all
{"access":["user\/user","user\/user_permission"],"modify":["user\/user","user\/user_permission"]}
- Log in to the admin panel
- Go to System>Users>User Groups>Name of User Group, and give yourself all the other required permissions
Thank your so much. Its solved...straightlight wrote: ↑Tue Sep 14, 2021 5:46 pmNot a suggested way as a workaround. Better to do it with converted arrays by queries than directly playing with JSON strings.Gergely wrote: ↑Tue Sep 14, 2021 5:39 pm(That is considering you have phpmyadmin. Depending on how your opencart was ported onto aws, this might not be the case. But anyway, you should probably get in touch with whoever migrated your site to help you with this.)
- Go to phpmyadmin
- Locate the 'user' table (it will have a db prefix, so could be something like 'oc_user' or similar)
- Find your username in the username field, and take note of the user_group_id in the same row
- Locate the user_group table (it will have the same prefix as the user table)
- Find the row with the user_group_id you noted down in step 3
- Click on edit
- Replace whatever is in the permissions field with the following:
Code: Select all
{"access":["user\/user","user\/user_permission"],"modify":["user\/user","user\/user_permission"]}
- Log in to the admin panel
- Go to System>Users>User Groups>Name of User Group, and give yourself all the other required permissions
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
I am having the same problem and by following the steps provided above, the issue can be fixed.
To avoid this problem to happen again, I tried to find the root cause without much success, thus I would like to know if somebody would know ?
can somebody tell me why this happends, I have the same issue.
Everytime I edit many products individial, I lose permissions
txs
Shouldn't happen as editing a product doesn't modify the user_group table in the database. Could be an issue with your theme or extensions. Could be an issue with your database. What version of OpenCart and PHP. What theme and extensions? Is the Permission Denied! coming from OpenCart (i.e. you have to modify the user_group table in the database to fix it)? Or is the Permission Denied! coming from your hosting?salvador72 wrote: ↑Sat Sep 30, 2023 6:40 pmHi,
can somebody tell me why this happends, I have the same issue.
Everytime I edit many products individial, I lose permissions
txs
What I can say is that when ever I start editing several products and save it ends with "pErmission denided" and everything(config, clientes, modules, etc) desapear or and only few thing remain but not possible to acess.Generaly (as I learn) I copy permissions at mysql, user_groupe, from admin to my user and paste, and everything goes back to normal, some say could be a conflit with extension, but don't now what exectaly, and 'till today no ones comes with a real solution for it.
So I had to make somechanges and by extensions to edit products.
That's what I experience...
It not a common problem and possibley not with OpenCart, which is why there is reported solution.salvador72 wrote: ↑Sun Oct 01, 2023 2:02 amHi,
What I can say is that when ever I start editing several products and save it ends with "pErmission denided" and everything(config, clientes, modules, etc) desapear or and only few thing remain but not possible to acess.Generaly (as I learn) I copy permissions at mysql, user_groupe, from admin to my user and paste, and everything goes back to normal, some say could be a conflit with extension, but don't now what exectaly, and 'till today no ones comes with a real solution for it.
So I had to make somechanges and by extensions to edit products.
That's what I experience...
What version of OpenCart and PHP are you using? What theme and extensions are you using?
Users browsing this forum: openalvin and 375 guests