Okay
  Public Ticket #1267207
Can't create table
Closed

Comments

  •  2
    cbkscicon started the conversation

    Hello,

    I have just purchased wpDataTable, when I create a basic manual table I get the following error when I click to create:

    "

    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.

    "

    I'm not sure what the solution is, I'm using WordPress 4.8.1, I hope you can help quickly as I urgently need this table created in the next 48 hours!

    Many thanks indeed!!

    Hugh



  • [deleted] replied

    Hi Hugh,

    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