On attempting to add the latest spam infestation to the blacklist I got this message:
An error occurred:
Could not save your blacklist data: Got a packet bigger than 'max_allowed_packet'
What next?
Gudday,
This a repeat of the problem described on the 8th July. Basically mysql is complaining that the list is too long.
If you're getting a dump of spam (as per the last few days) and the list is full open mt-blacklist.cgi and select the list option from the menu buttons at the top of the page. (The despam email will open mt-blacklist.cgi in order to do the necessary.)
Then you can delete a couple of unlikely-looking entries and add something which will block the current deluge.
One point about adding entries, add as wide a pattern as you can without getting everything. So, for example, to block all thing.furniture 10.com variants, you'd put furniture 10.com. One word of warning, mt-blacklist interprets a "." as 'any character'. To make mt-blacklist understand you really mean a ".", you need to escape the ".". This means you write it with a backslash in front of it (that is, furniture 10\.com).
Note: I added spaces to the urls above because mt-blacklist was blocking my comment .
Posted by: .carla at August 11, 2006 11:32 AM