Forums

Using PHPMyAdmin to delete form replies

Permalink
Hi
I need to delete a whole bunch of form answers (form has been spammed) and it seems like the easiest way to do this is to use PHPMyAdmin. However it appears that all form answers irrespective of which form are in the table btFormAnswers and I can't see each field individually only answer and answerlong. Is this correct or should I be looking elsewhere?

Thanks everyone.
wildfirelondon
 
hutman replied on at Permalink Reply
hutman
This is correct. The form is stored in btForm the questions are stored in btFormQuestions the answer set is stored in btFormAnswerSet and the actual answers are stored in btFormAnswers deleting form requests from the database is not exactly an easy thing to do.

If you wanted to delete all responses after a January 1, 2018 you could do something like this.

DELETE FROM btFormAnswerSet WHERE created => '2018-01-01 00:00:00';
DELETE FROM btFormAnswers WHERE asID NOT IN (SELECT asID FROM btFormAnswerSet);
JohntheFish replied on at Permalink Reply
JohntheFish
That's good for legacy forms. Express forms use different tables and are a bit more complicated in how they interact.