search

woocommerce / woocommerce-admin

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

4.4.0-> 4.5.2 DB issues with wc_admin_notes and wp_wc_admin_note_actions tables #5463

Closed megaginge closed 3 years ago

megaginge commented 4 years ago

Hello

Upgraded from 4.4.0 to 4.5.2 today.

UX is all fine but issues with column is_deleted in the wc_admin_notes table:

Unknown column 'is_deleted' in 'where clause'] SELECT * FROM wp_wc_admin_notes WHERE 1=1 AND name IN ('wc-admin-coupon-page-moved') AND is_deleted = 1 ORDER BY date_created DESC LIMIT 0, 10

WordPress database error: [Unknown column 'is_deleted' in 'where clause'] SELECT * FROM wp_wc_admin_notes WHERE 1=1 AND status IN ('unactioned') AND name IN ('wc-admin-coupon-page-moved') AND is_deleted = 0 ORDER BY date_created DESC LIMIT 0, 10

WordPress database error: [Unknown column 'actioned_text' in 'field list'] SELECT action_id, name, label, query, status, is_primary, actioned_text FROM wp_wc_admin_note_actions WHERE note_id = 0

Etc.

Presumably the patch between 4.4 and 4.5.2 has some issues.

For ref, I ran the below (After taking a backup) to suppress my local trouble:

alter table wp_wc_admin_notes add column is_deleted bool; alter table wp_wc_admin_note_actions add column is_deleted bool; alter table wp_wc_admin_note_actions add column actioned_text varchar(255); alter table wp_wc_admin_note_actions add column layout varchar(255); alter table wp_wc_admin_notes add column layout varchar(255); alter table wp_wc_admin_notes add column image varchar(255);

I did run the wordpress DB update after updating the plugin, these issues persisted that.

My issue seems resolved, though not ideal as I could not assume what you intended with your DB schema. So please advise?

Thanks Dave

rrennick commented 4 years ago

@megaginge The WooCommerce and WC Admin database update routines run via scheduled actions (Tools -> Scheduled Actions). At the time you reported this had you checked to see whether there were any Pending update routine actions?

michahenn commented 3 years ago

Same problem here but no pending actions.

michahenn commented 3 years ago

2020/09/25 02:40:17 [error] 5926#5926: 227531 FastCGI sent in stderr: "PHP message: WordPress-Datenbank-Fehler Unknown column 'is_deleted' in 'where clause' für Abfrage SELECT FROM XXXXwc_admin_notes WHERE 1=1 AND type IN ('survey') AND status IN ('actioned') AND is_deleted = 0 ORDER BY date_created DESC LIMIT 0, 15 von do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes::possibly_delete_survey_notes, WC_Data_Store->call, Automattic\WooCommerce\Admin\Notes\DataStore->get_notesPHP message: WordPress-Datenbank-Fehler Unknown column 'is_deleted' in 'where clause' für Abfrage SELECT FROM XXXXwc_admin_notes WHERE 1=1 AND name IN ('wc-admin-coupon-page-moved') AND is_deleted = 1 ORDER BY date_created DESC LIMIT 0, 15 von do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Coupon_Page_Moved::possibly_add_note, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Coupon_Page_Moved::can_be_added, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Coupon_Page_Moved::has_dismissed_note, WC_Data_Store->__call, Automattic\WooCommerce\Admin\Notes\DataStore->get_notesPHP message: WordPress-Datenbank-Fehler Unknown column 'is_deleted' in 'where clause' für Abfrage SELECT FROM XXXXwc_admin_notes WHERE 1=1 AND status IN ('unactioned') AND name IN ('wc-admin-coupon-page-moved') AND is_deleted = 0 ORDER BY date_created DESC LIMIT 0, 15 von do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Coupon_Page_Moved::possibly_add_note, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Coupon_Page_Moved::can_be_added, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Coupon_Page_Moved::has_unactioned_note, WC_Data_Store->call, Automattic\WooCommerce\Admin\Notes\DataStore->get_notes" while reading response header from upstream, client: 116.202.232.94, server: textilsucht.de, request: "GET /wp-admin/admin-ajax.php?action=wc

michahenn commented 3 years ago

`

WordPress Environment

WordPress address (URL): https://www.textilsucht.de Site address (URL): https://www.textilsucht.de WC Version: 4.5.2 REST API Version: ✔ 4.5.2 WC Blocks Version: ✔ 3.1.0 Action Scheduler Version: ✔ 3.1.6 WC Admin Version: ✔ 1.5.0 Log Directory Writable: ✔ WP Version: 5.5.1 WP Multisite: – WP Memory Limit: 7 GB WP Debug Mode: – WP Cron: – Language: de_DE External object cache: –

Server Environment

Server Info: nginx/1.16.1 PHP Version: 7.4.9 PHP Post Max Size: 100 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.52.1 OpenSSL/1.0.2u

SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.24-MariaDB-1:10.3.24+maria~stretch Max Upload Size: 100 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔

Database

WC Database Version: 4.5.2 WC Database Prefix: HdZlUviG Datenbank-Gesamtgröße: 2907.73MB Datenbank-Datengröße: 1951.92MB Datenbank-Indexgröße: 955.81MB HdZlUviGwoocommerce_sessions: Daten: 2.26MB + Index: 0.08MB + Engine MyISAM HdZlUviGwoocommerce_api_keys: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM HdZlUviGwoocommerce_attribute_taxonomies: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwoocommerce_downloadable_product_permissions: Daten: 13.46MB + Index: 11.87MB + Engine MyISAM HdZlUviGwoocommerce_order_items: Daten: 7.73MB + Index: 3.52MB + Engine MyISAM HdZlUviGwoocommerce_order_itemmeta: Daten: 58.42MB + Index: 40.21MB + Engine MyISAM HdZlUviGwoocommerce_tax_rates: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM HdZlUviGwoocommerce_tax_rate_locations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwoocommerce_shipping_zones: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwoocommerce_shipping_zone_locations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwoocommerce_shipping_zone_methods: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwoocommerce_payment_tokens: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwoocommerce_payment_tokenmeta: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM HdZlUviGwoocommerce_log: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM cerber_acl: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB cerber_blocks: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB cerber_countries: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB cerber_lab: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB cerber_lab_ip: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB cerber_lab_net: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB cerber_log: Daten: 0.06MB + Index: 0.05MB + Engine InnoDB cerber_traffic: Daten: 17.55MB + Index: 1.52MB + Engine InnoDB HdZlUviGAalb_Asin_Response: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGaawp_lists: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM HdZlUviGaawp_products: Daten: 0.44MB + Index: 0.04MB + Engine MyISAM HdZlUviGactionscheduler_actions: Daten: 6.20MB + Index: 1.73MB + Engine MyISAM HdZlUviGactionscheduler_claims: Daten: 0.06MB + Index: 0.12MB + Engine MyISAM HdZlUviGactionscheduler_groups: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM HdZlUviGactionscheduler_logs: Daten: 4.74MB + Index: 2.50MB + Engine MyISAM HdZlUviGadvads_clicks: Daten: 0.09MB + Index: 0.00MB + Engine InnoDB HdZlUviGadvads_impressions: Daten: 43.58MB + Index: 0.00MB + Engine InnoDB HdZlUviGaelia_dismissed_messages: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGberocket_termmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGblc_filters: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGblc_instances: Daten: 3.52MB + Index: 1.06MB + Engine InnoDB HdZlUviGblc_links: Daten: 12.52MB + Index: 3.31MB + Engine InnoDB HdZlUviGblc_synch: Daten: 1.52MB + Index: 0.42MB + Engine InnoDB HdZlUviGcmplz_cookiebanners: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGcmplz_cookies: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM HdZlUviGcmplz_dnsmpd: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGcmplz_services: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM HdZlUviGcmplz_statistics: Daten: 1.33MB + Index: 0.61MB + Engine MyISAM HdZlUviGcn_social_icon: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGcommentmeta: Daten: 0.25MB + Index: 0.23MB + Engine InnoDB HdZlUviGcomments: Daten: 22.55MB + Index: 15.09MB + Engine InnoDB HdZlUviGessb3_click_stats: Daten: 1.52MB + Index: 0.00MB + Engine InnoDB HdZlUviGewwwio_images: Daten: 50.58MB + Index: 29.19MB + Engine InnoDB HdZlUviGewwwio_queue: Daten: 0.38MB + Index: 0.22MB + Engine InnoDB HdZlUviGfailed_jobs: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGFinalTiles_gallery: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGFinalTiles_gallery_images: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGjet_post_types: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGjet_smart_filters_indexer: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGjet_taxonomies: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGlinkcategorymeta: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGlinks: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB HdZlUviGmailchimp_carts: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGmanage_schedule: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGms_snippets: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGmwd_display_options: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGmwd_forms: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGmwd_forms_backup: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGmwd_forms_blocked: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGmwd_forms_sessions: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGmwd_forms_submits: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGmwd_forms_views: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGmwd_themes: Daten: 0.14MB + Index: 0.00MB + Engine InnoDB HdZlUviGnovomap_gmap: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGnovomap_marker: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGnovomap_marker_logo: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGoptions: Daten: 64.53MB + Index: 2.48MB + Engine InnoDB HdZlUviGorgseriesicons: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGpostmeta: Daten: 962.98MB + Index: 733.98MB + Engine InnoDB HdZlUviGposts: Daten: 65.56MB + Index: 18.06MB + Engine InnoDB HdZlUviGpost_views: Daten: 494.00MB + Index: 0.00MB + Engine InnoDB HdZlUviGqueue: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGratings: Daten: 0.11MB + Index: 0.06MB + Engine InnoDB HdZlUviGrevslider_css: Daten: 0.13MB + Index: 0.00MB + Engine InnoDB HdZlUviGrevslider_layer_animations: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGrevslider_navigations: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGrevslider_settings: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGrevslider_sliders: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGrevslider_slides: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGrevslider_static_slides: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGsbi_instagram_feeds_posts: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGsbi_instagram_posts: Daten: 0.11MB + Index: 0.00MB + Engine MyISAM HdZlUviGseorankreporter: Daten: 0.06MB + Index: 0.00MB + Engine InnoDB HdZlUviGshirtee_import_products: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGshirtee_import_product_insert_cron: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGshirtee_import_settings: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGshirtee_import_woo_orders: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGshortpixel_folders: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB HdZlUviGshortpixel_meta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB HdZlUviGsib_model_contact: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM HdZlUviGsib_model_country: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM HdZlUviGsib_model_forms: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM HdZlUviGsib_model_users: Daten: 3.96MB + Index: 0.19MB + Engine MyISAM HdZlUviGsnippets: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM HdZlUviGspu_hits_logs: Daten: 9.52MB + Index: 4.55MB + Engine InnoDB HdZlUviGstoreabill_documentmeta: Daten: 11.52MB + Index: 10.03MB + Engine InnoDB HdZlUviGstoreabill_documents: Daten: 2.52MB + Index: 1.05MB + Engine InnoDB HdZlUviGstoreabill_document_itemmeta: Daten: 8.52MB + Index: 9.03MB + Engine InnoDB HdZlUviGstoreabill_document_items: Daten: 1.52MB + Index: 0.86MB + Engine InnoDB HdZlUviGstoreabill_document_noticemeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB HdZlUviGstoreabill_document_notices: Daten: 1.52MB + Index: 0.19MB + Engine InnoDB HdZlUviGstoreabill_journals: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB HdZlUviGtermmeta: Daten: 0.09MB + Index: 0.11MB + Engine InnoDB HdZlUviGterms: Daten: 0.23MB + Index: 0.22MB + Engine InnoDB HdZlUviGterm_relationships: Daten: 0.30MB + Index: 0.16MB + Engine InnoDB HdZlUviGterm_taxonomy: Daten: 0.30MB + Index: 0.20MB + Engine InnoDB HdZlUviGtm_taskmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB HdZlUviGtm_tasks: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB HdZlUviGusermeta: Daten: 13.52MB + Index: 10.03MB + Engine InnoDB HdZlUviGusers: Daten: 1.52MB + Index: 0.50MB + Engine InnoDB HdZlUviGwc_admin_notes: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwc_admin_note_actions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwc_category_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwc_customer_lookup: Daten: 4.03MB + Index: 2.79MB + Engine MyISAM HdZlUviGwc_download_log: Daten: 7.03MB + Index: 6.26MB + Engine MyISAM HdZlUviGwc_order_coupon_lookup: Daten: 0.04MB + Index: 0.07MB + Engine MyISAM HdZlUviGwc_order_product_lookup: Daten: 5.98MB + Index: 4.40MB + Engine MyISAM HdZlUviGwc_order_stats: Daten: 2.91MB + Index: 2.25MB + Engine MyISAM HdZlUviGwc_order_tax_lookup: Daten: 2.39MB + Index: 2.54MB + Engine MyISAM HdZlUviGwc_product_meta_lookup: Daten: 0.02MB + Index: 0.03MB + Engine MyISAM HdZlUviGwc_reserved_stock: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGwc_tax_rate_classes: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM HdZlUviGwc_webhooks: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwoocommerce_bundled_itemmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB HdZlUviGwoocommerce_bundled_items: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB HdZlUviGwoocommerce_gzd_dhl_labelmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwoocommerce_gzd_dhl_labels: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwoocommerce_gzd_shipmentmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwoocommerce_gzd_shipments: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwoocommerce_gzd_shipment_itemmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwoocommerce_gzd_shipment_items: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM HdZlUviGwoocommerce_gzd_shipping_provider: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwoocommerce_gzd_shipping_providermeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGwpmailsmtp_tasks_meta: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGwponlinebackup_activity_log: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB HdZlUviGwponlinebackup_event_log: Daten: 0.25MB + Index: 0.06MB + Engine InnoDB HdZlUviGwponlinebackup_generations: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB HdZlUviGwponlinebackup_items: Daten: 1.64MB + Index: 2.52MB + Engine MyISAM HdZlUviGwponlinebackup_local: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB HdZlUviGwponlinebackup_scan_log: Daten: 0.16MB + Index: 0.08MB + Engine InnoDB HdZlUviGwponlinebackup_status: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB HdZlUviGyith_wcaf_affiliates: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGyith_wcaf_clicks: Daten: 0.02MB + Index: 0.01MB + Engine MyISAM HdZlUviGyith_wcaf_commissions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGyith_wcaf_commission_notes: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGyith_wcaf_payments: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGyith_wcaf_payment_commission: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGyith_wcaf_payment_notes: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM HdZlUviGyoast_indexable: Daten: 23.56MB + Index: 23.61MB + Engine InnoDB HdZlUviGyoast_indexable_hierarchy: Daten: 0.11MB + Index: 0.19MB + Engine InnoDB HdZlUviGyoast_migrations: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB HdZlUviGyoast_primary_term: Daten: 0.06MB + Index: 0.03MB + Engine InnoDB HdZlUviGyoast_seo_links: Daten: 7.52MB + Index: 6.97MB + Engine InnoDB HdZlUviGyoast_seo_meta: Daten: 3.52MB + Index: 0.00MB + Engine InnoDB HdZlUviGzem_rp_tags: Daten: 0.09MB + Index: 0.09MB + Engine InnoDB woof_query_cache: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB

Post Type Counts

aawp_table: 2 acf-field: 6 acf-field-group: 1 advanced_ads: 8 aiosrs-schema: 2 amn_exact-metrics: 1 amp_validated_url: 3 attachment: 35619 br_labels: 2 custom_css: 9 customize_changeset: 12 dgd_scrollbox: 1 document_template: 98 elementor_font: 3 elementor_library: 74 feedback: 120 grid_template: 7 invoice: 26444 jet-menu: 14 jet-smart-filters: 11 jet-woo-builder: 1 kadslider: 1 logocarousel: 4 mc4wp-form: 2 nav_menu_item: 230 ninja-table: 1 oembed_cache: 69 opanda-item: 2 page: 54 post: 540 product: 159 product_variation: 80 qa_faqs: 3 raccartlist: 42 racemailtemplate: 2 revision: 1412 safecss: 1 saswp: 6 shop_coupon: 633 shop_order: 55051 shop_order_refund: 13 smart_faq: 1 spucpt: 7 tablepress_table: 6 testimonials-widget: 1 tt_font_control: 1 user_request: 5 woo_discount: 4 woo_discount_cart: 1 woo_faq: 1 woo_mb_template: 12 wpb_fp_shortcode_gen: 1 wysijap: 1

Security

Secure connection (HTTPS): ✔ Hide errors from visitors: ✔

Active Plugins (73)

TablePress Extension: Responsive Tables: von Tobias Bäthge – 1.7 AAWP: von AAWP – 3.14.1 Advanced Ads Pro: von Advanced Ads GmbH – 2.10.0 Advanced Ads – Responsive Anzeigen: von Advanced Ads GmbH – 1.9.2 Advanced Ads – Ad Tracking: von Advanced Ads GmbH – 1.21.0 Advanced Ads: von Thomas Maier Advanced Ads GmbH – 1.20.1

Advanced Custom Fields: von Elliot Condon – 5.9.1 AMP: von Mitwirkende des AMP-Projekts – 2.0.4 Black Studio TinyMCE Widget: von Black Studio – 2.6.9 CC & BCC for Woocommerce Order Emails: von Dario Curasì – 1.4.1 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet Classic Editor: von WordPress Contributors – 1.6 Cloudflare: von Cloudflare Inc. – 3.6.0

Code Snippets: von Code Snippets Pro – 2.14.0 Complianz Privacy Suite (GDPR/CCPA) Premium: von Really Simple Plugins – 4.7.2 Custom Related Products for WooCommerce: von Scott Nelle – 1.3 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet Customer Reviews for WooCommerce: von Customer Reviews – 3.126 Easy Social Share Buttons for WordPress: von CreoApps – 7.4 Elementor Pro: von Elementor.com – 3.0.5 Elementor: von Elementor.com – 3.0.10 Enable jQuery Migrate Helper: von The WordPress Team – 1.0.1 Envato Market: von Envato – 2.0.5 Facebook for WooCommerce: von Facebook – 2.0.1 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet Health Check & Troubleshooting: von Die WordPress.org-Community – 1.4.5 Image Watermark: von dFactory – 1.6.6 Smash Balloon Instagram Feed: von Smash Balloon – 2.4.6 JetBlog For Elementor: von Crocoblock – 2.2.9 JetElements For Elementor: von Crocoblock – 2.3.3 JetSmartFilters: von Crocoblock – 2.0.0 Jetpack von WordPress.com: von Automattic – 8.9.1 Klarna Order Management for WooCommerce: von klarna krokedil – 1.6.0

Klarna Payments for WooCommerce: von krokedil klarna automattic – 2.1.2 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet

Loco Translate: von Tim Whitlock – 2.4.3 Newsletter, SMTP, Email marketing and Subscribe forms by Sendinblue: von Sendinblue – 3.0.7 Max Mega Menu: von megamenu.com – 2.9.0.2 Nginx Helper: von rtCamp – 2.2.2 No noopener noreferrer - Don’t add rel="noopener noreferrer": von Matthew Tatum – 1.0.0 Novo-Map: von novo-media – 1.0.10 Post Views Counter: von Digital Factory – 1.3.2 Öffentliche Vorschau für Beiträge: von Dominik Schilling – 2.9.1 Quick Page/Post Redirect Plugin: von anadnet – 5.2.0 Rel Nofollow Checkbox: von Fabio Santos – 1.1.5 Restore Link Title Field: von Otto – 1.3 Revive Old Posts - Share Excerpts: von Revive Social – 1.0.0 RSS Image Feed: von Stefan Crämer – 4.2.5 Schema & Structured Data for WP & AMP: von Magazine3 – 1.9.49.1 ShortPixel Image Optimizer: von ShortPixel – 4.20.2 Table of Contents Plus: von Michael Tran – 2002 TablePress Extension: Automatic URL conversion: von Tobias Bäthge – 1.3 TablePress: von Tobias Bäthge – 1.12 TinyMCE Advanced: von Andrew Ozz – 5.5.0 Revive Old Posts Pro Add-on: von revive.social – 2.3.5 Revive Old Posts: von revive.social – 8.5.17 Vendidero Helper: von Vendidero – 1.3.0 Aelia Foundation Classes for WooCommerce: von Aelia – 2.0.21.200904 WPC Frequently Bought Together for WooCommerce: von WPClever.net – 3.3.2 Woo Discount Rules: von Flycart Technologies LLP – 2.2.2 PayPal PLUS für WooCommerce: von Inpsyde GmbH – 2.2.1 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet WPC Product Bundles for WooCommerce: von WPClever.net – 5.3.2 WooCommerce Admin: von WooCommerce – 1.5.0 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet WooCommerce Stripe-Gateway: von WooCommerce – 4.5.2 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet Germanized für WooCommerce Pro: von vendidero – 3.0.7 Germanized für WooCommerce: von vendidero – 3.2.0 WooCommerce Product SKU Generator: von SkyVerge – 2.4.5 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet WooCommerce Sendinblue Newsletter Subscription: von Sendinblue – 2.0.1 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet WooCommerce Sequential Order Numbers: von SkyVerge – 1.9.5 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet Aelia Tax Display by Country for WooCommerce: von Aelia – 1.15.1.200904 WooCommerce: von Automattic – 4.5.2 WooCommerce Email Customizer with Drag and Drop Email Builder: von Flycart Technologies LLP – 1.5.16 Yoast SEO: von Team Yoast – 14.9 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet WP Last Modified Info: von Sayan Datta – 1.7.2 WP Review: von MyThemeShop – 5.3.4 WP Rollback: von Impress.org – 1.7.1 Yoast SEO: WooCommerce: von Team Yoast – 13.5 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet

Inactive Plugins (18)

Advanced Ads – Selling Ads: von Thomas Maier – 1.2.6 Autoptimize: von Frank Goossens (futtta) – 2.7.7 Better Search Replace: von Delicious Brains – 1.3.3 Broken Link Checker: von WPMU DEV – 1.11.14 EWWW Image Optimizer: von Exactly WWW – 5.7.1 Free Downloads WooCommerce: von Square One Media – 3.2.0 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet Recover Abandoned Cart: von Fantastic Plugins – 22.0 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet Regenerate Thumbnails: von Alex Mills (Viper007Bond) – 3.1.3 Reminder for WooCommerce Unpaid Orders: von MB Création – 2.7.2 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet Resize Image After Upload: von ShortPixel – 1.8.6 Schema Pro: von Brainstorm Force – 1.6.1 ShortPixel Adaptive Images: von ShortPixel – 2.0.6 Sofortueberweisung / Klarna Gateway for Woocommerce: von Michael Leithold – 1.3.3 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet WP-Optimize - Clean, Compress, Cache: von David Anderson Ruhani Rabin Team Updraft – 3.1.4

WP-PostRatings: von Lester 'GaMerZ' Chan – 1.89 WPC Composite Products for WooCommerce: von WPClever.net – 3.1.3 WP Mail SMTP: von WPForms – 2.4.0 YITH WooCommerce Affiliates Premium: von YITH – 1.7.0 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet

Dropin Plugins (1)

maintenance.php: maintenance.php

Must Use Plugins (1)

Health Check Troubleshooting Mode: von – 1.7.2

Settings

API Enabled: – Force SSL: – Currency: EUR (€) Currency Position: right_space Thousand Separator: . Decimal Separator: , Number of Decimals: 2 Taxonomies: Product Types: bundle (bundle) composite (composite) external (external) grouped (grouped) simple (simple) variable (variable) woosb (woosb)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-catalog (exclude-from-catalog-2) 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) rated-5 (rated-5-2)

Connected to WooCommerce.com: ✔

WC Pages

Shop-Basis: woocommerce/woocommerce#5330 - /shop/ Warenkorb: woocommerce/woocommerce#5331 - /warenkorb/ Kasse: ❌ Die Seite enthält nicht den Shortcode. Mein Konto: ❌ Die Seite enthält nicht den Shortcode. Allgemeine Geschäftsbedingungen: woocommerce/woocommerce#1373 - /agb/

Theme

Name: Astra Version: 2.5.5 Author URL: https://wpastra.com/about/ Child Theme: ❌ – Wenn du WooCommerce mit einem Theme das du nicht selbst entwickelt hast an eigene Bedürfnisse anpasst dann empfehlen wir die Verwendung eines Child-Themes. Siehe Wie du ein Child-Theme erstellst (engl.)

WooCommerce Support: ✔

Templates

Overrides: –

Action Scheduler

Abgebrochen: 2 Oldest: 2020-09-23 14:41:35 +0200 Newest: 2020-09-23 15:09:29 +0200

Abgeschlossen: 7.970 Oldest: 2020-09-06 18:15:07 +0200 Newest: 2020-09-25 11:08:41 +0200

Fehlgeschlagen: 11.399 Oldest: 2020-08-04 08:15:52 +0200 Newest: 2020-09-25 11:02:13 +0200

In Bearbeitung: 1 Oldest: – Newest: –

Ausstehend: 1 Oldest: 2020-10-01 23:03:00 +0200 Newest: 2020-10-01 23:03:00 +0200

`

rrennick commented 3 years ago

Transferring this issue to the WooCommerce Admin repository

ilyasfoo commented 3 years ago

I was unable to reproduce the issue by manually installing WooCommerce 4.4.0 and upgrading to 4.5.2 via upload plugin in wp-admin.

I want to also add that the some of the column changes mentioned in the report were introduced in WooCommerce 4.3.3, not 4.4.0, so there could be more context to this that's missing.

github-actions[bot] commented 3 years ago

This issue has been automatically marked as stale because it has not had any recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

github-actions[bot] commented 3 years ago

This issue was automatically closed due to being stale. Please feel free to re-open it if you still experience this problem.