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.
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
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