OpenCart Community

I entered the smtp details and now when i click the mail button i get' Permission denied' I am the administrator.How can i get round this issue.Thanks

goto user groups and go down the list of pages and check and that are missing.

Daniel wrote:goto user groups and go down the list of pages and check and that are missing.

Cheers Daniel but I've checked and the admin is the only one there.There's only one page.What would be missing?

chiefk wrote:Cheers Daniel but I've checked and the admin is the only one there.There's only one page.What would be missing?

You need to click the edit link next to Top Administrator and check that all the boxes are ticked...

...and if we get "Permission Denied!" on the User Groups page?!

yeah.even in the user group i can't access it???

Help.Anyone with a clue to this problem

I have the same problem, can't access the customer-mail and User-User group page.

anyone help, I didn't configue smtp, use the default mail server

ANYONE?? Daniel, etc.........

Well it seems theres no help coming.
I've checked the demo site and it seems that OC has not loaded the mail tab files or it's corruptes, maybe.So i may have to do the dreaded task of uninstall/reinstall and se what happens. >:(

Run the following query (from the 1.3 install SQL) to replace the user group table will fix the problem:
Note: replace oc_ with your table prefix

DROP TABLE IF EXISTS `oc_user_group`;
CREATE TABLE `oc_user_group` (
`user_group_id` int(11) NOT NULL auto_increment,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`permission` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`user_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `oc_user_group`
--

INSERT INTO `oc_user_group` (`user_group_id`, `name`, `permission`) VALUES
(1, 'Top Administrator', 'a:2:{s:6:"access";a:74:{i:0;s:16:"catalog/category";i:1;s:16:"catalog/download";i:2;s:13:"catalog/image";i:3;s:19:"catalog/information";i:4;s:20:"catalog/manufacturer";i:5;s:15:"catalog/product";i:6;s:14:"catalog/review";i:7;s:16:"customer/contact";i:8;s:15:"customer/coupon";i:9;s:17:"customer/customer";i:10;s:14:"customer/order";i:11;s:14:"extension/feed";i:12;s:16:"extension/module";i:13;s:17:"extension/payment";i:14;s:18:"extension/shipping";i:15;s:15:"extension/total";i:16;s:20:"localisation/country";i:17;s:21:"localisation/currency";i:18;s:21:"localisation/geo_zone";i:19;s:21:"localisation/language";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/currency";i:29;s:18:"module/information";i:30;s:19:"module/manufacturer";i:31;s:21:"payment/bank_transfer";i:32;s:14:"payment/cheque";i:33;s:11:"payment/cod";i:34;s:20:"payment/moneybookers";i:35;s:17:"payment/pp_direct";i:36;s:20:"payment/pp_direct_uk";i:37;s:19:"payment/pp_standard";i:38;s:15:"payment/sagepay";i:39;s:16:"payment/worldpay";i:40;s:16:"report/purchased";i:41;s:11:"report/sale";i:42;s:13:"report/viewed";i:43;s:15:"setting/setting";i:44;s:17:"shipping/citylink";i:45;s:14:"shipping/fedex";i:46;s:13:"shipping/flat";i:47;s:13:"shipping/free";i:48;s:13:"shipping/item";i:49;s:23:"shipping/parcelforce_48";i:50;s:38:"shipping/royal_mail_1st_class_recorded";i:51;s:38:"shipping/royal_mail_1st_class_standard";i:52;s:38:"shipping/royal_mail_2nd_class_recorded";i:53;s:38:"shipping/royal_mail_2nd_class_standard";i:54;s:27:"shipping/royal_mail_airmail";i:55;s:27:"shipping/royal_mail_airsure";i:56;s:40:"shipping/royal_mail_international_signed";i:57;s:36:"shipping/royal_mail_special_delivery";i:58;s:36:"shipping/royal_mail_standard_parcels";i:59;s:27:"shipping/royal_mail_surface";i:60;s:12:"shipping/ups";i:61;s:13:"shipping/usps";i:62;s:15:"shipping/weight";i:63;s:11:"tool/backup";i:64;s:12:"total/coupon";i:65;s:14:"total/handling";i:66;s:19:"total/low_order_fee";i:67;s:14:"total/shipping";i:68;s:15:"total/sub_total";i:69;s:9:"total/tax";i:70;s:11:"total/total";i:71;s:9:"user/user";i:72;s:20:"user/user_permission";i:73;s:14:"payment/cheque";}s:6:"modify";a:74:{i:0;s:16:"catalog/category";i:1;s:16:"catalog/download";i:2;s:13:"catalog/image";i:3;s:19:"catalog/information";i:4;s:20:"catalog/manufacturer";i:5;s:15:"catalog/product";i:6;s:14:"catalog/review";i:7;s:16:"customer/contact";i:8;s:15:"customer/coupon";i:9;s:17:"customer/customer";i:10;s:14:"customer/order";i:11;s:14:"extension/feed";i:12;s:16:"extension/module";i:13;s:17:"extension/payment";i:14;s:18:"extension/shipping";i:15;s:15:"extension/total";i:16;s:20:"localisation/country";i:17;s:21:"localisation/currency";i:18;s:21:"localisation/geo_zone";i:19;s:21:"localisation/language";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/currency";i:29;s:18:"module/information";i:30;s:19:"module/manufacturer";i:31;s:21:"payment/bank_transfer";i:32;s:14:"payment/cheque";i:33;s:11:"payment/cod";i:34;s:20:"payment/moneybookers";i:35;s:17:"payment/pp_direct";i:36;s:20:"payment/pp_direct_uk";i:37;s:19:"payment/pp_standard";i:38;s:15:"payment/sagepay";i:39;s:16:"payment/worldpay";i:40;s:16:"report/purchased";i:41;s:11:"report/sale";i:42;s:13:"report/viewed";i:43;s:15:"setting/setting";i:44;s:17:"shipping/citylink";i:45;s:14:"shipping/fedex";i:46;s:13:"shipping/flat";i:47;s:13:"shipping/free";i:48;s:13:"shipping/item";i:49;s:23:"shipping/parcelforce_48";i:50;s:38:"shipping/royal_mail_1st_class_recorded";i:51;s:38:"shipping/royal_mail_1st_class_standard";i:52;s:38:"shipping/royal_mail_2nd_class_recorded";i:53;s:38:"shipping/royal_mail_2nd_class_standard";i:54;s:27:"shipping/royal_mail_airmail";i:55;s:27:"shipping/royal_mail_airsure";i:56;s:40:"shipping/royal_mail_international_signed";i:57;s:36:"shipping/royal_mail_special_delivery";i:58;s:36:"shipping/royal_mail_standard_parcels";i:59;s:27:"shipping/royal_mail_surface";i:60;s:12:"shipping/ups";i:61;s:13:"shipping/usps";i:62;s:15:"shipping/weight";i:63;s:11:"tool/backup";i:64;s:12:"total/coupon";i:65;s:14:"total/handling";i:66;s:19:"total/low_order_fee";i:67;s:14:"total/shipping";i:68;s:15:"total/sub_total";i:69;s:9:"total/tax";i:70;s:11:"total/total";i:71;s:9:"user/user";i:72;s:20:"user/user_permission";i:73;s:14:"payment/cheque";}}'),
(10, 'Demonstration', 'a:1:{s:6:"access";a:73:{i:0;s:16:"catalog/category";i:1;s:16:"catalog/download";i:2;s:13:"catalog/image";i:3;s:19:"catalog/information";i:4;s:20:"catalog/manufacturer";i:5;s:15:"catalog/product";i:6;s:14:"catalog/review";i:7;s:16:"customer/contact";i:8;s:15:"customer/coupon";i:9;s:17:"customer/customer";i:10;s:14:"customer/order";i:11;s:14:"extension/feed";i:12;s:16:"extension/module";i:13;s:17:"extension/payment";i:14;s:18:"extension/shipping";i:15;s:15:"extension/total";i:16;s:20:"localisation/country";i:17;s:21:"localisation/currency";i:18;s:21:"localisation/geo_zone";i:19;s:21:"localisation/language";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/currency";i:29;s:18:"module/information";i:30;s:19:"module/manufacturer";i:31;s:21:"payment/bank_transfer";i:32;s:14:"payment/cheque";i:33;s:11:"payment/cod";i:34;s:20:"payment/moneybookers";i:35;s:17:"payment/pp_direct";i:36;s:20:"payment/pp_direct_uk";i:37;s:19:"payment/pp_standard";i:38;s:15:"payment/sagepay";i:39;s:16:"payment/worldpay";i:40;s:16:"report/purchased";i:41;s:11:"report/sale";i:42;s:13:"report/viewed";i:43;s:15:"setting/setting";i:44;s:17:"shipping/citylink";i:45;s:14:"shipping/fedex";i:46;s:13:"shipping/flat";i:47;s:13:"shipping/free";i:48;s:13:"shipping/item";i:49;s:23:"shipping/parcelforce_48";i:50;s:38:"shipping/royal_mail_1st_class_recorded";i:51;s:38:"shipping/royal_mail_1st_class_standard";i:52;s:38:"shipping/royal_mail_2nd_class_recorded";i:53;s:38:"shipping/royal_mail_2nd_class_standard";i:54;s:27:"shipping/royal_mail_airmail";i:55;s:27:"shipping/royal_mail_airsure";i:56;s:40:"shipping/royal_mail_international_signed";i:57;s:36:"shipping/royal_mail_special_delivery";i:58;s:36:"shipping/royal_mail_standard_parcels";i:59;s:27:"shipping/royal_mail_surface";i:60;s:12:"shipping/ups";i:61;s:13:"shipping/usps";i:62;s:15:"shipping/weight";i:63;s:11:"tool/backup";i:64;s:12:"total/coupon";i:65;s:14:"total/handling";i:66;s:19:"total/low_order_fee";i:67;s:14:"total/shipping";i:68;s:15:"total/sub_total";i:69;s:9:"total/tax";i:70;s:11:"total/total";i:71;s:9:"user/user";i:72;s:20:"user/user_permission";}}');

Cheers. it worked!!Thank you.

Yup, worked for me too.. Thanks.

Thank You, you save my life .!

Raphael Dias
Brazilian User

Hi All,

I get the same issue where I can't access the User Groups page (havent tried all the others but they seem fine) and get a "Permission Denied" error message.
I have 3 different accounts set to Top Administrator and none of them can access this page?!
I was originally running V1.2.9 without problems then upgraded using your instructions to V1.3.0 where I noticed there was an issue but ignored it because I was going to upgrade to V1.3.2. Now I'm on 1.3.2 and the problem still exists....I followed your upgrade instructions each time so I dont know what I've done wrong.
Any help would be appreciated...I'm a real novice to this!

I am a novice as well, BUT...I checked the permissions on the Top Admin group and found that the tool/export function was not checked in either box....placed a check in both boxes and it worked without a problem.

Hi Corey,

Thanks for your reply. Unfortunately when I try to access the permissions for any user group I get the permission denied error also.
This didnt happen straight after the upgrade (Top Admins had full permissions before the upgrade) - only once I loaded the backup.sql file.