RSS Feed old and numeric URLs

Hey Ismael,

interesting. I did not modify the database before. But i think your approach is the way to go.

Since I am using another caching plugin i did not try wp-otimize, but i tried removing those URLs manually from the database. I went to my db and inside the “posts” table, looked up the URLs and removed them one by one. When i looked at my feed again they were gone. It worked.

But then i saw that the main menu/navigation on my site was also gone :) I tried refreshing the cache and different browsers, but did not got the menu back until i switched back to my old data base backup. Now i can switch back and forth, new database has those broken URLs removed but no menu/navigation, old db is of course stillt he same but the menu is working. Any idea why this happened and what i can do about it? I could try removing each link manually until i face the same problem again, but maybe you know why this happens … ?

Thanks once again!

Best regards

• This reply was modified 3 years, 1 month ago by hammerseo.

Hello,

well, I just went into my database > posts and searched for the URLs, e.g. i searched for 628, 627, 633 and so on. All of the URLs that are insinde my feed but should not be there. Each time i got only one result so i thought that must be right. There is even an /enfold-child/ URL but i did not touch it, since i was scared to break something.

I found the RSS script by searching on this topic. I do not remember exactly where, i think somewhere on stackexchange. There where some old suggestions that did not work properly, this one was the newest answer i found from 2020. You can see the pastebin link in the private field.

Best regards!

• This reply was modified 3 years, 1 month ago by hammerseo.

Hi Ismael,

as usual you gave me just the right hint.

WordPress does use multiple post types and my script included all of them. But i only needed ‘post’ and ‘page’ post types. Your first suggestion to solve the problem with deleting db entries was also right, but since the db entries included parts of the WordPress navigation it broke the navigation.

I solved the problem with putting this code inside my functions.php:

add_filter('request', 'feed_request');
function feed_request($qv){
    $rss_post_types = array('post', 'page');
    if(isset($qv['feed']) && !isset($qv['post_type']))
        $qv['post_type'] = $rss_post_types;
    return $qv;
}

This way only pages and posts are included into the feed.

Thanks for your awesome support once again!

Best Regards

• This reply was modified 3 years, 1 month ago by hammerseo.