batch approve comments...

Having trouble installing serendipity?
Post Reply
sloppy robot
Regular
Posts: 17
Joined: Tue Nov 15, 2005 9:30 pm

batch approve comments...

Post 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?
Top
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:
Contact garvinhicking

Re: batch approve comments...

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Top
Post Reply

Return to “Installation”