You could just go into MySQL and empty out the evo_antispam table. I don't have the SQL for you, but I know EdB has done this. Maybe he'll wander along and give you the magic code.

I did a bit of research and I think this should do it:

TRUNCATE TABLE evo_antispam;

That will basically drop the whole table, then recreate it as an empty table (so you don't get any errors when b2evo goes looking for the table). You can give that SQL to MySQL through the command line, or phpMyAdmin or we could write up a little php script for you to upload and run.

It is a good idea to install [url=http://www.phpmyadmin.net/]phpMyAdmin[/url] on your server, so you could access the [url=http://b2evolution/net]b2evolution[/url] database directly.

I do have php myadmin - so in the b2evo database I would then run the line

TRUNCATE TABLE evo_antispam;

with the semicolon as well ?

8|

That's right. You have to have that semicolon or your head will asplode.

I got all nervous that my site would asplode so I deleted every entry under the

evo_antispam / aspm_id table...

worked like a charm - not that I doubt your sql string I'm just really scared every time I go into a sql database. :o And to boot I'm too many beers into a Thursday to repair anything. Much thanks for the direction....

you know - theres a hell of alot of entries in there- at the end I was listing 1500 entries at a time - hitting check all and delete... I did that alot...

thats gotta be taking a hit on the performance on B2 Evo - either in reading or posting dosent it ?- and putting alot of sql query load on the host ?

I didn't mean asplode as in break your blog. The query just wouldn't have worked without the semicolon. Oh well, at least you got some exercise. Yeah, that does pull and push a lot of data between your webserver and mysql server. More than anything that's a testament to the efficiency of mysql. Or something.

I fear the mighty MY SQL -

Is a blacklist really a good idea anymore with the numerous entries?

:-/

It is a dangerous and powerful beast. There's no undo buttom and now recycle bin.

I think it still works. There are scripts that prune redundant entries and there's been talk of doing something to see which spammers are still active and which can be removed from the list.