The table names should have a prefix “wp_” by default, i.e. wp_cf7dbplugin_submits. All your WP tables for a particular instance should start with the same prefix that you set during the WP installation. make sure the CFDB table names have the same prefix as the tables in the new installation.
PS. you only need to copy data from the wp_ cf7dbplugin_submits table.
Thread Starter
UserDG
(@tenkepadu)
yes, i have a table prefix. the old table name have the same name of the new table but still not displayed
The old table has the same as the new one, but in the new database do all the other tables use the same prefix? If not, make the table have the same as the others.
I suspect you have 2 tables, one that you imported and on that CFDB created, both with a different prefix.
Thread Starter
UserDG
(@tenkepadu)
yes, the old and new table have same prefix. I query the new added rows thru phpmyadmin and the data is displayed but in WP UI is not 🙁
even I do a custom PHP that will display the data from _cf7dbplugin_submits table, the new added row is not displayed too.
I don’t think you understood my last post.
In a typical installation, the table name should be wp_cf7dbplugin_submits not _cf7dbplugin_submits. I suspect you have both of these tables and the plugin is reading from the empty one (wp_cf7dbplugin_submits).
If you explicitly changed the table prefix for the installation from “wp_” to something else like “xxxx_” then the name name must be “xxxx_cf7dbplugin_submits”.
The plugin will create a table for itself with the right prefix if it does not find one existing.
Hello Michael I have same problem. I’m going to upload CSV as same as format like table “wp_cf7dbplugin_submits”. Insertion done success but doesn’t display on front-end from that data entry display out of 500 entry.
What relation between “wp_cf7dbplugin_submits” & “wp_cf7dbplugin_st” ?
Need to add Dates in “wp_cf7dbplugin_st” ?
If you are using PHPMyAdmin to import CSV, make sure you use PHPMyAdmin to export the CSV. Don’t import CSV exported from the CFDB Admin page.
