woocommerce / woocommerce-admin

(Deprecated) This plugin has been merged to woocommerce/woocommerce
https://woocommerce.github.io/woocommerce-admin/#/
Other
361 stars 144 forks source link

[GlobalStep- WooCommerce 5.1 RC1]][PC] Database Error message is triggered upon clicking "Mollie Settings" linktext during Mollie payment setup. #6500

Closed gglobalstep closed 3 years ago

gglobalstep commented 3 years ago

Bug Description:

Database Error message is triggered upon clicking "Mollie Settings" linktext during Mollie payment setup

Test Instructions:

Add the Mollie payment provider setup task #6257: https://github.com/woocommerce/woocommerce/wiki/Release-Testing-Instructions-WooCommerce-5.1#add-the-mollie-payment-provider-setup-task-6257

Environment:

Woocommerce Version : WooCommerce 5.1 RC1 WordPress Beta Tester plugin (v5.7 RC2)

PC: Windows 10, Mac 10.14.6 Chrome(Version 88.0.4324.104) Firefox(Version 83.0) Safari: v13.1.2(13609.3.5.1.5)

Steps To Reproduce:

  1. Create any test site using JN site.
  2. Install and activate all the required plugins
  3. Complete the onboarding setup wizard and set up store address to United Kingdom.
  4. Go to the setup payments task on "WooCommerce->Home" Page
  5. Note that Mollie should be listed as an option
  6. Click "Setup" button on the Mollie task
  7. During the Setup process "Step 2: Connect your Mollie account" Note that you will observe "Mollie Settings" linktext, click on it
  8. Observe that Database Error message is triggered upon clicking "Mollie Settings" link during Mollie payment setup

Actual Result:

Database Error message is triggered upon clicking "Mollie Settings" linktext during Mollie payment setup

Expected Result:

"Mollie Settings" link text should smoothly navigate user to "Settings->Payments" option

Screenshot and Video:

#6500

https://user-images.githubusercontent.com/41110392/109829508-9ba7bd00-7c63-11eb-8613-0e591431336d.mov

Isolating the problem (mark completed items with an [x]):

``` ` ### WordPress Environment ### WordPress address (URL): https://liberal-cuckoo.jurassic.ninja Site address (URL): https://liberal-cuckoo.jurassic.ninja WC Version: 5.1.0 REST API Version: ✔ 5.1.0 WC Blocks Version: ✔ 4.4.3 Action Scheduler Version: ✔ 3.1.6 WC Admin Version: ✔ 2.0.1 Log Directory Writable: ✔ WP Version: 5.7-RC2 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: ✔ WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: Apache/2.4.46 (Unix) OpenSSL/1.0.2g PHP Version: 7.4.15 PHP Post Max Size: 1 GB PHP Time Limit: 30 PHP Max Input Vars: 5000 cURL Version: 7.47.0 OpenSSL/1.0.2g SUHOSIN Installed: – MySQL Version: 5.7.33-0ubuntu0.16.04.1-log Max Upload Size: 512 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 5.1.0 WC Database Prefix: wp_ Total Database Size: 4.86MB Database Data Size: 3.24MB Database Index Size: 1.62MB wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + 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.02MB + Index: 0.11MB + 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.02MB + Index: 0.03MB + Engine InnoDB wp_ce4wp_abandoned_checkout: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mollie_pending_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_options: Data: 2.03MB + Index: 0.09MB + Engine InnoDB wp_postmeta: Data: 0.22MB + Index: 0.19MB + Engine InnoDB wp_posts: Data: 0.11MB + Index: 0.06MB + 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: 0.02MB + Index: 0.02MB + Engine InnoDB wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wc_admin_notes: Data: 0.02MB + 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: 0.02MB + Index: 0.09MB + 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 ### Post Type Counts ### attachment: 27 customize_changeset: 9 nav_menu_item: 5 page: 9 post: 2 product: 48 product_variation: 48 revision: 3 shop_coupon: 1 shop_order: 3 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (17) ### Query Monitor: by John Blackbourn – 3.6.7 Akismet Anti-Spam: by Automattic – 4.1.8 Companion Plugin: by Osk – 1.18 Creative Mail by Constant Contact: by Constant Contact – 1.3.2 Facebook for WooCommerce: by Facebook – 2.3.2 Gutenberg: by Gutenberg Team – 10.1.0 Jetpack by WordPress.com: by Automattic – 9.5 Klarna Payments for WooCommerce: by krokedil klarna automattic – 2.3.0 Google Ads & Marketing by Kliken: by Kliken – 1.0.7 Mailchimp for WooCommerce: by Mailchimp – 2.5.0 Mollie Payments for WooCommerce: by Mollie – 6.1.0 WooCommerce Beta Tester: by WooCommerce – 2.0.2 WooCommerce PayPal Payments: by WooCommerce – 1.1.0 WooCommerce - ShipStation Integration: by WooCommerce – 4.1.41 WooCommerce: by Automattic – 5.1.0-rc.1 WordPress Beta Tester: by Peter Westwood Andy Fragen – 3.1.0 WP Crontrol: by John Blackbourn & crontributors – 1.10.0 ### Inactive Plugins (3) ### Hello Dolly: by Matt Mullenweg – 1.7.2 Ultimate Addons for Gutenberg: by Brainstorm Force – 1.21.0 WooCommerce Admin: by WooCommerce – 2.0.2 ### Dropin Plugins (1) ### db.php: Query Monitor Database Class ### Settings ### API Enabled: – Force SSL: – Currency: GBP (£) Currency Position: left 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: #6 - /shop/ Cart: #7 - /cart/ Checkout: #8 - /checkout/ My account: #9 - /my-account/ Terms and conditions: ❌ Page not set ### Theme ### Name: Twenty Twenty-One Version: 1.1 Author URL: https://wordpress.org/ 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: – ### Action Scheduler ### Canceled: 1 Oldest: 2021-03-03 07:26:53 +0000 Newest: 2021-03-03 07:26:53 +0000 Complete: 47 Oldest: 2021-03-03 07:26:53 +0000 Newest: 2021-03-03 13:34:50 +0000 ### Status report information ### Generated at: 2021-03-03 13:48:30 +00:00 ` ```
timmyc commented 3 years ago

Thank you for the report! The code path for this bug appears to be in the Mollie extension itself, and not in wc-admin. I have notified our partnership team of this and we will reach out to the Mollie team with details about this message. Since the warning does not impact the UI of the page and in this screenshot is only shown with a query manager plugin installed, I don't think we need to action upon this prior to the 5.1 release.

Since the message is being thrown by the plugin itself, and we can not change that in this repo, I'm going to close this as a won't/can't fix.