Hi kakashimateo,
Thank you for your purchase.

Please provide me a temporary WP-admin login for your site where this happens, 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 party. You can write credentials here just check Private Reply so nobody can see them except us.

Best regards.

Hi kakashimateo,

I logged in successfully now, Can you please tell me what should I do so I can reproduce this error.

Also can you please clear your browser cache just in case.

Best regards.

Hi kakashimateo,

You receive this picture am I right ( attachment) 

This is almost 90% related to some security on your server.

Can you please tell me do you maybe have mod_security installed on your server.

Also please try to deactivate WordFence and tell me do you still have the same issue.

Best regards.

Hi kakashimateo,

In regards to a site on your hosting account, the cause of the 404 error is usually due to a mod_security rule on the server.
Mod_security is a security module in the Apache web server that is enabled by default on all hosting accounts.
Apache web server, scans for violations of the rules it has set.
If an action occurs that violates one of these rules, the server will throw a 406 error.

1. If you’re receiving this message when trying to save wpDataTable based on MySQL query from your WP Admin, 
it means your hosting provider is restricting access to some of WordPress’ native functionality. 
To solve it, contact your hosting provider to ask them to remove this restriction.

2. Adding the following to the top of your .htaccess file. (This should be a temporary measure. 
You could try it just to see if it will work, but you probably don’t want to leave it.)
<IfModule mod_security.c>
SecFilterEngine OffSec
FilterScanPOST Off
</IfModule>

3. Backup your .htaccess file if you have one in the public_html directory.
Open the .htaccess file with any text editor and observe the lines between the “# BEGIN WordPress” and “# END WordPress” tags. 
Make sure the lines look somewhat like the following. If not then update the file with the following content and upload it to the ‘public_html’ directory.
# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>
# END WordPress

Best regards.

Hi kakashimateo,

If you take a look at our documentation you will see this notice:

Please note that MySQL query constructor is not an ‘ultimate generator’, it should be consider a helper that constructs a suggestion of a query trying to ‘guess’ what you want. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated your request is, the higher is the chance that it will not return exactly what you need. Play around with the resulting query to achieve better results.

Our suggestion when you have queries like this is to make a VIEW in phpmyadmin or any other database management system to see if the query is returning the right results. If the query is returning the right result you can use that query as an input ( SELECT * FROM VIEW ) when creating tables with Add from data source option.

Best regards.