I've added rows to a table via the excel view. When I delete those rows the wdt_id does not get rest. It will stay at the last row that has been added.
Is there a way to reset this number? The attached .jpg file shows the rows that the table still has, I have deleted the rows above these rows (1 - 52) and expected the rows to be re-number starting at number one.
I am hoping you can answer this question as well, I've created a bunch of test tables, those have been deleted and we want to start from fresh. However, when I create a new table it creates it with the next number in sequence, just like the WDT_ID problem. Is there a way to change the name of the table within the WP web interface? I've changed it in the backend but when I tried to save data in the front end, I get this error message below.
That's a different setting in the database. To reset the generated tables counter, you need to go to wp_options, and look for option_name "wdtGeneratedTablesCount":
I've added rows to a table via the excel view. When I delete those rows the wdt_id does not get rest. It will stay at the last row that has been added.
Is there a way to reset this number? The attached .jpg file shows the rows that the table still has, I have deleted the rows above these rows (1 - 52) and expected the rows to be re-number starting at number one.
Hello Eric
Thank you for your purchase.
This is an auto-increment column in the database, so it will always continue where it left off. You need to reset it in your database with this:
Where the value is the next value that should be used. So if you need to reset wp_wpdatatable_1 to 1, it should be:
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
Hello Aleksander,
I will try and let you know how it works.
Thanks
I am hoping you can answer this question as well, I've created a bunch of test tables, those have been deleted and we want to start from fresh. However, when I create a new table it creates it with the next number in sequence, just like the WDT_ID problem. Is there a way to change the name of the table within the WP web interface? I've changed it in the backend but when I tried to save data in the front end, I get this error message below.
Please advise.
Thanks
Hello again Eric
That's a different setting in the database. To reset the generated tables counter, you need to go to wp_options, and look for option_name "wdtGeneratedTablesCount":
There, you can reset the counter.
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
Thank you!
You're welcome, Eric
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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
For those out there who are new to Word Press / Databases, I found this article that was a great help.
https://anathallo.net/view-edit-the-wp_options-table-from-the-wordpress-dashboard/
Let's all learn together! :D
Thanks, Eric, that actually may come in handy in the future
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