hubchau

Forum Replies Created

Viewing 7 replies - 1 through 7 (of 7 total)
  • Forum: Plugins
    In reply to: [WooCommerce] Updating digital donwload file breaks donwloadability for previous customers
    Thread Starter hubchau

    (@hubchau)

    1 year, 4 months ago

    Hi,

    I was able to update the DB and to reattach the most recent/valid download_id to all matching orders.

    I guess this issue is resolved and I must ensure it doesn’t happen again 🙂

    Forum: Plugins
    In reply to: [WooCommerce] Updating digital donwload file breaks donwloadability for previous customers
    Thread Starter hubchau

    (@hubchau)

    1 year, 4 months ago

    Soooo, while trying to record my screen to highlight my issue, it appears that I’m not able to reproduce it and that by clicking the “Choose file” button and picking up a new version of my PDF as I stated in my initial message, orders placed on the previous version are properly updated to point at the newest PDF.

    So now, as somehow something went wrong or someone made a mistake, I need to fix all orders that are now missing their link to a pdf (I’d say round 505~510 orders). Do you think I could play a bit with PHP or phpMyAdmin to:

    • get the list of orders for a given product id
    • for each order, check if there is an attached downloadable product
    • if there is, go to the next order
    • if there isn’t, attach the given url

    My concern is with the “attach” action. It seems it’s a bit more complex than that as the generated link is usually more than just the url itself…

    Thanks a lot again

    Forum: Plugins
    In reply to: [WooCommerce] Updating digital donwload file breaks donwloadability for previous customers
    Thread Starter hubchau

    (@hubchau)

    1 year, 4 months ago

    Also, if it can help, I’d be more than happy to share a screen recording or even a screen sharing. Let me know!

    Thanks a lot for your time and effort

    Forum: Plugins
    In reply to: [WooCommerce] Updating digital donwload file breaks donwloadability for previous customers
    Thread Starter hubchau

    (@hubchau)

    1 year, 4 months ago

    Hi @doublezed2,

    If I open any order placed before I pushed the latest version of my ebook, the link to the ebook (previous version) does not appear. The “Downloadable Product Permissions” field is empty.

    As for the email sent when the order is placed, I believe the link is there (or I would have received quite a lot of complaints) and is working at the time of the order (and until I push a new version of my ebook)

    Forum: Plugins
    In reply to: [WooCommerce] Updating digital donwload file breaks donwloadability for previous customers
    Thread Starter hubchau

    (@hubchau)

    1 year, 4 months ago

    Hi,

    Thank you for your reply.

    To answer your questions:

    • Has this problem started recently? -> I’m not sure, I never checked past orders before…
    • Have there been any changes on your site, such as plugin updates? -> I update plugins almost daily so yes
    • Are you updating the file with the same name, and does it throw an error when trying to download the updated file? -> I’m not sure the new version of the file always has the exact same name as the previous one (+ woocommerce adds some kind of a hash at the end). And no, there’s no error when uploading a new one

    Here’s the system status report:

    ### WordPress Environment ###

WordPress address (URL): https://www.brindore.fr
Site address (URL): https://www.brindore.fr
WC Version: 9.4.2
Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.
Action Scheduler Version: ✔ 3.8.2
Log Directory Writable: ✔
WP Version: 6.7.1
WP Multisite: –
WP Memory Limit: 4 GB
WP Debug Mode: –
WP Cron: ✔
Language: fr_FR
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 8.1.30
PHP Post Max Size: 512 MB
PHP Time Limit: 360
PHP Max Input Vars: 2000000
cURL Version: 7.61.1
OpenSSL/1.1.1k

SUHOSIN Installed: –
MySQL Version: 10.6.20-MariaDB
Max Upload Size: 512 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 9.4.2
WC Database Prefix: wor7860_
Total Database Size: 187.53MB
Database Data Size: 159.96MB
Database Index Size: 27.57MB
wor7860_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_woocommerce_downloadable_product_permissions: Data: 0.11MB + Index: 0.20MB + Engine InnoDB
wor7860_woocommerce_order_items: Data: 0.13MB + Index: 0.05MB + Engine InnoDB
wor7860_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.45MB + Engine InnoDB
wor7860_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wor7860_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wor7860_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_actionscheduler_actions: Data: 5.52MB + Index: 2.11MB + Engine InnoDB
wor7860_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_actionscheduler_logs: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
wor7860_aioseo_cache: Data: 0.16MB + Index: 0.03MB + Engine InnoDB
wor7860_aioseo_notifications: Data: 0.03MB + Index: 0.06MB + Engine InnoDB
wor7860_aioseo_posts: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
wor7860_cf7db: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wor7860_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_comments: Data: 1.52MB + Index: 0.55MB + Engine InnoDB
wor7860_easywpsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_easywpsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_gglcptch_allowlist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wor7860_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_automations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_mailpoet_automation_runs: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wor7860_mailpoet_automation_run_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wor7860_mailpoet_automation_run_subjects: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_mailpoet_automation_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_mailpoet_automation_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_mailpoet_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_newsletters: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
wor7860_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wor7860_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wor7860_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wor7860_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wor7860_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wor7860_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wor7860_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_mailpoet_subscribers: Data: 0.08MB + Index: 0.23MB + Engine InnoDB
wor7860_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_subscriber_segment: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wor7860_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_mollie_pending_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_options: Data: 10.45MB + Index: 0.30MB + Engine InnoDB
wor7860_pimwick_gift_card: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_pimwick_gift_card_activity: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_postmeta: Data: 74.55MB + Index: 16.30MB + Engine InnoDB
wor7860_posts: Data: 51.52MB + Index: 1.28MB + Engine InnoDB
wor7860_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_term_relationships: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wor7860_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_usermeta: Data: 0.14MB + Index: 0.03MB + Engine InnoDB
wor7860_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wor7860_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_wc_admin_notes: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wor7860_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wor7860_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_wc_customer_lookup: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wor7860_wc_download_log: Data: 0.17MB + Index: 0.16MB + Engine InnoDB
wor7860_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wor7860_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wor7860_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_wc_order_product_lookup: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wor7860_wc_order_stats: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
wor7860_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_wc_product_meta_lookup: Data: 0.05MB + Index: 0.11MB + Engine InnoDB
wor7860_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_wfu_dbxqueue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_wfu_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_wfu_userdata: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_wpmailsmtp_debug_events: Data: 1.34MB + Index: 0.00MB + Engine InnoDB
wor7860_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wor7860_wpml_mails: Data: 4.02MB + Index: 0.02MB + Engine InnoDB
wor7860_yoast_indexable: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wor7860_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wor7860_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wor7860_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wor7860_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

aiovg_videos: 1
attachment: 2901
custom_css: 3
customize_changeset: 3
elementor_library: 7
mailpoet_page: 1
nav_menu_item: 43
note: 1
oceanwp_library: 3
page: 27
pi_dpmw_rules: 3
post: 10
product: 300
product_variation: 3
revision: 2878
shop_coupon: 11
shop_order: 703
shop_order_refund: 1
sl-insta-account: 1
sl-insta-feed: 1
sl-insta-media: 802
vg_gateway_condition: 1
wcpcsu-custom-post: 1
wor7860_global_style: 2
wp_block: 1
wp_global_styles: 1
wp_navigation: 1
wpcf7_contact_form: 5
wpforms: 2
yith_wcan_preset: 1

### Security ###

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

### Active Plugins (29) ###

Conditional Fields for Contact Form 7: by Jules Colle – 2.5.1
Classic Editor: by WordPress Contributors – 1.6.5
Classic Widgets: by WordPress Contributors – 0.3
Code Snippets: by Code Snippets Pro – 3.6.5.1
Contact Form 7: by Takayuki Miyoshi – 6.0
Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.5.1
Database for CF7: by Code4Life – 1.2.6
Drag and Drop Multiple File Upload - Contact Form 7: by Glen Don L. Mongaya – 1.3.8.5
Elementor: by Elementor.com – 3.25.9
Essential Addons for Elementor: by WPDeveloper – 6.0.10
Forget About Shortcode Buttons: by Designs & Code – 2.1.3
Hide Categories and Products for Woocommerce: by N.O.U.S. Open Useful and Simple – 1.2.9
Jetpack: by Automattic – 14.0
Media Deduper: by Cornershop Creative – 1.5.8
Mollie Payments for WooCommerce: by Mollie – 7.9.0
Ocean Extra: by OceanWP – 2.4.2
Payment Methods by Product & Country for WooCommerce: by WPFactory – 1.8.0
PW WooCommerce Gift Cards: by Pimwick
LLC – 2.9

Royal Elementor Addons: by WP Royal – 1.7.1003
Spotlight - Social Media Feeds: by RebelCode – 1.6.16
Tidio Chat: by Tidio LLC – 6.0.22
UpdraftPlus - Backup/Restore: by TeamUpdraft
DavidAnderson – 1.24.11

WooCommerce Stripe Gateway: by Stripe – 8.9.0
PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.9.0
WooCommerce: by Automattic – 9.4.2
WP Dashboard Notes: by Jeroen Sormani – 1.0.13
WP Fastest Cache: by Emre Vona – 1.3.2
WP Mail Logging: by WP Mail Logging Team – 1.13.1
WP Mail SMTP: by WP Mail SMTP – 4.2.0

### Inactive Plugins (1) ###

All-in-One Video Gallery: by Team Plugins360 – 3.8.3

### Settings ###

Legacy API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right_space
Thousand Separator: 
Decimal Separator: ,
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
pw gift card (pw-gift-card)
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: ✔
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: –

### Logging ###

Enabled: ✔
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 days
Level threshold: –
Log directory size: 865 KB

### WC Pages ###

Shop base: #935 - /boutique/
Cart: #425 - /panier/ -  Contains the [woocommerce_cart] shortcode
Checkout: #426 - /commander/ -  Contains the [woocommerce_checkout] shortcode
My account: #427 - /mon-compte/
Terms and conditions: #1330 - /cgv/

### Theme ###

Name: OceanWP Child Theme
Version: 1.0
Author URL: https://oceanwp.org/
Child Theme: ✔
Parent Theme Name: OceanWP
Parent Theme Version: 4.0.1 – 4.0.3 is available
Parent Theme Author URL: https://oceanwp.org/about-oceanwp/
WooCommerce Support: ✔

### Templates ###

Overrides: /home/yowu9351/public_html/wp-content/plugins/royal-elementor-addons/includes/woocommerce/templates/cart/cart.php
/home/yowu9351/public_html/wp-content/plugins/royal-elementor-addons/includes/woocommerce/templates/cart/mini-cart.php version 9.2.0 is out of date. The core version is 9.3.0
oceanwp/woocommerce/content-single-product.php
oceanwp/woocommerce/loop/loop-start.php
/home/yowu9351/public_html/wp-content/plugins/royal-elementor-addons/includes/woocommerce/templates/notices/error.php
/home/yowu9351/public_html/wp-content/plugins/royal-elementor-addons/includes/woocommerce/templates/notices/notice.php
/home/yowu9351/public_html/wp-content/plugins/royal-elementor-addons/includes/woocommerce/templates/notices/success.php
oceanwp/woocommerce/single-product/product-image.php
oceanwp/woocommerce/single-product/title.php

Outdated Templates: ❌


                        Learn how to update                  |




                        Clear system status theme info cache

### Admin ###

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customize-store
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
pattern-toolkit-full-composability
product-custom-fields
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
printful
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page
launch-your-store

Disabled Features: product-data-views
experimental-blocks
minified-js
product-pre-publish-modal
settings
async-product-editor-category-field
product-editor-template-system
blueprint
reactify-classic-payments-settings
use-wp-horizon

Daily Cron: ✔ Next scheduled: 2024-11-28 10:04:54 +01:00
Options: ✔
Notes: 142
Onboarding: completed

### Action Scheduler ###

Complete: 203
Oldest: 2024-10-28 08:59:32 +0100
Newest: 2024-11-28 07:34:46 +0100

Failed: 9,755
Oldest: 2023-02-20 10:11:46 +0100
Newest: 2024-09-09 11:14:24 +0200

Pending: 4
Oldest: 2024-11-28 10:29:12 +0100
Newest: 2024-12-22 10:08:55 +0100


### Status report information ###

Generated at: 2024-11-28 08:59:11 +01:00
    • This reply was modified 1 year, 4 months ago by hubchau.
    Forum: Plugins
    In reply to: [ReCaptcha v2 for Contact Form 7] Uncaught ReferenceError: grecaptcha is not defined
    hubchau

    (@hubchau)

    2 years ago

    Sorry, wrong topic

    • This reply was modified 2 years ago by hubchau.
    Forum: Plugins
    In reply to: [PW WooCommerce Gift Cards] gift card category unset
    Thread Starter hubchau

    (@hubchau)

    2 years, 3 months ago

    Thank you for the quick answer. I already had a product category selected in the Category section of the git card product. But when I do a get_the_terms($product->get_id(), 'product_cat') I get an empty string.

    Anyway, it’s not blocking in any way, so I’ll mark the topic as resolved 🙂

Viewing 7 replies - 1 through 7 (of 7 total)