Error [Got a packet bigger than ‘max_allowed_packet’ bytes]

  • Resolved markmende

    (@markmende)


    6 years, 1 month ago

    Hello,

    when i want to change the article number or something else i get this error:

    WordPress-Datenbank-Fehler: [Got a packet bigger than ‘max_allowed_packet’ bytes]
    UPDATE 7qQ5HBY8_options SET option_value = ‘a:6093:{i:1544533275;a:3:{s:34:\”wp_privacy_delete_old_export_files\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:6:\”hourly\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:3600;}}s:16:\”wp_version_check\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}s:17:\”wp_update_plugins\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}}i:1544533276;a:1:{s:16:\”wp_update_themes\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}}i:1544533330;a:2:{s:19:\”wp_scheduled_delete\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:5:\”daily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:86400;}}s:25:\”delete_expired_transients\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:5:\”daily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:86400;}}}i:1544533893;a:1:{s:26:\”action_scheduler_run_queue\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:12:\”every_minute\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:60;}}}i:1544534039;a:1:{s:25:\”delete_version_transients\”;a:1:{s:32:\”5e9adeb07122ca8970f12a74b4047f18\”;a:2:{s:8:\”schedule\”;b:0;s:4:\”args\”;a:1:{i:0;s:10:\”1544534009\”;}}}}i:1544534393;a:1:{s:30:\”wp_1_wc_regenerate_images_cron\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:39:\”wp_1_wc_regenerate_images_cron_interval\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:300;}}}i:1544534688;a:1:{s:28:\”elementor/tracker/send_event\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:5:\”daily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:86400;}}}i:1544535821;a:1:{s:25:\”delete_version_transients\”;a:1:{s:32:\”38686481877b16c87cdb1ec412698ce2\”;a:2:{s:8:\”schedule\”;b:0;s:4:\”args\”;a:1:{i:0;s:10:\”1544535791\”;}}}}i:1544535928;a:1:{s:25:\”delete_version_transients\”;a:1:{s:32:\”9bc024133246be99bc997746a3ba648f\”;a:2:{s:8:\”schedule\”;b:0;s:4:\”args\”;a:1:{i:0;s:10:\”1544535898\”;}}}}i:1544535929;a:1:{s:25:\”delete_version_transients\”;a:1:{s:32:\”59bc48d92fc5561f8ee8c698eec92430\”;a:2:{s:8:\”schedule\”;b:0;s:4:\”args\”;a:1:{i:0;s:10:\”1544535899\”;}}}}i:1544535935;a:1:{s:25:\”delete_version_transients\”;a:1:{s:32:\”aedadc66fbcae2aff49a510962bdc0ef\”;a:2:{s:8:\”schedule\”;b:0;s:4:\”args\”;a:1:{i:0;s:10:\”1544535905\”;}}}}i:1544535937;a:1:{s:25:\”delete_version_transients\”;a:1:{s:32:\”6508279235f24221ed904d4de0467d77\”;a:2:{s:8:\”schedule\”;b:0;s:4:\”args\”;a:1:{i:0;s:10:\”1544535907\”;}}}}i:1544535944;a:1:

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author pimwick

    (@pimwick)

    This looks like a server configuration issue where it isn’t allowing a large enough database connection. You need to contact your website host and ask them to increase the ‘max_allowed_packet’ configuration option.

    The exact error message you are showing appears to be something attempting to store a large amount of session / transient data into the options table but it fails because of the limit. Our plugin doesn’t make this type of insert so unfortunately I can’t help much further with this error.

    Plugin Author pimwick

    (@pimwick)

    Marking this thread as resolved. If you need further assistance just reply here.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Error [Got a packet bigger than ‘max_allowed_packet’ bytes]’ is closed to new replies.