aiowps_captcha autoload options quite crush our website

  • Resolved vimana

    (@vimana)


    2 years, 7 months ago

    After the last update the plugin started creating hundreds of thousands of rows in the options table with autoload like “yes” which almost made our website crash. Pages load times have grown more than tenfold and memory and resource usage has grown considerably. After deleting all the rows of the options table like “aiowps_captcha_string_info%” the values ??are back to normal. Now I have enabled google recaptcha and no more rows are created in the options table. But even with chapta disabled everywhere, if the “Google rechapta” option is disabled, these deleterious rows start to be inserted again in the wordpress options table.

    I post some images can explain better:

    Our server/database memory usage and speed
    WP options table rows

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support vupdraft

    (@vupdraft)

    Hi,

    Each of these paired entries represent a failed captcha login attempt. This means that your site is likely to be under some kind of brute force attack. I would recommend you activate some of the the other features under “Brute force”

    Thread Starter vimana

    (@vimana)

    I have all ready activated other features under “brute force”… We had a lot attack in the past and many blocked ip and never had problem. This a bug of the plugin not an attack. Since last updated of the plugin 9th April (you can see in the fist image i posted) “All In One WP Security & Firewall” start to create more than 100000 rows in our wp_options table whit autolad like “yes” that mean those options are loaded in every page load of the website with no sense. Bevfore there was only 500-600 rows whit autoload like “yes”. Can you explain me the sense to autoload 100000 options of captcha_string_info….

    • This reply was modified 2 years, 7 months ago by vimana.
    Plugin Author David Anderson

    (@davidanderson)

    @vimana I will report this to our developers.

    @vupdraft It’s the “autoload” part that’s the problem.

    Please am going through the same issue, aiowps created hundreds of thousands of rows in the options table with autoload, loading time is really up,

    Please how can I delete all this aiowps_captcha_string rows

    Kindly help

    @vimana please how did you delete all the rows

    Thread Starter vimana

    (@vimana)

    Backup your options table and than you have to execute the following SQL query:

    DELETE FROM yourtableprefix_options WHERE option_name LIKE “%aiowps_captcha_string%”

    where yourtableprefix = Your table prefix

    here a screenshot of
    phpMyAdmin (it’s in Italian Language buy I think it’s understandable)

    • This reply was modified 2 years, 5 months ago by vimana.

    Is there any resolution from the plugin developers to this or is going in and removing the entries the only remedy at this time?

    • This reply was modified 2 years, 3 months ago by andy_woz.
Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘aiowps_captcha autoload options quite crush our website’ is closed to new replies.