WordPress database error

  • Resolved joneiseman

    (@joneiseman)


    4 years ago

    When I enable WP_DEBUG I see the following message in the error log when I have the SG optimizer plugin enabled:
    WordPress database error Got a packet bigger than ‘max_allowed_packet’ bytes for query UPDATE wp_options SET option_value = …
    This is followed by more than 297000 options.
    When I remove the plugin this problem goes away. From what I can tell this database query should only get called when installing the plugin. But it seems to be happening all the time (maybe a hacker executing the php file?).

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Delyan Delov

    (@delyandelov)

    4 years ago

    Hi @joneiseman,

    We will be more than happy to assist you with resolving the error.

    However, in order to do that we will need the site’s URL you are experiencing the issue with as well as detailed steps on how to recreate the error on our end.

    Thread Starter joneiseman

    (@joneiseman)

    4 years ago

    Hi Delyan,

    This is no longer a problem for me since I’ve uninstalled the plugin. I just wanted to make the developers aware of the problem.

    Thanks,
    Jon

    Plugin Support Delyan Delov

    (@delyandelov)

    4 years ago

    I have tested the plugin on a fresh installation and the error was not presented.

    Most probably the wp_options table became too large which caused the query to exceed the limits on the server. This is why I requested for more information on how we can recreate the error and further investigate it.

    Thread Starter joneiseman

    (@joneiseman)

    4 years ago

    My wp_options table has 75045 entries. You would need to make sure the size of the wp_options table exceeds the maximum packet size for the mysql query command in order to reproduce the problem.

    Plugin Support Delyan Delov

    (@delyandelov)

    4 years ago

    The number of entries in wp_options table is not related rather than the size of the query. If your site exceeded the limits on the server this is not caused by our SGO plugin. Without the ability to recreate the exact error or without providing us with the full error log, I am afraid that we cannot further investigate the case. Thus, I am closing this thread as resolved.

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

The topic ‘WordPress database error’ is closed to new replies.