Post by saabman910 » Mon Oct 26, 2009 6:20 am

I just did the 1.3.2 upgrade using Qphoria's zip file. After I encountered the problem I followed the recommendations in one of the articles that suggests manually dropping and recreating the xx_user_group table and inserting the Top Administrator and Demonstration User groups. I still get Permission Denied when accessing the error logs, the user group or the measurement class. The one user that exists at the moment is has a user_group_id of 1 which is the value for the Top Administrator permissions. Does anyone have any ideas? ???

Newbie

Posts

Joined
Mon Oct 26, 2009 6:10 am

Post by fido-x » Mon Oct 26, 2009 9:06 am

saabman910 wrote:... I still get Permission Denied when accessing the error logs, the user group or the measurement class.
Delete the error log file ("system/logs/error.txt"). As long as the permissions are correct on the "system/logs" folder (0777), the file can be re-created by the software.

With regard to permissions on the "user group", you will need to reset these by editing the database directly. Using phpMyAdmin (or something similar), find the table called "user_group", and edit the entry for the "Top Administrator". Replace the contents of the "permission" field with the following:-

Code: Select all

a:2:{s:6:"access";a:66:{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:16:"customer/contact";i:7;s:15:"customer/coupon";i:8;s:17:"customer/customer";i:9;s:23:"customer/customer_group";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:30:"localisation/measurement_class";i:21;s:25:"localisation/order_status";i:22;s:25:"localisation/stock_status";i:23;s:22:"localisation/tax_class";i:24;s:25:"localisation/weight_class";i:25;s:17:"localisation/zone";i:26;s:17:"module/bestseller";i:27;s:11:"module/cart";i:28;s:15:"module/category";i:29;s:15:"module/currency";i:30;s:18:"module/information";i:31;s:19:"module/manufacturer";i:32;s:21:"payment/bank_transfer";i:33;s:14:"payment/cheque";i:34;s:11:"payment/cod";i:35;s:20:"payment/moneybookers";i:36;s:17:"payment/pp_direct";i:37;s:20:"payment/pp_direct_uk";i:38;s:19:"payment/pp_standard";i:39;s:15:"payment/sagepay";i:40;s:16:"payment/worldpay";i:41;s:16:"report/purchased";i:42;s:11:"report/sale";i:43;s:13:"report/viewed";i:44;s:15:"setting/setting";i:45;s:17:"shipping/citylink";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:15:"shipping/weight";i:51;s:11:"tool/backup";i:52;s:14:"tool/error_log";i:53;s:12:"total/coupon";i:54;s:14:"total/handling";i:55;s:19:"total/low_order_fee";i:56;s:14:"total/shipping";i:57;s:15:"total/sub_total";i:58;s:9:"total/tax";i:59;s:11:"total/total";i:60;s:9:"user/user";i:61;s:20:"user/user_permission";i:62;s:23:"shipping/parcelforce_48";i:63;s:13:"shipping/item";i:64;s:13:"shipping/flat";i:65;s:17:"shipping/citylink";}s:6:"modify";a:66:{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:16:"customer/contact";i:7;s:15:"customer/coupon";i:8;s:17:"customer/customer";i:9;s:23:"customer/customer_group";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:30:"localisation/measurement_class";i:21;s:25:"localisation/order_status";i:22;s:25:"localisation/stock_status";i:23;s:22:"localisation/tax_class";i:24;s:25:"localisation/weight_class";i:25;s:17:"localisation/zone";i:26;s:17:"module/bestseller";i:27;s:11:"module/cart";i:28;s:15:"module/category";i:29;s:15:"module/currency";i:30;s:18:"module/information";i:31;s:19:"module/manufacturer";i:32;s:21:"payment/bank_transfer";i:33;s:14:"payment/cheque";i:34;s:11:"payment/cod";i:35;s:20:"payment/moneybookers";i:36;s:17:"payment/pp_direct";i:37;s:20:"payment/pp_direct_uk";i:38;s:19:"payment/pp_standard";i:39;s:15:"payment/sagepay";i:40;s:16:"payment/worldpay";i:41;s:16:"report/purchased";i:42;s:11:"report/sale";i:43;s:13:"report/viewed";i:44;s:15:"setting/setting";i:45;s:17:"shipping/citylink";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:15:"shipping/weight";i:51;s:11:"tool/backup";i:52;s:14:"tool/error_log";i:53;s:12:"total/coupon";i:54;s:14:"total/handling";i:55;s:19:"total/low_order_fee";i:56;s:14:"total/shipping";i:57;s:15:"total/sub_total";i:58;s:9:"total/tax";i:59;s:11:"total/total";i:60;s:9:"user/user";i:61;s:20:"user/user_permission";i:62;s:23:"shipping/parcelforce_48";i:63;s:13:"shipping/item";i:64;s:13:"shipping/flat";i:65;s:17:"shipping/citylink";}}
This will reset everything back to defaults.

Image
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool

If you're not living on the edge ... you're taking up too much space!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by saabman910 » Mon Oct 26, 2009 11:03 pm

Everything seems to be fixed, thanks a million. I am new to Opencart and have not had the chance to look under the covers. I appreciate the help. One last question,I need to leave the system/logs permissions at 777?

Newbie

Posts

Joined
Mon Oct 26, 2009 6:10 am

Post by yeuxbleus » Mon Mar 29, 2010 3:11 am

just to learn ... what do the numbers in the db table refer to (eg i:64;s:13:)? (am very new in on this php/mysql planet)

I have a similar permission denied issue for the new export/import tool after the upgrade to 1.4.5 (first I have upgraded to 1.4.5. then installed tool). Tool is not visible in User Group permissions. I would like to manually add the access permissions in the DB, is that possible (i?:s?;tool/export)

cheers
Maarten

User avatar
Newbie

Posts

Joined
Wed Mar 24, 2010 6:45 pm

Post by thodaiuy3r » Fri Apr 02, 2010 12:08 pm

Hello fido-x, I'm using opencart1.4.0 after successful update from 1.3.4. Everything else runs fine, just every part admin / sale is that I can not access with error:
Permission denied. I followed your instructions Fido-x, edit the entry for the "Top Administrator. Replace the contents of the "permission" field with the Following:

Code: Select all

    a:2:{s:6:"access";a:66:{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:16:"customer/contact";i:7;s:15:"customer/coupon";i:8;s:17:"customer/customer";i:9;s:23:"customer/customer_group";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:30:"localisation/measurement_class";i:21;s:25:"localisation/order_status";i:22;s:25:"localisation/stock_status";i:23;s:22:"localisation/tax_class";i:24;s:25:"localisation/weight_class";i:25;s:17:"localisation/zone";i:26;s:17:"module/bestseller";i:27;s:11:"module/cart";i:28;s:15:"module/category";i:29;s:15:"module/currency";i:30;s:18:"module/information";i:31;s:19:"module/manufacturer";i:32;s:21:"payment/bank_transfer";i:33;s:14:"payment/cheque";i:34;s:11:"payment/cod";i:35;s:20:"payment/moneybookers";i:36;s:17:"payment/pp_direct";i:37;s:20:"payment/pp_direct_uk";i:38;s:19:"payment/pp_standard";i:39;s:15:"payment/sagepay";i:40;s:16:"payment/worldpay";i:41;s:16:"report/purchased";i:42;s:11:"report/sale";i:43;s:13:"report/viewed";i:44;s:15:"setting/setting";i:45;s:17:"shipping/citylink";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:15:"shipping/weight";i:51;s:11:"tool/backup";i:52;s:14:"tool/error_log";i:53;s:12:"total/coupon";i:54;s:14:"total/handling";i:55;s:19:"total/low_order_fee";i:56;s:14:"total/shipping";i:57;s:15:"total/sub_total";i:58;s:9:"total/tax";i:59;s:11:"total/total";i:60;s:9:"user/user";i:61;s:20:"user/user_permission";i:62;s:23:"shipping/parcelforce_48";i:63;s:13:"shipping/item";i:64;s:13:"shipping/flat";i:65;s:17:"shipping/citylink";}s:6:"modify";a:66:{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:16:"customer/contact";i:7;s:15:"customer/coupon";i:8;s:17:"customer/customer";i:9;s:23:"customer/customer_group";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:30:"localisation/measurement_class";i:21;s:25:"localisation/order_status";i:22;s:25:"localisation/stock_status";i:23;s:22:"localisation/tax_class";i:24;s:25:"localisation/weight_class";i:25;s:17:"localisation/zone";i:26;s:17:"module/bestseller";i:27;s:11:"module/cart";i:28;s:15:"module/category";i:29;s:15:"module/currency";i:30;s:18:"module/information";i:31;s:19:"module/manufacturer";i:32;s:21:"payment/bank_transfer";i:33;s:14:"payment/cheque";i:34;s:11:"payment/cod";i:35;s:20:"payment/moneybookers";i:36;s:17:"payment/pp_direct";i:37;s:20:"payment/pp_direct_uk";i:38;s:19:"payment/pp_standard";i:39;s:15:"payment/sagepay";i:40;s:16:"payment/worldpay";i:41;s:16:"report/purchased";i:42;s:11:"report/sale";i:43;s:13:"report/viewed";i:44;s:15:"setting/setting";i:45;s:17:"shipping/citylink";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:15:"shipping/weight";i:51;s:11:"tool/backup";i:52;s:14:"tool/error_log";i:53;s:12:"total/coupon";i:54;s:14:"total/handling";i:55;s:19:"total/low_order_fee";i:56;s:14:"total/shipping";i:57;s:15:"total/sub_total";i:58;s:9:"total/tax";i:59;s:11:"total/total";i:60;s:9:"user/user";i:61;s:20:"user/user_permission";i:62;s:23:"shipping/parcelforce_48";i:63;s:13:"shipping/item";i:64;s:13:"shipping/flat";i:65;s:17:"shipping/citylink";}}
But then, I can not access the administration page it error as follows:
Content Encoding Error:
The page you are trying to view can not be Shown Because it uses an invalid or Unsupported form of compression.

Can you help me fix this. thank you very much.

good health, good luck

Newbie

Posts

Joined
Tue Mar 23, 2010 12:17 pm
Who is online

Users browsing this forum: No registered users and 12 guests