I’ve uninstalled extension using Magento downloader despite of red label near uninstall button and now frontend and backend are broken. What should I do?
You should have access to database (for example via phpMyAdmin). Select your database, select 'eav_attribute' table, search by 'attribute_code' for these fields: review_fields_available, use_parent_review_settings, popularity_by_sells, popularity_by_reviews, popularity_by_rating. Remove them.
Also you need delete these tables:
review_helpful, author_ips, review_proscons.
And delete such columns from 'review_detail':
remote_addr, sizing, body_type, location, age, height, good_detail, no_good_detail, response, image, video, pros, cons, recommend_to.
Here is the list of MySQL commands to revert all changes in DB:
1) DELETE FROM eav_attribute WHERE attribute_code IN ('review_fields_available', 'use_parent_review_settings', 'popularity_by_sells', 'popularity_by_reviews', 'popularity_by_rating')
DELETE FROM eav_attribute WHERE attribute_code IN ('review_fields_available', 'use_parent_review_settings', 'popularity_by_sells', 'popularity_by_reviews', 'popularity_by_rating')
2) DROP TABLE IF EXISTS review_helpful, author_ips, review_proscons
DROP TABLE IF EXISTS review_helpful, author_ips, review_proscons
3) ALTER TABLE review_detail DROP COLUMN remote_addr, DROP COLUMN sizing, DROP COLUMN body_type, DROP COLUMN location, DROP COLUMN age, DROP COLUMN height, DROP COLUMN good_detail, DROP COLUMN no_good_detail, DROP COLUMN response, DROP COLUMN image, DROP COLUMN video, DROP COLUMN pros, DROP COLUMN cons, DROP COLUMN recommend_to
ALTER TABLE review_detail DROP COLUMN remote_addr, DROP COLUMN sizing, DROP COLUMN body_type, DROP COLUMN location, DROP COLUMN age, DROP COLUMN height, DROP COLUMN good_detail, DROP COLUMN no_good_detail, DROP COLUMN response, DROP COLUMN image, DROP COLUMN video, DROP COLUMN pros, DROP COLUMN cons, DROP COLUMN recommend_to
Note that the last command (#3) can depend on you Detailed Review module version (not all columns are present in your database)