Plugin Contributor
Kim L
(@kimmyx)
Hi Shawn,
May we know which plugin is the table from?
We’d like to test it out on our end.
Looking forward to your response!
@kimmyx
Table name: wp_wpr_rocket_cache
Plugin: WP-Rocket
The table is used to hold preload queue by the plugin.
Ty.
What is the table type of this table in the Data Explorer Shawn?
Thanks,
Peter
Hi Shawn,
I cannot find a free version of the WP ROCKET plugin, so I cannot test this on my development machine, bit I think WP ROCKET adds its plugin table to the WordPress table list. WP Data Access uses this list to identify and protect WordPress tables. DDL actions are generally not supported on WordPress tables. There is no way to get around this and I really don’t want to remove this protection layer.
But there is a workaround. DDL on WordPress tables is not supported, but DML is. You can remove all records using the Query Builder with “delete from wp_wpr_rocket_cache”. To perform this action you need to disable the “Protect WordPress tables” checkbox. Please be aware that truncate table does not work in the Query Builder either. This is a bit abitrary but helps to protect your WordPress tables.
Does this help?
Thanks,
Peter
