Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 26 Nov 2014, 16:15
John Diver John Diver is offline
 
Join Date: Nov 2003
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
__________________
CanaryHotspot.com - Canary Island forum and information
InternationalChatForum.com - International Travel Chat Forum and information
Reply With Quote
  #2  
Old 26 Nov 2014, 19:48
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
Originally Posted by John Diver View Post
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.
Reply With Quote
  #3  
Old 26 Nov 2014, 20:26
John Diver John Diver is offline
 
Join Date: Nov 2003
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
__________________
CanaryHotspot.com - Canary Island forum and information
InternationalChatForum.com - International Travel Chat Forum and information
Reply With Quote
  #4  
Old 27 Nov 2014, 03:42
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
Originally Posted by John Diver View Post
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?
Reply With Quote
  #5  
Old 27 Nov 2014, 09:02
John Diver John Diver is offline
 
Join Date: Nov 2003
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
__________________
CanaryHotspot.com - Canary Island forum and information
InternationalChatForum.com - International Travel Chat Forum and information
Reply With Quote
  #6  
Old 27 Nov 2014, 11:30
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
Originally Posted by John Diver View Post
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?
Reply With Quote
  #7  
Old 27 Nov 2014, 17:13
John Diver John Diver is offline
 
Join Date: Nov 2003
Yeah the site was live, I meant I did a copy as a test site so I wasn't working with the live db
__________________
CanaryHotspot.com - Canary Island forum and information
InternationalChatForum.com - International Travel Chat Forum and information
Reply With Quote
  #8  
Old 27 Nov 2014, 17:40
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Did you check the actual RSS feed itself to see if it was feeding you blank posts?
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #9  
Old 27 Nov 2014, 18:19
John Diver John Diver is offline
 
Join Date: Nov 2003
Hey Lynne, yeah I checked it and the feed is working fine
__________________
CanaryHotspot.com - Canary Island forum and information
InternationalChatForum.com - International Travel Chat Forum and information
Reply With Quote
  #10  
Old 27 Nov 2014, 18:50
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
Originally Posted by John Diver View Post
Yeah the site was live, I meant I did a copy as a test site so I wasn't working with the live db
Ah ok.
Reply With Quote
  #11  
Old 27 Nov 2014, 19:06
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Can we get a link to the feed and also what do you have set for the RSS template?
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #12  
Old 27 Nov 2014, 19:44
John Diver John Diver is offline
 
Join Date: Nov 2003
Hey Lynee, is there a query I can run to find posts with a blank body (No characters for the message)?

Thanks
__________________
CanaryHotspot.com - Canary Island forum and information
InternationalChatForum.com - International Travel Chat Forum and information
Reply With Quote
  #13  
Old 27 Nov 2014, 19:58
vBNinja's Avatar
vBNinja vBNinja is offline
 
Join Date: May 2011
Originally Posted by John Diver View Post
Hey Lynee, is there a query I can run to find posts with a blank body (No characters for the message)?

Thanks

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

I don't see why you would have blank posts though
__________________
PM me for Custom Mod Requests/Work
Reply With Quote
  #14  
Old 27 Nov 2014, 20:25
John Diver John Diver is offline
 
Join Date: Nov 2003
Showing rows 0 - 29 (2957 total, Query took 0.0164 sec)
So thats 2957 empty posts or am I getting something wrong?
__________________
CanaryHotspot.com - Canary Island forum and information
InternationalChatForum.com - International Travel Chat Forum and information
Reply With Quote
  #15  
Old 27 Nov 2014, 21:11
vBNinja's Avatar
vBNinja vBNinja is offline
 
Join Date: May 2011
Originally Posted by John Diver View Post
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
__________________
PM me for Custom Mod Requests/Work
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 16:00.

Layout Options | Width: Wide Color: