Okay
  Public Ticket #3209207
Moved Website
Closed

Comments

  • Edward Keeley started the conversation

    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,850
    Miloš replied

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