tarik916

Thanks for the response. It turns out my custom code to alter the archive query did not include !is_singular(), so it was trying to display query results on the details page, causing the error.

For the default archive, I used pre_get_posts to do the following.

$meta_query = array(
            'relation' => 'AND',
            array(
                'key' => 'event-date',
                'compare' => 'EXISTS',
            ),
            array(
                'key' => 'event-date',
                'value' => time(),
                'compare' => '>=',
                'type' => 'NUMERIC',
            ),
        );

 $query->set( 'meta_query', $meta_query );

        $query->set( 'meta_key', 'event-date' );        
        $query->set( 'orderby', 'event-date' ); 

I’m glad you figured out the temporary fix of disabling lazy loading. I will patiently await a release, so I can enable lazy loading again.

• This reply was modified 1 year, 9 months ago by tarik916. Reason: Spelling

I would also like this updated. Please fix.

I manually fix the issue every time by commenting out this code:

//if (strlen($card_exp_year) == 2) {
//$card_exp_year += 2000;
//}

in

/wp-content/plugins/woo-paypal-gateway/includes/gateways/paypal-pro-payflow/class-woo-paypal-gateway-paypal-pro-payflow.php

The reference here: https://www.ads-software.com/support/topic/paypal-pro-payflow-expiration-date-bugfix/

Every time the plugin is updated, I have to do it again, and this time, there were about 20 failed transactions for a customer before catching the issue. After the update, the cards work properly, and they all have future expiration dates.

• This reply was modified 2 years, 2 months ago by tarik916.

I also tested using the WPDA_SAS_COURSE table from the demo and was unable to get the between filter to work on the date field.

https://share.getcloudapp.com/WnuqxwDb

Let me know if this answers your question. https://share.getcloudapp.com/eDuljJwO
It is not working with the table after converting the view to use date.

Oh, got it. Thank you!

I also used convert date when creating a new view but do not see the range option. I probably did something wrong. Screenshot: https://share.getcloudapp.com/xQuzbJJN

The column is pulling the user registered column from the user table which is defined as datetime. Does that hider the functionality?

Here is a quick screen recording: https://share.getcloudapp.com/4guZ28lv

I installed the latest version and see the premium options, so please ignore the search builder comment. I would still like to know how to create a date range search.

Sorry for the delay and thank you for responding so quickly. I did not get an email alert.

It turns out the error was due to Wordfence blocking the request. Thanks!

The admin error is:

PayPal Pro (Payflow) payment failed. Payment was rejected due to an error: (24) “Invalid expiration date: 10563-This transaction cannot be processed. Please enter a valid credit card expiration month.” Order status changed from Pending payment to Failed.

By the way, my customer had 10 failed orders due to this error.

I have the same issue using version 4.0.2 and 4.0.3. Hacking the plugin and making the updates suggested here: https://www.ads-software.com/support/topic/paypal-pro-payflow-expiration-date-bugfix/ worked for me but would obviously like it to be fixed in the plugin. Thanks!

Thanks! This was helpful! I added $title = str_replace(” “,”_”, $title); below the first lowercase command in order to better format the classes.

Instead of how.can.we.help, it’s how_can_we_help.