Lately when creating a table using MYSQL as input, WPDATATABLES is now throwing me out when trying to run the SQL to create the table. It is a basic table SQL. I have created tables in the past this way ever without error.
Same issue happening when updating small existing tables, seems every other update to options or anything to the output right in the plugin.
The problem is that the app all of a sudden wigs out, throws a DATE TIME STAMP only on the browser and any attempt to reverse course or just refresh puts me back to the main menu and all changes tried are lost.
I testes a hunch and if I have back to back updates, I make one and it runs fine, but I do something else in the app, then come back do a simple change to the table and it works. I then try another update right away and it blows up, it is like it won't take any consecutive updates. However, the same is going on now trying to create the simple tables so we are dead and have to use other plugins even though we purchased this one.
We even updated our one site to a Virtual Private Server so we have no resource issues and your app was doing great until just after the last version.
Thanks for any advice.
We do not provide any logins anymore for security reasons so let me know what we can provide. The output is just a full DATE TIME stamp in the upper left corner and a white background.
Sorry for late response we did not work in past 5 days due to national holidays.
When the Datetime stamp occurs then the issue can be in the security on the server.
Can you please tell me do you have installed mod_security on your server.
If that is the case here is the workaround below.
In regards to a site on your hosting account, the cause of the 406 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
Lately when creating a table using MYSQL as input, WPDATATABLES is now throwing me out when trying to run the SQL to create the table. It is a basic table SQL. I have created tables in the past this way ever without error.
Same issue happening when updating small existing tables, seems every other update to options or anything to the output right in the plugin.
The problem is that the app all of a sudden wigs out, throws a DATE TIME STAMP only on the browser and any attempt to reverse course or just refresh puts me back to the main menu and all changes tried are lost.
I testes a hunch and if I have back to back updates, I make one and it runs fine, but I do something else in the app, then come back do a simple change to the table and it works. I then try another update right away and it blows up, it is like it won't take any consecutive updates. However, the same is going on now trying to create the simple tables so we are dead and have to use other plugins even though we purchased this one.
We even updated our one site to a Virtual Private Server so we have no resource issues and your app was doing great until just after the last version.
Thanks for any advice.
We do not provide any logins anymore for security reasons so let me know what we can provide. The output is just a full DATE TIME stamp in the upper left corner and a white background.
HI Alan,
Thank you for your purchase.
Sorry for late response we did not work in past 5 days due to national holidays.
When the Datetime stamp occurs then the issue can be in the security on the server.
Can you please tell me do you have installed mod_security on your server.
If that is the case here is the workaround below.
In regards to a site on your hosting account, the cause of the 406 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
Hope this can help.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables