You need to click the edit link next to Top Administrator and check that all the boxes are ticked...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?
Scott Lawrence - Creative agency - Bespoke web and graphic design
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";}}');
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";}}');
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 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!
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.
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.
Who is online
Users browsing this forum: No registered users and 64 guests