Bulk Delete Data?

@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!

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.

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