all visitors see the message “0, 0, you have already rated it”

  • Resolved toologic

    (@toologic)


    5 years ago

    1. Activate (deactivate) plugin = MYSQL 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 request ALTER TABLE XXXX_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)

    2. add do_shotrcode [“[ratings…]”] into my post template, all visitosr see next message
    0 balls, 0 counts, you are already rated this post

    There is no rating in the database

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Lester Chan

    (@gamerz)

    Are you using MultiSite? Can check if wp_ratings table are created in the database?

    Also what version of PHP and MySQL you are using?

    Thread Starter toologic

    (@toologic)

    1. MySQL 5.7.x No, simple WP last version. Table was created in Db normally.
    2. Resolved. I used [ratings id=XXX ] shortcode, not the correct [ratings]

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘all visitors see the message “0, 0, you have already rated it”’ is closed to new replies.