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:
-
Access the database via phpMyAdmin
-
Select the database
-
Select the 'Structure' tab of the opc_reviews table
-
Select the 'Change' button next to the 'id' field
-
Check the checkbox under 'A_I' to set the 'id' field as an auto increment field
-
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,