We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
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->queryAND...
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