Fatal Error – got packet bigger than max_allowed_packets

  • Resolved glowbright77

    (@glowbright77)


    2 years, 8 months ago

    Hi, unfortunately I have the following problem when installing the plugin “Security Ninja”.

    It causes a fatal error, the installation is aborted.

    Message: WordPress database error: [Got a packet bigger than ‘max_allowed_packets’ bytes].

    This is an installation on localhost. XAMPP has never had problems with any plugins here and it seems strange to me that the default settings should not be sufficient.

    settings now in the my.cnf:
    [mysqldump]
    max_allowed_packet=16M

    the zip-file of the plugin security-ninja: 2.9MB
    first i tired to install it with the wordpress-dashboard plugin manager. then i downloaded it from the official site.

    Unfortunately, I am a beginner and don’t really know where I stand here.

    Here is a Part of the very very very long Error-Log:

    [has been deleted by moderator] – and i am not able to paste the GIANT content of the debug.log on pastebin.com, like the moderator told me to do. it doesnt work. i made a screenshot, but…i can not post it here. hmpf…

    here is what pastebin.com told me:

    Pastebin’s SMART filters have detected potentially offensive or questionable content in your paste.
    The content you are trying to publish has been deemed potentially offensive or questionable by our filters, because of this you’re receiving this warning.
    This paste can only be published with the visibility set to “Private”.

    my debug.log has a size of 356MB!!!! i tried to open it with visual studio code – in trusted mode. i am really scared now.

    can anybody tell me whats going on here, please?

Viewing 1 replies (of 1 total)
  • Plugin Author Lars Koudal

    (@lkoudal)

    Hello – We are sorry to hear you have this issue. Googling the error message seems to indicate it is an error related to MySQL server configuration, “MySQL Error 1153”.

    Sorry, we cannot help you configure MySQL for WordPress use. This particular error has not occurred in our testing before.

    Your debug.log file is indeed very large. The easiest way to reset that is to simply delete the debug.log file (take a backup first) – and then try accessing your local WP site again, there should now be new data in the file.

    Debug.log logs everything going on, and if you cannot install the plugin it seems the 356MB is coming from somewhere else, indicating some other error.

    “potentially offensive or questionable content” <- not sure what that would be, this is a message from pastebin.com.

    Our best guess? You have a configuration issue on your localhost, in particular the MySQL server. There might be other issues on your local installation, but we cannot provide general WP installation support.

    If you are able to gain specific information/bugs from the debug.log file that refers to a bug in Security Ninja, please let us know and we will do our best to fix that.

Viewing 1 replies (of 1 total)
  • The topic ‘Fatal Error – got packet bigger than max_allowed_packets’ is closed to new replies.