Okay
  Public Ticket #2941365
ERRORS in Tables- display all not workinf
Closed

Comments

  • David started the conversation

    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


  •  471
    Isidora replied

    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: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables