[NSFW] PLugin won’t activate

Hi

I’ve recently updated to WordPress 5.5 and needed to deactivate WP_Postratings to troubleshoot a problem which was resolved. I then upgraded to version 1.89 from 1.88 and the plugin will not activate due to a fatal error.

I seem to remember that when I installed 1.88 that I remarked out an alter table command
// maybe_add_column($wpdb->ratings, ‘rating_userid’, “ALTER TABLE $wpdb->ratings ADD rating_userid INT( 10 ) NOT NULL DEFAULT ‘0’;”);

I tried this again but still get an error

[Thu Aug 20 11:37:35.803969 2020] [php7:notice] [pid 16322] [client 31.53.16.67:45936] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘rating_postid INT(11) NOT NULL ,rating_posttitle TEXT NOT NULL,rating_rating INT’ at line 1 for query ALTER TABLE wp_ratings CHANGE COLUMN rating_id rating_id INT(11) NOT NULL auto_increment,rating_postid INT(11) NOT NULL ,rating_posttitle TEXT NOT NULL,rating_rating INT(2) NOT NULL ,rating_timestamp VARCHAR(15) NOT NULL ,rating_ip VARCHAR(40) NOT NULL ,rating_host VARCHAR(200) NOT NULL,rating_username VARCHAR(50) NOT NULL,rating_userid int(10) NOT NULL default ‘0’,PRIMARY KEY (rating_id),KEY rating_userid (rating_userid),KEY rating_postid_ip (rating_postid, rating_ip) /* From [bags-of-books.co.uk/wp-admin/plugins.php?action=error_scrape&plugin=wp-postratings%2Fwp-postratings.php&_wpnonce=9537db4a32] in [/nas/content/live/bagsofbomaster/wp-content/plugins/wp-postratings/includes/postratings-activation.php:56] */ made by do_action(‘activate_wp-postratings/wp-postratings.php’), WP_Hook->do_action, WP_Hook->apply_filters, ratings_activation, ratings_activate, dbDelta, referer: https://bags-of-books.co.uk/wp-admin/network/plugins.php?plugin=wp-postratings%2Fwp-postratings.php

I have gone into phpmyadmin and the table wp_ratings has been created as have the indexes so I am at a loss as to what the error is

Any help appreciated