Title: Re-create plugin?
Last modified: September 13, 2025

---

# Re-create plugin?

 *  Resolved [granatdesign](https://wordpress.org/support/users/granatdesign/)
 * (@granatdesign)
 * [8 months, 3 weeks ago](https://wordpress.org/support/topic/re-create-plugin/)
 * Hi –
   I’ve been having an issue with automated incremental backups on my server
   using RunCloud. Based on their support, it looks like your plugin might have 
   something to do with database collation (though I don’t fully comprehend this
   myself). I see there’s an option in advanced settings to do the following:Re-
   create the database tables of the plugin.Please note: this removes all settings
   and reviews.My question is how difficult is it to manually add back the reviews
   after this procedure?
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fre-create-plugin%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Support [Laca](https://wordpress.org/support/users/lacadev/)
 * (@lacadev)
 * [8 months, 3 weeks ago](https://wordpress.org/support/topic/re-create-plugin/#post-18641483)
 * Hi [@granatdesign](https://wordpress.org/support/users/granatdesign/) 
   It’s not
   complicated — the widget will simply reset to a fresh install state. You’ll just
   need to reconnect your account and configure the plugin again, the same way you
   did when you first installed it.
 * Kind regards,
   Laca from Trustindex
 *  Thread Starter [granatdesign](https://wordpress.org/support/users/granatdesign/)
 * (@granatdesign)
 * [8 months, 3 weeks ago](https://wordpress.org/support/topic/re-create-plugin/#post-18642582)
 * ok thank you for reply. 
   Any insight into why the backups might not be working?
 * _ie. it looks like your plugin might have something to do with database collation_
 * fyi deactivated the plugin and the backups worked without issue..
 *  Plugin Support [Laca](https://wordpress.org/support/users/lacadev/)
 * (@lacadev)
 * [8 months, 3 weeks ago](https://wordpress.org/support/topic/re-create-plugin/#post-18643334)
 * Hi [@granatdesign](https://wordpress.org/support/users/granatdesign/)
 * Could you please try to get an exact error message or a clear description from
   the support team about what they believe is not working correctly? Even an example
   of how they expect it to work would be very helpful. That way, we’ll have a concrete
   starting point to investigate further.
 * Kind regards,
   Laca from Trustindex
 *  Thread Starter [granatdesign](https://wordpress.org/support/users/granatdesign/)
 * (@granatdesign)
 * [8 months, 3 weeks ago](https://wordpress.org/support/topic/re-create-plugin/#post-18643826)
 * thx for reply. Here’s what the support team at Runcloud wrote:
 * _It appears that the backup failed due to mydumper being unable to read the database
   collation for a table that has “utf8mb4\_uca1400\_ai\_ci” collation.  It looks
   like the root cause was that the CHARACTER\_SET\_NAME is NULL.  ​​_
 * `MariaDB [(none)]>  SELECT * FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME
   LIKE '%uca1400_ai_ci%';
   +----------------+--------------------+------+------------
   +-------------+---------+---------+| COLLATION_NAME | CHARACTER_SET_NAME | ID
   | IS_DEFAULT | IS_COMPILED | SORTLEN | COMMENT |+----------------+--------------------
   +------+------------+-------------+---------+---------+| uca1400_ai_ci  | NULL
   | NULL | NULL       | Yes         |       8 |         |+----------------+--------------------
   +------+------------+-------------+---------+---------+1 row in set (0.006 sec)
 * _Kindly see the affected table for one of your databases ‘frazerfirm2\_1736124192’_
 * `MariaDB [(none)]> SELECT TABLE_NAME, TABLE_COLLATION FROM information_schema.
   TABLES WHERE TABLE_SCHEMA = 'frazerfirm2_1736124192' AND TABLE_COLLATION = 'utf8mb4_uca1400_ai_ci';
   
   +----------------------------+-----------------------+| TABLE_NAME           
   | TABLE_COLLATION       |+----------------------------+-----------------------
   +| **wp_trustindex_google_views **| utf8mb4_uca1400_ai_ci |+----------------------------
   +-----------------------+1 row in set (0.001 sec)
 * _As a workaround, you need to change the collation manually from your end, by
   running the below command inside MySQL:_
 * `ALTER TABLE <tablename> COLLATE utf8mb4_general_ci;`
 * So it seems like what they are saying is that your plugin is adding it’s data
   with the character set as ‘Null’
 *  Plugin Support [Laca](https://wordpress.org/support/users/lacadev/)
 * (@lacadev)
 * [8 months, 3 weeks ago](https://wordpress.org/support/topic/re-create-plugin/#post-18646987)
 * Hi [@granatdesign](https://wordpress.org/support/users/granatdesign/)
 * This issue is most likely not determined by our plugin, since no specific collation
   is set within it.
   As a solution, you can safely run the following SQL command
   in your database:
 * `ALTER TABLE wp_trustindex_google_views COLLATE utf8mb4_general_ci;`
 * This should resolve the problem.
 * Kind regards,
   Laca from Trustindex
 *  Thread Starter [granatdesign](https://wordpress.org/support/users/granatdesign/)
 * (@granatdesign)
 * [8 months, 3 weeks ago](https://wordpress.org/support/topic/re-create-plugin/#post-18647170)
 * ok thx. I tried to run that command, but it said nothing took place, so I did
   it in ‘operations’ 
   note: I first made a staging site to test this
 * ![](https://wordpress.org/6a4f7e33-82b3-4259-9111-e2f5460bfba1)
 *  Plugin Support [Laca](https://wordpress.org/support/users/lacadev/)
 * (@lacadev)
 * [8 months, 3 weeks ago](https://wordpress.org/support/topic/re-create-plugin/#post-18648433)
 * Hi [@granatdesign](https://wordpress.org/support/users/granatdesign/) 
   Please
   check the collation directly on your database tables.In phpMyAdmin you can see
   it in the **“Collation”** column (screenshot attached: [https://snipboard.io/tG43Xc.jpg](https://snipboard.io/tG43Xc.jpg)).
 * When you run a collation change, MySQL may show _“0 rows affected”_ even if the
   collation was actually updated. That message only refers to data rows, not to
   table definitions. The real way to confirm the change is to look at the “Collation”
   column in phpMyAdmin (see screenshot).
 * Kind regards,
   Laca from Trustindex
 *  Thread Starter [granatdesign](https://wordpress.org/support/users/granatdesign/)
 * (@granatdesign)
 * [8 months, 3 weeks ago](https://wordpress.org/support/topic/re-create-plugin/#post-18648441)
 * Yes. I ran it and now backup works.
   thx!

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

The topic ‘Re-create plugin?’ is closed to new replies.

 * ![](https://ps.w.org/wp-reviews-plugin-for-google/assets/icon-256x256.png?rev
   =2721569)
 * [Widgets for Google Reviews](https://wordpress.org/plugins/wp-reviews-plugin-for-google/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-reviews-plugin-for-google/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-reviews-plugin-for-google/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-reviews-plugin-for-google/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-reviews-plugin-for-google/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-reviews-plugin-for-google/reviews/)

 * 8 replies
 * 2 participants
 * Last reply from: [granatdesign](https://wordpress.org/support/users/granatdesign/)
 * Last activity: [8 months, 3 weeks ago](https://wordpress.org/support/topic/re-create-plugin/#post-18648441)
 * Status: resolved