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:

  1. Log in to phpMyAdmin (through the hosting control panel).

  2. Select the SiteBuilder database.

  3. Select the 'opc_permissions' table.

  4. Change the SiteGroup field from 'E-Sore' to 'E-Store' where the SetPg field is 'reviews'.

  5. 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.

  6. 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.