I tired using a different browser and upgrading MT-Blacklist to 1.6.5, but I still get a “Could not save your blacklist data: Got a packet bigger than ‘max_allowed_packet'” error when I try to update my spam list. Help! I’m being drowned in spam and I can’t stop it!
First. And I have no idea what you are talking about.
I last saw that as a mysql error. The prob could be the mysql configuration on the server. There is a line something like
set-variable = max_allowed_packet=8M
The 8M may be different, but whatever it is it just needs to be made bigger (16M? maybe)
Have you tried updating your blacklist piecemeal? Try updating with a very small blacklist, then increase its size until you get the error.
Also, make sure your MT-Blacklist is compatible with your version of MT.
Otherwise, you’ll probably have to contact your hosting company to see if they can change the MySQL settings like tinkas suggests.
Google reveals:
http://www.onegeeksopinion.com/mt/archives/000085.php
But this is probably only applicable if you’re running MySQL off your own computer, which is not the case?
You might also want to keep an eye on this thread, or even chime in with your own situation. It looks like there’s an “advanced member” willing to help.
Yeah, I started that thread.
you could try renaming your mt-comments.cgi to something else, most spam bots just send post data to that file without clicking an actual link. Just don’t forget to specify the new comment file name in mt.cfg and rebuild your site. I’m trying to help Bill Whittle do this right now.
if you want, i can send you a gmail invite Frank…
If you tire or dealing with that, I use a spam filter program called K9 (http://keir.net/k9.html) that works wonders for me. I’ve been using it for more than a year now, and overall it has a 97.8% accuracy rating. It takes a while to get good at it, but it’s well worth it. You might want to check it out.
Thought I might throw another $0.02 in before I go out for the evening (Aus time). I had a read through the install guide for MT-Blacklist and noticed that you can use YAML as a last resort. If the hosting company cant or wont increase the max_allowed_packet variable, it may be worth your while having a stab at the YAML path.
Cid, I agree that K9 is great (if you have more patience than I), however MT-Blacklist is for stopping comment spam , it will have no effect on email spam.
Just use the same method that Samizdata (and myself) use: James Seng’s scode plugin
http://james.seng.cc/archives/000145.html
It forces people to type in a number displayed in a graphical image before it allows the comment, so if there are blind people using screen readers to provide them with the glory that is IMAO, they won’t be able to make comments. But on the other hand, I haven’t received any spam since applying the change. Beats MT-Blacklist all hollow.
2 possible solutions:
1)Hit “escape”
2)Hit your computer with a stick
(Why not… it works well on dogs and children)
Rauchen in der schwangerschaft schadet ihrem kind edustartpage