Clearing out apparently large spamblock file

[trevorgensch]

My hosting provider has contacted me saying I have a file in my serendipity which is about 1.5 gig in size and making very large calls on their database.

They want me to clear it out but I don't know how to do it. I will put what they have asked me to do below here:

=======================
I have noticed that in Database "mmmcommentari_install_1203822582", the table "serendipity_spamblocklog" contains the size of "1.5 GB" and looks like most of all the entries belongs to spam block.

Below query tried to insert many instances and failed and query killed from our end.

insert into serendipity_spamblocklog (timestamp, type, reason, entry_id, author, email, url, useragent, ip, referer, body) values (N, 'S', 'S', 'S', 'S', 'S', 'S', 'S', 'S', 'S', 'S')

I would suggest you to clear the unwanted contents from table "serendipity_spamblocklog".
=======================

Now I don't know what to do... help appreciated.

Trev.

[Don Chambers]

Do you have phpMyAdmin? You can empty the table using that. You can disable logging completely in the plugin configuration.

[Timbalu]

There is also a new plugin dbclean http://board.s9y.org/viewtopic.php?f=4& ... #p10422478 which could help to clean up those tables in future.
It probably won't help in this case, but you might give it a try.

Ian

[trevorgensch]

Do you have phpMyAdmin? You can empty the table using that. You can disable logging completely in the plugin configuration.

Is that something as part of a standard install, or do I need to add it?>

Apologies for the noob questions, I don't know a hell of a lot about it, well I knew a little when I set it up, but that was 4 years ago - I haven't had to really touch the admin side since then

Help appreciated.

Trev.

[kleinerChemiker]

So you didn't do any updates either? Thats very risky. Several bugs have been fixed and there are allready some blogs that have been hacked because the used outdated versions of s9y.

[Timbalu]

No, this a seperate program based on PHP. It has nothing todo with Serendipity (*).
Normally, if you have webspace with a mysql db, this is the standard tool to work in the database.
Ask your provider.
If they do not have it, maybe they can truncate the spamblocklog table for you.

Ian

* well, it has..., since Garvin was/is involved in both

[Timbalu]

...have been hacked because they used outdated versions of s9y.

To be clear here, there were some third party includes being vulnerable which compromised serendipty installations.

Ian