TABLE KEY ERRORS – How to manually update WordPress row?

  • Resolved BrandDedication

    (@noahjnet)


    10 years, 8 months ago

    I search your FAQ and every post on this forum and could find how to manually update a wordpress table row. How can I do that?

    I have created a default wordpress installtion using your plugin, but when I try to install this setup using duplicator on local mamp I get the following:

    “TABLE KEY ERRORS (2)
    A primary key is required on a table to efficiently run the update engine. Below is a list of tables and the rows that will need to be manually updated. Use the query below to find the data.
    SELECT @row := @row + 1 as row, t.* FROM some_table t, (SELECT @row := 0) r
    Row [719] on Table [Default_Setup_wp_wfStatus] requires a manual update.
    Row [928] on Table [Default_Setup_wp_wfStatus] requires a manual update.”

    I tried using “SELECT @row := @row + 1 as row, t.* FROM some_table t, (SELECT @row := 0) r” in the search query box, but… to no avail…

    I’m not familiar database tables that much. I searched online and can’t find a straight tutorial on how to do this. I do know that the Table ending in “wfStatus” is related to the Wordfence Security plugin. So, I deactivated it and made another package, then tried to install my setup locally again. But I get the same update errors. I get 500 errors on my admin when I have this Table Key Error.

    Please help guru. Any relevant tutorial should suffice.

    http://wordpress.org/plugins/duplicator/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter BrandDedication

    (@noahjnet)

    10 years, 8 months ago

    Nevermind! I didn’t figure out how to manually update the WordPress data table row, but in the Wordfence Security “Options” I checked the box for Wordfence to delete its data tables upon deactivation (It’s near the very bottom in the option settings). Now I can duplicate my package with no problems.

    Just a note if any one has problems with duplicating packages with Wordfence Security plugin.

    Cory Lamle

    (@corylamleorg)

    10 years, 8 months ago

    Hi noahjnet,

    Thanks for the feedback and posting your solution! Some aspects of the plugin are very technical and there really is no way to get around it. I usually recommend to most people when they run into issues that they can’t resolve or are not listed on the online knowledge base to just grab a developer really quick from a source like freelancer or odesk and this way they can work through the issue without spending hours/days trying to figure things out on there own.

    Fixing database entries manually without the know-how can cause issues to any database. It looks like you found the right solution, however to others reading this thread please take caution with the report results.

    Cheers~

    Thread Starter BrandDedication

    (@noahjnet)

    10 years, 8 months ago

    Cheers!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘TABLE KEY ERRORS – How to manually update WordPress row?’ is closed to new replies.