Hi, Dean.

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

Regarding that SQL table error,

could i tell me a bit more details about this table you are pulling from the database?

-

For example, did you have wpDataTables on another site/ or database, then migrated to a new site,

and perhaps the database table prefix has changed?

Usually when i see this error, that is the use-case, then the user needs to check what is the current DB prefix.

But let me know if you perhaps migrated the plugin from another site, or anything like that?

-

If i can also check out the back-end setup , as well as the database - if you wish to save some time, maybe it is best if i go through everything right away.

Please provide me a temporary WP-admin (administrator) user for your website where this happens, 

as well as FTP credentials 

and access to the database ( either link with credentials for PHPmyAdmin, or access to Hosting Panel),

so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

Hi, Dean.

Sorry, i pressed "send" without responding to your additional questions.

2. In regards to duplicating tables through our plugin's built-in options without any "row data" but just to create a  "table settings template with columns and table settings but no rows",

unfortunately, something like that is not currently possible,  because in our plugin the table has to have at least one or more rows to be generated - otherwise you will get "table is empty" errors;

but this is a good idea for a future option.

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

-

At the moment, maybe you can try through your database management tool, such as PHPMyAdmin to try and duplicate tables, ( our support does not cover that, you will have to research online resources to find this information/tutorials);

 then you can call them in our SQL tables, like "SELECT * FROM table_name",

but as mentioned, each table has to have at least 1 dummy row of data to initially generate the table - later on you can remove that row/ edit/ add new rows.

-

3.  In regards to a question how to delete a row, i am not sure i understood.

Basically, in order to have a table editable, the most important detail is the table has to have a unique auto-increment integer column which will serve as "column for editing".

In our Manual Tables, we automatically generate a 'wdt_ID' column, which serves as "ID column for Editing",

but when you make SQL tables - you have to make sure to include one "row ID" column,

and in Editing Tab, choose this column as "ID column for editing", otherwise you won't be able to add/edit/delete rows.

You can learn more about how to make Editable tables here.https://wpdatatables.com/documentation/front-end-editing/creating-editable-tables/

4. Replacing source data in tables :

You can only replace source data in our Manual Tables.

Please check more about this feature here : Update manual tables from source files (CSV, Excel or Google sheet)