90k + Spammer IPs in Database causing GUI timeout (502 server error)

  • Resolved Saskia Teichmann

    (@jyria)


    2 years, 7 months ago

    Hello there!

    Thanks for this plugin!

    As described in this issue’s title, admin page is timing out resulting in a server error 502 when trying to access the “Spammer IPs”-Tab while there are 90+k IPs in the database.

    Is there a WPCLI command that allows me to trash all IPs without having to access my DB directly and use a manual SQL command, as it is not possible to load this list within admin gui…

    Thanks

    saskia

Viewing 1 replies (of 1 total)
  • Plugin Support Dinesh Karki

    (@dcsupport)

    2 years, 7 months ago

    @jyria,

    I am so sorry as we don’t have any WPCLI command to remove it. So only option here is to flush the table using SQL for phpmyadmin.

    Those IPs are recorded in TABLE_PREFIX_wpae_spammer_ip.

    Also, in future release, we are thinking to add auto deletion of IPs that are X no of days old.

    Thanks

Viewing 1 replies (of 1 total)

The topic ‘90k + Spammer IPs in Database causing GUI timeout (502 server error)’ is closed to new replies.