We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
Hi,
I have a table where I defined wdt_id as ID column for editing.
I use this row for a current number. If I am adding a new row, the value is increasing (auto increment in the sql table is on). This is ok an useable.
But if I delete a row (deleting the yellow row) in the table then the auto increment value in the My_SQL table is not decreasing.
The result is, that I have not a uniform numbering in my table.
Can you help?
Best regards
Siegfried
PS Congratulation to the plugin. It is really the best to work with tables and I tried a lot of such plugins.
Hi Uebes,
This is limitation on MySQL side and not ours. From their documentation:
You cannot reset the counter to a value less than or equal to the value that is currently in use. For both InnoDB and MyISAM, if the value is less than or equal to the maximum value currently in the AUTO_INCREMENT column, the value is reset to the current maximum AUTO_INCREMENT column value plus one.
There is a couple solutions to affect this behaviour but we are not recommending it because they are workarounds.
ok thank you.