Hi, tony.

Looking at your other ticket where you mentioned a migration;

i guess you perhaps moved the plugin's data to another database, or changed domain?

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, tony.

I am sorry, but i am not familiar with CDN bucket in the Amazon,  and the "offload plugin",

but we can help you change all the URL paths of the files which are linked for your tables in our plugin.

-

The first step will be to determine what is the "new" / current path for any new tables if you connect them with source files.

First, please create a new table linked to any Excel or CSV file;  it should generate just fine. 

Once you do that, access your database with your Database Management Tool  ( for example PHPMyAdmin), and open the 'wp_wpdatatables' database table.

( the  wp_  prefix is the default WordPress Database table prefix, on your site, it might be different)

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 on your database ( via your database management tool, such as PHPMyAdmin):

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

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

but on your site it could be anything, so you should run `your_prefix_wpdatatables` and actually replace the part of the path in "this_part" and "that_part" sections.

If you're unsure how to do this SQL Query in your database, 

we can do it for you if you can provide us with WP-Admin Administrator access,

 with a temporary wp-admin user (administrator), and database (phpMyAdmin) access URL with credentials.

If you send us any credentials, please make sure to mark reply as PRIVATE, for security reasons.

-

Our developers will be working on adding an easier solution to export everything, but we can't say an ETA on this.

Let me know if that helps.

-

In regards to this other comments :

2. advanced-form-intergration-premium was causing several warnings/critical 504s across all sites :

We do not own or develop "Advanced Form integration premium", that is not our plugin,

can you check who develops that plugin and reach out to their support to determine why you are getting error 504?

3. what version of php is required for the updated plugin? (we don't have PHP V8 )

I will tell you the minimum and also recommended versions for both WordPress and PHP.

WordPress Version : has to be minimum 4.5 or higher .  

We recommend WP version 6 at this time.  Our Test site/server has 6.1 version and our plugins work without issues there, so you can also use 6.1 if you wish.

-

PHP Version: 5.6 or higher. We recommend PHP 7.4 , it is the most stable version , we use it on our Testing sites and have no issues.

If you wish, you can try PHP 8.0 , with caution.  

wpDataTables is optimised for it,  but there are a lot of other plugins and Themes that are not yet ready for it - so they can cause conflicts.