I have a table that refuses to assign the next wdt_ID to new rows. Most of the records have a proper wdt_ID assigned to them. However, when adding new records to this table, it's no longer assigning the wdt_ID key.
I've removed the records where the wdt_ID is null, and tried a number of ways to re-enter the records (through the normal interface, using the Excel front-end, and through SQL inside phpMyAdmin). Each time the new records do not get a wdt_ID assigned.
Aleksandar, thank you for your help! The table is behaving perfect now after testing it. I don't know how the column definition was changed, but I appreciate you helping me find the solution.
I have a table that refuses to assign the next wdt_ID to new rows. Most of the records have a proper wdt_ID assigned to them. However, when adding new records to this table, it's no longer assigning the wdt_ID key.
I've removed the records where the wdt_ID is null, and tried a number of ways to re-enter the records (through the normal interface, using the Excel front-end, and through SQL inside phpMyAdmin). Each time the new records do not get a wdt_ID assigned.
Hello Robert.
This issue usually comes from the database.
Please open wp_options, and go to Search above the table:
There, under option_name, set operator to LIKE %...% and enter "wdt":
You're looking for wdtGeneratedTablesCount. Change that to a bigger value where it stopped adding new wdt_IDs and it should solve the issue.
I couldn't log in, because of WordFence:
You may need to whitelist my IP, for me to be able to remote in:
178.148.79.105
Best regards.
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
I tried your suggestion and it didn't work. I've whitelisted your IP, so you should be able to login now. Thank you.
Hello again Robert.
I went in, and set the wdt_ID column to be Auto-Increment in PHPMyAdmin, and now it deletes and adds new rows without any issues.
I left one entry (wdt_ID = 118) as test, and also left the wdt_ID column visible.
Please test the table and let me know if it works correctly.
Best regards.
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
Also, forgot to mention.
The column was set to assign NULL instead of AI (Auto increment), and that's why you ended up with new rows without wdt_ID (see attachment).
Best regards.
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
Aleksandar, thank you for your help! The table is behaving perfect now after testing it. I don't know how the column definition was changed, but I appreciate you helping me find the solution.
Sincerely,
Rob
You're welcome Rob.
Glad I could help.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Best regards.
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