Title: A database operation failed
Last modified: August 20, 2016

---

# A database operation failed

 *  [Dave](https://wordpress.org/support/users/crazybikerdave/)
 * (@crazybikerdave)
 * [14 years, 9 months ago](https://wordpress.org/support/topic/a-database-operation-failed/)
 * 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](https://wordpress.org/support/users/driskell/)
 * (@driskell)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/a-database-operation-failed/#post-2274860)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/wponlinebackup_7192a1.svg)
 * [Online Backup for WordPress](https://wordpress.org/plugins/wponlinebackup/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wponlinebackup/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wponlinebackup/)
 * [Active Topics](https://wordpress.org/support/plugin/wponlinebackup/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wponlinebackup/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wponlinebackup/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Online Backup](https://wordpress.org/support/users/driskell/)
 * Last activity: [14 years, 8 months ago](https://wordpress.org/support/topic/a-database-operation-failed/#post-2274860)
 * Status: not resolved