Erro: Table ‘azure_wordpress.wp_wpdatatables’ doesn’t exist

Hello,
Can you please confirm you have the latest Plugin version installed, and is it the Lite/free or Premium Version?
For the Lite, it should be 3.4.2.6 and if it is the Premium wpDataTables, it should be 6.2.1 version.

If you are using the Premium Version, please open a ticket on our main Support platform here, and one of our Agents will respond as quickly as possible.

If you don’t have a licence (or if it expired), please open a pre-purchase ticket which doesn’t require a purchase code.

Premium products are not supported in these forums, as per this comment by WordPress.org moderators.


2. But if you are using our Lite Plugin Version, we can proceed to advise here.
If that is the case, can you please check what is your current WordPress SQL Database Prefix?
One of our main Plugin tables which stores important details of the Plugin is named wp_wpdatatables, and it gets created in your WordPress Database during the Plugin installation and activation.

This is very rare to happen, but it could be that your WordPress SQL Table Prefix, for some reason, does not correctly ‘match’ with what our Plugin is expecting.

Can you please log in your Database via PHPMyAdmin or any other DB Management Tool you use;
and search if you can find any Table that contains “wpdatatable” as part of the table name?
The default prefix is wp_ so the table name is wp_wpdatatables, but the DB prefix on your Site could be anything;
So check if you find “yourDBprefix_wp_wpdatatables” or “yourDBPrefix_wpdatatables”.
–

1. The easiest way to try and fix this is, to uninstall our Plugin and re-install it.
If you have not made any important Tables or Data yet that you don’t wish to lose in our Plugin;

then you can go in the Main plugin settings, and disable/uncheck this option : Prevent deleting tables in database.

That option is used to keep all the tables/charts/any data safely stored in the WP Database in case if you delete the Plugin from the WP Back-End’s Plugin List.

But in this case, ( if you don’t have anything important yet) we want to completely delete any trace of our Plugin and to start again – in hope that it creates the right DB prefix in your WP Database for the wp_wpdatatables Table.

​Now, you can deactivate our Plugin and delete it completely from the  “Plugins” section in WP-Admin.

After that, reinstall it again, activate it, purge cache of your Site, then try to make a new Table again.

See if that solves the issue?

If it does – then just re-enable/check that option from the Main Plugin settings, because we want your future Tables+settings to stay safe in the WP Database when this is fixed.

2. If that does not help, and if you can find our wp_wpdatatables Table, just with a ‘wrong DB Prefix’,  

try to rename our wp_wpdatatables Table in the WP Database to have your DB prefix, like “yourPrefix_wpdatatables”.

And check if this solves the issue.

3. If none of that helps, we can try to remote in and take a closer look, but we would need remote access and we can not achieve that on this Public Forum.

If you need us to do that, please open a PRIVATE ticket on our main Support platform here, and one of our Agents will respond as quickly as possible.

If you don’t have a licence (or if it expired), please open a pre-purchase ticket which doesn’t require a purchase code.

Hello,
We got feedback from our Main support on that ticket.
They checked all the details for you and found the issue seems to be coming from your Hosting Server which is holding that Database.
It is some kind of permissions issue – Our Plugin is being denied from creating new Tables in that Database;
They will keep following up on that ticket, so just check their reply, we hope the issue gets solved as soon as possible.

Thank you.