Please refer to my many requests for help this week, this errors I found could help you with these issues I am having with wpdatables and wp datatables gravity forms integration, please help!
[19-Dec-2021 14:25:30 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1' at line 1 for query SELECT SQL_CALC_FOUND_RO
WS DISTINCT `t1`.`id` FROM `wpv0_gf_entry` AS `t1` LEFT JOIN `wpv0_gf_entry_meta` AS `m3` ON `m3`.`entry_id` = `t1`.`id` LEFT JOIN `wpv0_gf_entry_meta` AS `o2` ON (`o2`.`entry_id` = `t1`.`id` AND `o2`.`meta_key` = 17) WHERE (`t1`.`form_i
d` IN (25) AND (`t1`.`status` = 'active' AND `m3`.`meta_value` LIKE '%%')) ORDER BY `o2`.`meta_value` DESC LIMIT -1 made by do_action('wp_ajax_get_wdtable'), WP_Hook->do_action, WP_Hook->apply_filters, wdtGetAjaxData, do_action('wpdatata
bles_generate_gravity'), WP_Hook->do_action, WP_Hook->apply_filters, WDTGravityIntegrationPlugin::gravityBasedConstruct, WDTGravityIntegrationPlugin::generateFormArray, GFAPI::get_entries, GF_Query->get, GF_Query->query
[19-Dec-2021 14:25:30 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1' at line 1 for query SELECT SQL_CALC_FOUND_RO
WS DISTINCT `t1`.`id` FROM `wpv0_gf_entry` AS `t1` LEFT JOIN `wpv0_gf_entry_meta` AS `m3` ON `m3`.`entry_id` = `t1`.`id` LEFT JOIN `wpv0_gf_entry_meta` AS `o2` ON (`o2`.`entry_id` = `t1`.`id` AND `o2`.`meta_key` = 1) WHERE (`t1`.`form_id
` IN (51) AND (`t1`.`status` = 'active' AND `m3`.`meta_value` LIKE '%%')) ORDER BY `o2`.`meta_value` ASC LIMIT -1 made by do_action('wp_ajax_get_wdtable'), WP_Hook->do_action, WP_Hook->apply_filters, wdtGetAjaxData, do_action('wpdatatabl
es_generate_gravity'), WP_Hook->do_action, WP_Hook->apply_filters, WDTGravityIntegrationPlugin::gravityBasedConstruct, WDTGravityIntegrationPlugin::generateFormArray, GFAPI::get_entries, GF_Query->get, GF_Query->query
[19-Dec-2021 14:25:36 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1' at line 1 for query SELECT SQL_CALC_FOUND_RO
WS DISTINCT `t1`.`id` FROM `wpv0_gf_entry` AS `t1` LEFT JOIN `wpv0_gf_entry_meta` AS `o2` ON (`o2`.`entry_id` = `t1`.`id` AND `o2`.`meta_key` = 20) WHERE (`t1`.`form_id` IN (25) AND `t1`.`status` = 'active') ORDER BY `o2`.`meta_value` AS
C LIMIT -1 made by do_action('wp_ajax_wdt_gravity_save_table_config'), WP_Hook->do_action, WP_Hook->apply_filters, WDTGravityIntegrationPlugin::saveTableConfig, WDTConfigController::saveTableConfig, WPDataTable::loadWpDataTable, WPDataT
able->fillFromData, do_action('wpdatatables_generate_gravity'), WP_Hook->do_action, WP_Hook->apply_filters, WDTGravityIntegrationPlugin::gravityBasedConstruct, WDTGravityIntegrationPlugin::generateFormArray, GFAPI::get_entries, GF_Quer
y->get, GF_Query->query
[19-Dec-2021 14:25:39 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1' at line 1 for query SELECT SQL_CALC_FOUND_RO
WS DISTINCT `t1`.`id` FROM `wpv0_gf_entry` AS `t1` LEFT JOIN `wpv0_gf_entry_meta` AS `o2` ON (`o2`.`entry_id` = `t1`.`id` AND `o2`.`meta_key` = 4) WHERE (`t1`.`form_id` IN (25) AND (`t1`.`status` = 'active' AND `t1`.`date_created` >= '20
21-11-19 05:00:00' AND `t1`.`date_created` <= '2021-12-20 04:59:59')) ORDER BY `o2`.`meta_value` ASC LIMIT -1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/Divi/page.php'), the_c
ontent, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, ET_Builder_Element->_render, ET_Builder_Section->render, do_shortcode, preg_replace_callback, do_shortcode_tag, ET_Build
er_Element->_render, ET_Builder_Row->render, do_shortcode, preg_replace_callback, do_shortcode_tag, ET_Builder_Element->_render, ET_Builder_Column->render, do_shortcode, preg_replace_callback, do_shortcode_tag, ET_Builder_Element->_rende
r, do_shortcode, preg_replace_callback, do_shortcode_tag, wdtWpDataTableShortcodeHandler, WPDataTable->fillFromData, do_action('wpdatatables_generate_gravity'), WP_Hook->do_action, WP_Hook->apply_filters, WDTGravityIntegrationPlugin::gr
avityBasedConstruct, WDTGravityIntegrationPlugin::generateFormArray, GFAPI::get_entries, GF_Query->get, GF_Query->query
[19-Dec-2021 14:25:40 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1' at line 1 for query SELECT SQL_CALC_FOUND_RO
WS DISTINCT `t1`.`id` FROM `wpv0_gf_entry` AS `t1` LEFT JOIN `wpv0_gf_entry_meta` AS `o2` ON (`o2`.`entry_id` = `t1`.`id` AND `o2`.`meta_key` = 20) WHERE (`t1`.`form_id` IN (25) AND `t1`.`status` = 'active') ORDER BY `o2`.`meta_value` AS
C LIMIT -1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/Divi/page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback,
do_shortcode_tag, ET_Builder_Element->_render, ET_Builder_Section->render, do_shortcode, preg_replace_callback, do_shortcode_tag, ET_Builder_Element->_render, ET_Builder_Row->render, do_shortcode, preg_replace_callback, do_shortcode_tag,
ET_Builder_Element->_render, ET_Builder_Column->render, do_shortcode, preg_replace_callback, do_shortcode_tag, ET_Builder_Element->_render, do_shortcode, preg_replace_callback, do_shortcode_tag, wdtWpDataTableShortcodeHandler, WPDataTab
le->fillFromData, do_action('wpdatatables_generate_gravity'), WP_Hook->do_action, WP_Hook->apply_filters, WDTGravityIntegrationPlugin::gravityBasedConstruct, WDTGravityIntegrationPlugin::generateFormArray, GFAPI::get_entries, GF_Query-
>get, GF_Query->query
[19-Dec-2021 14:25:40 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1' at line 1 for query SELECT SQL_CALC_FOUND_RO
WS DISTINCT `t1`.`id` FROM `wpv0_gf_entry` AS `t1` LEFT JOIN `wpv0_gf_entry_meta` AS `o2` ON (`o2`.`entry_id` = `t1`.`id` AND `o2`.`meta_key` = 1) WHERE (`t1`.`form_id` IN (51) AND `t1`.`status` = 'active') ORDER BY `o2`.`meta_value` ASC
LIMIT -1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/Divi/page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, d
o_shortcode_tag, ET_Builder_Element->_render, ET_Builder_Section->render, do_shortcode, preg_replace_callback, do_shortcode_tag, ET_Builder_Element->_render, ET_Builder_Element->_render, ET_Builder_Section->render, do_shortcode, preg_rep
lace_callback, do_shortcode_tag, ET_Builder_Element->_render, ET_Builder_Row->render, do_shortcode, preg_replace_callback, do_shortcode_tag, ET_Builder_Element->_render, ET_Builder_Column->render, do_shortcode, preg_replace_callback, do_
shortcode_tag, ET_Builder_Element->_render, do_shortcode, preg_replace_callback, do_shortcode_tag, wdtWpDataTableShortcodeHandler, WPDataTable->fillFromData, do_action('wpdatatables_generate_gravity'), WP_Hook->do_action, WP_Hook->apply_
filters, WDTGravityIntegrationPlugin::gravityBasedConstruct, WDTGravityIntegrationPlugin::generateFormArray, GFAPI::get_entries, GF_Query->get, GF_Query->query
[19-Dec-2021 14:25:41 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1' at line 1 for query SELECT SQL_CALC_FOUND_RO
WS DISTINCT `t1`.`id` FROM `wpv0_gf_entry` AS `t1` LEFT JOIN `wpv0_gf_entry_meta` AS `m3` ON `m3`.`entry_id` = `t1`.`id` LEFT JOIN `wpv0_gf_entry_meta` AS `o2` ON (`o2`.`entry_id` = `t1`.`id` AND `o2`.`meta_key` = 5) WHERE (`t1`.`form_id
` IN (25) AND ((`t1`.`status` = 'active' AND `t1`.`date_created` >= '2021-11-19 05:00:00' AND `t1`.`date_created` <= '2021-12-20 04:59:59') AND `m3`.`meta_value` LIKE '%%')) ORDER BY `o2`.`meta_value` DESC LIMIT -1 made by do_action('wp_
ajax_get_wdtable'), WP_Hook->do_action, WP_Hook->apply_filters, wdtGetAjaxData, do_action('wpdatatables_generate_gravity'), WP_Hook->do_action, WP_Hook->apply_filters, WDTGravityIntegrationPlugin::gravityBasedConstruct, WDTGravityIntegr
ationPlugin::generateFormArray, GFAPI::get_entries, GF_Query->get, GF_Query->query
[19-Dec-2021 14:25:41 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1' at line 1 for query SELECT SQL_CALC_FOUND_RO
WS DISTINCT `t1`.`id` FROM `wpv0_gf_entry` AS `t1` LEFT JOIN `wpv0_gf_entry_meta` AS `m3` ON `m3`.`entry_id` = `t1`.`id` LEFT JOIN `wpv0_gf_entry_meta` AS `o2` ON (`o2`.`entry_id` = `t1`.`id` AND `o2`.`meta_key` = 1) WHERE (`t1`.`form_id
` IN (51) AND (`t1`.`status` = 'active' AND `m3`.`meta_value` LIKE '%%')) ORDER BY `o2`.`meta_value` ASC LIMIT -1 made by do_action('wp_ajax_get_wdtable'), WP_Hook->do_action, WP_Hook->apply_filters, wdtGetAjaxData, do_action('wpdatatabl
es_generate_gravity'), WP_Hook->do_action, WP_Hook->apply_filters, WDTGravityIntegrationPlugin::gravityBasedConstruct, WDTGravityIntegrationPlugin::generateFormArray, GFAPI::get_entries, GF_Query->get, GF_Query->query
AND...
[19-Dec-2021 14:26:08 UTC] PHP Warning: Illegal offset type in isset or empty in /home/carreromortgage/public_html/upload/wp-includes/capabilities.php on line 621
[19-Dec-2021 14:26:08 UTC] PHP Warning: Illegal offset type in isset or empty in /home/carreromortgage/public_html/upload/wp-includes/class-wp-user.php on line 796
Please refer to my many requests for help this week, this errors I found could help you with these issues I am having with wpdatables and wp datatables gravity forms integration, please help!
AND...
Hi David,
We see that you open more similar tickets and we will continue on this one
https://tmsplugins.ticksy.com/ticket/2939763
and we will close others.
Thank you for understanding.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables