A database operation failed

  • Dave

    (@crazybikerdave)


    12 years, 7 months 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!

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

    (@driskell)

    12 years, 7 months 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.

Viewing 1 replies (of 1 total)
  • The topic ‘A database operation failed’ is closed to new replies.