Un utente ha chiesto informazioni su WooCommerce di Wordpress

Eventi cron importanti mancanti

Un utente ha chiesto πŸ‘‡

Ho avuto qualche problema con le vendite programmate che non le aggiornavano, all’inizio pensavamo fosse solo il wp cron che incasinava, quindi abbiamo impostato un cron job lato server.

Ad ogni modo, dopo aver installato WP Crontrol, non ho alcuni eventi cron di Woocommerce che dovrei avere.

Ho un accordo quasi identico con un sito gemello che funziona correttamente ed Γ¨ stato in grado di confrontare i due e i loro eventi cron.

Mi manca questo sito:
wc_admin_unsnooze_admin_notes
wc_admin_process_orders_milestone
woocommerce_cancel_unpaid_orders
wc_admin_daily
woocommerce_scheduled_sales

Non ho cancellato alcun evento cron in passato, infatti questa Γ¨ la prima volta che li incontro da quando ho provato a risolvere questo problema. C’Γ¨ qualche motivo per cui ciΓ² potrebbe accadere e un modo per risolverlo e prevenirlo in futuro?

Esiste una sorta di elenco di eventi cron predefinito da cui posso lavorare per aggiungere gli eventi o un modo per recuperare gli eventi cron mancanti?

Grazie mille,

Sophie

Supporto per plugin

(@riaanknoetze)

11 mesi, 1 settimana fa

Ciao,

Alcuni dei lavori CRON che hai elencato sarebbero rilevanti solo se stai utilizzando una versione relativamente breve di WooCommerce poichΓ© si concentra sulla nuova interfaccia di WooCommerce. Con questo in mente, puoi condividere una copia del tuo rapporto sullo stato come si trova in ** WooCommerce> Stato del sistema **?

Lanciatore di thread

(@sophierose)

11 mesi, 1 settimana fa

@riaanknoetze

Penso di avere l’ultima versione:


### WordPress Environment ###

WordPress address (URL): https://www.omgitssmall.com
Site address (URL): https://www.omgitssmall.com
WC Version: 4.0.1
REST API Version: βœ” 1.0.7
WC Blocks Version: βœ” 2.5.14
Action Scheduler Version: βœ” 3.1.4
WC Admin Version: βœ” 1.0.3
Log Directory Writable: βœ”
WP Version: 5.4
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: –
Language: en_CA
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.3.16
PHP Post Max Size: 128 MB
PHP Time Limit: 120
PHP Max Input Vars: 3000
cURL Version: 7.59.0
OpenSSL/1.0.2r

SUHOSIN Installed: –
MySQL Version: 5.6.40-84.0-log
Max Upload Size: 128 MB
Default Timezone is UTC: βœ”
fsockopen/cURL: βœ”
SoapClient: βœ”
DOMDocument: βœ”
GZip: βœ”
Multibyte String: βœ”
Remote Post: βœ”
Remote Get: βœ”

### Database ###

WC Database Version: 4.0.1
WC Database Prefix: yrou_
Total Database Size: 51.29MB
Database Data Size: 44.37MB
Database Index Size: 6.92MB
yrou_woocommerce_sessions: Data: 0.16MB + Index: 0.02MB + Engine InnoDB
yrou_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
yrou_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
yrou_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
yrou_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
yrou_woocommerce_order_itemmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
yrou_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
yrou_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
yrou_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
yrou_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
yrou_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
yrou_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
yrou_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
yrou_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
yrou_actionscheduler_actions: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
yrou_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
yrou_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
yrou_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
yrou_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
yrou_blc_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
yrou_blc_instances: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
yrou_blc_links: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
yrou_blc_synch: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
yrou_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
yrou_comments: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
yrou_crp_portfolios: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
yrou_crp_projects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
yrou_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
yrou_ngg_album: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
yrou_ngg_gallery: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
yrou_ngg_pictures: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
yrou_options: Data: 4.23MB + Index: 0.46MB + Engine MyISAM
yrou_postmeta: Data: 31.09MB + Index: 3.93MB + Engine MyISAM
yrou_posts: Data: 4.72MB + Index: 0.63MB + Engine MyISAM
yrou_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
yrou_revslider_css_bkp: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
yrou_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
yrou_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
yrou_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
yrou_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
yrou_revslider_sliders: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
yrou_revslider_sliders_bkp: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
yrou_revslider_slides: Data: 0.31MB + Index: 0.00MB + Engine InnoDB
yrou_revslider_slides_bkp: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
yrou_revslider_static_slides: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
yrou_revslider_static_slides_bkp: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
yrou_shipment_batch_process: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
yrou_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
yrou_termmeta: Data: 0.11MB + Index: 0.14MB + Engine InnoDB
yrou_terms: Data: 0.02MB + Index: 0.04MB + Engine MyISAM
yrou_term_relationships: Data: 0.11MB + Index: 0.21MB + Engine MyISAM
yrou_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
yrou_usermeta: Data: 0.06MB + Index: 0.02MB + Engine MyISAM
yrou_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
yrou_wcsc_error_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
yrou_wcsc_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
yrou_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
yrou_wc_product_meta_lookup: Data: 0.23MB + Index: 0.50MB + Engine InnoDB
yrou_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
yrou_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
yrou_woof_query_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
yrou_woo_shippment_provider: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
yrou_yoast_seo_links: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
yrou_yoast_seo_meta: Data: 0.23MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

aigpl_gallery: 8
album_gallery: 2
amn_exact-metrics: 1
attachment: 3440
br_product_filter: 2
custom_css: 1
customize_changeset: 4
kwlogos: 6
logoshowcase: 26
mc4wp-form: 1
mt_pp: 3
nav_menu_item: 31
oembed_cache: 3
page: 37
pdf_lv: 1
post: 39
product: 784
product_variation: 1251
revision: 1197
shop_coupon: 1
shop_order: 11
wpcf7_contact_form: 4
yith-wcbm-badge: 1
ywctm-button-label: 1

### Security ###

Secure connection (HTTPS): βœ”
Hide errors from visitors: βœ”

### Active Plugins (35) ###

Redux Framework: by Team Redux – 3.6.18
Advanced Cron Manager: by BracketSpace – 2.3.10
Album and Image Gallery Plus Lightbox Pro: by WP Online Support – 1.2.7
Broken Link Checker: by WPMU DEV – 1.11.12
Classic Editor: by WordPress Contributors – 1.5
Contact Form 7: by Takayuki Miyoshi – 5.1.7
Custom Related Products for WooCommerce: by Scott Nelle – 1.3 – Not tested with the active version of WooCommerce
Google Analytics Dashboard for WP (GADWP): by ExactMetrics – 6.0.2
WPBakery Page Builder: by Michael M - WPBakery.com – 6.1
Kirki Customizer Framework: by Ari Stathopoulos (@aristath) – 3.1.2
Loco Translate: by Tim Whitlock – 2.3.3
MC4WP: Mailchimp for WordPress: by ibericode – 4.7.6
Meta Box: by MetaBox.io – 5.2.10
User Profile Picture: by Ronald Huereca – 2.3.11
Multiple Packages for WooCommerce: by Erica Dion – 1.1 – Not tested with the active version of WooCommerce
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.3
Slider Revolution: by ThemePunch – 6.2.2
SEO Optimized Images: by priyanshu.mittal – 1.8
SG Optimizer: by SiteGround – 5.5.0
Simple CSS: by Tom Usborne – 1.1
Sober Addons: by UIX Themes – 1.4.2
Soo Demo Importer: by SooThemes – 1.1
Soo Product Filter: by UIX Themes – 1.0.8 – Not tested with the active version of WooCommerce
Sucuri Security - Auditing, Malware Scanner and Hardening: by Sucuri Inc. – 1.8.24
User Role Editor: by Vladimir Garagulya – 4.53.1
Variation Swatcher for WooCommerce: by ThemeAlien – 1.0.7 – Not tested with the active version of WooCommerce
Advanced Shipment Tracking for WooCommerce: by zorem – 2.9.5 – Not tested with the active version of WooCommerce
WooCommerce Product Categories Selection: by PluginForage.com – 2.0 – Not tested with the active version of WooCommerce
WooCommerce: by Automattic – 4.0.1
Yoast SEO: by Team Yoast – 13.5
WP-Cron Status Checker: by Webhead LLC – 1.2.1
WP Logo Showcase Responsive Slider: by WP OnlineSupport – 2.5.3
WP Smush Pro: by WPMU DEV – 2.7.8
WPMU DEV Dashboard: by WPMU DEV – 4.8.1
YITH WooCommerce Catalog Mode Premium: by YITH – 2.0.2 – Not tested with the active version of WooCommerce

### Inactive Plugins (0) ###

### Settings ###

API Enabled: βœ”
Force SSL: –
Currency: CAD ($)
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: #9 - /products/
Cart: #10 - /cart/
Checkout: #11 - /checkout/
My account: #12 - /my-account/
Terms and conditions: #4093 - /terms-of-use/

### Theme ###

Name: OMG it's small Custom Child
Version: 1.0.0
Author URL: http://thebearbranding.com/
Child Theme: βœ”
Parent Theme Name: OMG it's small Custom Child
Parent Theme Version: 2.3.0
Parent Theme Author URL: http://thebearbranding.com/
WooCommerce Support: βœ”

### Templates ###

Overrides: sober/woocommerce/cart/cart-shipping.php
sober/woocommerce/cart/cart.php
sober/woocommerce/cart/mini-cart.php
sober/woocommerce/checkout/form-checkout.php
sober/woocommerce/checkout/form-coupon.php
sober/woocommerce/checkout/form-login.php
sober/woocommerce/checkout/review-order.php
sober/woocommerce/global/form-login.php
sober/woocommerce/global/quantity-input.php
sober/woocommerce/global/wrapper-end.php
sober/woocommerce/global/wrapper-start.php
sober/woocommerce/loop/add-to-cart.php
sober/woocommerce/loop/price.php
sober/woocommerce/loop/result-count.php
sober/woocommerce/myaccount/dashboard.php
sober/woocommerce/myaccount/form-edit-account.php
sober/woocommerce/myaccount/form-login.php
sober/woocommerce/myaccount/my-address.php
sober/woocommerce/notices/error.php
sober/woocommerce/notices/success.php
sober/woocommerce/order/form-tracking.php
sober/woocommerce/single-product/add-to-cart/external.php
sober/woocommerce/single-product/add-to-cart/grouped.php
sober/woocommerce/single-product/add-to-cart/simple.php
sober/woocommerce/single-product/add-to-cart/variable.php
sober/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
sober/woocommerce/single-product/product-image.php
sober/woocommerce/single-product/product-thumbnails.php
sober/woocommerce/single-product/related.php
sober/woocommerce/single-product/review-meta.php
sober/woocommerce/single-product/tabs/additional-information.php
sober/woocommerce/single-product/tabs/tabs.php
sober/woocommerce/single-product/up-sells.php
sober/woocommerce/single-product-reviews.php

### Action Scheduler ###

Complete: 47
Oldest: 2020-03-31 10:13:10 +0000
Newest: 2020-04-27 10:39:53 +0000

Lanciatore di thread

(@sophierose)

11 mesi fa

Ciao qualcuno puΓ² aiutare?

Inoltre mi sembra di ricevere questi errori

Table 'omgitssm_27po_st1.yrou_wc_admin_notes' doesn't exist]
SELECT note_id FROM yrou_wc_admin_notes WHERE name = 'wc-admin-wc-helper-connection' ORDER BY note_id ASC

WordPress database error: [Table 'omgitssm_27po_st1.yrou_wc_admin_notes' doesn't exist]
SELECT note_id FROM yrou_wc_admin_notes WHERE name = 'wc-admin-wc-helper-connection' ORDER BY note_id ASC

WordPress database error: [Table 'omgitssm_27po_st1.yrou_wc_admin_notes' doesn't exist]
SELECT note_id FROM yrou_wc_admin_notes WHERE name = 'wc-admin-wc-helper-subscription' ORDER BY note_id ASC

WordPress database error: [Table 'omgitssm_27po_st1.yrou_wc_admin_notes' doesn't exist]
SHOW FULL COLUMNS FROM <code>yrou_wc_admin_notes</code>

WordPress database error: [Table 'omgitssm_27po_st1.yrou_wc_admin_note_actions' doesn't exist]
DELETE FROM yrou_wc_admin_note_actions WHERE note_id = 0

WordPress database error: [Table 'omgitssm_27po_st1.yrou_wc_admin_note_actions' doesn't exist]
SHOW FULL COLUMNS FROM <code>yrou_wc_admin_note_actions</code>

WordPress database error: [Table 'omgitssm_27po_st1.yrou_wc_admin_note_actions' doesn't exist]
SELECT action_id, name, label, query, status, is_primary FROM yrou_wc_admin_note_actions WHERE note_id = 0

WordPress database error: [Table 'omgitssm_27po_st1.yrou_wc_admin_notes' doesn't exist]
SELECT note_id FROM yrou_wc_admin_notes WHERE name = 'wc-update-db-reminder' ORDER BY note_id ASC

Che Γ¨ apparentemente da un aggiornamento di wordpress 4.0 e anche il problema sta causando il problema dei miei post di cron. Vedi un altro biglietto:

https://wordpress.org/support/topic/wordpress-database-error-table-during-upgrade-to-4-0/

@riaanknoetze qualche consiglio?

Was this helpful?

0 / 0

Lascia un commento 0

Your email address will not be published. Required fields are marked *