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.
If you like our plugin and support we'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. It means a lot to us.
That can be found on the server or asking hosting company.
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.
I just called my hosting company, which is GoDaddy, and they are telling me that this property cannot be modified because it is set in one place for all accounts on the shared server.
What hosting services are you aware of that have the option of turning mod_security off?
Also, if I modify my htaccess file on the GoDaddy site, what are the downsides or risks of using this solution?
I am not very familiar with hosting services are able to turn off mod_securities so I can not tell you precisely the name of the hosting company.
The issue is that some hosting companies for some reason enable that mod_secuirty and applied it to the WordPress generally, so every lets say "suspicious" query is blacklisted and that is probably you get that date when you try to save some changes.
Can you please check your server log and tell me if there are some errors.
Yes, there was some restrictions and issues with the Wordfence plugin but in some of the previous version of our plugin. We did not have any reports recently that there is a conflict with Wordfence and with the latest version of our plugin.
Maybe there was an update from the Wordfence recently. I will take a look at their latest news to see if there were some update on their side.
Also it is possible to ask Wordfence team to whitelist our plugin so the issues like this would not happen.
This issue with the Wordfence is forwarded to my team and in a meantime you can also contact their support to ask them to whitelist our plugin in this case there should not be any issues.
About the New button:
Can you please send me the link of that table/page so I can take a look.
For the second table on the page can you pleaes check if that table is set to be editable at all.
For the first table on the page you checked Popover edit block in the table settings ( attachment). If you disable this option the buttons will appear next to the Table tools on top of the table.
If you like our plugin and support we'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. It means a lot to us.
Thanks.
The Apply button is greyed outed and I cannot click it to save a new table.
I've tried unsuccessfully with both a MySQL datasource (separate connection that tested succesfully) and Google Docs source.
FYI, I am running it on multisite.
Hi jjanicik,
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.
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 jjanicik,
I successfully created a table on one of your sites. (Cit Driven Network)
You can take a look at attachment file.
Can you please tell me from which file did you try to make a table so I can try to reproduce the issue.
Also please clear the browser cache maybe this can be the issue.
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 jjanicik,
Glad to hear that everythig is working fine now.
You are welcome.
If you like our plugin and support we'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. It means a lot to us.
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 Jim,
Can you please tell me do you have installed mod_security on your server because the error ( date) is almost 90% related to that.
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
What do you mean by mod_security?
Is that in a plugin? If so, what are the possible names of the plugins?
Hi Jim,
That can be found on the server or asking hosting company.
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
Bogdan,
I just called my hosting company, which is GoDaddy, and they are telling me that this property cannot be modified because it is set in one place for all accounts on the shared server.
What hosting services are you aware of that have the option of turning mod_security off?
Also, if I modify my htaccess file on the GoDaddy site, what are the downsides or risks of using this solution?
Thanks,
Jim
I just added both of the modification that you suggested to my htaccess file and I am getting the same error.
See attached screenshot of error.
Please advise.
Hi Jim,
I am not very familiar with hosting services are able to turn off mod_securities so I can not tell you precisely the name of the hosting company.
The issue is that some hosting companies for some reason enable that mod_secuirty and applied it to the WordPress generally, so every lets say "suspicious" query is blacklisted and that is probably you get that date when you try to save some changes.
Can you please check your server log and tell me if there are some errors.
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
Bogdan,
It looks like the security block is coming from a plugin called Wordfence.
I temporarily disabled it and was able to modify and save a datatable.
Have you had others users ask you about Wordfence before?
Jim
Hi Jim,
Yes, there was some restrictions and issues with the Wordfence plugin but in some of the previous version of our plugin. We did not have any reports recently that there is a conflict with Wordfence and with the latest version of our plugin.
Maybe there was an update from the Wordfence recently.
I will take a look at their latest news to see if there were some update on their side.
Also it is possible to ask Wordfence team to whitelist our plugin so the issues like this would not happen.
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
Bogdan,
Any insights from Wordfence as to how to edit wpdatables successfully while Wordfence is still activated?
For the short term, I am deactivating Wordence while I do wpdatable editing.
Not a good long term solution, but it lets me keep moving forward.
One other question for you.
I have successfully created a manual table that is connected to another manual table that is being used as a foreign key.
I can successfully add new records in the admin screen by clicking on the "New" link at the top of the table.
However, when I embed the table on a page and view it from the Wordpress front end, there is no "New" link to insert a new record.
Please advise.
Thanks,
Jim
Hi Jim,
This issue with the Wordfence is forwarded to my team and in a meantime you can also contact their support to ask them to whitelist our plugin in this case there should not be any issues.
About the New button:
Can you please send me the link of that table/page 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 jjanicik,
It looks like there is some issue with the tag-cloud-widget plugin which is causing the JS error on the page which can be the issue.
Can you please deactivate that plugin and tell me 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
Deactivated and deleted that plugin.
Still do not see the New link.
Hi jjanicik,
For the second table on the page can you pleaes check if that table is set to be editable at all.
For the first table on the page you checked Popover edit block in the table settings ( attachment).
If you disable this option the buttons will appear next to the Table tools on top of the 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
It works!.
Awesome, thanks for all of your help getting me going.
HI jjanicik,
Glad to help you out.
You are welcome.
If you like our plugin and support we'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. It means a lot to us. Thanks.
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