Sean Reiser
Rebuilding Drupal Comment Stats and Comment Threads
June 6th, 2009 I've been doing some hand fiddling with the Drupal comments file recently and have needed to rebuild the statistics and the tread field in the comments table. Where there are many scripts I've found to rebuild comment_statistics, there's little out there on rebuilding the comment thread field (which at first looks like a little black magic). I've built a script which walks all nodes and rebuilds both. (Parts of the script are mine, parts are lifted out of comments.module parts are bits of code I've found on drupal.org). I figured I'd post the code for it here (it's also the baseline for some code I'm going to post later in the week).
To be honest, I've lost track which lines are owned by which programmer, but all of it is either from the comments module or code I pulled from the drupal forum (If I find that post I'll credit it here). I'll also post the code over on drupal.org.
Sean Reiser, 40, is a developer, technologist, and amateur photographer. Sean has spent the past 20 years as a programmer, system architect and development manager. He is a life long New York resident.
Sean currently serves as the President and Chief Geek Officer of Repair Sense, Inc.. Please go to that site with any professional inquiries.
Sean can be found using a number of social networks. These are the ones he's most active on:
- Well said, sir.
4 weeks 5 days ago - Thank you for the scripts!
22 weeks 47 min ago - Sean, I couldn't agree more!
22 weeks 13 hours ago - Just a quick follow-up: the
22 weeks 5 days ago - Awesome. Thanks!
22 weeks 5 days ago - If you have the development
22 weeks 5 days ago - Thanks for this snippet - it
22 weeks 5 days ago - well, I think partial SSNs
22 weeks 5 days ago - Check out
23 weeks 4 days ago - @sreiser, Does your drupal
23 weeks 4 days ago
- iSeanReiser (198) - Geek Blog
- The Early Reiser (32) - Mainstream Blog
- Livejournal (171) - Old Livejournal Blog
- Great Existence (149) - Photo of the Day
- Photosets (135) - Photos on Flickr
- January 2010 (2)
- September 2009 (1)
- August 2009 (30)
- July 2009 (55)
- June 2009 (49)
Mon, 2010-02-08 17:42
seanreiser tweeted "Today's Lesson: Couture represents the quality of a dress isn't a brand name ... Until this meeting I had today I thought it was a brand" 5:42pm#- seanreiser tweeted "today I am full of Epic Fail!" 5:30pm#
- seanreiser tweeted "I Miss the Boy Scouts http://ff.im/-fB5rW" 10:20am#
seanreiser shared I Miss the Boy Scouts 10:00am#Sun, 2010-02-07 21:42
- seanreiser tweeted "@AlisonM ooo Tish... That's French....." 9:42pm#
- seanreiser tweeted "RT @ChrisPirillo: The Toyota Super Bowl commercial has just been recalled." 9:12pm#
- seanreiser tweeted "how to impress a french girl: know how to search the internet without a commercial" 8:56pm#
- seanreiser tweeted "Onside Kick? #superbowl" 8:22pm#
- seanreiser tweeted "I'm sorry 60+ year old Daltry and Townsend w/o Moon or Entwistle is not The Who.." 8:19pm#
- seanreiser tweeted "there's something wrong about 60+ year old men singing about teenaged revolution" 8:10pm#
Thanks for this snippet - it might be really helpful to a lot of people. I'm painstakingly porting a database over from scoop, and I need to rebuild the threading. This might do it.
Can you post something about how you deploy this code? Where would you put it to run? How does it know about Drupal's internals?
If you have the development module installed you should be able to just do a copy / paste and hit execute from the "Run PHP Code" page. Alternatively, you could put it in a function in your template file and fire it off using Drush.
Awesome. Thanks!
Just a quick follow-up: the code worked perfectly with no modifications. Paste and run. It traversed an import of 40,000 comments and didn't even hiccup.
Thanks! You saved me many braincells.