enabling all comments

  • We opened our own domain using wordpress template. Someone hacked in and turned off all of our comment threads. I can go back and turn on comments one by one, but that will take at least 2 hours. Is there anyway I can turn all of the comments back on for all of the threads? There is not box to check to turn them all on/off when I go to admin—->user—–>discussion. Help Please.

Viewing 1 replies (of 1 total)

  • 1. Backup your database.
    2. Make sure you have a good backup of your database.
    3. Use phpMyAdmin to execute this SQL statement 

    UPDATE wp_posts SET comment_status='open'
  WHERE post_status = 'publish'
  AND post_type = 'post';

    * if wp_posts is not your posts table then change the reference accordingly.

    [edit oops changed it from closed to open in the SQL statement]

Viewing 1 replies (of 1 total)
  • The topic ‘enabling all comments’ is closed to new replies.

Tags