Drupal + Drush: Delete 100k unpublished Spam Comments

Problem:

100.000 unpublished Spam Comments.

Solution

#drush php:eval '
$storage = \Drupal::entityTypeManager()->getStorage("comment");

do {
  $ids = \Drupal::entityQuery("comment")
    ->accessCheck(FALSE)
    ->condition("status", \Drupal\comment\CommentInterface::NOT_PUBLISHED)
    ->range(0, 100)
    ->execute();
                           
  if ($ids && rand(1,9999) < 2) {
    $storage->delete($storage->loadMultiple($ids));
    print "Comments deleted: " . count($ids) . PHP_EOL;
  }
} while ($ids);
'

 

 

Drupal
drush

Neuen Kommentar schreiben

Hilfe zum Textformat
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.

Suche

Neueste Kommentare

  • Short Code w. Radio Buttons, Checkbox, Textarea, Email, Phone

    1 month 2 weeks ago
    Formulare: alle Text Felder mit Test / Demo Daten füllen (mit JQuery)
    $("input[type='radio']").each(function () {

  • Wildcard

    4 months 3 weeks ago
    How to Renew Let’s Encrypt SSL Certificate on Plesk via Ubuntu Shell

    Let’s Encrypt will only accept a wildcard via DNS challenge. 

    If your Plesk instance can’t create the _acme-challenge.example.com TXT (external DNS), the extension can’t complete validation and will show no success. 

  • Same problem

    5 months ago
    Warning: Undefined array key "url" in Drupal\Core\Asset\CssCollectionOptimizerLazy->optimizeGroup() 
    Warning: Undefined array key "url" in Drupal\Core\Asset\JsCollectionOptimizerLazy->optimizeGroup()

  • set-timezone Europe/Berlin

    5 months ago
    Server install & config : Debian 12 + Plesk + Apache + nginx + MariaDB + Solr
    sudo timedatectl set-timezone Europe/Berlin

  • Try this:1. Go to  Tools &…

    5 months 1 week ago
    Warning: PHP Startup: Unable to load dynamic library 'apcu.so' ... cannot open shared object file: No such file or directory

    Try this:

  • Alternative (without warnings like "no crontab for user")

    5 months 3 weeks ago
    List Cronjobs for all users (via for + crontab)

    Alternative (without warnings like "no crontab for dovecot") to see all tasks:

  • php 8.3 apcu

    5 months 3 weeks ago
    Install APCu (PHP 8.1, Plesk)

    php 8.3 apcu failed

    über Plesk hat es geklappt.

     

  • phpize failed error?

    5 months 3 weeks ago
    Install APCu (PHP 8.1, Plesk)

     

    install:

    # sudo apt install php-dev

  • phpize
    # sudo apt install…

    5 months 3 weeks ago
    pecl install apcu : phpize: not found / ERROR: `phpize' failed

    phpize

    # sudo apt install php-dev

     

    details

  • Problem:
    /opt/plesk/php/8.3…

    5 months 3 weeks ago
    Install APCu (PHP 8.1, Plesk)

    Problem: