“wp wc update” not working for me
-
After I did the instructed database update via the command line as instructed by the plugin, I get the following messages as response:
wp wc update Encontradas 2 actualizaciones (wc_update_650_approved_download_directories, wc_update_651_approved_download_directories) Actualizando la base de datos 100% [=================================================================================================================================] 0:00 / 0:00 Success: Actualizaciones de 2 completas. La versión de la base de datos es 6.4.0However when I visited /wp-admin/admin.php?page=wc-admin I still see:
WooCommerce database update required WooCommerce has been updated! To keep things running smoothly, we have to update your database to the newest version. The database update process runs in the background and may take a little while, so please be patient. Advanced users can alternatively update via WP CLI.Again the same instruction. So I do it again on the command line:
wp wc update Encontradas 2 actualizaciones (wc_update_650_approved_download_directories, wc_update_651_approved_download_directories) Actualizando la base de datos 100% [=================================================================================================================================] 0:00 / 0:00 Success: Actualizaciones de 2 completas. La versión de la base de datos es 6.4.0Apparently my previous attempt did not work, but following attempts give the same response. This is not getting me any further. It’s broken.
I am forced to do it through the web gui, which is a slower process, waiting for CRON etc. Can this please be fixed in future releases? Or for lack of a fix, could you please remove the wp-cli instruction instead, until it works again?
This makes me doubt the functionality of the “wp wc update” alternative all together because apparently it is not being tested.
-
Hi @erniecom
“wp wc update” hasn’t been reported to be not working. Do you see the same behavior if you go for it when all plugins except WooCommerce are disabled and a basic theme such as Storefront is active?
Here’s a tutorial: https://support.pagely.com/hc/en-us/articles/115003313251-Manually-Updating-Your-WooCommerce-Database-via-Command-Line
I deactivated all the plugins except woocommerce and changed to theme twentytwentytwo and I get identical results.
The wp-cli tutorial explains what I did I already. What the command returns is different though. According to the example of the tutorial in my case I would expect the following lines but they were missing :
Calling update function: wc_update_650_approved_download_directories
Calling update function: wc_update_651_approved_download_directoriesThese update functions are simply not called and consequently the db version stays at 6.4.0 as you can read in my original post.
Hello @erniecom!
For better assistance, please share your WooCommerce error logs and System Status on this thread so we can take a look at your configuration and check the issue further:
System Status: You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
Error Log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).
Thanks!
Hi all—please note this problem is now logged as a bug:
https://github.com/woocommerce/woocommerce/issues/33262
Thanks!
### WordPress Environment ### WordPress address (URL): https://dev.foto-r3.com Site address (URL): https://dev.foto-r3.com WC Version: 6.5.1 REST API Version: ✔ 6.5.1 WC Blocks Version: ✔ 7.4.3 Action Scheduler Version: ✔ 3.4.0 Log Directory Writable: ✔ WP Version: 6.0 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: – Language: es_ES External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.4.28 PHP Post Max Size: 256 MB PHP Time Limit: 3000 PHP Max Input Vars: 4000 cURL Version: 7.58.0 OpenSSL/1.1.1 SUHOSIN Installed: – MySQL Version: 5.7.38-0ubuntu0.18.04.1 Max Upload Size: 256 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 6.4.0 WC Database Prefix: wp_ Total Database Size: 542.62MB Database Data Size: 447.91MB Database Index Size: 94.71MB wp_woocommerce_sessions: Data: 34.56MB + Index: 1.52MB + 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: 1.52MB + Index: 1.52MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 14.52MB + Index: 12.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.52MB + Index: 0.66MB + 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.47MB + Index: 0.28MB + Engine InnoDB wp_b2s_posts: Data: 0.02MB + Index: 0.14MB + Engine InnoDB wp_b2s_posts_drafts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_b2s_posts_favorites: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_b2s_posts_network_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_b2s_posts_sched_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_b2s_user: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_b2s_user_contact: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_b2s_user_network_settings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cegg_autoblog: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_cegg_price_alert: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_cegg_price_history: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_cegg_product: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_commentmeta: Data: 0.20MB + Index: 0.23MB + Engine InnoDB wp_comments: Data: 4.52MB + Index: 3.56MB + Engine InnoDB wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB wp_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_e_submissions: Data: 0.31MB + Index: 0.59MB + Engine InnoDB wp_e_submissions_actions_log: Data: 0.08MB + Index: 0.11MB + Engine InnoDB wp_e_submissions_values: Data: 1.52MB + Index: 0.22MB + Engine InnoDB wp_frmt_form_entry: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_frmt_form_entry_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_frmt_form_views: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_gglcptch_allowlist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_iconic_was_fees: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nextend2_section_storage: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nextend2_smartslider3_sliders: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nextend2_smartslider3_slides: Data: 0.05MB + Index: 0.11MB + Engine InnoDB wp_options: Data: 6.52MB + Index: 1.69MB + Engine InnoDB wp_postmeta: Data: 148.56MB + Index: 29.11MB + Engine InnoDB wp_posts: Data: 164.52MB + Index: 4.20MB + Engine InnoDB wp_redirection_404: Data: 2.52MB + Index: 0.64MB + Engine InnoDB wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_redirection_logs: Data: 2.52MB + Index: 0.36MB + Engine InnoDB wp_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_sbi_instagram_posts: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_seur_custom_rates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_seur_svpr: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_sm_advanced_search_temp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_termmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_term_relationships: Data: 0.17MB + Index: 0.13MB + Engine InnoDB wp_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_trp_dictionary_en_us_es_es: Data: 3.52MB + Index: 3.20MB + Engine InnoDB wp_trp_dictionary_es_es_en_us: Data: 5.52MB + Index: 6.47MB + Engine InnoDB wp_trp_gettext_en_us: Data: 1.52MB + Index: 1.94MB + Engine InnoDB wp_trp_gettext_es_es: Data: 1.52MB + Index: 1.98MB + Engine InnoDB wp_trp_original_meta: Data: 1.52MB + Index: 0.84MB + Engine InnoDB wp_trp_original_strings: Data: 5.52MB + Index: 4.55MB + Engine InnoDB wp_usermeta: Data: 11.52MB + Index: 11.03MB + Engine InnoDB wp_useronline: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_users: Data: 1.52MB + Index: 0.55MB + Engine InnoDB wp_wcpdf_invoice_number: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_wcpdf_invoice_number_2021: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + 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.27MB + Index: 0.22MB + 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: 1.52MB + Index: 1.22MB + Engine InnoDB wp_wc_order_stats: Data: 0.31MB + Index: 0.30MB + Engine InnoDB wp_wc_order_tax_lookup: Data: 0.22MB + Index: 0.20MB + Engine InnoDB wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.20MB + Index: 0.45MB + Engine InnoDB wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + 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_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wfconfig: Data: 0.52MB + Index: 0.00MB + Engine InnoDB wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wffilemods: Data: 12.55MB + Index: 0.00MB + Engine InnoDB wp_wfhits: Data: 1.52MB + Index: 0.25MB + Engine InnoDB wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wfknownfilelist: Data: 8.52MB + Index: 0.00MB + Engine InnoDB wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wflogins: Data: 0.45MB + Index: 0.16MB + Engine InnoDB wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wfstatus: Data: 0.19MB + Index: 0.13MB + Engine InnoDB wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpf_filters: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_wpf_meta_data: Data: 0.25MB + Index: 0.73MB + Engine InnoDB wp_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpf_meta_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpf_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpf_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpf_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wt_iew_action_history: Data: 0.09MB + Index: 0.00MB + Engine InnoDB wp_wt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_yoast_indexable: Data: 2.52MB + Index: 0.97MB + Engine InnoDB wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_yoast_seo_links: Data: 0.25MB + Index: 0.17MB + Engine InnoDB wp_yoast_seo_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### attachment: 1735 custom_css: 2 elementor_font: 8 elementor_library: 78 forminator_forms: 2 iwp-importer: 1 language_switcher: 4 ml-slider: 1 nav_menu_item: 110 oembed_cache: 40 page: 51 pewc_field: 449 pewc_group: 109 pewc_product_extra: 602 post: 11 product: 813 product_variation: 31 revision: 3157 seur_labels: 48 shop_coupon: 22 shop_order: 2632 shop_order_refund: 15 sp_wps_shortcodes: 1 wc_mmqw: 3 wcps: 1 wcps_layout: 3 wp_global_styles: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (1) ### WooCommerce: by Automattic – 6.5.1 ### Inactive Plugins (42) ### Adapta RGPD: by Superadmin – 1.3.5 Advanced Order Export For WooCommerce: by AlgolPlus – 3.3.1 Bizum WooCommerce: by Bizum – 3.0.2 Correos Oficial: by Correos – 1.0.11 Cost of Goods for WooCommerce: by WPFactory – 2.5.7 DHL Express Commerce: by DHL Express – 3.0.0 Duplicate Page: by mndpsingh287 – 4.4.8 Easy WP SMTP: by wpecommerce alexanderfoxc – 1.4.7 Elementor: by Elementor.com – 3.6.5 Elementor Pro: by Elementor.com – 3.6.5 Envato Market: by Envato – 2.0.7 Foto R3: by René Nieuwburg – 1.0 Health Check & Troubleshooting: by The WordPress.org community – 1.4.5 Mailhog for WordPress: by Tareq Hasan – 1.0.1 Minimum and Maximum Quantity for WooCommerce: by theDotstore – 1.0.6 Product Filter by WooBeWoo: by WooBeWoo – 2.1.4 reCaptcha by BestWebSoft: by BestWebSoft – 1.67 Redirection: by John Godley – 5.2.3 Redsys WooCommerce: by Redsys – 3.1.1 REHub Framework: by Wpsoul – 17.3 RH WooCommerce Tools: by Wpsoul.com – 1.1.6 Safe SVG: by 10up – 2.0.1 SEUR Oficial: by José Conti – 1.8.1 Show Stock Status for WooCommerce: by Bright Plugins – 1.0.3 Site Kit by Google: by Google – 1.75.0 TranslatePress - Multilingual: by Cozmoslabs Razvan Mocanu Madalin Ungureanu Cristophor Hurduban – 2.2.7 WC - APG NIF/CIF/NIE Field: by Art Project Group – 1.7.2.3 WooCommerce PayPal Payments: by WooCommerce – 1.8.0 WooCommerce PDF Invoices & Packing Slips: by WP Overnight – 2.14.5 WooCommerce PDF Invoices & Packing Slips Premium Templates: by WP Overnight – 2.18.1 WooCommerce Product Add-Ons Ultimate: by Plugin Republic – 3.9.7 WooCommerce Product Attachment: by theDotstore – 2.1.3 WooCommerce Shipping & Tax: by WooCommerce – 1.26.0 WooCommerce Stripe Gateway: by WooCommerce – 6.4.0 Woo Product Filter PRO: by WooBeWoo – 2.1.4 Wordfence Security: by Wordfence – 7.5.10 WP-UserOnline: by Lester 'GaMerZ' Chan – 2.87.6 WP Crontrol: by John Blackbourn & crontributors – 1.12.1 WP Fastest Cache: by Emre Vona – 1.0.1 WP Fastest Cache Premium: by Emre Vona – 1.6.4 WP Overnight Sidekick: by Jeremiah Prummer Ewout Fernhout Michael Kluver – 2.4.0 Yoast SEO: by Team Yoast – 18.9 ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Settings ### API Enabled: ✔ Force SSL: – Currency: EUR (€) Currency Position: right 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: ✔ Enforce Approved Product Download Directories: – ### WC Pages ### Shop base: #17564 - /tienda/ Cart: #23 - /carrito/ Checkout: #24 - /finalizar-compra/ My account: ❌ Page does not contain the [woocommerce_my_account] shortcode. Terms and conditions: #10725 - /politicas/ ### Theme ### Name: Twenty Twenty-Two Version: 1.2 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 ### Complete: 1,849 Oldest: 2022-04-29 19:27:11 +0200 Newest: 2022-05-31 10:28:09 +0200 Pending: 1 Oldest: 2022-05-31 10:28:19 +0200 Newest: 2022-05-31 10:28:19 +0200 ### Status report information ### Generated at: 2022-05-31 10:28:30 +02:00There are many logs but none is on the dates I ran the command and are related to payment transactions which is not our case.
Hello @erniecom,
Thanks for sharing the system report.
As you can see for Barry’s comment above, this bug has since been confirmed and a fix in underway. Feel free to follow the progress here: https://github.com/woocommerce/woocommerce/issues/33262
I’ll go ahead and close this topic as at this moment there’s nothing further we can do here in the forum.
Thanks for reporting this issue!
Cool, thanks!
Hello,
If you have any further questions, I recommend creating a new thread, since this one is tagged already as resolved.
Be sure to follow the updates on GitHub about the issue reported.
Thank you.
The topic ‘“wp wc update” not working for me’ is closed to new replies.