WordPress.org

Ready to get started?Download WordPress

Forums

Online Backup for WordPress
A database operation failed (2 posts)

  1. Crazybikerdave
    Member
    Posted 2 years ago #

    Hello there,

    I'm looking for some assitance. I can't seem to figure out why online backup is not working. Here's my error log:

    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: /mnt/stor10-wc2-dfw1/569360/602396/www.tsquarehealth.com/web/content/tsh/wp-content/plugins/wponlinebackup/include/transmission.php:205
    Message: WPDB error: Table '602396_wp_1956_0tsq.wp42TlEvt_wponlinebackup_items' doesn't exist. Last query: DELETE FROM <code>wp42TlEvt_wponlinebackup_items</code> LIMIT 500

    I've already re-installed the plugin several different times, so I'm hoping someone can point me in the right direction.

    Thanks!

  2. Online Backup
    Member
    Plugin Author

    Posted 2 years ago #

    Hi crazybikerdave,

    Try running this in phpMyAdmin. We found an issue with the plugin when the MySQL server is configured for InnoDB by default.

    CREATE TABLE `wp_wponlinebackup_items` (
    `bin` INT(10) UNSIGNED NOT NULL,
    `item_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `parent_id` INT(10) UNSIGNED NOT NULL,
    `type` SMALLINT(1) UNSIGNED NOT NULL,
    `name` VARCHAR(255) NOT NULL,
    `exists` SMALLINT(1) UNSIGNED DEFAULT NULL,
    `file_size` INT(10) UNSIGNED DEFAULT NULL,
    `mod_time` INT(10) UNSIGNED DEFAULT NULL,
    `backup` SMALLINT(1) UNSIGNED DEFAULT NULL,
    `new_exists` SMALLINT(1) UNSIGNED DEFAULT NULL,
    `new_file_size` INT(10) UNSIGNED DEFAULT NULL,
    `new_mod_time` INT(10) UNSIGNED DEFAULT NULL,
    `activity_id` INT(10) UNSIGNED NOT NULL,
    `counter` INT(10) UNSIGNED NOT NULL,
    `path` TEXT NOT NULL,
    PRIMARY KEY (`bin`, `item_id`),
    UNIQUE `item` (`bin`, `parent_id`, `type`, `name`),
    INDEX `browse` (`bin`, `parent_id`, `exists`, `type`, `name`),
    INDEX `activity_id` (`activity_id`, `backup`, `bin`, `item_id`),
    INDEX `exists` (`bin`, `exists`, `activity_id`)
    ) ENGINE=MyISAM;

    This should create the missing table.

    Jason.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic