Support » Plugin: WP-PostRatings » Fatal error on activation

  • rubengc

    (@rubengc)


    Looks like there is an issue when WP PostRatings tries to alter the ratings table

    Error from debug.log:

    [15-May-2018 08:21:35 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INT(11) NOT NULL ,rating_posttitle TEXT NOT NULL,rating_rating INT(2) NOT NULL ,’ at line 1 for query ALTER TABLE gp_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) made by activate_plugin, do_action(‘activate_wp-postratings/wp-postratings.php’), WP_Hook->do_action, WP_Hook->apply_filters, ratings_activation, ratings_activate, dbDelta

Viewing 5 replies - 1 through 5 (of 5 total)
Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.