As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #1261000
Ajax error message
Closed

Comments

  •  2
    mikecrbenton started the conversation
    August 1, 2017 at 9:06pm

    Hi,

    I've been working with 2.0 Datatables on my staging site.  When I tried to run a search through one of the column filters I got this error:


    Pop-up error:

    DataTables warning: table id=table_1 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

    Developer Tools/Console error:

    13/wp-admin/admin-ajax.php?action=get_wdtable&table_id=4 Failed to load resource: the server responded with a status of 500 (Internal Server Error)

    Thanks for your help!  Mike

  • [deleted] replied
    August 2, 2017 at 8:06am

    Hi mikecrbenton,


    This looks like some problem with your server response. Could you please check your server error log to see what is going on. You should be able to find it in cPanel or other hosting management solution  

  •  2
    mikecrbenton replied
    August 2, 2017 at 6:41pm

    Miljko,

    Thanks for your response.  I tried looking up the error log, and researching online.  I couldn't find anything concrete on what the propblem might be.  I posted the error log below.  Perhaps you might quickly see something that is a clue?  Thanks for your time! Mike


    [Tue Aug 01 20:54:38.231460 2017] [:error] [pid 13705] [client 24.116.121.62:41422] PHP Fatal error: Uncaught exception 'PHPSQLParser\\exceptions\\UnsupportedFeatureException' with message 'WHERE not implemented.' in /nas/content/staging/alliedgenetics/wp-content/plugins/wpdatatables/lib/PHPSQLParser/PHPSQLCreator.php:130\nStack trace:\n#0 /nas/content/staging/alliedgenetics/wp-content/plugins/wpdatatables/source/class.wpdatatable.php(1596): PHPSQLParser\\PHPSQLCreator->create(Array)\n#1 /nas/content/staging/alliedgenetics/wp-content/plugins/wpdatatables/controllers/wdt_ajax_actions.php(164): WPDataTable->queryBasedConstruct('SELECT * FROM w...', Array, Array)\n#2 [internal function]: wdtGetAjaxData('')\n#3 /nas/content/staging/alliedgenetics/wp-includes/class-wp-hook.php(298): call_user_func_array('wdtGetAjaxData', Array)\n#4 /nas/content/staging/alliedgenetics/wp-includes/class-wp-hook.php(323): WP_Hook->apply_filters('', Array)\n#5 /nas/content/staging/alliedgenetics/wp-includes/plugin.php(453): WP_Hook->do_action(Array)\n#6 /nas/content/staging/alliedgenetics/wp-admin/admin-ajax.php(91): do_action('wp_ajax_get_wdt. in /nas/content/staging/alliedgenetics/wp-content/plugins/wpdatatables/lib/PHPSQLParser/PHPSQLCreator.php on line 130, referer: http://alliedgenetics.staging.wpengine.com/soybeans/

  • [deleted] replied
    August 3, 2017 at 2:33pm

    Hi mikecrbenton,

    Could you please send me temporary admin credentials for this website so I can take a look?

  •  2
    Paul replied
    September 12, 2017 at 4:14pm

    Hi, was this ever resolved?  i found a way to work around this in 1.6.1 by changing the server method GET to POST. i am not sure if this is to true fix...but it worked for me. 

  • [deleted] replied
    September 13, 2017 at 9:40am

    Hi purcepa,

    Error from version 1.6.1 is not similar with this error. We already changed server method to POST from version 1.7.