But the table with ID 7 was suddenly emptied of its contents...
I looked directly at the database with phpmyadmin. and surprise : there is no correlation between id on the wordpress administration and id in the database.
For example, in the sql database, the wpdatatable_5 has the ID 8 in Wordpress.
Other example :
I want to change the name of the [wpdatatable id=12] but it's impossible because "wpdatatable_4_1' doesn't exist" .
Not all wpDataTables are stored in the database. Tables linked to an existing data source are not saved in the database, but they still need an ID for the shortcode. So, if you have 3 manual tables, then 4 tables linked to an existing data source, and then another 3 manual tables they would look like this in the plugin:
[wpdatatable id=1]
[wpdatatable id=2]
[wpdatatable id=3]
[wpdatatable id=4]
[wpdatatable id=5]
[wpdatatable id=6]
[wpdatatable id=7]
[wpdatatable id=8]
[wpdatatable id=9]
[wpdatatable id=10]
But in the database, you would have only these:
wp_wpdatatable_1 - [wpdatatable id=1]
wp_wpdatatable_2 - [wpdatatable id=2]
wp_wpdatatable_3 - [wpdatatable id=3]
wp_wpdatatable_4 - [wpdatatable id=8]
wp_wpdatatable_5 - [wpdatatable id=9]
wp_wpdatatable_6 - [wpdatatable id=10]
Duplicated tables receive a _1 after each duplication, so if you duplicate table 1, you will have
wp_wpdatatable_1 and wp_wpdatatable_1_1
You can see the database name when you go to "Editing" tab above the table.
Hello
I created few datatables, deleted someones.
Today, I deleted the table with ID 6.
But the table with ID 7 was suddenly emptied of its contents...
I looked directly at the database with phpmyadmin.
and surprise : there is no correlation between id on the wordpress administration and id in the database.
For example, in the sql database, the wpdatatable_5 has the ID 8 in Wordpress.
Other example :
I want to change the name of the [wpdatatable id=12] but it's impossible because "wpdatatable_4_1' doesn't exist" .
It's a real mess.
Elise
Hi Elise
Not all wpDataTables are stored in the database. Tables linked to an existing data source are not saved in the database, but they still need an ID for the shortcode. So, if you have 3 manual tables, then 4 tables linked to an existing data source, and then another 3 manual tables they would look like this in the plugin:
[wpdatatable id=1]
[wpdatatable id=2]
[wpdatatable id=3]
[wpdatatable id=4]
[wpdatatable id=5]
[wpdatatable id=6]
[wpdatatable id=7]
[wpdatatable id=8]
[wpdatatable id=9]
[wpdatatable id=10]
But in the database, you would have only these:
wp_wpdatatable_1 - [wpdatatable id=1]
wp_wpdatatable_2 - [wpdatatable id=2]
wp_wpdatatable_3 - [wpdatatable id=3]
wp_wpdatatable_4 - [wpdatatable id=8]
wp_wpdatatable_5 - [wpdatatable id=9]
wp_wpdatatable_6 - [wpdatatable id=10]
Duplicated tables receive a _1 after each duplication, so if you duplicate table 1, you will have
wp_wpdatatable_1 and wp_wpdatatable_1_1
You can see the database name when you go to "Editing" tab above the table.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables