Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By tesol on
Hi, my user/registration is getting hammered by spammers and I am trying to use the dr_watchdog table in phpMyAdmin to find out the worst offenders.
The question I have is this; which setting within the table is best for finding out the worst spammers: Primary descending, Type descending, UID descending, or Severity descending?
(I assume descending is based on the latest timestamp?)
If you know which is best, can you tell me why it is the best?
Thanks
Comments
It may be easier to work from
It may be easier to work from the Drupal interface under reports, but either way I would filter the type by 'user' (or it may be 'users') and look for entries that mention registration. (The question of descending is field specific, most (all) sql field types can be sort ascending or descending)