140MB of data in DB table “sitemeta”

  • By accident we discovered, that an endless number of entries have been made by this plugin in our database, 140MB of data to be precise.

    Here’s an sample:
    INSERT INTO wp_6cpy3tqmn0_sitemeta ( meta_id, site_id, meta_key, meta_value) VALUES (808, 1, ‘ws_menu_editor’, ‘a:19:{s:22:”hide_adv[…]

    cheers

Viewing 1 replies (of 1 total)
  • Plugin Author Janis Elsts

    (@whiteshadow)

    That’s a known issue with some Multisite installs. It’s usually caused either by database corruption or concurrency issues. To fix it:

    1. Export your settings (just to be safe).
    2. Deactivate the plugin.
    3. Check & repair the wp_sitemeta table.
    4. Delete all of the duplicate ws_menu_editor entries except one. It’s probably best to leave the one with the highest ID.
    5. Reactivate the plugin.
Viewing 1 replies (of 1 total)
  • The topic ‘140MB of data in DB table “sitemeta”’ is closed to new replies.