Serendipity Forums

Hi,

Is it safe to delete records in this table ?

Mine is currently at 45Mb (!) after only a few weeks.

We seem to be getting lots of hits on the site trying to spam us seemingly from automated bots.

I've turned 'up' the moderation and that's stopped them making any posts but the load on the server must be big.

Is there anything I can do to reduce this - I see a post regarding something with the HTaccess file - is there more clarification on this ?

Other than the Spam issue I'm really pleased with Serendipity

Cheers & Thanks

David

Hi David,

We used to keep our spamblock log as well.
Ours hit more than 200 MB!

We use the Akismet API in Spamblock combined with the ReCaptcha plugin as a one-two punch against blog spam.

We disabled the log over here because Akismet is pretty decent at catching 99% of the spam... sometimes though the occassional trackback ping spam occurs, and sometimes some comments are incorrectly marked as spam, but i think that is a small price to pay!

Cheers. We're not getting much actual spam through so not loggin is cool with me.

How did you disable the log ?

(I can't log into admin at the moment due to other problems )

Hi!

You can turn it off by configuring the anti-spam plugin through the admin interface.

Regards,
Garvin

I've switch the setting to a log file for now.

Is it safe to delete the contents of serendipity_spamblocklog using phpmyadmin ?

And when the log file is too big is it sage to delete it out using my ftp client ?

thanks for your help (should be my last question !)

Best

David

Hi!

Yes, the file is purely for your own information, it is not evaluated by s9y itself. You can delete if if you don't need it any longer.

Same applies to the file via FTP.

Best regards,
Garvin