7.4.1 update generates DB errors and crash sites

  • Resolved ant0nell0

    (@ant0nell0)


    5 years, 4 months ago

    Latest update hangs the website due a DB error. Here is the log. Very sad about it… I’ve to disable this important plugin. Is any plug-in’s developer than can handle this issue. Here is the log:

    [07-Nov-2019 01:01:06 UTC] WordPress errore sul database Server shutdown in progress per la query SELECT *, CASE
    WHEN type = 3 THEN 0
    WHEN type = 4 THEN 1
    WHEN type = 7 THEN 2
    WHEN type = 6 THEN 3
    WHEN type = 5 THEN 4
    WHEN type = 9 THEN 5
    WHEN type = 8 THEN 6
    WHEN type = 2 THEN 7
    WHEN type = 1 THEN 8
    ELSE 9999
    END AS typeSort, CASE
    WHEN type = 3 THEN parameters
    WHEN type = 4 THEN parameters
    WHEN type = 1 THEN IP
    WHEN type = 9 THEN IP
    WHEN type = 5 THEN IP
    WHEN type = 6 THEN IP
    WHEN type = 7 THEN IP
    WHEN type = 2 THEN IP
    WHEN type = 8 THEN IP
    ELSE 9999
    END AS detailSort
    FROM wp_wfBlocks7 WHERE type IN (4) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC fatta da wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::patternBlocks, wfBlock::allBlocks
    [07-Nov-2019 01:01:06 UTC] PHP Warning: Error while sending QUERY packet. PID=592 in /srv/data/web/vhosts/www.angolodeldiabetico.it/htdocs/wp-includes/wp-db.php on line 1924

Viewing 5 replies - 1 through 5 (of 5 total)

  • Hey @ant0nell0,

    I’m sorry to hear that you’ve run into this.

    This sounds like a WordPress plugin update that didn’t go well. Can you please try reinstalling Wordfence and let me know if it helps?

    https://www.wordfence.com/help/advanced/remove-or-reset/

    Please let me know how it goes.

    Thanks,

    Gerroald

    Thread Starter ant0nell0

    (@ant0nell0)

    Dear @wfgerald , I’ve just installed the plugin again with no success. We’re talking of a production site so I don’t want to reset the settings. Can you help me? I’m @ you disposal to share logs and configs. Best,
    Antonello

    Hey @ant0nell0,

    Can you send me a Diagnostics report so I can get a better overview of your environment? Please navigate to Wordfence > Tools > Diagnostics. Here you can select SEND REPORT BY EMAIL. Please include your www.remarpro.com username and update this thread after you’ve sent it.

    Thanks,

    Gerroald

    Thread Starter ant0nell0

    (@ant0nell0)

    I was able to solve deleting one by one the DB keys, saving the setting as well. Thanks for your support anyway. I agree with you… something related to my DB goes wrong.

    Hey @ant0nell0,

    Thanks for the update, and happy to hear you were able to sort this out. Would you mind sharing which keys you removed? It may help others in the future.

    Please let me know.

    Thanks,

    Gerroald

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘7.4.1 update generates DB errors and crash sites’ is closed to new replies.