Forum Replies Created

Viewing 10 replies - 1 through 10 (of 10 total)
  • Thread Starter fxdfxd

    (@fxdfxd)

    Unfortunately I didn’t solve the problem. Review keeps disapearing, sometimes all the reviews for a random product, sometimes just a random review on a random product… I’m tired of all this πŸ™

    Thread Starter fxdfxd

    (@fxdfxd)

    Ok I still lost some comments unfortunately πŸ™
    I investigated further, and found dozen of wrongful entries in the _wc_product_meta_lookup table.
    I deleted them, and I’ll see if the comment still disappear from now on.

    The investigation continues …

    Thanks

    Thread Starter fxdfxd

    (@fxdfxd)

    Ok thanks for the explanation. I’ll see if this solve my problems.

    Thanks

    Thread Starter fxdfxd

    (@fxdfxd)

    <span style=”font-family: Inter, sans-serif; white-space-collapse: collapse; background-color: rgb(251, 251, 251);”>Deleting those variations might explain why the reviews were disappearing if the reviews were attached to those orphaned posts instead of the correct product.</span>

    Please note that the reviews where disappearing BEFORE I manually deleted the orphaned variations. Now I’ve deleted these variations, we will see if the reviews stays online. I don’t know why these variations still existed in the first place, and why they were not deleted by that dedicated option in woocommerce interface.

    Thanks

    Thread Starter fxdfxd

    (@fxdfxd)

    Hey Frank,

    Please read my previous post. I disabled cache plugins, and comments still disappears from the database.

    But I think I have a clue why. When browsing products on the database, I saw plenty of orphaned product variations on the _postmeta table, even if already did the “delete orphaned variations” procedure many times.
    Some of them had duplicate SKU with my existing products, that’s maybe why the reviews were messy. Unfortunately I stupidly deleted them without checking if they contained the reviews.
    I’ll try to post new reviews and see if they keeps disappearing.


    Thanks

    Thread Starter fxdfxd

    (@fxdfxd)

    Edit

    • This reply was modified 3 months, 3 weeks ago by fxdfxd.
    • This reply was modified 3 months, 3 weeks ago by fxdfxd.
    Thread Starter fxdfxd

    (@fxdfxd)

    Hey πŸ™‚

    I’ve not much plugins running on my website, as you can see on the status report I posted.
    Only the cache plugin (WP fastest cache, premium version) has database optimisation, but I recently installed it, and my comment disappear prior to this.

    The crazy thing is that I disabled it, posted a new test review on a product, I approved it from the reviews interface, and now the comment is already gone! 1h after posting it! That’s crazy!

    Thread Starter fxdfxd

    (@fxdfxd)

    Unfortunately they’re not in the database anymore, I just checked. I see only the remaining reviews.

    I have a way to recover them, because they still appears in some WPML strings that I can translate on the WPML dashboard. But the problem is that I already did this, and they keep disapearing!
    And I have absolutely no idea why, as it seems pretty random in timing/products affected πŸ™

    Thanks

    Thread Starter fxdfxd

    (@fxdfxd)

    Thanks for the reply LovingBro,

    The reviews are configured correctly, in the settings and in the products, and are still displayed on some products, not all products, and not all reviews. Disappeared review doesn’t show in the reviews interface, and thus not with another theme either. Disabling most plugins doesn’t help to get them back. I think they’re simply gone.

    I’ll to find them directly in the database, but I’m not sure how they are stored, I’ll look further.

    Thanks

    Thread Starter fxdfxd

    (@fxdfxd)

    System Status Report

    ### WordPress Environment ###
    
    WordPress address (URL): [Redacted]
    Site address (URL): [Redacted]
    WC Version: 10.3.6
    Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.
    Action Scheduler Version: βœ” 3.9.3
    Log Directory Writable: βœ”
    WP Version: 6.9
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: βœ”
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    Server Architecture: Linux 5.15.167-ovh-vps-grsec-zfs-classid x86_64
    PHP Version: 8.4.10
    PHP Post Max Size: 130 MB
    PHP Time Limit: 165
    PHP Max Input Vars: 16000
    cURL Version: 7.64.0
    OpenSSL/1.1.1n
    
    SUHOSIN Installed: –
    MySQL Version: 8.0.43-34
    Max Upload Size: 128 MB
    Default Timezone is UTC: βœ”
    fsockopen/cURL: βœ”
    SoapClient: βœ”
    DOMDocument: βœ”
    GZip: βœ”
    Multibyte String: βœ”
    Remote Post: βœ”
    Remote Get: βœ”
    
    ### Database ###
    
    [REDACTED]
    
    ### Post Type Counts ###
    
    attachment: 1973
    cms_block: 21
    custom_css: 1
    customize_changeset: 2
    efbl_skins: 9
    elementor_library: 1
    foobar_notification: 2
    fts: 1
    mif_skins: 3
    nav_menu_item: 31
    oembed_cache: 22
    page: 46
    portfolio: 21
    post: 1
    product: 81
    product_variation: 78
    revision: 39
    shop_coupon: 6
    shop_order: 397
    tm_global_cp: 12
    wapf_product: 6
    wd_product_tabs: 1
    woodmart_size_guide: 1
    woodmart_slide: 19
    wp_font_face: 33
    wp_font_family: 12
    wp_global_styles: 2
    wp_navigation: 1
    wpcf7_contact_form: 2
    wpcode: 2
    yaye_option_set: 1
    
    ### Security ###
    
    Secure connection (HTTPS): βœ”
    Hide errors from visitors: βœ”
    
    ### Active Plugins (29) ###
    
    Advanced Custom Fields Multilingual: by OnTheGoSystems – 2.1.5
    WPML Multilingual for CF7: by OnTheGoSystems – 1.3.3
    Contact Form 7: by Rock Lobster Inc. – 6.1.4
    Custom Global Variables: by new target
    inc – 1.1.2
    
    Dashboard Columns: by Polygon Themes – 1.3.1
    Disable auto-update Email Notifications: by Gutoz – 1.5.0
    Envato Market: by Envato – 2.0.12
    HookMeUp for WooCommerce: by Get Bowtied – 3.0
    Independent Analytics: by Independent Analytics – 2.13.5
    WPBakery Page Builder: by WPBakery – 8.7.2
    Slider Revolution: by ThemePunch – 6.7.38
    WPML Multilingual CMS: by OnTheGoSystems – 4.8.6
    Orders Tracking for WooCommerce: by VillaTheme – 1.2.16
    WooCommerce Product Image Gallery Options: by Create and Code – 1.1.0
    WooCommerce.com Update Manager: by Automattic – 1.0.3
    WooCommerce Stripe Gateway: by Stripe – 10.1.0
    WPML Multilingual & Multicurrency for WooCommerce: by OnTheGoSystems – 5.5.3.1
    WooCommerce PayPal Payments: by PayPal – 3.3.1
    WooCommerce Tax: by WooCommerce – 3.2.3
    WooCommerce Shipping: by WooCommerce – 2.0.1
    Extra Product Options & Add-Ons for WooCommerce: by ThemeComplete – 7.5.4
    WooCommerce: by Automattic – 10.3.6
    Woodmart Core: by  – 1.1.5
    WoodMart Images Optimizer: by XTemos – 1.3.3
    WP Fastest Cache Premium: by Emre Vona – 1.7.5
    WP Fastest Cache: by Emre Vona – 1.4.3
    WPML Media Translation: by OnTheGoSystems – 3.0.0
    WPML String Translation: by OnTheGoSystems – 3.4.1
    Smart Coupons For WooCommerce Coupons: by WebToffee – 2.2.4
    
    ### Inactive Plugins (2) ###
    
    Query Monitor: by John Blackbourn – 3.20.1
    Redis Object Cache: by Till KrΓΌss – 2.7.0
    
    ### Settings ###
    
    Legacy API Enabled: –
    Force SSL: –
    Currency: EUR (€)
    Currency Position: right_space
    Thousand Separator: 
    Decimal Separator: .
    Number of Decimals: 0
    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: –
    HPOS feature enabled: βœ”
    Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
    HPOS data sync enabled: βœ”
    Enabled Features: analytics
    marketplace
    site_visibility_badge
    email_improvements
    blueprint
    point_of_sale
    custom_order_tables
    cost_of_goods_sold
    
    
    ### Logging ###
    
    Enabled: βœ”
    Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
    Retention period: 30 days
    Level threshold: –
    Log directory size: 16 KB
    
    ### WC Pages ###
    
    Shop base: #1249 - /shop/
    Cart: #37419 - /cart/ -  Contains the [woocommerce_cart] shortcode
    Checkout: #37420 - /checkout/ -  Contains the [woocommerce_checkout] shortcode
    My account: #37421 - /my-account-2/ -  Contains the [woocommerce_my_account] shortcode
    Terms and conditions: #2382 - /terms-and-conditions/
    
    ### Theme ###
    
    Name: Woodmart Child
    Version: 1.0.0
    Author URL: http://xtemos.com
    Child Theme: βœ”
    Parent Theme Name: Woodmart
    Parent Theme Version: 8.3.7
    Parent Theme Author URL: http://themeforest.net/user/xtemos
    Theme type: Classic theme
    WooCommerce Support: βœ”
    
    ### Templates ###
    
    Overrides: woodmart/woocommerce/archive-product.php
    woodmart/woocommerce/cart/cart-item-data.php
    woodmart/woocommerce/cart/cart.php
    woodmart/woocommerce/cart/cross-sells.php
    woodmart/woocommerce/cart/mini-cart.php
    woodmart/woocommerce/checkout/form-checkout.php
    woodmart/woocommerce/checkout/thankyou.php
    woodmart/woocommerce/content-product-cat.php
    woodmart/woocommerce/content-product.php
    woodmart/woocommerce/content-single-product.php
    woodmart/woocommerce/content-widget-product.php
    woodmart/woocommerce/global/breadcrumb.php
    woodmart/woocommerce/global/form-login.php
    woodmart/woocommerce/global/quantity-input.php
    woodmart/woocommerce/loop/add-to-cart.php
    woodmart/woocommerce/loop/loop-end.php
    woodmart/woocommerce/loop/loop-start.php
    woodmart/woocommerce/loop/no-products-found.php
    woodmart/woocommerce/loop/orderby.php
    woodmart/woocommerce/loop/pagination.php
    woodmart/woocommerce/loop/sale-flash.php
    woodmart/woocommerce/myaccount/form-login.php
    woodmart/woocommerce/myaccount/my-account.php
    woodmart/woocommerce/product-searchform.php
    woodmart/woocommerce/single-product/add-to-cart/grouped.php
    woodmart/woocommerce/single-product/add-to-cart/variable.php
    woodmart/woocommerce/single-product/meta.php
    woodmart/woocommerce/single-product/product-attributes.php
    woodmart/woocommerce/single-product/product-image.php
    woodmart/woocommerce/single-product/product-thumbnails.php
    woodmart/woocommerce/single-product/rating.php
    woodmart/woocommerce/single-product/related.php
    woodmart/woocommerce/single-product/sale-flash.php
    woodmart/woocommerce/single-product/tabs/description.php
    woodmart/woocommerce/single-product/tabs/tabs.php
    woodmart/woocommerce/single-product/title.php
    woodmart/woocommerce/single-product/up-sells.php
    woodmart/woocommerce/single-product-reviews.php
    woodmart/woocommerce/single-product.php
    
    
    ### WooCommerce Stripe Payment Gateway ###
    
    Version: 10.1.0
    Account ID: acct_1S2s7oE0eHqTwJBn
    Account Email: fxdefaut@gmail.com
    Test Mode Enabled: βœ”
                        No
    OAuth Connected: βœ”
                        Yes
    Sync Enabled: βœ”
                        Yes
    Legacy Checkout Experience: βœ”
                        No
    Optimized Checkout Enabled: No
    Enabled Payment Methods: bancontact,card,klarna,revolut_pay,sepa_debit
    Express Checkout: Disabled
    Auth and Capture: βœ”
                        Yes
    Logging: No
    
    ### WooCommerce PayPal Payments ###
    
    Onboarded: βœ”
    Branded only: –
    New UI active: βœ”
    Shop country code: GR
    WooCommerce currency supported: βœ”
    Advanced Card Processing available in country: βœ”
    Pay Later messaging available in country: –
    Webhook status: βœ”
    PayPal Vault enabled: –
    ACDC Vault enabled: –
    Logging enabled: –
    Reference Transactions: βœ”
    Used PayPal Checkout plugin: βœ”
    Subscriptions Mode: Disabled
    PayPal Shipping Callback: –
    Apple Pay: –
    Google Pay: –
    Fastlane: –
    
    ### 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
    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
    experimental-iapi-mini-cart
    experimental-iapi-runtime
    coming-soon-newsletter-template
    minified-js
    product-pre-publish-modal
    settings
    async-product-editor-category-field
    product-editor-template-system
    use-wp-horizon
    rest-api-v4
    
    Daily Cron: βœ” Next scheduled: 2025-12-09 21:11:38 +02:00
    Options: βœ”
    Notes: 34
    Onboarding: completed
    
    ### Action Scheduler ###
    
    Complete: 2,149
    Oldest: 2025-11-08 18:57:44 +0000
    Newest: 2025-12-09 18:15:22 +0000
    
    Failed: 5,548
    Oldest: 2020-05-01 23:44:32 +0000
    Newest: 2025-12-09 14:47:02 +0000
    
    Pending: 14
    Oldest: 2025-12-09 19:11:22 +0000
    Newest: 2025-12-19 20:49:26 +0000
    
    
    ### Status report information ###
    
    Generated at: 2025-12-09 20:34:02 +02:00
Viewing 10 replies - 1 through 10 (of 10 total)