Page 1 of 1

batch approve comments...

Posted: Wed Nov 16, 2005 12:01 am
by sloppy robot
i just installed and all my imported comments want approval.. but theres hundreds of them.. do i have to do it one at a ttime?

Re: batch approve comments...

Posted: Thu Nov 17, 2005 12:43 pm
by garvinhicking
From which system did you import the comments? It should set the comments to pending, usually...

You can approve all comments with this SQL query:

Code: Select all

UPDATE serendipity_comments SET status = 'approved'
HTH,
Garvin