Unhide a SPAM Comment

Sam · 2008-10-09 14:31:16

Hi,

I was wondering what the procedure is to unhide a comment that was marked as SPAM?

I notice that the comments visible field in the database is marked as -1. Would resetting that to 1 do it? Does anything else have to be done?

Thanks! :)

ruud · 2008-10-09 15:13:13

Can’t you mark it as something else than spam through the comments tab?

Sam · 2008-10-09 15:17:29

The “Hide (spam)” option removes them from the comments tab though? I would if I could!

maniqui · 2008-10-09 15:30:11

(I think) There is a checkbox at the bottom of the Comments tab to show comments marked as spam.

ruud · 2008-10-09 15:42:55

^^ yep, there’s a checkbox which you can ‘uncheck’ to show spam comments as well.

Sam · 2008-10-09 17:08:14

My clients site does not have this checkbox. Probably because it says there are “No comments recorded.” (The only comments that were added were accidentally marked as spam).

Is it ok to simply change that -1 to a 1 via PHPMyAdmin, does anything else need modified is all I really need to know??

Thanks guys.

ruud · 2008-10-09 17:32:16

You should also update the comment_count in the textpattern table for the correponding article.

Sam · 2008-10-09 18:03:40

Super thanks Ruud, will give that a go.

wet · 2008-10-10 20:03:19

Bug fixed with r2985. Thanks for the report.

Textpattern CMS

Textpattern CMS support forum

#1 2008-10-09 14:31:16

Unhide a SPAM Comment

#2 2008-10-09 15:13:13

Re: Unhide a SPAM Comment

#3 2008-10-09 15:17:29

Re: Unhide a SPAM Comment

#4 2008-10-09 15:30:11

Re: Unhide a SPAM Comment

#5 2008-10-09 15:42:55

Re: Unhide a SPAM Comment

#6 2008-10-09 17:08:14

Re: Unhide a SPAM Comment

#7 2008-10-09 17:32:16

Re: Unhide a SPAM Comment

#8 2008-10-09 18:03:40

Re: Unhide a SPAM Comment

#9 2008-10-10 20:03:19

Re: Unhide a SPAM Comment

Board footer