WordPress.org

Ready to get started?Download WordPress

Forums

Online Backup for WordPress
[resolved] Error database operation failed (6 posts)

  1. mrsbeata
    Member
    Posted 1 year ago #

    I got a problem backing up. I have followed the instructions, and I have reinstalled the plugin but still I get the same message. I have a different site, a test site, where I get the exact same issue.

    I'm trying to upgrade to the latest version of WordPress but I can't do it until I have a proper backup.

    Below is the error message.

    ********************

    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. Diagnostic information follows:

    Failed at: 1173(/storage/content/71/143371/frontwalker.biz/public_html/wp-content/plugins/wponlinebackup/include/files.php)
    WPDB error: An entry for a file was inserted into the database but couldn't be found afterwards!
    Hexdump of the file name is: 53756e647376616c6c7367c3a46e6765742d313530783135302e6a7067
    When escaped for insertion: 53756e647376616c6c7367c33f6e6765742d313530783135302e6a7067 (Sundsvallsg

    http://wordpress.org/extend/plugins/wponlinebackup/

  2. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Hi mrsbeata,

    Sincere apologies for the issue. We were battling some issues with UTF-8 encoded files as they weren't backing up properly. Recent updates improved it drastically but created some instances where the backup would completely fail (where before it would work or silently skip the file.)

    Using the error message you gave we've reproduced it for your filename exactly. And we've fixed it.

    It's going through testing at the moment, more stringent than before as we now have test cases to ensure no regressions. Hopefully we'll have the fix released by the end of today.

    Again, apologies for any inconvenience.

    Kind Regards,

    Jason

  3. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    The fix is scheduled to be released tomorrow morning.

    There is some maintenance happening on the server at the moment also which hadn't completed properly on Friday. Should be all back up and running by 8PM I believe.

    I'll post again when the fix is released.

    Jason.

  4. emcyze
    Member
    Posted 1 year ago #

    Hello Driskell,

    i'm facing the same issue on several instances of WP for which i have updated the plugin.

    Thank you for your upcoming fix.

    ++

    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. Diagnostic information follows:

    Failed at: 1173(/html/wp-content/plugins/wponlinebackup/include/files.php)
    WPDB error: An entry for a file was inserted into the database but couldn't be found afterwards!
    Hexdump of the file name is: 7468c3a92d676c6163c3a92d636f66667265742d7468c3a92d626f782d37357837352e6a7067
    When escaped for insertion: 7468c33f2d676c6163c33f2d636f66667265742d7468c33f2d626f782d37357837352e6a7067 (th??-glac??-coffret-th??-box-75x75.jpg)
    . Last query: SELECT counter, name_bin FROM <code>wptb_wponlinebackup_items</code> WHERE bin = 2 AND parent_id = 2690 AND type = 1 AND name = 'glac??-coffret-75x75.jpg'
  5. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Hi mrsbeata and emcyze,

    2.2.11 has been released moments ago and should be available within the next hour. Please update and let us know if you continue to have issues.

    It should fix all these issues with the insertions.

    Thanks,

    Jason

  6. mrsbeata
    Member
    Posted 1 year ago #

    I updated the plugin yesterday and did a manual back up and it works.

    Thanks for the swift response.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.