Return to previous page

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

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

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?

#233797 Copied Theme version: version 6.3.1

4 Answers

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/

#233801 Copied

Rose Tyler

Support staff

April 18, 2020 at 07:20

Hello,

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

Regards

#233860 Copied

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

#233871 Copied

Rose Tyler

Support staff

April 21, 2020 at 09:18

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

Regards

#234079 Copied
Viewing 5 results - 1 through 5 (of 5 total)