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

  • pleatedjeans


    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/
    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’

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


    Hi pleatedjeans,

    Take a look at the following topic:

    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.


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.