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

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/

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.