Search for empty posts and delete

[Lynne]

Can we get a link to the feed and also what do you have set for the RSS template?

[John Diver]

Hey Lynee, is there a query I can run to find posts with a blank body (No characters for the message)?

Thanks

[vBNinja]

Originally Posted by John Diver

Hey Lynee, is there a query I can run to find posts with a blank body (No characters for the message)?

Thanks

PHP Code:

SELECT postid FROM post WHERE pagetext = ''; 


I don't see why you would have blank posts though

[John Diver]

Showing rows 0 - 29 (2957 total, Query took 0.0164 sec)

So thats 2957 empty posts or am I getting something wrong?

[vBNinja]

Originally Posted by John Diver

So thats 2957 empty posts or am I getting something wrong?

Yes it means there are 2957 empty posts... No clue why you have that lol

[John Diver]

Weird... Could anyone help with the query to remove the blank posts, I wonder if they were blank or if the content was lost..

Thanks again

[kh99]

It's a pretty simple query to DELETE FROM post WHERE pagetext = '', but I don't know if that's a good idea. When you delete a post in vbulletin it also handles deleteing anything else that needs to be deleted (like the thread if you delete the only post), and keeps counters up to date. I think it would be a better idea to use a php script to query for the post ids, then call the vbulletin delete_post() function for each one.

[Lynne]

If you are going to run a query to do this, I would STRONGLY suggest doing it on a test site first. If you don't write a script like Kevin suggested, then make sure your run Rebuild Thread Information, Rebuild Forum Information, Rebuild Post Count, Remove Orphan Threads, and Remove Orphan Posts all from the Maintenance > General Update Tools screen. Then click on some threads/posts that you know were empty and see if everything is working correctly. And then, and ONLY then, should you do a database backup of your live site and do the same thing there.

[John Diver]

Thanks for the replies.

Bit of a mission to get this fixed, I will try doing a fresh test upgrade again and see if the same happens.

Kevin, you posted before that the RSS poster would bypass vBulletin stopping a post if it was blank, but if it was run through the admincp an error would show that the subject of body is blank, does that mean the script is still able to bypass that and post a blank message?

[kh99]

Originally Posted by John Diver

Kevin, you posted before that the RSS poster would bypass vBulletin stopping a post if it was blank, but if it was run through the admincp an error would show that the subject of body is blank, does that mean the script is still able to bypass that and post a blank message?

Oh, no, if you were seeing errors about it then probably not. I based my comment on the code in the thread/post data manager. If the post is being made as "automated" then it skips some checks (like minimum characters). There are some things done to the post body after that check, like censorng and removing unprintable characters, so I imagine that it's possible that a post could turn out blank anyway, but maybe there's some other explanation in your case.

If you have a feed that's producing blank posts then it might help track down that error.