action not allowed on WordPress tables

  • Resolved wpshushu

    (@wpshushu)


    2 years ago

    Hello,

    Trying to truncate a wp_ prefixed table, it’s from a plugin, not from WP core, but I still got “Action not allowed on WordPress tables” message, how may I get rid of it?

    Thanks
    Shawn

Viewing 5 replies - 1 through 5 (of 5 total)
  • 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!

    Thread Starter wpshushu

    (@wpshushu)

    @kimmyx

    Table name: wp_wpr_rocket_cache
    Plugin: WP-Rocket

    The table is used to hold preload queue by the plugin.

    Ty.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    What is the table type of this table in the Data Explorer Shawn?

    Thanks,
    Peter

    Thread Starter wpshushu

    (@wpshushu)

    @peterschulznl

    “WordPress table”

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘action not allowed on WordPress tables’ is closed to new replies.