I've had a spammer/hacker submit several hundred feedback messages. I don't want to go one-by-one and check them as read. Is there a way to remove them all in one go? I can do it directly on the database, but what should I be deleting?
| Comment | File | Size | Author |
|---|---|---|---|
| #7 | delete.patch | 345 bytes | mfb |
Comments
Comment #1
sunCurrently only possible via the database.
Postponing on #323506: Allow to delete items
Comment #2
gallamine commentedHow would I go about doing that? Is it just items in one table that I need to delete, or are there links?
Comment #3
asood99 commentedThere is a mySql database associated with your site. In my case it's my hosting service user account followed by _drp1 (like acctc_drp1).
You can manage the db with phpMyAdmin or MySqlWorkbench. (My hosting provider, Bluehost, has phpMyAdmin in my control panel.)
Connect to the db (like acctc_drp1) with either application.
Once it's open, look for something like drp_feedback. The important part is "_feedback". Select it and it will open a page will the feedback entries.
Select browse. You can see all of the entries so you can bulk select and delete whatever you want.
Comment #4
jody lynnComment #5
jody lynnI want to allow bulk deletion via views bulk operation.
#453820: Views integration, #323506: Allow to delete items, and #353548: Add trigger/action for e-mail notification each have to land first.
Comment #6
molenick commentedIt looks like this still doesn't work.
I've enabled the view and added a views_bulk_operations field to it, set up to delete. When I go through the process, it tells me the correct number of items are deleted, but they are not.
I haven't dug down but my guess is that it's because feedback is stored in the feedback table and vbo intends to work on drupal objects?
Comment #7
mfbThis adds the missing deletion callback so Views bulk operations works w/ Feedback.
(A label callback would be nice so the confirmation page makes sense; also VBO should be able to change feedback status not just delete).
Comment #8
mfbAnyone have a chance to review this one?
Comment #9
eluchel commentedI will look at it either tomorrow or next week.
Comment #10
eluchel commentedIt looks good! Thanks mfb!
Comment #11
eluchel commented