SQL Query question

  • Under phpMyAdmin, I ran an SQL query to turn off all comments on all articles at once, and it said it modified something like 3,000 strings (or lines, or whatever. I don’t remember). Does this make sense? I only have 30 or so articles.

    The query was:

    UPDATE wp_posts
SET comment_status = 'closed', ping_status = 'closed';

Viewing 3 replies - 1 through 3 (of 3 total)

  • The wp_posts table stores posts, pages, attachments, and revisions (and possibly other things), so you changed all of them – 3000 rows. This may be OK, depending on how the other types of rows use that status.

    Thread Starter Dario D.

    (@dario-d)

    Dang, thanks.

    So, issue #2 is restoring my backed up mySQL database. I backed it up before running that query, but, upon restoring, I ran into an error that said:
    “Duplicate entry ‘408’ for key 1”

    Any ideas?

    Depending on how the backup was done you might have to either drop or truncate the tables in the database before you can restore.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘SQL Query question’ is closed to new replies.