[drupal-devel] *Begging* for checkbox to moderation pages
To understand why I'm asking this you have too see this picture: http://www.cesspit.net/misc/spam.gif Now all that is *already* in the moderation queue, so it's not published. But I absolutely need a way to delete all that crap. It spans various pages and it would take me HOURS to delete each message one by one. Please, can someone build a small patch to apply to Drupal 4.5.2 that adds checkboxes to each comment so that I can wipe all that with one action? Who I have to pay for that? -HRose / Abalieno
On Friday 25 February 2005 06:54, Abalieno wrote:
To understand why I'm asking this you have too see this picture: http://www.cesspit.net/misc/spam.gif
Now all that is *already* in the moderation queue, so it's not published. But I absolutely need a way to delete all that crap. It spans various pages and it would take me HOURS to delete each message one by one.
Please, can someone build a small patch to apply to Drupal 4.5.2 that adds checkboxes to each comment so that I can wipe all that with one action?
Don't you have the spam module installed? It would auto-block all of that after you told it the first one was spam: http://drupal.org/node/11104/release HTH Richard.
On Fri, 25 Feb 2005 09:22:49 +0100, Richard Bennett <richard.b@gritechnologies.com> wrote:
On Friday 25 February 2005 06:54, Abalieno wrote:
To understand why I'm asking this you have too see this picture: http://www.cesspit.net/misc/spam.gif
Now all that is *already* in the moderation queue, so it's not published. But I absolutely need a way to delete all that crap. It spans various pages and it would take me HOURS to delete each message one by one.
Please, can someone build a small patch to apply to Drupal 4.5.2 that adds checkboxes to each comment so that I can wipe all that with one action?
Don't you have the spam module installed? It would auto-block all of that after you told it the first one was spam: http://drupal.org/node/11104/release
And there's an optional patch included with the module to allow mass comment changes (deletion, marking as spam, etc). -- Tim Altman
So I tried to install the module and I saw also the patch that will allow me to mass delete all that. But while running the SQL query in phpmyadmin I got the following error: Error SQL-query : CREATE TABLE spam_comments( cid int( 10 ) unsigned default '0', rating int( 2 ) unsigned default '0', spam tinyint( 1 ) unsigned default '0', last int( 11 ) unsigned default '0', PRIMARY KEY cid( cid ) , KEY rating( rating ) , KEY spam( spam ) , KEY last( last ) ) TYPE = MYISAM MySQL said: #1171 - All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead How can I fix this so that I'm able to move forward?
try adding 'NOT NULL' on the end of this line: cid int( 10 ) unsigned default '0', like this: cid int( 10 ) unsigned default '0' NOT NULL, Abalieno wrote:
So I tried to install the module and I saw also the patch that will allow me to mass delete all that.
But while running the SQL query in phpmyadmin I got the following error:
Error SQL-query : CREATE TABLE spam_comments( cid int( 10 ) unsigned default '0', rating int( 2 ) unsigned default '0', spam tinyint( 1 ) unsigned default '0', last int( 11 ) unsigned default '0', PRIMARY KEY cid( cid ) , KEY rating( rating ) , KEY spam( spam ) , KEY last( last ) ) TYPE = MYISAM MySQL said:
#1171 - All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead
How can I fix this so that I'm able to move forward?
try adding 'NOT NULL' on the end of this line: cid int( 10 ) unsigned default '0', like this: cid int( 10 ) unsigned default '0' NOT NULL,
It worked perfectly, the situation is again under control :) That patch that adds the checkboxes should be integrated in the default installation. It's too nice to not show it to everyone. Thanks again. -HRose / Abalieno
On 2005-02-25 12:06 +0100, Abalieno wrote:
That patch that adds the checkboxes should be integrated in the default installation. It's too nice to not show it to everyone.
+1 on that from me. -- Michael Rowe <mrowe@mojain.com> http://www.mojain.com/ http://www.therowes.id.au/
Hi, Please try to keep support request on the support list. This will make future search much easier, and also others who need support will be able to find it there! Devel should really be limited to development issues. Bèr Op vrijdag 25 februari 2005 12:06, schreef Abalieno:
try adding 'NOT NULL' on the end of this line: cid int( 10 ) unsigned default '0', like this: cid int( 10 ) unsigned default '0' NOT NULL,
It worked perfectly, the situation is again under control :) That patch that adds the checkboxes should be integrated in the default installation. It's too nice to not show it to everyone.
Thanks again.
-HRose / Abalieno Regards, Bèr -- [ Bèr Kessels | Drupal services www.webschuur.com ]
Don't you have the spam module installed? It would auto-block all of that after you told it the first one was spam: http://drupal.org/node/11104/release
I didn't install it because I've quickly read the description and it sounds like it just "unpublish" what it consider spam. The point is that on my site the anonymous comments already are in the moderation queue, so they already are unpublished. My problem is about physically remove them. Anyway, I'll give it a look... (btw, I have eight pages of spam now) -HRose / Abalieno
On Fri, 25 Feb 2005 10:46:23 +0100 "Abalieno" <abalieno@cesspit.net> wrote:
I didn't install it because I've quickly read the description and it sounds like it just "unpublish" what it consider spam.
I have very recently added an option to the spam module that allows you to configure a custom filter that auto-deletes spam on receipt. For example, I have a regex defined that when matched simply deletes the spam without even telling me: /online poker/i Looking at your screenshot, you may benefit from a similar filter... ;) Cheers, -Jeremy
participants (7)
-
Abalieno -
Bèr Kessels -
Jeremy Andrews -
Michael Rowe -
Richard Bennett -
Ross Kendall -
Tim Altman