OpenCart Community

Hello,
I am removed all modify permissions for the Top Administrator while in the User Group section of OC form sql database

How can I restore my permissions?

3.0.3.1

Thanks

You do not have permission to access this page, please refer to your system administrator.

The safest way to do this is to login to your panel / contact your service provider and restore your database from a version prior to the delete.
The downside is that if you have made any changes / orders etc - these will be lost

Good advise would be to get a back up of the current site as is, front and back end - but do not copy over a previous backup.

There is a way to enter the details in manually just for that field
user_group => permissions again from a back up

You can also use a copy from the original sql file from opencart

IF YOU DO NOT KNOW WHAT YOU ARE DOING - ASK FOR HELP IN THE COMMERCIAL SECTION
This is not difficult, but you can destroy your site playing with the database directly.

There is a way to enter the details in manually just for that field
user_group => permissions again from a back up

I need all permissions to add manually to user group for 3.0.3.1

Thanks

Jut go to phpMyAdmin and empty oc_user_group table.
Then copy from opencart.sql, INSERT INTO `oc_user_group`..... and add back in database using SQL tab.

Change oc_ prefix if isn't the same.

After you are logged in admin, you can sellect all permision for others modules/extensions

xxvirusxx wrote: ↑

Sun Jul 28, 2019 6:25 pm

Jut go to phpMyAdmin and empty oc_user_group table.
Then copy from opencart.sql, INSERT INTO `oc_user_group`..... and add back in database using SQL tab.

Change oc_ prefix if isn't the same.

After you are logged in admin, you can sellect all permision for others modules/extensions

you have copy of oc user group permision for 3.0.3.1 ?

You can download
https://www.opencart.com/index.php?rout ... ad/history

xxvirusxx wrote: ↑

Tue Jul 30, 2019 12:54 am

You can download
https://www.opencart.com/index.php?rout ... ad/history

How copy opencart.sql or how upload only sql to cpanel

hi
I am solved by restore backup data base and copy promsition to last data base and now every thing work
thanks for every one help me