I am new to drupal and I recently went live with a new site, fantapedia.net. Today I deleted a duplicate comment I had posted through administrator -> comments. As far as I can tell something went wrong and ALL of the comments on my site were deleted. I ran a query against the comments table and it returned 0 results. The main page still shows the comment count, however if you go to a node with comments none are displayed with the excption of one new comment I posted after the delete. Can anyone tell me how this happened? Is it possible to recover the lost comments short of a DB restore?
I only had about 30 comments and it appears that new comments are working correctly. Here is the excerpt from the watchdog where it logs the delete actions. Notice how most of them occured at 20:13.
content 10/31/2006 - 20:15 Comment: deleted . Ty
content 10/31/2006 - 20:15 Comment: deleted . Ty
content 10/31/2006 - 20:13 Comment: deleted . Ty
content 10/31/2006 - 20:13 Comment: deleted Player movement. Ty
content 10/31/2006 - 20:13 Comment: deleted More Randolph. Ty
content 10/31/2006 - 20:13 Comment: deleted Injured centers. Ty
content 10/31/2006 - 20:13 Comment: deleted Agreed. Ty
content 10/31/2006 - 20:13 Comment: deleted one more. Ty
content 10/31/2006 - 20:13 Comment: deleted What about rebounds. Ty
content 10/31/2006 - 20:13 Comment: deleted Comments. Ty
content 10/31/2006 - 20:13 Comment: deleted Drafting Fools. Ty
content 10/31/2006 - 20:13 Comment: deleted Steve Nash/Zach Randolph. Ty
content 10/31/2006 - 20:13 Comment: deleted Wade over Gilby. Ty
content 10/31/2006 - 20:13 Comment: deleted Great!. Ty
content 10/31/2006 - 20:13 Comment: deleted Childress. Ty
content 10/31/2006 - 20:13 Comment: deleted Compliment to Childress. Ty
content 10/31/2006 - 20:13 Comment: deleted Lebron and co...etc.... Ty
content 10/31/2006 - 20:13 Comment: deleted Cavs/Bulls/Pistons. Ty
content 10/31/2006 - 20:13 Comment: deleted Sixers. Ty
content 10/31/2006 - 20:13 Comment: deleted An idea. Ty
content 10/31/2006 - 20:13 Comment: deleted Brilliant!. Ty
content 10/31/2006 - 20:13 Comment: deleted RE:Wade. Ty
content 10/31/2006 - 20:13 Comment: deleted Wade. Ty
content 10/31/2006 - 20:13 Comment: deleted Howard. Ty
content 10/31/2006 - 20:13 Comment: deleted Howard is 2 dimensional. Ty
content 10/31/2006 - 20:13 Comment: deleted Some comments. Ty
content 10/31/2006 - 20:13 Comment: deleted True. Ty
content 10/31/2006 - 20:13 Comment: deleted Childress, seriously?. Ty
content 10/31/2006 - 20:13 Comment: deleted good point. Ty
content 10/31/2006 - 20:13 Comment: deleted damn. Ty
content 10/31/2006 - 20:13 Comment: deleted Kirilenko. Ty
content 10/31/2006 - 20:13 Comment: deleted I would. Ty
content 10/31/2006 - 20:13 Comment: deleted nash and kidd. Ty
content 10/31/2006 - 20:13 Comment: deleted Nice. Ty
content 10/31/2006 - 20:13 Comment: deleted Words from the docta. Ty
content 10/31/2006 - 20:13 Comment: deleted Comment. Ty
content 10/31/2006 - 20:13 Comment: deleted . Ty
content 10/31/2006 - 20:12 Comment: deleted What about rebounds. Ty
content 10/31/2006 - 20:05 Comment: added What about rebounds. Ty view
warning content 10/31/2006 - 20:05 Comment: duplicate What about rebounds. Ty
content 10/31/2006 - 20:04 Comment: added What about rebounds. Ty view
Any help is appreciated. Thanks.
- Tyson
Comments
A Clue!
After doing some more searching on the forums I noticed this thread; http://drupal.org/node/67745. I looks like this issue has been seen before and was apparently patched. My production Drupal version is 4.7.2 and it looks like the patch was added a couple of weeks after 4.7.2 was released. I will need to update my site to make sure this does not happen again.