How do I manually accept an answer in the database?
 
   
  
 
 
I want posts from a specific user to be automatically accepted, thus I am doing a db trigger. But first: What exactly do I need to set for the post/thread to be accepted?
 
I've tried to set askbot_post.approved = 1 and askbot_thread.accepted_answer_id / accepter_answer_at but still no luck.
 
Cheers
 
 
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)
  
 
 
 
 
 
 Chesnaught's avatar

      21
    
 
 
 
 Chesnaught 
 
 
    asked 9 years ago 
 
 
 
 
        
 
 
 
Comments
 
 
 
  see more comments