plugin suddenly broken

  • Resolved enigma2k

    (@enigma2k)


    4 years, 10 months ago

    Hi,

    I had installed the plugin a few months ago and it ran without any problems. Today I looked back on the page and I have seen that the plugin seems to be broken.

    It can no longer fetch the number of some reviews for the overview shortcut (so the rating for a review and the number of the reviews are missing). I just get a “0” for the score and it says “0” reviews.

    This only happens for some reviews. but the mysterious part is that when I click under tools: “Recalculate Summary Counts”, it will then show the correct numbers that were missing before BUT the numbers of the other reviews are now missing and show a “0”.

    I don’t know with which version number this bug occurred because it did auto update itself.

    Under Tools/Console I get the following but I don’t know if this has anything to do with this:
    [2020-04-06 21:52:52] WARNING [Modules/Validator/ValidateReview.php:177] The Honeypot caught a bad submission:

    (this is all that is in the console without the actual submission showing up that has caused this warning message)

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Gemini Labs

    (@geminilabs)

    Sounds like the migration did not run successfully when you updated to v4.0

    Please first run the migration tool, and then run the recalculate summary counts tool.

    Thread Starter enigma2k

    (@enigma2k)

    Thanks for the quick reply! I have started with version 4 and was never below version 4.

    I have now run the “Migrate Plugin” under tools and then clicked again on the recalculate but it did not fix it.

    Do you know what else could be wrong?

    Plugin Author Gemini Labs

    (@geminilabs)

    Please use the “Contact Support” section on the help page to send me the system info, and also the URL of the page on your website.

    Plugin Author Gemini Labs

    (@geminilabs)

    When Site Reviews performs a re-calculation of summary counts, it first purges all meta_keys that store the rating counts, then it calculates and stores the correct rating values.

    This issue was introduced in v4.5 and is happening due to a race condition in the database, meaning that these database commands are not being performed synchronously. This is possibly due to the way that SiteGround optimises your database queries, as I am unable to reproduce the issue on my development server.

    It actually is unnecessary to purge meta_keys with the categories, so a quick fix is to remove the following highlighted line:

    https://github.com/pryley/site-reviews/blob/8e7eafa4625b2194b5d4fb6a602719ea60f626f6/plugin/Database/TermCountsManager.php#L93

    You can either do this yourself using the Plugin Editor, or you can wait until the next plugin update to fix this.

    Plugin Author Gemini Labs

    (@geminilabs)

    Fixed in v4.6

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘plugin suddenly broken’ is closed to new replies.