Online Backup for WordPress
The Backup Failed: A Database Operation Failed (2 posts)

  1. pleatedjeans
    Posted 4 years 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 = '?-500x198.png'


  2. Online Backup
    Plugin Author

    Posted 4 years ago #

    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.


Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic