It seems like the wpDataTables counter got stuck in the database, and now it's trying to add a new table with an existing ID.
If you have access to your database, please first take a look and see what the last ID is. In my example below, it's wp_wpdatatable_9:
Then, access wp_options table and click on "Search" in the top menu. In the "option_name" section, type "wdtGeneratedTablesCount" and search for that:
That will return one row which will display the count in the "option_value" column. In my database, it's correctly set to "9", but on your end, it's most likely wrong:
So, based on the last ID you see in your database (for example, if it's wp_wpdatatable_127) change the option_value in the screenshot above from 124 to 127 (again, this is just an example). Save that, and try to create a table again.
Hello, Support office
Today I could not upload any excel file,.
Please see the screen shot of the excel file. I already uploaded this file yesterday, but today I could not upload it either
Please see the screenshot of the issues and let me know the reason
I appreciate your super help
Samuel
Attached files: screen shot.png
Excel file.png
Hi, Samuel
Thanks for reaching out to us
-
It seems like the wpDataTables counter got stuck in the database, and now it's trying to add a new table with an existing ID.
If you have access to your database, please first take a look and see what the last ID is. In my example below, it's wp_wpdatatable_9:
Then, access wp_options table and click on "Search" in the top menu. In the "option_name" section, type "wdtGeneratedTablesCount" and search for that:
That will return one row which will display the count in the "option_value" column. In my database, it's correctly set to "9", but on your end, it's most likely wrong:
So, based on the last ID you see in your database (for example, if it's wp_wpdatatable_127) change the option_value in the screenshot above from 124 to 127 (again, this is just an example). Save that, and try to create a table again.
Please let me know how that goes.
Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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