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!

Okay
  Public Ticket #3209207
Moved Website
Closed

Comments

  • Edward Keeley started the conversation
    January 16, 2023 at 10:36pm

    Hi,

    I have migrated the website that I am using WP Data Tables on from a server that is running Windows NT to a server that is running Linux.  The tables are populated viz Excel spreadsheet.  The table is saying the spreadsheet does not exist, but it is there.  Is this because the file structure in Linux is different from Windows and does not have a C: drive?  If so, is there a way I can fix this without rebuilding the tables?

  •  1,894
    Miloš replied
    January 18, 2023 at 5:23pm

    Hi, Edward

    Sorry for the delay

    -

    When you migrate the site, the tables' names are updated, 

    but the command for pulling the table from the database,

     and the table's database name remains the same, 

    so when the plugin is calling "wp_wpdatatable_1" it can't find it because it's now "xyz_wpdatatable_22" 

    (for example).

    Here's what you need to do:

    Go to your database, and verify that the tables changed their prefix from "wp_" to "xyz_". 

    Then go to "xyz_wpdatatables" database table.

     In there, you will need to replace all instances of "wp_" with "xyz_". You can do it with these two queries:

    UPDATE `xyz_wpdatatables` SET content=REPLACE(content,'wp_','xyz_');

    That replaces the prefix in the "Content" column. And this:

    UPDATE `xyz_wpdatatables` SET mysql_table_name=REPLACE(mysql_table_name,'wp_','xyz_');

    That replaces the prefix in the "mysql_table_name" column. Once you do this, you should be able to simply load all your tables without issues.

    Let us know if this helps.

    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