Hi @tonynakhla,
Thanks for reaching out to Google Listings & Ads support!
To help you better, first of all, could you please send me a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, you can paste it here in your reply.
Looking forward to hearing back from you.
### WordPress Environment ###
WordPress address (URL): http://localhost/best
Site address (URL): http://localhost/best
WC Version: 5.9.0
REST API Version: ✔ 5.9.0
WC Blocks Version: ✔ 6.1.0
Action Scheduler Version: ✔ 3.3.0
WC Admin Version: ✔ 2.8.0
Log Directory Writable: ✔
WP Version: 5.8.2
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_US
External object cache: –
### Server Environment ###
Server Info: Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.4.14
PHP Version: 7.4.14
PHP Post Max Size: 400 MB
PHP Time Limit: 600
PHP Max Input Vars: 1000
cURL Version: 7.70.0
OpenSSL/1.1.1h
SUHOSIN Installed: –
MySQL Version: 5.5.5-10.4.17-MariaDB
Max Upload Size: 400 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ❌ Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔
### Database ###
WC Database Version: 5.9.0
WC Database Prefix: wp_
Total Database Size: 79.81MB
Database Data Size: 62.61MB
Database Index Size: 17.20MB
wp_woocommerce_sessions: Data: 1.52MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.44MB + Index: 0.78MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 0.44MB + Index: 0.38MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 5.14MB + Index: 0.09MB + Engine InnoDB
wp_postmeta: Data: 42.56MB + Index: 9.03MB + Engine InnoDB
wp_posts: Data: 8.52MB + Index: 3.81MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 1.52MB + Index: 0.52MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 1.52MB + Index: 1.00MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wdp_orders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wdp_order_items: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wdp_rules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
### Post Type Counts ###
attachment: 9826
custom_css: 1
customize_changeset: 19
elementor_library: 20
envato_tk_import: 1
nav_menu_item: 38
page: 12
post: 3
product: 2734
revision: 498
shop_order: 3
shop_order_refund: 1
### Security ###
Secure connection (HTTPS): ❌
Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
Hide errors from visitors: ✔
### Active Plugins (11) ###
Elementor Pro: by Elementor.com – 3.3.0
Elementor: by Elementor.com – 3.2.4
ElementsKit Lite: by Wpmet – 2.3.1.1
Jetpack: by Automattic – 10.3
Template Kit Import: by Envato – 1.0.11
Themify - WooCommerce Product Filter: by Themify – 1.3.5
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.16.66
WooCommerce Stripe Gateway: by WooCommerce – 5.9.0
WooCommerce Payments: by Automattic – 3.3.0 (update to version 3.5.0 is available)
WooCommerce Shipping & Tax: by WooCommerce – 1.25.20
WooCommerce: by Automattic – 5.9.0 (update to version 6.0.0 is available)
### Inactive Plugins (2) ###
FiboSearch - AJAX Search for WooCommerce: by FiboSearch Team – 1.14.0
Google Listings and Ads: by WooCommerce – 1.9.0
### Settings ###
API Enabled: –
Force SSL: –
Currency: DirhamUae (AED)
Currency Position: right_space
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)
Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)
Connected to WooCommerce.com: –
### WC Pages ###
Shop base: #12 - /index.php/shop/
Cart: #13 - /index.php/cart/
Checkout: #14 - /index.php/checkout/
My account: #15 - /index.php/my-account/
Terms and conditions: ❌ Page not set
### Theme ###
Name: Hello Elementor
Version: 2.3.1 (update to version 2.4.2 is available)
Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ✔
### Templates ###
Overrides: –
### WooCommerce Payments ###
Version: 3.3.0
Connected to WPCOM: No
Blog ID: -
Account ID: -
### Action Scheduler ###
Complete: 1,826
Oldest: 2021-12-06 10:01:37 +0000
Newest: 2022-01-03 20:42:46 +0000
Pending: 1
Oldest: 2022-01-04 20:41:41 +0000
Newest: 2022-01-04 20:41:41 +0000
### Status report information ###
Generated at: 2022-01-03 20:43:09 +00:00
Hey @tonynakhla,
Thanks for sharing your System Status Report
.
It looks like when you are activating the extension it’s running into problems creating the required database tables.
It’s likely there is a problem with your database user permissions. Your site URL looks like it’s a local testing environment so I suggest referring to the documentation of the setup you’re using to ensure you have the required configuration.
However, please be aware that this extension relies heavily on connections to WordPress.com and Google accounts. On a local development environment, you’re likely going to run into connection issues that would prevent the extension from functioning properly.
I hope that helps!
Kind regards,
thanks for the replay but acutely I had this problem on a live site but I couldn’t access the wp-admin at all
but I fixed the problem and the website is good now I will give you the report for the live site
### WordPress Environment ###
WordPress address (URL): https://bestpricearts.com
Site address (URL): https://bestpricearts.com
WC Version: 5.9.0
REST API Version: ✔ 5.9.0
WC Blocks Version: ✔ 6.1.0
Action Scheduler Version: ✔ 3.3.0
WC Admin Version: ✔ 2.8.0
Log Directory Writable: ✔
WP Version: 5.8.2
WP Multisite: –
WP Memory Limit: ❌ 40 MB - We recommend setting memory to at least 64MB. See: Increasing memory allocated to PHP
WP Debug Mode: –
WP Cron: ✔
Language: en_US
External object cache: –
### Server Environment ###
Server Info: Apache
PHP Version: 8.1.0
PHP Post Max Size: 64 MB
PHP Time Limit: 50000
PHP Max Input Vars: 5000
cURL Version: 7.64.0
OpenSSL/1.1.1d
SUHOSIN Installed: –
MySQL Version: 5.5.5-10.5.12-MariaDB-1:10.5.12+maria~buster-log
Max Upload Size: 64 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔
### Database ###
WC Database Version: 5.9.0
WC Database Prefix: wp_
Total Database Size: 87.20MB
Database Data Size: 69.36MB
Database Index Size: 17.84MB
wp_woocommerce_sessions: Data: 2.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 1.17MB + Index: 0.70MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 1.22MB + Index: 0.38MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 6.06MB + Index: 1.06MB + Engine InnoDB
wp_postmeta: Data: 45.45MB + Index: 8.94MB + Engine InnoDB
wp_posts: Data: 9.52MB + Index: 3.80MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 1.45MB + Index: 0.42MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 1.52MB + Index: 0.94MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wdp_orders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wdp_order_items: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wdp_rules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
### Post Type Counts ###
attachment: 9826
custom_css: 1
customize_changeset: 19
elementor_library: 20
envato_tk_import: 1
nav_menu_item: 38
page: 12
post: 3
product: 2734
revision: 499
shop_order: 5
shop_order_refund: 1
### Security ###
Secure connection (HTTPS): ✔
Hide errors from visitors: ✔
### Active Plugins (12) ###
Elementor Pro: by Elementor.com – 3.3.0
Elementor: by Elementor.com – 3.2.4
ElementsKit Lite: by Wpmet – 2.3.1.1
Jetpack: by Automattic – 10.3
Template Kit Import: by Envato – 1.0.11
Themify - WooCommerce Product Filter: by Themify – 1.3.5
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.16.66
WooCommerce Stripe Gateway: by WooCommerce – 5.9.0
WooCommerce Payments: by Automattic – 3.3.0 (update to version 3.5.0 is available)
WooCommerce Shipping & Tax: by WooCommerce – 1.25.20
WooCommerce: by Automattic – 5.9.0 (update to version 6.0.0 is available)
### Inactive Plugins (2) ###
FiboSearch - AJAX Search for WooCommerce: by FiboSearch Team – 1.14.0
Google Listings and Ads: by WooCommerce – 1.9.0
### Settings ###
API Enabled: –
Force SSL: –
Currency: DirhamUae (AED)
Currency Position: right_space
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)
Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)
Connected to WooCommerce.com: –
### WC Pages ###
Shop base: #12 - /index.php/shop/
Cart: #13 - /index.php/cart/
Checkout: #14 - /index.php/checkout/
My account: #15 - /index.php/my-account/
Terms and conditions: ❌ Page not set
### Theme ###
Name: Hello Elementor
Version: 2.3.1 (update to version 2.4.2 is available)
Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ✔
### Templates ###
Overrides: –
### WooCommerce Payments ###
Version: 3.3.0
Connected to WPCOM: Yes
Blog ID: 200028997
Account ID: -
### Action Scheduler ###
Complete: 1,884
Oldest: 2021-12-06 10:01:37 +0000
Newest: 2022-01-04 13:50:29 +0000
Pending: 2
Oldest: 2022-01-04 15:50:29 +0000
Newest: 2022-01-05 13:29:51 +0000
### Status report information ###
Generated at: 2022-01-04 15:21:54 +00:00
Glad to hear that you solved the problem!
We also have a bug report for it here:
https://github.com/woocommerce/google-listings-and-ads/issues/746
Relevant details:
https://github.com/woocommerce/google-listings-and-ads/issues/746#issuecomment-997910536
So just for the record, this seems to affect folks on PHP 8.1, which your status report says you are using. If you see this again, temporarily downgrading to PHP 8.0 might be the best way to avoid it, at least until WordPress 5.9.0 is released.
Let us know if you need further help. Thanks!