Post Meta Table Crashed

This topic contains 8 replies, has 4 voices, and was last updated by  Giri 7 years, 5 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • December 16, 2016 at 5:47 pm #325758

    kstock
    Full Member
    Post count: 39

    Hi,

    I have a site that has approximately 4500 listings. I recently have run into an issue with adding menus. See attached image. My wordpress developer told me the issue is the wp meta tables has too much data and is crashing. I uninstalled all plugins and tried to switch themes with no luck.

    I’m really not sure where to turn at this point. I have a dedicated server with hostgator and have room to spare. Any help would be appreciated

    December 16, 2016 at 6:03 pm #325766

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Kstock,

    We don’t use the post meta table 🙂
    If you provide wp-admin, FTP and DB access i will check if i can see any probs.

    Thanks,

    Stiofan

    December 16, 2016 at 7:53 pm #325865

    kstock
    Full Member
    Post count: 39
    This reply has been marked as private.
    December 16, 2016 at 8:01 pm #325872

    Paolo
    Site Admin
    Post count: 31206

    Would you mind also providing a link and admin credentials for the website?

    December 16, 2016 at 8:12 pm #325876

    kstock
    Full Member
    Post count: 39
    This reply has been marked as private.
    December 16, 2016 at 10:57 pm #325898

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    As Stiofan said, GeoDirectory doesn’t use that table.

    The vast majority of entries in that table are from a wprss plugin. Examples:
    wprss_item_permalink
    wprss_ftp_feed_source
    wprss_ftp_media:thumbnail

    and several more.

    There are other from what I presume was a Job listings plugin.
    _job_expires
    _wpas_done_all
    and several more.

    There are also some referring to geolocation, but they are not from GeoDirectory. They must be from another plugin or theme:

    geolocation_state_short
    geolocation_formatted_address

    In total you have 72499 table rows, removing the rss plugin would make a good clean, but I’m sure there is more that can be removed.

    Thanks

    December 17, 2016 at 9:10 am #326059

    Giri
    Expired Member
    Post count: 3155

    Hi kstock,

    If you still have this problem. Try switching your theme.

    Thanks

    December 17, 2016 at 2:00 pm #326148

    kstock
    Full Member
    Post count: 39

    Hi,

    this did fix my problem. Thank you so much for the quick help on this

    December 17, 2016 at 2:10 pm #326153

    Giri
    Expired Member
    Post count: 3155

    You are welcome 🙂

  • Author
    Posts
Viewing 9 posts - 1 through 9 (of 9 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket