Forum Replies Created

Viewing 1 replies (of 1 total)
  • Thread Starter warrenopus

    (@warrenopus)

    RESOLVED.

    I used WSD security to rename the database table prefixes. So they would not be wp_%tablename%, the wp_ is replaced. All plugins work fine with this but not WordPress Form Manager.

    WordPress Form Manager stores it’s table name inside the database!

    mysql> SELECT data_table FROM wp_fm_forms WHERE ID = ‘1’
    -> ;
    +————–+
    | data_table |
    +————–+
    | wp_fm_data_1 |
    +————–+

    The data_table value is hardset in the DB to wp_fm_data_1
    When you utilize WSD security to alter your table prefix this is what happens, the datatable name is now set to %newprefix%_fm_data_1
    but the table name stored in the DB is still wp_fm_data_1 not %newprefix%_fm_data_1

    Use a mysql update statement
    update %newprefix%_fm_forms set data_table = ‘%newprefix%_fm_data_1’ where ID = ‘1’;

    update %newprefix%_fm_forms set data_table = ‘%newprefix%_fm_data_1’ where ID = ‘2’;

    etc…

Viewing 1 replies (of 1 total)