How to clear askbot_anonymousquestion and askbot_anonymousanswer tables?
 
   
  
 
 
These tables contain 10,384 and 108,444 records respectively of spam on our system. Enabling Anonymous Questions / Answers has become a backdoor for bots to post spam so we have had to disable this feature. How can we clear these tables? Is it ok to just delete the records or will this break integrity or corrupt the app elsewhere?
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 Rupreck's avatar

      305
    
 
 
 
 Rupreck 
 
 
    asked 10 years ago,
        
    updated 10 years ago 
 
 
 
 
        
 
 
 
Comments
 
 
 
 
  
 
 
 
Check your own tables and see if you have the same problem.  

Probably the best way is to place a captcha on the page for users to complete when making an anonymous post.
 
 
 Rupreck's avatar Rupreck (10 years ago)   
 
 
  
 
 
  
 
 
 
Does anyone know the answer to this question?
 
 
 Rupreck's avatar Rupreck (10 years ago)   
 
 
  
 
  see more comments