Post by dupfold » Thu Aug 17, 2017 11:20 pm

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
Last edited by dupfold on Fri Aug 18, 2017 9:29 pm, edited 1 time in total.

New member

Posts

Joined
Wed Oct 21, 2015 3:42 am

Post by pm-netti » Fri Aug 18, 2017 4:22 am

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

User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä, Finland

Post by dupfold » 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?

New member

Posts

Joined
Wed Oct 21, 2015 3:42 am

Post by pm-netti » Fri Aug 18, 2017 10:36 pm

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'.

User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä, Finland

Post by dupfold » Fri Aug 18, 2017 11:38 pm

Thanks... but I gave up and just done clean install of 3.0.2.0. ;D

New member

Posts

Joined
Wed Oct 21, 2015 3:42 am

Post by flashgraham » Sun Dec 29, 2019 11:45 pm

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

User avatar
New member

Posts

Joined
Mon Mar 21, 2011 9:14 pm
Location - West Yorkshire

Post by xxvirusxx » Mon Dec 30, 2019 1:17 am

Empty table oc_user_group then insert again from opencart sql.

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 flashgraham » Mon Dec 30, 2019 10:45 pm

Hiya,
Thanks for your reply, but I unable to make this work, still the same problems,
Regards

User avatar
New member

Posts

Joined
Mon Mar 21, 2011 9:14 pm
Location - West Yorkshire

Post by straightlight » Mon Dec 30, 2019 10:56 pm

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.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 41 guests