Reviews cannot be activated or aren't working properly (v. 2.93)

On a new SiteBuilder installation, reviews cannot be activated, because the id field is not auto incremented. (This does not occur if upgrading from a previous version system.)

To fix this on a site that already has the SiteBuilder system installed:

  1. Access the database via phpMyAdmin

  2. Select the database

  3. Select the 'Structure' tab of the opc_reviews table

  4. Select the 'Change' button next to the 'id' field

  5. Check the checkbox under 'A_I' to set the 'id' field as an auto increment field

  6. Click 'Save'

For future installs, open the setup.php file and change the lines:

$reviews_query = "CREATE TABLE IF NOT EXISTS " .$f_databaseprefix ."_reviews (
id int(11) NOT NULL,

to:

$reviews_query = "CREATE TABLE IF NOT EXISTS " .$f_databaseprefix ."_reviews (
id int(11) NOT NULL auto_increment,