Max_allowed_packet error

  • Resolved alternateroute

    (@alternateroute)


    11 years, 4 months ago

    I have been getting a huge error log on my site.
    It starts with

    WordPress database error Got a packet bigger than ‘max_allowed_packet’ bytes for query UPDATE wp_options SET option_value = ‘a:8545:{i:0;s:99:\”/

    followed by lots of file names and ends with

    WHERE option_name = ‘backup-to-dropbox-processed-files’ made by do_action_ref_array, call_user_func_array, run_dropbox_backup, WP_Backup->execute, WP_Backup->backup_path, WP_Backup_Config->add_processed_files, update_option

    I have a relatively large NextGen gallery on my site (3500 images)and I am backing it up.
    It seems like by writing the names of all these files (and the thumbnails) it is exceeding the size allowed in the option table.
    (The backup is frozen at 86%)
    It there a way to stop the plugin recording the names of the files it backs up?
    I will try another backup, excluding the gallery, but longer term it would be nice to be able to do it.
    AJ

    http://wordpress.org/extend/plugins/wordpress-backup-to-dropbox/

Viewing 1 replies (of 1 total)
  • Plugin Contributor Michael De Wildt

    (@michaeldewildt)

    11 years, 4 months ago

    Gday mate,

    Yup, thats an issue. Im going to need to make some changes to fix it.

    In the mean time you could comment out line 68 of class-wp-backup.php:

    $this->config->add_processed_files($current_processed_files);

    This will stop recording the files processed and mean that if you backup falls over it will not know where to restart it.

    Cheers,
    Mikey

Viewing 1 replies (of 1 total)
  • The topic ‘Max_allowed_packet error’ is closed to new replies.