Title: warrenopus's Replies | WordPress.org

---

# warrenopus

  [  ](https://wordpress.org/support/users/warrenopus/)

 *   [Profile](https://wordpress.org/support/users/warrenopus/)
 *   [Topics Started](https://wordpress.org/support/users/warrenopus/topics/)
 *   [Replies Created](https://wordpress.org/support/users/warrenopus/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/warrenopus/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/warrenopus/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/warrenopus/engagements/)
 *   [Favorites](https://wordpress.org/support/users/warrenopus/favorites/)

 Search replies:

## Forum Replies Created

Viewing 1 replies (of 1 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Form Manager] MySQL errors – mysql_fetch_row(): supplied argument is not a valid MySQL result](https://wordpress.org/support/topic/mysql-errors-mysql_fetch_row-supplied-argument-is-not-a-valid-mysql-result/)
 *  Thread Starter [warrenopus](https://wordpress.org/support/users/warrenopus/)
 * (@warrenopus)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/mysql-errors-mysql_fetch_row-supplied-argument-is-not-a-valid-mysql-result/#post-3458095)
 * 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)