Hello Stefan,

Sorry for the waiting time.

We don't work on weekends so it adds two days to the waiting time.

We appreciate your patience.

If I understood, it seems this issue of 'unknown' DB connection name was only temporarily happening for some old SQL tables - And now for new tables, it correctly sets your desired 'default DB connection', right?


So now you wish to just edit the DB connection set on those old/existing tables with 'unknown' connection?

There is a way how you can edit the existing SQL table's DB connection, but it has to be done directly in your WordPress Database.
There is one of our Plugin tables, which 'holds' this information, on all tables.

Here are more details :

For each table, during creation we have to manually select the DB connection from the dropdown;

and the only way to change that after the tables were already made by our plugin,

is to go in the database where your WordPress is,

there find our plugin's database table named 'wp_wpdatatables'.

(Please note, the wp_  is the default WordPress Database table prefix,   on your site's database that table prefix might be different, but it should be easy to recognise, all tables would have the same DB prefix,

so check for "yourTablePrefix_wpdatatables")

This table holds the details and settings for each table from our plugin.

If you wish to sort it by table type, you can hit the Header of column 'table_type' and just look for 'mysql' type tables,

or you can do a "search" on wp_wpdatatables to only show this table type.

Then check under the "connection" column, here the "external DB connection" name is set.

You can edit that field for all MySQL tables you need from our plugin and change the DB connection name.

Under the "content" you will also see the SQL Query used for each table,

and of course, in the ID field, it will show each wpDataTable's ID,  as they would show on the Shortcodes.

Here is an example screenshot from a user's database that has two different external DB Connections and how that looks in the table's data :

I hope that helps. Let me know how it goes.

Hello Stefan,

You're very welcome, I am happy to help.
Anything else that we could assist with, please don't hesitate to create new tickets.