Support » Plugin: WP RSS Aggregator » Bulk Delete Data?

  • Resolved mindeeforman

    (@mindeeforman)


    Hi there,

    I had installed WP RSS Aggregator a few years ago to aggregate a feed for my website, but it never really worked the way I wanted it to.

    Fast forward to today, and I now want to use it to pull in an RSS feed from Medium, but all my old data is still there. It’s more than 2 million feed items – 132,000 pages. Is there a way to bulk delete all the plugin data and start fresh? I’ve uninstalled the plugin, but when I reinstall it, the data is still there. I talked to my hosting service and they were no help.

    Thanks,

    Mindee

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Naweed Chougle

    (@hypersonic)

    @mindeeforman You can run the following command using your MySQL client:

    DELETE p,tr,pm
        FROM wp_posts p
        LEFT JOIN wp_term_relationships tr
            ON (p.ID = tr.object_id)
        LEFT JOIN wp_postmeta pm
            ON (p.ID = pm.post_id)
        WHERE p.post_type = 'wprss_feed_item';

    This will delete all feed items previously imported. Please ensure you have a full backup first, just in case something goes wrong.

    Thanks – I tried that and it said “Table ‘edovatec_ss_dbname7b7.wp_posts’ doesn’t exist”

    This really should be a feature of the plugin – is that possible to add?

    The plugin has also been operating VERY slowly for me (possibly because of the 2 million+ entries) and tends to only show some items. For example, when I was deleting the old feeds, there were 21 of them but I would only ever see 2-3 at a time.

    Also, I had no templates this morning, so added one, and now I have 20 called “Default” and the one I added isn’t showing.

    Any ideas?

    Thanks again!

    Plugin Support Naweed Chougle

    (@hypersonic)

    Can you check if the user running the command has the adequate permissions? Perhaps your database may have got corrupted, and you may need to run a repair from your MySQL client.

    As for the trouble with Templates, we’ve seen this happen with users who skip an intermediate release while updating their core plugin to the latest version. To fix this, you’ll need to delete the templates from your database to get the site back to normal. To do so, delete all posts from wp_posts with post_type equal to wprss_feed_template.

    Plugin Support Naweed Chougle

    (@hypersonic)

    Closing this thread since it’s been inactive for a while.

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.