Reviews link does not appear in storeadmin (v. 2.93)
If the "Item Reviews" link does not show in the storeadmin area on a site that's been newly set up as a 2.93 site, it's due to a typo in the setup.php file. (This should not happen to upgraded systems.) You can still directly access the reviews page by going directly to yoursite/storeadmin/reviews.php, but the link won't appear in the storeadmin navigation links. To correct this:
-
Log in to phpMyAdmin (through the hosting control panel).
-
Select the SiteBuilder database.
-
Select the 'opc_permissions' table.
-
Change the SiteGroup field from 'E-Sore' to 'E-Store' where the SetPg field is 'reviews'.
-
Hint: If you're not sure how to do this, select the SQL tab and in the text box, enter:
UPDATE opc_permissions SET SiteGroup='E-Store' WHERE SetPg='reviews';
Important! If your SB_DB_PREFIX is not "opc", you'll need to change the above query to match your database prefix.
-
To stop this from happening in future new sites, open the setup.php file in the main public folder of your core files, and change the line:
(48, 'Item Reviews', 'reviews', 'E-Sore', '', '" . $default_permissions['reviews'] ."', 48)";
to:
(48, 'Item Reviews', 'reviews', 'E-Store', '', '" . $default_permissions['reviews'] ."', 48)";
Note: The 2.93 zip file does not have the above change. We will include this update in the next release.