wps_cf7dbplugin_submits table not editable in phpmyadmin?

  • scalare

    (@scalare)


    9 years ago

    I’ve installed your plugin in wpengine host (www.wpengine.com). Everything is working great, but I need to make a manual edit to the table wps_cf7dbplugin_submits. But I cannot do it because I get this at phpmyadmin:

    “Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.”

    This does not happen in another host where I have the same site installed as a staging environment. Do you know why this could be happening? The hosting company suggested that I should make an index on one of the columns, or that I should add an auto-increment column to make each record unique. It makes sense, but I’m not sure if that could affect the plugin function in any way.

    Can you please advice?

    Thank you.
    Andres

    https://wordpress.org/plugins/contact-form-7-to-database-extension/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    9 years ago

    I don’t see any reason why you should not be able to edit it. If PHPMyAdmin can do it on one site but not another, then there is some other issue. Your hosting people are just guessing. You could try the new column with auto-increment but I won’t guarantee that it will not result in other issues in the future.

    Thread Starter scalare

    (@scalare)

    9 years ago

    It seems the later versions of phpmyadmin display this error when there is no primary key for a table, and the version of phpmyadmin we have in the staging environment is rather old.

    I’ve just created a temporary primary key using submit_time, field_name and form_name as multiple-column key for the table, so phpmyadmin would let me edit the records, and then removed the index again.

    (Just in case this helps someone else)

    Andres

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘wps_cf7dbplugin_submits table not editable in phpmyadmin?’ is closed to new replies.