[Plugin: Online Backup for WordPress] The Backup Failed: A Database Operation Failed

  • pleatedjeans

    (@pleatedjeans)


    12 years, 7 months ago

    Hi, just installed this plugin as my previous backup plugin was not working. I keep getting a failure message when I try a manual backup. I tried reinstalling the plugin. Here is the full event log, any help would be greatly appreciated.

    A database operation failed.
    Please try reinstalling the plugin – in most cases this will repair the database.
    Please contact support if the issue persists, providing the complete event log for the activity. Error information follows:
    Location: 862:/nfs/c08/h02/mnt/115300/domains/pleated-jeans.com/html/wp-content/plugins/wponlinebackup/include/files.php
    Message: WPDB error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘=’. Last query: UPDATE wp_pleatedjeans_wponlinebackup_items SET new_file_size = 131778, new_mod_time = 1310572622, backup = IF(exists IS NULL OR file_size != new_file_size OR mod_time != new_mod_time, 1, 0) WHERE bin = 2 AND parent_id = 18880 AND type = 1 AND name = ‘?-500×198.png’

    http://wordpress.org/extend/plugins/wponlinebackup/

Viewing 1 replies (of 1 total)
  • Plugin Author Online Backup

    (@driskell)

    12 years, 7 months ago

    Hi pleatedjeans,

    Take a look at the following topic:
    http://wordpress.org/support/topic/backup-only-partially-working?replies=5

    Basically you need to login to phpMyAdmin and change the collation of the wp_pleatedjeans_wponlinebackup_items table to utf8_general_ci, and also change the collation of a couple of columns.

    The next version of the plugin will automatically do this patching to stop further issues. It’s all down the fact the filename has a non-english character in it and because the database wasn’t created with UTF-8 it doesn’t like it!

    Hope this helps.

    Jason.

Viewing 1 replies (of 1 total)
  • The topic ‘[Plugin: Online Backup for WordPress] The Backup Failed: A Database Operation Failed’ is closed to new replies.