getting error: Error while trying to import table. Exception: There was an error when trying to create the table MySQL side: Table "wp_wptable_125 already exists. - I have deleted table 125 and renamed the .xls file to upload and it still is giving the dame error that table 125 already exists.
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 "124":
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.
getting error: Error while trying to import table. Exception: There was an error when trying to create the table MySQL side: Table "wp_wptable_125 already exists. - I have deleted table 125 and renamed the .xls file to upload and it still is giving the dame error that table 125 already exists.
Hi, Charles
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 "124":
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.
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