• Hi,

    First, I’m sorry if this post ends up having nothing to do with the plugins named, TablePress and Online Backup for WordPress.

    I did do a search for, “plugin:+TablePress+key” before posting.

    I am unable to locate the tables listed in the warning from Online Backup for WordPress.

    And, I believe the only table I use is with TablePress.

    When I run the Online Backup for WordPress I get two warnings,
    Table ‘wp_etright_answer’ has no PRIMARY or UNIQUE key! Backup of this table may be inconsistent; some rows could get missed. See FAQ for more information.
    Table ‘wp_etcomment_rating’ has no PRIMARY or UNIQUE key! Backup of this table may be inconsistent; some rows could get missed. See FAQ for more information.

    So, I went to the Online Backup for WordPress website and found a reference to a similar sounding error. That site indicates the following, The backup log is reporting “Table has no PRIMARY key! Some rows could get missed.
    Because our plugin takes data from your tables section by section instead of all at once to prevent any problems with web servers that don’t like long running scripts, we need a method of distinguishing between what we have backed up already, and what we haven’t, in case the database contents change during the backup. We could lock the tables and prevent changes but this would not be a feasible approach for a constantly changing blog. So to get around the problem of changing data, we use the table PRIMARY key, which is a unique value in every row and allows us to remember exactly which rows we have already backed up.

    However, some tables are poorly designed and do not have any PRIMARY key, so we do not have a unique value to distinguish between rows and we are forced to request a range of rows. What this means is that if a new row of information is inserted into the table at the beginning, and we are in the middle of a backup, when we ask for the range of rows “50-100”, we would instead receive what was previously rows “49-99” (the inserted row will make row 1 become row 2, and so on.) This will cause the backup to contain the same row twice. In a potentially worse scenario, if the first row is deleted while we are performing a backup, when we request rows “50-100” we would receive rows “51-101”! We would essentially miss row 50, and have no way of knowing or preventing this.

    Because of this problem, we have made the plugin report this as a warning so that you are aware that should the table be consistently changing, the backup may not be completely consistent, and some rows may have been duplicated or lost.”

    I believe the only table in my wordpress site is the one I created using TablePress.

    Can anyone offer a suggestion on how to troubleshoot this?

    My website is here.

    Thank you for any support you can offer.

The topic ‘[Plugin: TablePress / Online Backup for WordPress] locate wp_etright_answer’ is closed to new replies.