Mass edit of posts (to allow for comments)?

The only way I can think that you currently can do that is via a command in the database. I’m MySQL stupid, so someone else will have to give you the command to use….

Oh, I’m a MySQL nightmare so if that is the only way, I had better stick to a post-by-post edit.

This is exactly what I had, and used SQL to change that. If you want to allow comments to all your posts, the SQL command is of the following form:

UPDATE wp_posts SET comment_status = “open” ;

Now, it depends if the tables making up your installation indeed start with the “wp_” prefix (this is the default, but you can set this to anything else at installation time, so check this).

As to how to use the command, it depends what type of interface to MySQL you use. It could be in command mode (via a shell window), or through an interface such as phpMyAdmin (you may have to backquote the name of the table, like so: wp_posts, as well as that of the column: comment_status).

Good luck

Awesome! Worked like a charm! =D Except instead of enabling them all, I disabled them all!

UPDATE wp_posts SET comment_status = "closed";

Thanks for posting this Miklos… =)

spencerp

I would also like to open up my old posts for comments, but unfortunately I have no clue what I am doing here. Where do I enter this command using phpMyAdmin?

digink, do you have the Database Manager plugin by GamerZ? If you do, as far as I know you could just use/run that query right inside the Blog’s Control panel under the Database Manager section.. =/

But for the phpMyAdmin, you click on the database you want in there, then click on the SQL Query tab at top of that database, and you should get a box with a “GO” button, you’d then just put that query in there, and click “GO”.

But as far as I know, the quicker way, should be the Database Manager plugin though..

spencerp

Don’t have that plugin but I did find the query box you were talking about. Seems to have worked, thanks!

Don’t have that plugin but I did find the query box you were talking about. Seems to have worked, thanks!

No problem.. =)

spencerp