Column Will Not Delete

  • Resolved joeldault

    (@joeldault)


    10 years, 3 months ago

    I have created a form that has several fields. Some of these columns titles have names with ” ‘ ” symbol in them. For instance, one column is named “lender’s”. For some reason these columns will not work with part of the short code. if the “‘” symbol is in the columns name. That is understandable. I have been trying to delete these columns for two days. They will not delete. I have also tried to remain them. which will not work either. Please help. When I attempt to rename them to remove the “‘” symbol they renaming wrong. For instance… the name “Lender’s”. When I try to rename the column it changes to “Lender/’s”. When I try to delete it, it goes through the process but does not actually delete the column. Please help

    https://www.ads-software.com/plugins/contact-form-7-to-database-extension/

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

    (@msimpson)

    The best thing to do at this point is probably rename the column in the database to something without the single quote in it.

    This will replace “Lender’s” and “Lender/’s” with “Lenders”

    update wp_cf7dbplugin_submits
set
field_name = 'Lenders'
where
field_name = 'Lender''s' or
field_name = 'Lender/''s'
    Thread Starter joeldault

    (@joeldault)

    I am sorry, I not nit sure what I am supposed to do with that

    Plugin Author Michael Simpson

    (@msimpson)

    Run that query in PHPMyAdmin for you database.

    Thread Starter joeldault

    (@joeldault)

    Thanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Column Will Not Delete’ is closed to new replies.