Page 1 of 1

Updated from 2.3.0.2 to 3.0.2.0 - now no store theme and admin 'Permission Denied'!

Posted: Thu Aug 17, 2017 11:20 pm
by dupfold
Hello

I've update from 2.3.0.2 to 3.0.2.0, but website now states 'Error: A theme has not been assigned to this store!'. Whilst then trying to fix that, I get "Permission Denied! - You do not have permission to access this page, please refer to your system administrator.". I no longer have access to any settings via dashboard. The only things on navigation bar is 'Dashboard', 'Catalog' and 'Reports'.

1. How do I fix this so as I have permission again? I am/was the only administrator.

2. How do I fix theme error?

Thank you

Re: Updated from 2.3.0.2 to 3.0.2.0 - now no store theme and admin 'Permission Denied'!

Posted: Fri Aug 18, 2017 4:22 am
by pm-netti
This is 2 lines Sql ( change/add DB_PREFIX, is need)

Code: Select all

UPDATE extension SET `code` = 'default' WHERE `type` = 'theme';
UPDATE setting SET `value` = 'default' WHERE `key` = 'config_theme';
Add this your in phpmyadmin page.

Ps. Your need go to admin > user > user group and add full permissions. Oc 3.x use new route marketplace/extension

Re: Updated from 2.3.0.2 to 3.0.2.0 - now no store theme and admin 'Permission Denied'!

Posted: Fri Aug 18, 2017 9:30 pm
by dupfold
Thanks pm-netti, but where do I find 'phpmyadmin' page please?

Also as said, I no longer have access to admin > user > user group. The only things I have visible now on dashboard are Catalog and Reports. How can I gain full permission again please without the use of the dashboard?

Re: Updated from 2.3.0.2 to 3.0.2.0 - now no store theme and admin 'Permission Denied'!

Posted: Fri Aug 18, 2017 10:36 pm
by pm-netti
dupfold wrote:
Fri Aug 18, 2017 9:30 pm
Thanks pm-netti, but where do I find 'phpmyadmin' page please?

Also as said, I no longer have access to admin > user > user group. The only things I have visible now on dashboard are Catalog and Reports. How can I gain full permission again please without the use of the dashboard?
Is you cpanel ? It url can be yourstore.com:2083 or yourstore.com/cpanel, phpmyadmin found there. You can ask it your Host.
Was your store 2.3.0.2 upgraded version or clean installation? If it is upgrade, your maybe need change column 'permission' type to 'mediumtext' to table 'user_group'.

Re: Updated from 2.3.0.2 to 3.0.2.0 - now no store theme and admin 'Permission Denied'!

Posted: Fri Aug 18, 2017 11:38 pm
by dupfold
Thanks... but I gave up and just done clean install of 3.0.2.0. ;D

Re: Updated from 2.3.0.2 to 3.0.2.0 - now no store theme and admin 'Permission Denied'!

Posted: Sun Dec 29, 2019 11:45 pm
by flashgraham
Hiya,
I have the same problem, I am unable to access anything on the admin after logging in, just see permission denied, unable to access my own profile. Click on the settings icon and get this message You do not have permission to access this page, please refer to your system administrator. I have updated the settings in phpmyadmin but still I have no theme and no access,
Any help would be very much appreciated,
Thank you
Graham

Re: Updated from 2.3.0.2 to 3.0.2.0 - now no store theme and admin 'Permission Denied'!

Posted: Mon Dec 30, 2019 1:17 am
by xxvirusxx
Empty table oc_user_group then insert again from opencart sql.

Re: Updated from 2.3.0.2 to 3.0.2.0 - now no store theme and admin 'Permission Denied'!

Posted: Mon Dec 30, 2019 10:45 pm
by flashgraham
Hiya,
Thanks for your reply, but I unable to make this work, still the same problems,
Regards

Re: Updated from 2.3.0.2 to 3.0.2.0 - now no store theme and admin 'Permission Denied'!

Posted: Mon Dec 30, 2019 10:56 pm
by straightlight
flashgraham wrote:
Mon Dec 30, 2019 10:45 pm
Hiya,
Thanks for your reply, but I unable to make this work, still the same problems,
Regards
Create a new service request in the Commercial Support section of the forum to get this resolved as a custom job.