Post by s3eed » Fri Jul 26, 2019 11:29 pm

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

New member

Posts

Joined
Thu Apr 19, 2018 5:21 pm

Post by s3eed » Sat Jul 27, 2019 1:00 am

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

New member

Posts

Joined
Thu Apr 19, 2018 5:21 pm

Post by by mona » Sat Jul 27, 2019 1:43 am

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.

DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.


https://www.youtube.com/watch?v=zXIxDoCRc84


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by s3eed » Sun Jul 28, 2019 5:50 pm

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

New member

Posts

Joined
Thu Apr 19, 2018 5:21 pm

Post by xxvirusxx » 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

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by s3eed » Tue Jul 30, 2019 12:18 am

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 ?

New member

Posts

Joined
Thu Apr 19, 2018 5:21 pm

User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by s3eed » Tue Jul 30, 2019 5:46 pm

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

New member

Posts

Joined
Thu Apr 19, 2018 5:21 pm

Post by s3eed » Tue Jul 30, 2019 7:55 pm

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

New member

Posts

Joined
Thu Apr 19, 2018 5:21 pm
Who is online

Users browsing this forum: No registered users and 111 guests