Okay
  Public Ticket #1634213
" There was an error while trying to save the table! Not Found "
Open

Comments

  • kakashimateo started the conversation

    Bought this plugin today and getting this error on almost anything I try to do. System specs:

    PHP Version 7.0.18
    MySQL Version 5.6.36
    Zip extension Installed
    Curl extension 7.19.7

    Using TwentySeventeen theme on WP 4.9.7. 

  •  407
    Bogdan replied

    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.

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •   kakashimateo replied privately
  •   Bogdan replied privately
  •   kakashimateo replied privately
  •  407
    Bogdan replied

    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.

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  • kakashimateo replied

    Dear Bogdan, 

    Please create any table and you shall see that error appears. Especially with merged tables. 

  •  407
    Bogdan replied

    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.

    Attached files:  Screen Shot 2018-07-11 at 12.30.08 PM.png

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  • kakashimateo replied

    Dear Bogdan, 

    Turning off Word fence doesn't change anything. Hosting provider informed me that mod_security is turned on.

  •  407
    Bogdan replied

    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.

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  • kakashimateo replied

    Dear Bogdan,

    I tried to use your hint with .htaccess but still same error appeared when finalizing creation with Generator. However this time I copied MySQL code and tried to create table manually, which worked fine... It seems there could be some problem with Generator rather than security. Could you please check again? Website is in beta so I do not mind you do some tests. 

  • kakashimateo replied

    Dear Bogdan,

    Just an update: I noticed, that generator breaks when I try to link the mysql data with user_ID or user_email. 

  •  407
    Bogdan replied

    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.

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net