As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #3047297
error importing table
Closed

Comments

  • Charles Tamburello started the conversation

    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.  

  •  1,896
    Miloš replied

    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:

    4571764284.png

    Then, access wp_options table and click on "Search" in the top menu. In the "option_name" section, type "wdtGeneratedTablesCount" and search for that:

    4446270216.png

    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":

    4874171096.png

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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