Apache errors, long after removal of plugin

  • Resolved benizioni

    (@benizioni)


    1 week ago

    HI,

    I’ve started to see Apache errors on my server which seems to relate to a database table created by this plugin, despite it being deativated and removed a while ago.

    Here are the error details…

    AH01071: Got error ‘PHP message: WordPress database error Got a packet bigger than ‘max_allowed_packet’ bytes for query UPDATE wp_options SET option_value = ‘a:4:{s:17:\\”starting_point_kb\\”;d:2108.603515625;s:18:\\”starting_point_num\\”;s:4:\\”2350\\”;s:19:\\”starting_point_date\\”;s:19:\\”2025-12-18 14:29:35\\”;s:12:\\”used_options\\”;a:272140:{s:37:\\”wc_feature_woocommerce_brands_enabled\\”;i:40482149;s:15:\\”timezone_string\\”;i:266912522;s:10:\\”gmt_offset\\”;i:93842333;s:16:\\”option_optimizer\\”;i:1343410;s:14:\\”active_plugins\\”;i:19800203;s:10:\\”w3tc_state\\”;i:1344004;s:52:\\”_transient_jetpack_connection_active_plugins_refresh\\”;i:1231915;s:44:\\”_site_transient_timeout_t15s-registry-gforms\\”;i:502;s:36:\\”_site_transient_t15s-registry-gforms\\”;i:1346;s:9:\\”hack_file\\”;i:3395;s:18:\\”recently_activated\\”;i:245;s:7:\\”siteurl\\”;i:171247544;s:26:\\”wc_pending_batch_processes\\”;i:11;s:25:\\”woocommerce_admin_notices\\”;i:1231898;s:4:\\”cron\\”;i:19777592;s:45:\\”_transient_timeout_code_snippets_welcome_data\\”;i:199969;s:37:\\”_transient_code_sn…’

    When I investigated this, it seems like something is trying to update the database field ‘wp_options’ with the name ‘option_optimizer’, which I believe is an entry created and used by this plugin.

    This is happening multiple times per minute and is quite concerning.

    Do you please have any advice to stop this happening?

    Regards,
    Craig.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Filip Ilić

    (@filipi)

    6 days, 11 hours ago

    Hi,

    Thanks for the detailed report — that helped a lot.

    Since the plugin was deactivated it is certainly not running, what’s left behind is a single leftover row of data in your database that the plugin created back when it was still active. That row should be removed when the plugin was uninstalled (deactivated and deleted from Plugins screen), but since it is still present it looks like that the plugin was removed in some other way (maybe using FTP?).

    Without more details I can’t be sure, but looks like something on your site is still trying to save it over and over – which is what’s filling your error log.The fix is to delete that leftover row. Once it’s gone, there’s nothing left to save and the errors stop.

    The easiest way would be to install and activate plugin again, then deactivate and delete it from the Plugins screen.

    Alternatively you can use PHPMyAdmin to delete the row with (if the site uses a different table prefix than wp_, adjust accordingly.):
    DELETE FROM wp_options WHERE option_name = 'option_optimizer';

    If the errors somehow continue after doing this, let us know and I will take another look.

    Best,
    Filip

    • This reply was modified 6 days, 11 hours ago by Filip Ilić.
    Thread Starter benizioni

    (@benizioni)

    6 days, 6 hours ago

    Thank you, this worked!

    Thanks again,
    Craig,

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

You must be logged in to reply to this topic.