Hi, Victor.

When you changed the domain, the path to the files for the source data of tables most likely changed, and it is also possible that you changed your Database Table Prefix.

In order to check what is the current/new path of the tables,

first you can create a new table linked to an Excel or CSV file, and it should generate just fine. 

Once you do that, access your database, and open wp_wpdatatables database table.

In the "content" column, you will see the path related to the new table. 

So, if the new file is stored in (for example):

/var/www/html/your-NEW-site/wp-content/uploads/2021/02/file-one.xls

And your old files are in:

/var/www/html/your-OLD-site/wp-content/uploads/2021/02/file-two.xls

You need to modify the content column for each row, and replace the path.

To do that, you can run this SQL command in your Database ( via PHPMyAdmin):

UPDATE `wp_wpdatatables` SET content=REPLACE(content,'this_part','that_part')

Please bear in mind that wp_ is the default table prefix of WordPress,

 but on your new site it could be anything, so check what is your DB table prefix,

then you should run `your_prefix_wpdatatables` and actually replace the part of the path in "this_part" and "that_part" sections.

-

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 manual tables without issues.

-

If you're unsure how to do this, I can do it for you if you can provide me with a temporary wp-admin user (administrator), 

and database (phpMyAdmin) access credentials.

If you send us access, please make sure to check PRIVATE reply - for safety reasons, so that only we can see it.

Hi, Victor.

Thank you for this update.

We will do our best to advise what you can check next.

If i understood, server is on an internal tunnel network.

And that PHP file path opens through your browser, but our plugin gives the error.

-

Can you confirm, if you try to make a new PHP Array Table, with the same URL path to the PHP file ,

does it create a new table successfully, and just the existing tables are giving you an error;

or it is the same error when you try to make a new table from this PHP URL?

-

Can you please show us some screenshots of how this error looks on the screen?

Can you also please record a Video of your screen,

show us how it looks/which path you use exactly as URL to open this in your browser;

and which path is set in the table's back-end settings of our plugin,

in the Input file path or URL for the Serialized PHP Array table?

Can you also perhaps send me an example of any PHP file that you would use-

i can try to just check if i can place this file on my localhost folder, and try to link a table to it?

Also, if you send us any sensitive data, please make sure to mark the reply as PRIVATE, for safety reasons.

Thank you.