Posted on: 07/07/06 11:22pm
By: winnerdk
I had more than 5,000 submissions (all spam) today. Spamx isn't working with GL1.4 When I try to access the admin section to clear them out I get a 30-second timout.
What's the best way to:
1. Clear out all the spam
2. Keep it from happening again
spamx for 1.4 ?
Posted on: 07/08/06 03:23am
By: Dirk
[QUOTE BY= winnerdk] Spamx isn't working with GL1.4 [/QUOTE]
Of course it is.
What sort of submissions are we talking about? Comments, stories, events, ...? Do you have the keywords in your blacklist?
bye, Dirk
spamx for 1.4 ?
Posted on: 07/08/06 05:59pm
By: winnerdk
There were more than 5,000 submissions last night, and now there are more than 14,000. I can't access the admin section to see what they are (articles, comments, links) or to set the blacklist words...
spamx for 1.4 ?
Posted on: 07/08/06 06:11pm
By: Dirk
Hmm. It shouldn't really timeout there ...
Anyway, check the database directly (using phpMyAdmin for example). See what's in your submission tables (gl_eventsubmission, gl_linksubmission, gl_storysubmission). You can clear out those tables if you want (i.e. delete their content, not the tables themselves) - you would only risk losing any legit submissions buried between the spam.
bye, Dirk
spamx for 1.4 ?
Posted on: 07/08/06 08:08pm
By: winnerdk
Thanks Dirk. I retuncated the gl_eventsubmission table with phpMyAdmin and by the time I could get back to the homepage to see if it worked there were three more. It's all spam from casino and gambling sites. Now that I know how to clear them out (thanks) what's the best way to shut this type of activity down? Blacklist keywords?
spamx for 1.4 ?
Posted on: 07/09/06 03:21am
By: Dirk
Yep, blacklist the usual keywords.
You could also switch on the email notifications for spam postings. The emails contain the HTTP header of the spam submission which may provide additional information to feed for the filters (e.g. IP addresses, user agents).
Since you seem to get a lot of those, you could also try out one of the more
experimental Spam-X modules[*1] .
bye, Dirk
spamx for 1.4 ?
Posted on: 07/09/06 10:16am
By: Dirk
Sorry about the blocking. You better not use the C word here on the site
bye, Dirk
spamx for 1.4 ?
Posted on: 07/10/06 10:20am
By: winnerdk
Ok. I'll just call them Ka zee no's or something . Anyway, I now have the site running 1.4.0sr4 but I still can't get spam-x to work. When I try to get into it from the admin panel I'm getting an error message saying there's an "SQL" error and to check the log, but when I do it's not showing up as far as I can tell... So I still can't get into spam-x, but at least now it installed.
spamx for 1.4 ?
Posted on: 07/10/06 02:08pm
By: Dirk
Without the actual SQL error message, it's impossible to say what's happening. Make sure your error.log is writable.
bye, Dirk
spamx for 1.4 ?
Posted on: 08/14/06 08:59am
By: winnerdk
OK, I got the error log working, and the error I got was "Mon 14 Aug 2006 08:48:09 EDT - 1146: Table 'panamax_geeklog.gl_spamx' doesn't exist. SQL in question: SELECT COUNT(*) FROM gl_spamx WHERE name = 'MTBlacklist' "
This error was also causing me problems with the site statistics, and when I disabled spamx then the stats came back on.
spamx for 1.4 ?
Posted on: 08/14/06 02:13pm
By: Dirk
How did you manage to delete the gl_spamx table but keep the plugin intact? Since that's what is happening: It's trying to access the Spam-X plugin's table - which is not there. But it wouldn't do that if the plugin would have been uninstalled properly ...
Suggestion: Create the table again (see sql/mysqltableandata.php for the table structure) manually. But it would be empty then, i.e. you seem to have lost all your blacklist entries. A database backup would come in handy about now.
bye, Dirk
spamx for 1.4 ?
Posted on: 08/14/06 05:12pm
By: winnerdk
Actually, I'm not convinced that I ever managed to get a correctly functioning spamx install. I've created the table (thanks...) and now spamx seems to be working. I'm also not getting the error when I ask for the stats anymore. But my problem (and question) is just migrating downstream. I still have a bunch of old comments in the database that are spam. What's the best way to re-populate the blacklist and clean house?
spamx for 1.4 ?
Posted on: 08/14/06 05:24pm
By: Dirk
Feed URLs and spammy keywords that you find in those comments into the personal blacklist, then use the Mass Delete Comment option to get rid of those comments.
bye, Dirk
spamx for 1.4 ?
Posted on: 08/14/06 06:10pm
By: Chrispcritters
Does Spam-X work with forum posts?
spamx for 1.4 ?
Posted on: 08/15/06 01:58am
By: Dirk
[QUOTE BY= Chrispcritters] Does Spam-X work with forum posts?[/QUOTE]
Actually, the question should read "does the forum use Spam-X"
Yes, it does. At least the current version - not sure when exactly Blaine added it.
bye, Dirk
spamx for 1.4 ?
Posted on: 08/15/06 08:38am
By: winnerdk
Sooner or later I'm going to get this thing working.
Now, when I try to add words to the personal blacklist, I get the following error in the log:
"Tue 15 Aug 2006 08:32:37 EDT - 1062: Duplicate entry 'Personal' for key 1. SQL in question: INSERT INTO gl_spamx VALUES ("Personal","kkkkk")"
I put "kkkkk" where the word I'm trying to blacklist appeared to get past your filters.
What's going on now?
spamx for 1.4 ?
Posted on: 08/15/06 09:39am
By: Laugh
Sounds like you have a primary key specified for the name field. There should be no primary keys just one index called spamx_name on the name column.
I would suggest maybe uninstalling and reinstalling spam-x if you are having these problems.