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.
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.
Also point me to the table ID so I can take a look.
The editor input type for some of the columns ( for example current year status) it is set to One line edit ( attachment). For the columns that you do not want to be editable in frontend or backend just set editor input type to None.
And sorry another question .. when I duplicate a table .. will it duplicate all the "rules" that are set in the column settings. Like whether its editable or not? Format of the data?
About the first question, a lot of users requested that if the column is not visible the editor input type should not be disabled by default because a lot of them use the option to edit that column even that column is not visible in table.
About the duplicate a table, yes all of the settings that are applied to the table should be applied to the duplicated table.
I was able to install wpDataTables and setup a new table. However, when I try to update anything on that table I receive the following error.
Any help would be appreciated!
Error
There was an error while trying to save the table! Not Acceptable
Not Acceptable!
An appropriate representation of the requested resource could not be found on this server. This error was generated by Mod_Security.
HI Rhonda Stark,
Thank you for your purchase.
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
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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
Hi Rhonda,
Can you please go to wpdatatables settings page and check our uncheck Include bootstrap.js files.
Let me know the result.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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
It was turned on and when I turned it off nothing displayed on the front end.
Hi Rhonda,
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.
Also point me to the table ID so I can take a look.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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
Hi Rhonda,
I can see what is the issue.
The editor input type for some of the columns ( for example current year status) it is set to One line edit ( attachment).
For the columns that you do not want to be editable in frontend or backend just set editor input type to None.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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
I'm sorry that it was something I missed .. thanks for checking into it!
Hi Rhonda,
No problem at all.
Hope that everything is working fine now.
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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
Just thinking .. if I'm setting the column not to be displayed on the front end .. wouldn't it make sense to default the Editor Input Type to None?
And sorry another question .. when I duplicate a table .. will it duplicate all the "rules" that are set in the column settings. Like whether its editable or not? Format of the data?
Hi Rhonda Stark,
About the first question, a lot of users requested that if the column is not visible the editor input type should not be disabled by default because a lot of them use the option to edit that column even that column is not visible in table.
About the duplicate a table, yes all of the settings that are applied to the table should be applied to the duplicated table.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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