6.9.7 issue

  • nimonogi

    (@nimonogi)


    5 days, 20 hours ago

    after updating to 6.9.7 the reviews aren’t showing neither on front or backend.

    • This topic was modified 5 days, 20 hours ago by nimonogi.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Daniel K.

    (@richplugins)

    5 days, 19 hours ago

    Hi @nimonogi,

    Thank you for reporting this.

    We found that this issue can happen on some existing installations after updating to version 6.9.7 because of a database collation mismatch between the existing reviews table and the new review text table added in this release.

    We are preparing an automatic plugin-side fix for the next update.

    As a temporary fix, please make a database backup first, then run this SQL query:

    ALTER TABLE wp_grp_google_review_text
MODIFY review_id VARCHAR(80)
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci
NOT NULL;

    If your WordPress database prefix is not wp_, please replace wp_grp_google_review_text with your actual table name.

    After running this query, please clear any site/plugin cache and check the reviews again on the front-end and back-end.

    Sorry for the inconvenience, and thank you for your patience.

    Crescendo

    (@crescendoweb)

    1 day, 8 hours ago

    Hi @richplugins,

    issue is still present on version 6.9.8. Version 6.9.6 is the last working.

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.