Forum Replies Created

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter ghislefou

    (@ghislefou)

    Hi there,

    Thank you so much for your answer, let me test it.
    I have another question regarding the number of queries that are made on every request on the back office for example.
    I can see some queries like related to:

    • woocommerce_custom_orders_table_data_sync_enabled
    • wc_feature_woocommerce_brands_enabled
    • wc_brands_show_description
    • woocommerce_show_marketplace_suggestions
    • woocommerce_pickup_location_settings
    • woocommerce_flat_rate_settings
    • woocommerce_free_shipping_settings
    • woocommerce_international_delivery_settings

    like:

    SELECT option_value
    FROM wp_options
    WHERE option_name = 'woocommerce_international_delivery_settings'
    LIMIT 1

    They seems to be related to woocommerce features we are not using.
    Is there a way to get rid of these DB queries if the feature is not used?

    Thanks for your help.

    Best,

    Thread Starter ghislefou

    (@ghislefou)

    Hi @doublezed2,

    Thanks for your message.


    Actually, the theme is a custom one, we are a digital agency.
    This is not the 60 minutes time limit which is setting the status, because, as you can see on the timestamp of the order, everything takes place at the same time. What I shared here is the complete order note for the transaction with issue.


    I deep dived into woocommerce stripe gateway plugin code and what I could see in the code is that there is huge try / catch wrapping all the code of payment process method and which changing order status from anything … to Failed. It looks like we are in this case.

    Regarding the log previously mentioned, what seems to happen is that the order is created into the DB, status move to Pending … and then an exception is thrown by code which changes it to Failed (see the timestamp on order note, it is the same for each note).


    Today, we could talked with the customer whose order failed and could reproduce the issue on its own computer … but it’s strange and not sure it makes sense. What we could see is that the customer is denying cookies on 1st visit. Doing it (we are using cookiebot), the credit card form is not loaded and fires a JS “Stripe is not defined” error which prevents Stripe’s credit card fields from being inserted.

    We are going to also investigate in this way and try to prevent the Stripe necessary scripts from being loaded when cookie consent is denied.

    Thanks for your help.

    Best regards.

    Thread Starter ghislefou

    (@ghislefou)

    HI @carolm29 ,

    Thanks for your answer.

    So many questions 🙂
    Here is an example of order notes (in french, and another one in english):

    Unfortunately, there is no similarity, as far as I could see, between orders:

    • Sometimes 2 tickets buying, sometime one
    • Sometime on the french website, sometime on the english one
    • Different products
    • Visitors are different, coming from various countries
    • Only Stripe payment method via credit card available

    Here is the status report: https://gist.github.com/ghisleouf/6dbd9813bc5393c884c8e3ea9acc4673

    I don’t have any fatal error log as you can see on the screenshot, but maybe I’m missing something.
    Thanks a lot for your help.

    Best regards.

    Thread Starter ghislefou

    (@ghislefou)

    Me again,

    After some investigations, I’m still having the issue.
    I could find a customer with this issue in the woocommerce stripe plugin logs with a suspicious trace:

    2024-04-25T07:51:41+00:00 Debug 
    ====Stripe Version: 8.2.0====
    ====Stripe Plugin API Version: 2019-09-09====
    ====Start Log====
    customers request: Array
    (
        [email] => xxx@xxx.com
        [description] => Nom : XXX XXX, Invité
        [name] => XXX XXX
        [metadata] => Array
            (
            )
    
        [preferred_locales] => Array
            (
                [0] => fr-FR
            )
    
        [address] => Array
            (
                [line1] => XX XXXXXX 44
                [line2] => 
                [postal_code] => XXXX
                [city] => XXXXXXX
                [state] => FR
                [country] => CH
            )
    
    )
    
    ====End Log====
    
    2024-04-25T07:51:42+00:00 Debug 
    ====Stripe Version: 8.2.0====
    ====Stripe Plugin API Version: 2019-09-09====
    ====Start Log====
    customers response with stripe-version: 2019-09-09
    ====End Log====
    
    2024-04-25T07:51:42+00:00 Debug 
    ====Stripe Version: 8.2.0====
    ====Stripe Plugin API Version: 2019-09-09====
    ====Start Log====
    Error: stdClass Object
    (
        [token_id] => 
        [customer] => cus_PzLnXR1xS4XEDR
        [source] => 
        [source_object] => 
        [payment_method] => 
    )
    
    ====End Log====

    As you can see, the first request to Stripe API creates the customer but the next one is failing for unknown reason.

    Not all the payment are failing.

    Seems to be the exact same issue encountered here by @pihasurfer but without any response and maybe related to WooCommerce Stripe Payment Gateway

    If you have any idea about the issue … thanks for your help.

    Best,

    • This reply was modified 1 year, 11 months ago by ghislefou.

    Hello,

    In fact, I solved the issue. It was due to a “space” before head tag.
    Header was already sent before redirection.

    I removed the white space and now it works just fine !

    Thanks !

    Hello,

    I’m currently running a multisite install of wordpress ( 3.5.1 version) with last release of w3tc ( 0.9.3 ) and I’m still having the same problem.

    url without trailing slash is not redirected ( except after the first request just after a cache flush) properly to the same url with the trailing slash.

    It happens only with Page Cache activated. I’m using memcached as Page Cache method and can’t change to disk enhanced.

    If you have any idea that could help to find a solution to the problem.

    Thanks a lot !

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