Search for empty posts and delete
 

Hey,

I upgraded a forum from 3.8 and I have some RSS feeds setup, some of the feeds are showing blank posts - I would like to know how I can search for any blank posts first so I can check the feed and how I could delete any posts that have a blank message - Some posts have the title but no actual post for some reason.

Thanks for any help :)

Have you recounted everything after upgrading from vb 3.8 to vb 4? If not you need to login to your admincp and go to Maintenance>General Update Tools and update your threads, forums, posts, members, etc.

Thanks for the reply.

I have been running these today, its taking quite a while, 260k+ threads - But these were new posts, it was showing the title but no body content.

I was hoping to find any that are coming blank so I can work on that feed.

Thanks Len

Yeah when you have a large forum it will take quite some time to do these. Something seriously freaky is going on with your site since your upgrade. What steps did you take for your upgrade exactly and what version did you upgrade from?

Hey Len

I upgraded from 3.8.3 I think it was,, it was 3.8.x anyway.

I copied the database to a new db by SSH and just ran through the upgrade script

Why did you copy it to a new database? That is a step that you do not need to do. Was the site live at the time?

Yeah the site was live, I meant I did a copy as a test site so I wasn't working with the live db

Did you check the actual RSS feed itself to see if it was feeding you blank posts?

Hey Lynne, yeah I checked it and the feed is working fine

Ah ok. :)