Answers.Body: <p>Welcome to SE!  Those errors look to relate to WooCommerce, not CiviCRM.  What happens if you disable WooCommerce?</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-08T04:25:24.797Z
Answers.Text: Those are definitely WooCommerce and not CiviCRM errors.  However, if you can definitively say that the site works with CiviCRM disabled, and not when it's enabled, then it's likely your host gave you the wrong errors - it's not uncommon.
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-07T13:14:24.127Z
Answers.LastActivityDate: 2022-02-07T13:14:24.127Z
Answers.UserDisplayName: Aidan
Body: <p>When downloading civicrm it immediately shuts down the website due to error database</p>
  <p>Any help is much appreciated and is something I have been struggling with for MONTHS to figure out.
  This is the error my host says popped up:</p>
  <p><a href="https://paste.websitehostserver.net/text_2022-01-22_05-03-16_gDI32TmKk2" rel="nofollow noreferrer">https://paste.websitehostserver.net/text_2022-01-22_05-03-16_gDI32TmKk2</a>
  or
  &quot;[13-Jan-2022 04:51:44 UTC] PHP Warning:  include(): Failed opening '' for inclusion (include_path='.:/opt/alt/php74/usr/share/pear') in /home/greenp18/public_html/wp-content/plugins/woocommerce/includes/wc-template-functions.php on line 53
  [16-Jan-2022 11:24:25 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 ') AND meta_key LIKE 'attribute\<em>%'' at line 1 for query SELECT post_id as variation_id, meta_key as attribute_key, meta_value as attribute_value FROM wp73nj_postmeta WHERE post_id IN () AND meta_key LIKE 'attribute\</em>%' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get_template_part, locate_template, load_template, require('/themes/one-page-express/template-parts/content-page.php'), the_content, apply_filters('the_content'), WP_Hook-&gt;apply_filters, do_blocks, render_block, WP_Block-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock-&gt;render_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;get_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;prime_product_variations
  [16-Jan-2022 11:37:57 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 ') AND meta_key LIKE 'attribute\<em>%'' at line 1 for query SELECT post_id as variation_id, meta_key as attribute_key, meta_value as attribute_value FROM wp73nj_postmeta WHERE post_id IN () AND meta_key LIKE 'attribute\</em>%' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get_template_part, locate_template, load_template, require('/themes/one-page-express/template-parts/content-page.php'), the_content, apply_filters('the_content'), WP_Hook-&gt;apply_filters, do_blocks, render_block, WP_Block-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock-&gt;render_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;get_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;prime_product_variations
  [16-Jan-2022 18:35:46 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 ') AND meta_key LIKE 'attribute\<em>%'' at line 1 for query SELECT post_id as variation_id, meta_key as attribute_key, meta_value as attribute_value FROM wp73nj_postmeta WHERE post_id IN () AND meta_key LIKE 'attribute\</em>%' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get_template_part, locate_template, load_template, require('/themes/one-page-express/template-parts/content-page.php'), the_content, apply_filters('the_content'), WP_Hook-&gt;apply_filters, do_blocks, render_block, WP_Block-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock-&gt;render_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;get_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;prime_product_variations
  [17-Jan-2022 00:30:54 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 ') AND meta_key LIKE 'attribute\<em>%'' at line 1 for query SELECT post_id as variation_id, meta_key as attribute_key, meta_value as attribute_value FROM wp73nj_postmeta WHERE post_id IN () AND meta_key LIKE 'attribute\</em>%' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get_template_part, locate_template, load_template, require('/themes/one-page-express/template-parts/content-page.php'), the_content, apply_filters('the_content'), WP_Hook-&gt;apply_filters, do_blocks, render_block, WP_Block-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock-&gt;render_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;get_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;prime_product_variations
  [17-Jan-2022 02:09:15 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 ') AND meta_key LIKE 'attribute\<em>%'' at line 1 for query SELECT post_id as variation_id, meta_key as attribute_key, meta_value as attribute_value FROM wp73nj_postmeta WHERE post_id IN () AND meta_key LIKE 'attribute\</em>%' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get_template_part, locate_template, load_template, require('/themes/one-page-express/template-parts/content-page.php'), the_content, apply_filters('the_content'), WP_Hook-&gt;apply_filters, do_blocks, render_block, WP_Block-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock-&gt;render_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;get_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;prime_product_variations
  [17-Jan-2022 02:59:56 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 ') AND meta_key LIKE 'attribute\<em>%'' at line 1 for query SELECT post_id as variation_id, meta_key as attribute_key, meta_value as attribute_value FROM wp73nj_postmeta WHERE post_id IN () AND meta_key LIKE 'attribute\</em>%' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get_template_part, locate_template, load_template, require('/themes/one-page-express/template-parts/content-page.php'), the_content, apply_filters('the_content'), WP_Hook-&gt;apply_filters, do_blocks, render_block, WP_Block-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock-&gt;render_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;get_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;prime_product_variations
  [18-Jan-2022 02:12:51 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 ') AND meta_key LIKE 'attribute\<em>%'' at line 1 for query SELECT post_id as variation_id, meta_key as attribute_key, meta_value as attribute_value FROM wp73nj_postmeta WHERE post_id IN () AND meta_key LIKE 'attribute\</em>%' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get_template_part, locate_template, load_template, require('/themes/one-page-express/template-parts/content-page.php'), the_content, apply_filters('the_content'), WP_Hook-&gt;apply_filters, do_blocks, render_block, WP_Block-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock-&gt;render_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;get_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;prime_product_variations
  [18-Jan-2022 19:27:59 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 ') AND meta_key LIKE 'attribute\<em>%'' at line 1 for query SELECT post_id as variation_id, meta_key as attribute_key, meta_value as attribute_value FROM wp73nj_postmeta WHERE post_id IN () AND meta_key LIKE 'attribute\</em>%' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get_template_part, locate_template, load_template, require('/themes/one-page-express/template-parts/content-page.php'), the_content, apply_filters('the_content'), WP_Hook-&gt;apply_filters, do_blocks, render_block, WP_Block-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock-&gt;render_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;get_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;prime_product_variations
  [21-Jan-2022 02:53:56 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 ') AND meta_key LIKE 'attribute\<em>%'' at line 1 for query SELECT post_id as variation_id, meta_key as attribute_key, meta_value as attribute_value FROM wp73nj_postmeta WHERE post_id IN () AND meta_key LIKE 'attribute\</em>%' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get_template_part, locate_template, load_template, require('/themes/one-page-express/template-parts/content-page.php'), the_content, apply_filters('the_content'), WP_Hook-&gt;apply_filters, do_blocks, render_block, WP_Block-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock-&gt;render_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;get_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid-&gt;prime_product_variations&quot;</p>
  
Tags: <wordpress>
Title: CIVICRM plugin leads to database error
ThreadText: # CIVICRM plugin leads to database error
  
  (Asked by: username_0 on 2022-02-04)
  
  When downloading civicrm it immediately shuts down the website due to error database
  
  Any help is much appreciated and is something I have been struggling with for MONTHS to figure out.
  This is the error my host says popped up:
  
  <https://paste.websitehostserver.net/text_2022-01-22_05-03-16_gDI32TmKk2>
  or
  "[13-Jan-2022 04:51:44 UTC] PHP Warning: include(): Failed opening '' for inclusion (include\_path='.:/opt/alt/php74/usr/share/pear') in /home/greenp18/public\_html/wp-content/plugins/woocommerce/includes/wc-template-functions.php on line 53
  [16-Jan-2022 11:24:25 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 ') AND meta\_key LIKE 'attribute\*%'' at line 1 for query SELECT post\_id as variation\_id, meta\_key as attribute\_key, meta\_value as attribute\_value FROM wp73nj\_postmeta WHERE post\_id IN () AND meta\_key LIKE 'attribute\*%' made by require('wp-blog-header.php'), require\_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get\_template\_part, locate\_template, load\_template, require('/themes/one-page-express/template-parts/content-page.php'), the\_content, apply\_filters('the\_content'), WP\_Hook->apply\_filters, do\_blocks, render\_block, WP\_Block->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock->render\_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->get\_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->prime\_product\_variations
  [16-Jan-2022 11:37:57 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 ') AND meta\_key LIKE 'attribute\*%'' at line 1 for query SELECT post\_id as variation\_id, meta\_key as attribute\_key, meta\_value as attribute\_value FROM wp73nj\_postmeta WHERE post\_id IN () AND meta\_key LIKE 'attribute\*%' made by require('wp-blog-header.php'), require\_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get\_template\_part, locate\_template, load\_template, require('/themes/one-page-express/template-parts/content-page.php'), the\_content, apply\_filters('the\_content'), WP\_Hook->apply\_filters, do\_blocks, render\_block, WP\_Block->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock->render\_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->get\_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->prime\_product\_variations
  [16-Jan-2022 18:35:46 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 ') AND meta\_key LIKE 'attribute\*%'' at line 1 for query SELECT post\_id as variation\_id, meta\_key as attribute\_key, meta\_value as attribute\_value FROM wp73nj\_postmeta WHERE post\_id IN () AND meta\_key LIKE 'attribute\*%' made by require('wp-blog-header.php'), require\_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get\_template\_part, locate\_template, load\_template, require('/themes/one-page-express/template-parts/content-page.php'), the\_content, apply\_filters('the\_content'), WP\_Hook->apply\_filters, do\_blocks, render\_block, WP\_Block->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock->render\_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->get\_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->prime\_product\_variations
  [17-Jan-2022 00:30:54 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 ') AND meta\_key LIKE 'attribute\*%'' at line 1 for query SELECT post\_id as variation\_id, meta\_key as attribute\_key, meta\_value as attribute\_value FROM wp73nj\_postmeta WHERE post\_id IN () AND meta\_key LIKE 'attribute\*%' made by require('wp-blog-header.php'), require\_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get\_template\_part, locate\_template, load\_template, require('/themes/one-page-express/template-parts/content-page.php'), the\_content, apply\_filters('the\_content'), WP\_Hook->apply\_filters, do\_blocks, render\_block, WP\_Block->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock->render\_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->get\_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->prime\_product\_variations
  [17-Jan-2022 02:09:15 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 ') AND meta\_key LIKE 'attribute\*%'' at line 1 for query SELECT post\_id as variation\_id, meta\_key as attribute\_key, meta\_value as attribute\_value FROM wp73nj\_postmeta WHERE post\_id IN () AND meta\_key LIKE 'attribute\*%' made by require('wp-blog-header.php'), require\_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get\_template\_part, locate\_template, load\_template, require('/themes/one-page-express/template-parts/content-page.php'), the\_content, apply\_filters('the\_content'), WP\_Hook->apply\_filters, do\_blocks, render\_block, WP\_Block->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock->render\_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->get\_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->prime\_product\_variations
  [17-Jan-2022 02:59:56 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 ') AND meta\_key LIKE 'attribute\*%'' at line 1 for query SELECT post\_id as variation\_id, meta\_key as attribute\_key, meta\_value as attribute\_value FROM wp73nj\_postmeta WHERE post\_id IN () AND meta\_key LIKE 'attribute\*%' made by require('wp-blog-header.php'), require\_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get\_template\_part, locate\_template, load\_template, require('/themes/one-page-express/template-parts/content-page.php'), the\_content, apply\_filters('the\_content'), WP\_Hook->apply\_filters, do\_blocks, render\_block, WP\_Block->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock->render\_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->get\_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->prime\_product\_variations
  [18-Jan-2022 02:12:51 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 ') AND meta\_key LIKE 'attribute\*%'' at line 1 for query SELECT post\_id as variation\_id, meta\_key as attribute\_key, meta\_value as attribute\_value FROM wp73nj\_postmeta WHERE post\_id IN () AND meta\_key LIKE 'attribute\*%' made by require('wp-blog-header.php'), require\_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get\_template\_part, locate\_template, load\_template, require('/themes/one-page-express/template-parts/content-page.php'), the\_content, apply\_filters('the\_content'), WP\_Hook->apply\_filters, do\_blocks, render\_block, WP\_Block->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock->render\_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->get\_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->prime\_product\_variations
  [18-Jan-2022 19:27:59 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 ') AND meta\_key LIKE 'attribute\*%'' at line 1 for query SELECT post\_id as variation\_id, meta\_key as attribute\_key, meta\_value as attribute\_value FROM wp73nj\_postmeta WHERE post\_id IN () AND meta\_key LIKE 'attribute\*%' made by require('wp-blog-header.php'), require\_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get\_template\_part, locate\_template, load\_template, require('/themes/one-page-express/template-parts/content-page.php'), the\_content, apply\_filters('the\_content'), WP\_Hook->apply\_filters, do\_blocks, render\_block, WP\_Block->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock->render\_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->get\_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->prime\_product\_variations
  [21-Jan-2022 02:53:56 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 ') AND meta\_key LIKE 'attribute\*%'' at line 1 for query SELECT post\_id as variation\_id, meta\_key as attribute\_key, meta\_value as attribute\_value FROM wp73nj\_postmeta WHERE post\_id IN () AND meta\_key LIKE 'attribute\*%' made by require('wp-blog-header.php'), require\_once('wp-includes/template-loader.php'), include('/themes/one-page-express/page.php'), get\_template\_part, locate\_template, load\_template, require('/themes/one-page-express/template-parts/content-page.php'), the\_content, apply\_filters('the\_content'), WP\_Hook->apply\_filters, do\_blocks, render\_block, WP\_Block->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractBlock->render\_callback, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->render, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->get\_products, Automattic\WooCommerce\Blocks\BlockTypes\AbstractProductGrid->prime\_product\_variations"
  
  **Tags:** wordpress
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-02-07. Score: 2
  
  Welcome to SE! Those errors look to relate to WooCommerce, not CiviCRM. What happens if you disable WooCommerce?
  
  > **Comments:**
  > **username_2**: Those are definitely WooCommerce and not CiviCRM errors.  However, if you can definitively say that the site works with CiviCRM disabled, and not when it's enabled, then it's likely your host gave you the wrong errors - it's not uncommon.  
  
  ---
  
  