I find some issues in the log files, - by liuhui5318

This topic has 5 replies, 2 voices, and was last updated 3 years, 10 months ago ago by Rose Tyler

  • Avatar: liuhui5318
    liuhui5318
    Participant
    April 17, 2020 at 13:51

    my website host in cloudways.com, i find many Error Logs.

    such as:

    [Fri Apr 17 07:15:24.459625 2020] [proxy_fcgi:error] [pid 3489] [client 223.104.1.159:41364] AH01071: Got error ‘PHP message: 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 ‘) GROUP BY terms.term_id’ at line 15 for query SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, terms.term_id as term_count_id FROM wp_posts \n INNER JOIN wp_term_relationships AS term_relationships ON wp_posts.ID = term_relationships.object_id\n INNER JOIN wp_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )\n INNER JOIN wp_terms AS terms USING( term_id )\n LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) \n WHERE wp_posts.post_type IN ( ‘product’ )\n AND wp_posts.post_status = ‘publish’ AND ( \n wp_posts.ID NOT IN (\n\t\t\t\tSELECT object_id\n\t\t\t\tFROM wp_term_relationships\n\t\t\t\tWHERE term_taxonomy_id IN (7)\n\t\t\t) \n AND \n wp_term_relationships.term_taxonomy_id IN (68)\n)AND terms.term_id IN () GROUP BY terms.term_id made by require(‘wp-…\n’, referer: https://www.giganoble.com/

    [Thu Apr 16 04:06:53.605703 2020] [proxy_fcgi:error] [pid 22560] [client 38.39.232.223:60526] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught Error: Cannot use object of type WP_Error as array in /home/395337.cloudwaysapps.com/axpushujdn/public_html/wp-content/plugins/et-core-plugin/app/controllers/admin/import.php:717\nStack trace:\n#0 /home/395337.cloudwaysapps.com/axpushujdn/public_html/wp-content/plugins/et-core-plugin/app/controllers/admin/import.php(181): ETC\\App\\Controllers\\Admin\\Import->import_variations_trems(‘product_variati…’)\n#1 /home/395337.cloudwaysapps.com/axpushujdn/public_html/wp-includes/class-wp-hook.php(288): ETC\\App\\Controllers\\Admin\\Import->import_data(”)\n#2 /home/395337.cloudwaysapps.com/axpushujdn/public_html/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters(”, Array)\n#3 /home/395337.cloudwaysapps.com/axpushujdn/public_html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)\n#4 /home/395337.cloudwaysapps.com/axpushujdn/public_html/wp-admin/admin-ajax.php(175): do_action(‘wp_ajax_etheme_…’)\n#5 {main}\n thrown in /home/395337.cloudwaysapps.com/axpushujdn/public_html/w…\n’, referer: https://www.giganoble.com/wp-admin/admin.php?page=et-panel-demos

    how to fix?

    4 Answers
    Avatar: liuhui5318
    liuhui5318
    Participant
    April 17, 2020 at 14:54

    i think the plugin et-core-plugin is causing the error as it seems to be faulty.

    after deactivate this plugin and check in the logs, The error will be no more.

    Error in your SQL syntax:

    GROUP BY terms.term_id’ at line 15 for query SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, terms.term_id as term_count_id FROM wp_posts \n INNER JOIN wp_term_relationships AS term_relationships ON wp_posts.ID = term_relationships.object_id\n INNER JOIN wp_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )\n INNER JOIN wp_terms AS terms USING( term_id )\n LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) \n WHERE wp_posts.post_type IN ( ‘product’ )\n AND wp_posts.post_status = ‘publish’ AND ( \n wp_posts.ID NOT IN (\n\t\t\t\tSELECT object_id\n\t\t\t\tFROM wp_term_relationships\n\t\t\t\tWHERE term_taxonomy_id IN (7)\n\t\t\t) \n AND \n wp_term_relationships.term_taxonomy_id IN (68)\n)AND terms.term_id IN () GROUP BY terms.term_id made by require(‘wp-…\n’, referer: https://www.giganoble.com/

    Avatar: Rose Tyler
    Rose Tyler
    Support staff
    April 18, 2020 at 07:20

    Hello,

    Could you, please, provide temporary wp-admin and FTP access?

    Regards

    Avatar: Rose Tyler
    Rose Tyler
    Support staff
    April 18, 2020 at 08:51

    Did you import only 1 demo version or a few? What exactly versions? It was a full import or particular elements like pages http://prntscr.com/s1nww6 ? Please describe it in detail.

    Regards

    Avatar: Rose Tyler
    Rose Tyler
    Support staff
    April 21, 2020 at 09:18

    What version of WooCommerce plugin do you use? Did you update WC database?

    Regards

  • Viewing 5 results - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.Log in/Sign up

We're using our own and third-party cookies to improve your experience and our website. Keep on browsing to accept our cookie policy.