Hello,
I am new to OC and I accidentally removed all modify permissions for the Top Administrator while in the User Group section of OC. I just upgraded to 1.4.93 from 1.40. When I try to change anything I get:
Warning! You do not have permission to modify user groups!
How can I restore my permissions?
Thanks
do you have access to your database?
If you do, you can run the following query to restore default permissions
If you do, you can run the following query to restore default permissions
Code: Select all
DELETE FROM user_group;
INSERT INTO `user_group` (`user_group_id`, `name`, `permission`) VALUES
(1, 'Top Administrator', 'a:2:{s:6:"access";a:84:{i:0;s:16:"catalog/category";i:1;s:16:"catalog/download";i:2;s:19:"catalog/information";i:3;s:20:"catalog/manufacturer";i:4;s:15:"catalog/product";i:5;s:14:"catalog/review";i:6;s:18:"common/filemanager";i:7;s:19:"extension/affiliate";i:8;s:14:"extension/feed";i:9;s:16:"extension/module";i:10;s:17:"extension/payment";i:11;s:18:"extension/shipping";i:12;s:15:"extension/total";i:13;s:16:"feed/google_base";i:14;s:19:"feed/google_sitemap";i:15;s:20:"localisation/country";i:16;s:21:"localisation/currency";i:17;s:21:"localisation/geo_zone";i:18;s:21:"localisation/language";i:19;s:25:"localisation/length_class";i:20;s:25:"localisation/order_status";i:21;s:25:"localisation/stock_status";i:22;s:22:"localisation/tax_class";i:23;s:25:"localisation/weight_class";i:24;s:17:"localisation/zone";i:25;s:17:"module/bestseller";i:26;s:11:"module/cart";i:27;s:15:"module/category";i:28;s:15:"module/featured";i:29;s:23:"module/google_analytics";i:30;s:18:"module/google_talk";i:31;s:18:"module/information";i:32;s:13:"module/latest";i:33;s:19:"module/manufacturer";i:34;s:14:"module/special";i:35;s:16:"payment/alertpay";i:36;s:24:"payment/authorizenet_aim";i:37;s:21:"payment/bank_transfer";i:38;s:14:"payment/cheque";i:39;s:11:"payment/cod";i:40;s:14:"payment/liqpay";i:41;s:20:"payment/moneybookers";i:42;s:15:"payment/paymate";i:43;s:16:"payment/paypoint";i:44;s:26:"payment/perpetual_payments";i:45;s:14:"payment/pp_pro";i:46;s:17:"payment/pp_pro_uk";i:47;s:19:"payment/pp_standard";i:48;s:15:"payment/sagepay";i:49;s:22:"payment/sagepay_direct";i:50;s:18:"payment/sagepay_us";i:51;s:19:"payment/twocheckout";i:52;s:16:"payment/worldpay";i:53;s:16:"report/purchased";i:54;s:11:"report/sale";i:55;s:13:"report/viewed";i:56;s:12:"sale/contact";i:57;s:11:"sale/coupon";i:58;s:13:"sale/customer";i:59;s:19:"sale/customer_group";i:60;s:10:"sale/order";i:61;s:15:"setting/setting";i:62;s:13:"setting/store";i:63;s:17:"shipping/citylink";i:64;s:13:"shipping/flat";i:65;s:13:"shipping/free";i:66;s:13:"shipping/item";i:67;s:23:"shipping/parcelforce_48";i:68;s:15:"shipping/pickup";i:69;s:19:"shipping/royal_mail";i:70;s:12:"shipping/ups";i:71;s:13:"shipping/usps";i:72;s:15:"shipping/weight";i:73;s:11:"tool/backup";i:74;s:14:"tool/error_log";i:75;s:12:"total/coupon";i:76;s:14:"total/handling";i:77;s:19:"total/low_order_fee";i:78;s:14:"total/shipping";i:79;s:15:"total/sub_total";i:80;s:9:"total/tax";i:81;s:11:"total/total";i:82;s:9:"user/user";i:83;s:20:"user/user_permission";}s:6:"modify";a:84:{i:0;s:16:"catalog/category";i:1;s:16:"catalog/download";i:2;s:19:"catalog/information";i:3;s:20:"catalog/manufacturer";i:4;s:15:"catalog/product";i:5;s:14:"catalog/review";i:6;s:18:"common/filemanager";i:7;s:19:"extension/affiliate";i:8;s:14:"extension/feed";i:9;s:16:"extension/module";i:10;s:17:"extension/payment";i:11;s:18:"extension/shipping";i:12;s:15:"extension/total";i:13;s:16:"feed/google_base";i:14;s:19:"feed/google_sitemap";i:15;s:20:"localisation/country";i:16;s:21:"localisation/currency";i:17;s:21:"localisation/geo_zone";i:18;s:21:"localisation/language";i:19;s:25:"localisation/length_class";i:20;s:25:"localisation/order_status";i:21;s:25:"localisation/stock_status";i:22;s:22:"localisation/tax_class";i:23;s:25:"localisation/weight_class";i:24;s:17:"localisation/zone";i:25;s:17:"module/bestseller";i:26;s:11:"module/cart";i:27;s:15:"module/category";i:28;s:15:"module/featured";i:29;s:23:"module/google_analytics";i:30;s:18:"module/google_talk";i:31;s:18:"module/information";i:32;s:13:"module/latest";i:33;s:19:"module/manufacturer";i:34;s:14:"module/special";i:35;s:16:"payment/alertpay";i:36;s:24:"payment/authorizenet_aim";i:37;s:21:"payment/bank_transfer";i:38;s:14:"payment/cheque";i:39;s:11:"payment/cod";i:40;s:14:"payment/liqpay";i:41;s:20:"payment/moneybookers";i:42;s:15:"payment/paymate";i:43;s:16:"payment/paypoint";i:44;s:26:"payment/perpetual_payments";i:45;s:14:"payment/pp_pro";i:46;s:17:"payment/pp_pro_uk";i:47;s:19:"payment/pp_standard";i:48;s:15:"payment/sagepay";i:49;s:22:"payment/sagepay_direct";i:50;s:18:"payment/sagepay_us";i:51;s:19:"payment/twocheckout";i:52;s:16:"payment/worldpay";i:53;s:16:"report/purchased";i:54;s:11:"report/sale";i:55;s:13:"report/viewed";i:56;s:12:"sale/contact";i:57;s:11:"sale/coupon";i:58;s:13:"sale/customer";i:59;s:19:"sale/customer_group";i:60;s:10:"sale/order";i:61;s:15:"setting/setting";i:62;s:13:"setting/store";i:63;s:17:"shipping/citylink";i:64;s:13:"shipping/flat";i:65;s:13:"shipping/free";i:66;s:13:"shipping/item";i:67;s:23:"shipping/parcelforce_48";i:68;s:15:"shipping/pickup";i:69;s:19:"shipping/royal_mail";i:70;s:12:"shipping/ups";i:71;s:13:"shipping/usps";i:72;s:15:"shipping/weight";i:73;s:11:"tool/backup";i:74;s:14:"tool/error_log";i:75;s:12:"total/coupon";i:76;s:14:"total/handling";i:77;s:19:"total/low_order_fee";i:78;s:14:"total/shipping";i:79;s:15:"total/sub_total";i:80;s:9:"total/tax";i:81;s:11:"total/total";i:82;s:9:"user/user";i:83;s:20:"user/user_permission";}}')
Same problem here but I get this error when I run the query in phpMyAdmin
Code: Select all
You have to choose at least one column to displayOpenCart Newbie | Using v1.5.1.1
Did you give the top administrator group all rights? Just use the select all by access and modify permisions at the User Group edit page and save
TOP 5 Opencart Extensions:
1:Opencart Reservations
2:Stock Report, import/export stock levels with Excel
3:3D Carousel
4:Product Price Changer by Category
5:Set price Inclusive Taxes
DEMO SHOP
Hi Saile,
I have the same problems on my OC 1.5.4.1
have a look my post with print-screens
http://forum.opencart.com/viewtopic.php?f=19&t=95164
Regards
I have the same problems on my OC 1.5.4.1
have a look my post with print-screens
http://forum.opencart.com/viewtopic.php?f=19&t=95164
Regards
Hi,
My client is having this issue.
All Top Administrators have the Users and User Group pages restricted with the message:
Page Not Found!
The page you are looking for could not be found! Please contact your administrator if the problem persists.
I tried to change the Top Administrator restrictions directly in the database but it didn't work.
I have even installed a fresh Opencart installation and copied over the whole oc_user_group table, but still... nothing works.
Getting very frustrated here.
Any ideas?
Many thanks
My client is having this issue.
All Top Administrators have the Users and User Group pages restricted with the message:
Page Not Found!
The page you are looking for could not be found! Please contact your administrator if the problem persists.
I tried to change the Top Administrator restrictions directly in the database but it didn't work.
I have even installed a fresh Opencart installation and copied over the whole oc_user_group table, but still... nothing works.
Getting very frustrated here.
Any ideas?
Many thanks
(1) Backup is a religion best practiced. From the getgo, when everything first worked. You can use the OC admin panel (to the better effect) or the phpMyAdmin in your account control panel.
(2) Lacking a last v. good working backup, you can make a backup and manually edit tables. You can use a decent pure text editor (e.g., Crimson Editor) or a database tool (e.g., Oracle's Workbench). If you know the lingo, the machine syntax and punctuation, and what NOT to do, you can fill in the blanks, then "restore" it into place (cf. 1).
(3) For that purpose (cf. 2) you can make a template that has everything in good working order. Just set up a separate OC installation on the same host server with a separate but similar databasename (only particular tables, records, and fields will be of interest). Bag a backup of that, open it (cf. 2), and either follow it or plant its crucial gridwork into the database you're trying to fix. Then restore that.
You may feel as though you're trying by candlelight with a stick and spoon to do surgery at a wreck, but at least it can be done. Then make backups.
(2) Lacking a last v. good working backup, you can make a backup and manually edit tables. You can use a decent pure text editor (e.g., Crimson Editor) or a database tool (e.g., Oracle's Workbench). If you know the lingo, the machine syntax and punctuation, and what NOT to do, you can fill in the blanks, then "restore" it into place (cf. 1).
(3) For that purpose (cf. 2) you can make a template that has everything in good working order. Just set up a separate OC installation on the same host server with a separate but similar databasename (only particular tables, records, and fields will be of interest). Bag a backup of that, open it (cf. 2), and either follow it or plant its crucial gridwork into the database you're trying to fix. Then restore that.
You may feel as though you're trying by candlelight with a stick and spoon to do surgery at a wreck, but at least it can be done. Then make backups.
ok, so i had a similar problem. one day i logged in and woops...my admin permissions had dissapeared. I was rather desperate as my website was actually worth quite abit of cash. So i looked on this thread, and in desperation, copied and pasted the code that the gentleman/woman provided in the above thread. (this is after several weeks of getting nowhere and watching my business go down the pan). what happened? my problem worsened immensly 
i logged in onto too see lines of error code. yey! so i managed after a couple of weeks to get the whole thing restored to original settings, and lo and behold, the same issue is also restored!! i cant even access the user groups to change it. ANY ADVICE? before i have a total breakdown and start signing on job seekers again (haha im kidding, i dont beg at the gates of babylon). but thanks to mister whats is face for destroying my webpage with his code, i was ever so grateful.
i logged in onto too see lines of error code. yey! so i managed after a couple of weeks to get the whole thing restored to original settings, and lo and behold, the same issue is also restored!! i cant even access the user groups to change it. ANY ADVICE? before i have a total breakdown and start signing on job seekers again (haha im kidding, i dont beg at the gates of babylon). but thanks to mister whats is face for destroying my webpage with his code, i was ever so grateful.ECain01, which version do you have, and was it a clean install or was it upgraded (which to which?)? There can be several causes of permission problems; yours seems more mysterious and intransigent than most. You might give these a whirl, some of them may not be shots into the dark (if you hear a growl back, run).
(1) If you have vqmod running did you flush the vqmod cache (that'll be one basal file in /vqmod/ and the several files in vqmod/vqcache/). Did you flush the /system/cache/ content? (You can keep those files as backups by shunting them into a setaside/ directory, for peace of mind.) If not, then flush.
(2) Look in your /download/ directory. Are there any odd files in there (such as one named "*.jpg.* with long character strings)? If yes, delete.
(3) Are all of your directories and files set to 755 and 644 permissions (Linux/Unix only, not Windows)? Which distribution of Linux (or of Unix) or version of Windows is your server? If no, reset to 755/644 (in FileZilla Client, recurse, all dirs or all files).
(4) Is SSL protecting /admin/? If SSL is on, what happens if you turn it off? What happens if you set .htaccess aside briefly (renamed or slipped into a setaside/ directory or similar)?
(5) Which version of php.exe is your server or account running? If you can and if relevant, try 5.3.x instead.
(6) Check your logs (error.txt) for abundant iterations of this doublet of thrown errors:
2013-07-31 11:54:19 - PHP Notice: Undefined variable: c_ads in /usr/local/lib/php/foot.php on line 5
2013-07-31 11:54:19 - PHP Notice: Undefined variable: c_ads_code in /usr/local/lib/php/foot.php on line 6
The c_ads and c_ads_code errors are thrown by script which will be only on the server side, only in the host's own inner sanctum where uppermost system administrators can go (where support fears even to think about going), not in your own account area. You will not ordinarily have a "foot.php" or that directory path. The script, in foot.php, pertains to advertising for the host, usually associated with "free" accounts.
Only the server's own system administrators can remedy that one. Ask support (you'll probably need to start out with request to escalate the ticket straight to system administrators).
(7) Please be able to tell us you do not have a "free" account. If you do, be happy that OC even ran.
(8) For a look at it from the outside, what is the URL (address)? (If you're keeping it under wraps, then you can send as PM.)
(9) Given what happened earlier on, whenever you are about to mess with your database, make two fresh database backups, one inside OC admin panel (System / Backup, or with a good enough extension System / Export, for later Restore or Import, if needed), the other in the host panel's phpMyAdmin (Export -- for later Import if needed). Do not mix the means and files (all named .sql); the data content is the same but the formats differ slightly.
(1) If you have vqmod running did you flush the vqmod cache (that'll be one basal file in /vqmod/ and the several files in vqmod/vqcache/). Did you flush the /system/cache/ content? (You can keep those files as backups by shunting them into a setaside/ directory, for peace of mind.) If not, then flush.
(2) Look in your /download/ directory. Are there any odd files in there (such as one named "*.jpg.* with long character strings)? If yes, delete.
(3) Are all of your directories and files set to 755 and 644 permissions (Linux/Unix only, not Windows)? Which distribution of Linux (or of Unix) or version of Windows is your server? If no, reset to 755/644 (in FileZilla Client, recurse, all dirs or all files).
(4) Is SSL protecting /admin/? If SSL is on, what happens if you turn it off? What happens if you set .htaccess aside briefly (renamed or slipped into a setaside/ directory or similar)?
(5) Which version of php.exe is your server or account running? If you can and if relevant, try 5.3.x instead.
(6) Check your logs (error.txt) for abundant iterations of this doublet of thrown errors:
2013-07-31 11:54:19 - PHP Notice: Undefined variable: c_ads in /usr/local/lib/php/foot.php on line 5
2013-07-31 11:54:19 - PHP Notice: Undefined variable: c_ads_code in /usr/local/lib/php/foot.php on line 6
The c_ads and c_ads_code errors are thrown by script which will be only on the server side, only in the host's own inner sanctum where uppermost system administrators can go (where support fears even to think about going), not in your own account area. You will not ordinarily have a "foot.php" or that directory path. The script, in foot.php, pertains to advertising for the host, usually associated with "free" accounts.
Only the server's own system administrators can remedy that one. Ask support (you'll probably need to start out with request to escalate the ticket straight to system administrators).
(7) Please be able to tell us you do not have a "free" account. If you do, be happy that OC even ran.
(8) For a look at it from the outside, what is the URL (address)? (If you're keeping it under wraps, then you can send as PM.)
(9) Given what happened earlier on, whenever you are about to mess with your database, make two fresh database backups, one inside OC admin panel (System / Backup, or with a good enough extension System / Export, for later Restore or Import, if needed), the other in the host panel's phpMyAdmin (Export -- for later Import if needed). Do not mix the means and files (all named .sql); the data content is the same but the formats differ slightly.
Bump for this post. Really save my life ! Thanx to jcsmithy
I'm using OC 1.5.6.4 & adding new group with admin access. However, I screw up Select All / Unselect All option and denied in Admin panel.
For my case instead of these codes:
I run with these:
Then I enter admin panel again to ensure the right selection is done (some of it missing the permission).
I'm using OC 1.5.6.4 & adding new group with admin access. However, I screw up Select All / Unselect All option and denied in Admin panel.
For my case instead of these codes:
Code: Select all
DELETE FROM user_group;
INSERT INTO `user_group` (`user_group_id`, `name`, `permission`) VALUES ....Code: Select all
DELETE FROM oc_user_group;
INSERT INTO `oc_user_group` (`user_group_id`, `name`, `permission`) VALUES ....If you are using Opencart 2.2.x try this sql update to regain permissions:
Code: Select all
UPDATE `oc_user_group` SET `permission`='{"access":["analytics/google_analytics","captcha/basic_captcha","captcha/google_captcha","catalog/attribute","catalog/attribute_group","catalog/category","catalog/download","catalog/filter","catalog/information","catalog/manufacturer","catalog/option","catalog/product","catalog/recurring","catalog/review","common/column_left","common/filemanager","common/menu","common/profile","common/stats","customer/custom_field","customer/customer","customer/customer_group","design/banner","design/language","design/layout","design/theme","extension/analytics","extension/captcha","extension/feed","extension/fraud","extension/installer","extension/modification","extension/module","extension/openbay","extension/payment","extension/shipping","extension/theme","extension/total","feed/google_base","feed/google_sitemap","feed/openbaypro","fraud/fraudlabspro","fraud/ip","fraud/maxmind","localisation/country","localisation/currency","localisation/geo_zone","localisation/language","localisation/length_class","localisation/location","localisation/order_status","localisation/return_action","localisation/return_reason","localisation/return_status","localisation/stock_status","localisation/tax_class","localisation/tax_rate","localisation/weight_class","localisation/zone","marketing/affiliate","marketing/contact","marketing/coupon","marketing/marketing","module/account","module/affiliate","module/amazon_login","module/amazon_pay","module/banner","module/bestseller","module/carousel","module/category","module/ebay_listing","module/featured","module/filter","module/google_hangouts","module/html","module/information","module/latest","module/pp_button","module/pp_login","module/sagepay_direct_cards","module/sagepay_server_cards","module/slideshow","module/special","module/store","openbay/amazon","openbay/amazon_listing","openbay/amazon_product","openbay/amazonus","openbay/amazonus_listing","openbay/amazonus_product","openbay/ebay","openbay/ebay_profile","openbay/ebay_template","openbay/etsy","openbay/etsy_product","openbay/etsy_shipping","openbay/etsy_shop","payment/amazon_login_pay","payment/authorizenet_aim","payment/authorizenet_sim","payment/bank_transfer","payment/bluepay_hosted","payment/bluepay_redirect","payment/cheque","payment/cod","payment/eway","payment/firstdata","payment/firstdata_remote","payment/free_checkout","payment/g2apay","payment/globalpay","payment/globalpay_remote","payment/klarna_account","payment/klarna_invoice","payment/liqpay","payment/nochex","payment/paymate","payment/paypoint","payment/payza","payment/perpetual_payments","payment/pp_express","payment/pp_payflow","payment/pp_payflow_iframe","payment/pp_pro","payment/pp_pro_iframe","payment/pp_standard","payment/realex","payment/realex_remote","payment/sagepay_direct","payment/sagepay_server","payment/sagepay_us","payment/securetrading_pp","payment/securetrading_ws","payment/skrill","payment/twocheckout","payment/web_payment_software","payment/worldpay","report/affiliate","report/affiliate_activity","report/affiliate_login","report/customer_activity","report/customer_credit","report/customer_login","report/customer_online","report/customer_order","report/customer_reward","report/marketing","report/product_purchased","report/product_viewed","report/sale_coupon","report/sale_order","report/sale_return","report/sale_shipping","report/sale_tax","sale/order","sale/recurring","sale/return","sale/voucher","sale/voucher_theme","setting/setting","setting/store","shipping/auspost","shipping/citylink","shipping/fedex","shipping/flat","shipping/free","shipping/item","shipping/parcelforce_48","shipping/pickup","shipping/royal_mail","shipping/ups","shipping/usps","shipping/weight","startup/error","startup/event","startup/language","startup/login","startup/permission","startup/router","startup/sass","startup/setting","theme/theme_default","tool/backup","tool/error_log","tool/upload","total/coupon","total/credit","total/handling","total/klarna_fee","total/low_order_fee","total/reward","total/shipping","total/sub_total","total/tax","total/total","total/voucher","user/api","user/user","user/user_permission"],"modify":["analytics/google_analytics","captcha/basic_captcha","captcha/google_captcha","catalog/attribute","catalog/attribute_group","catalog/category","catalog/download","catalog/filter","catalog/information","catalog/manufacturer","catalog/option","catalog/product","catalog/recurring","catalog/review","common/column_left","common/filemanager","common/menu","common/profile","common/stats","customer/custom_field","customer/customer","customer/customer_group","design/banner","design/language","design/layout","design/theme","extension/analytics","extension/captcha","extension/feed","extension/fraud","extension/installer","extension/modification","extension/module","extension/openbay","extension/payment","extension/shipping","extension/theme","extension/total","feed/google_base","feed/google_sitemap","feed/openbaypro","fraud/fraudlabspro","fraud/ip","fraud/maxmind","localisation/country","localisation/currency","localisation/geo_zone","localisation/language","localisation/length_class","localisation/location","localisation/order_status","localisation/return_action","localisation/return_reason","localisation/return_status","localisation/stock_status","localisation/tax_class","localisation/tax_rate","localisation/weight_class","localisation/zone","marketing/affiliate","marketing/contact","marketing/coupon","marketing/marketing","module/account","module/affiliate","module/amazon_login","module/amazon_pay","module/banner","module/bestseller","module/carousel","module/category","module/ebay_listing","module/featured","module/filter","module/google_hangouts","module/html","module/information","module/latest","module/pp_button","module/pp_login","module/sagepay_direct_cards","module/sagepay_server_cards","module/slideshow","module/special","module/store","openbay/amazon","openbay/amazon_listing","openbay/amazon_product","openbay/amazonus","openbay/amazonus_listing","openbay/amazonus_product","openbay/ebay","openbay/ebay_profile","openbay/ebay_template","openbay/etsy","openbay/etsy_product","openbay/etsy_shipping","openbay/etsy_shop","payment/amazon_login_pay","payment/authorizenet_aim","payment/authorizenet_sim","payment/bank_transfer","payment/bluepay_hosted","payment/bluepay_redirect","payment/cheque","payment/cod","payment/eway","payment/firstdata","payment/firstdata_remote","payment/free_checkout","payment/g2apay","payment/globalpay","payment/globalpay_remote","payment/klarna_account","payment/klarna_invoice","payment/liqpay","payment/nochex","payment/paymate","payment/paypoint","payment/payza","payment/perpetual_payments","payment/pp_express","payment/pp_payflow","payment/pp_payflow_iframe","payment/pp_pro","payment/pp_pro_iframe","payment/pp_standard","payment/realex","payment/realex_remote","payment/sagepay_direct","payment/sagepay_server","payment/sagepay_us","payment/securetrading_pp","payment/securetrading_ws","payment/skrill","payment/twocheckout","payment/web_payment_software","payment/worldpay","report/affiliate","report/affiliate_activity","report/affiliate_login","report/customer_activity","report/customer_credit","report/customer_login","report/customer_online","report/customer_order","report/customer_reward","report/marketing","report/product_purchased","report/product_viewed","report/sale_coupon","report/sale_order","report/sale_return","report/sale_shipping","report/sale_tax","sale/order","sale/recurring","sale/return","sale/voucher","sale/voucher_theme","setting/setting","setting/store","shipping/auspost","shipping/citylink","shipping/fedex","shipping/flat","shipping/free","shipping/item","shipping/parcelforce_48","shipping/pickup","shipping/royal_mail","shipping/ups","shipping/usps","shipping/weight","startup/error","startup/event","startup/language","startup/login","startup/permission","startup/router","startup/sass","startup/setting","theme/theme_default","tool/backup","tool/error_log","tool/upload","total/coupon","total/credit","total/handling","total/klarna_fee","total/low_order_fee","total/reward","total/shipping","total/sub_total","total/tax","total/total","total/voucher","user/api","user/user","user/user_permission"]}'
WHERE `user_group_id`=1;
Hello Guys,
Having same issue. Completely been locked out of the opencart store (well I can login in but that's pretty much it.
I'm on v2.0.3.1
I'm assuming the last post from SilverPaladin might work, but where do I put this.
I'm not an expert, so please make it simple for me.
Thanks
Having same issue. Completely been locked out of the opencart store (well I can login in but that's pretty much it.
I'm on v2.0.3.1
I'm assuming the last post from SilverPaladin might work, but where do I put this.
I'm not an expert, so please make it simple for me.
Thanks
Copy the content of the code above, and paste it on an empty file, by use of a NOTEPAD ++ or similar Code/Text Editor, never MS Word or other nasty Things, and save it as whateveryouwanttonameit.sql
Then, upload this file to your Server Shop Section, and execute it, by calling it's name and extension from your Browser.
That's about it! But only valid for OC-v2.2.x, I assume!
PLUS: Make a full DB Backup + COPY, including Tables and everything, on your Server, by use of the Server PHP Admin Tool,
just in case...
Good Luck!
Ernie
Then, upload this file to your Server Shop Section, and execute it, by calling it's name and extension from your Browser.
That's about it! But only valid for OC-v2.2.x, I assume!
PLUS: Make a full DB Backup + COPY, including Tables and everything, on your Server, by use of the Server PHP Admin Tool,
just in case...
Good Luck!
Ernie
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Thankyou! Very Very much SilverPaladin!SilverPaladin wrote: ↑Thu Jul 28, 2016 4:43 amIf you are using Opencart 2.2.x try this sql update to regain permissions:
Code: Select all
UPDATE `oc_user_group` SET `permission`='{"access":["analytics/google_analytics","captcha/basic_captcha",...
You just have saved me a week or more of research and painfull 'try and error' on my DB.
Once more! Thankyou!
Who is online
Users browsing this forum: No registered users and 18 guests
