crashed tables in the database

  • Resolved Anonymous User 15521305

    (@anonymized-15521305)


    4 years, 6 months ago

    Hello,

    There were crashed tables in the database of my site. Is it related to your plugin? Here is the error log:

    [04-Sep-2020 05:01:05 UTC] ???????????????<200b>??????? Malformed packet ???????????? SELECT * FROM wpgy_trustindex_tripadvisor_reviews WHERE (rating IN (5) or rating IS NULL) and text != '' ORDER BY date DESC LIMIT 5 ??? require('wp-blog-header.php'), require_onc
includes/template-loader.php'), include('/themes/woodmart/page.php'), get_footer, locate_template, load_template, require_once('/themes/woodmart/footer.php'), wp_footer, do_action('wp_footer'), WP_Hook->do_action, WP_Hook->apply_filters, woodmart_mobile_menu, dyna
mic_sidebar, WP_Widget->display_callback, WOODMART_Static_Block_Widget->widget, woodmart_get_html_block, do_shortcode, preg_replace_callback, do_shortcode_tag, vc_do_shortcode, WPBakeryShortCode->output, WPBakeryShortCode_Vc_Row->content, WPBakeryShortCode->loadTe
mplate, require('/plugins/js_composer/include/templates/shortcodes/vc_row.php'), wpb_js_remove_wpautop, do_shortcode, preg_replace_callback, do_shortcode_tag, vc_do_shortcode, WPBakeryShortCode->output, WPBakeryShortCode->content, WPBakeryShortCode->loadTemplate,
require('/plugins/js_composer/include/templates/shortcodes/vc_column.php'), wpb_js_remove_wpautop, do_shortcode, preg_replace_callback, do_shortcode_tag, vc_do_shortcode, WPBakeryShortCode->output, WPBakeryShortCode->content, WPBakeryShortCode->loadTemplate, requi
re('/plugins/js_composer/include/templates/shortcodes/vc_tta_global.php'), WPBakeryShortCode_Vc_Tta_Accordion->getTemplateVariable, WPBakeryShortCode_Vc_Tta_Accordion->getParamContent, wpb_js_remove_wpautop, do_shortcode, preg_replace_callback, do_shortcode_tag, v
c_do_shortcode, WPBakeryShortCode->output, WPBakeryShortCode->content, WPBakeryShortCode->loadTemplate, require('/plugins/js_composer/include/templates/shortcodes/vc_tta_section.php'), WPBakeryShortCode_Vc_Tta_Accordion->getTemplateVariable, WPBakeryShortCode_Vc_T
ta_Section->getParamContent, wpb_js_remove_wpautop, do_shortcode, preg_replace_callback, do_shortcode_tag, vc_do_shortcode, WPBakeryShortCode->output, WPBakeryShortCode->content, WPBakeryShortCode->loadTemplate, require('/plugins/js_composer/include/templates/shor
tcodes/vc_column_text.php'), wpb_js_remove_wpautop, do_shortcode, preg_replace_callback, do_shortcode_tag, TrustindexPlugin->shortcode_func, TrustindexPlugin->get_noreg_list_reviews
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Trustindex

    (@trustindex)

    Hello @topsan123,

    It is a mysql client bug: it is about auth switch request. Your client is out of date and using a old protocol communication.

    You need to update or downgrade the MySQL Client first.

    My second advice is to try to change your username, and use only [a-z] and [0-9] characters.

    Is it solved your problem? If not:
    – What is your mysql’s version number?
    – What is your php’s version number?
    – What is your WordPress’s version number?

    Thread Starter Anonymous User 15521305

    (@anonymized-15521305)

    – Server version: 5.7.31-log – MySQL Community Server (GPL)
    – Php’s version number: 7.3
    – WordPress’s version numbe: 5.5.1

    Plugin Author Trustindex

    (@trustindex)

    Have you tried to eliminate special characters from your mysql username and password?

    • This reply was modified 4 years, 6 months ago by Trustindex.
    Thread Starter Anonymous User 15521305

    (@anonymized-15521305)

    I have normal character. I try to disable optimize plugins and your plugin to see which one causes the issue. I will update here later. Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘crashed tables in the database’ is closed to new replies.