WordPress.org

Forums

Online Backup for WordPress
What Does This Warning Mean? (6 posts)

  1. freedom1
    Member
    Posted 2 years ago #

    My last automatic backup failed a few days ago.

    I have just successfully manually performed the backup, but, I noticed that a Warning appeared, which is the same warning that showed up the previous 4 times it backed up.

    It reads "Table 'wp_dprv_post_content_files' has no PRIMARY or UNIQUE key! Backup of this table may be inconsistent; some rows could get missed. See FAQ for more information."

    My site is http://www.ourhometools.com

    Can you please tell me what this warning means, and how to resolve any issues?

    Thanks

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

  2. Online Backup
    Member
    Plugin Author

    Posted 2 years ago #

    Hi freedom1,

    The warning is relating to a database table that must have been created by a plugin. The table was created with no way to distinguish between rows. This makes backing it up without locking the table extremely difficult and unreliable, and so we report the warning.

    If the data for that plugin is not 100% important, you can safely ignore it. Otherwise it is best to contact the plugin developer and ask them to add a primary/unique key to their database table so our backup plugin can distinguish between rows.

    Jason.

  3. freedom1
    Member
    Posted 2 years ago #

    Thanks Jason,

    I assume then it must be a plugin I installed in the past few weeks, as it's only over the past month I've seen those warnings.

    I'll try to figure out which of the plugins it could be, though I don't think I have any plugins on this particular blog that I don't have on my others, yet this is the only blog showing this warning.

    Geoff

  4. Online Backup
    Member
    Plugin Author

    Posted 2 years ago #

    Hi Geoff,

    I wouldn't rule it been a table created by a plugin you USED to have installed, either.

    Through our company use of WordPress we have seen some plugins that didn't delete their database data when you removed them, and we had to manually deleted it. Not ideal!

    Regards,

    Jason

  5. freedom1
    Member
    Posted 2 years ago #

    Thanks Jason,

    I can't even think of any plugins I've removed recently from just that one blog, so I'm struggling to identify which one might have left its database data.

    I think it's something I'll have to live with and hope in the event of a loss of my data it won't impact too badly when I need to recover it.

    Geoff

  6. Online Backup
    Member
    Plugin Author

    Posted 2 years ago #

    Hi freedom1,

    No problem. In 99% of cases it will not be a problem. It will only be a problem if that database table changes at all in the middle of backup.

    The worst case is it will make whichever plugin is using that table behave incorrectly. But for most plugins it won't even if the table doesn't backup properly.

    It definitely will not affect the WordPress core as those tables are always well-formed and have proper indexing.

    Regards,

    Jason

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic