Ainsley Clark

Hi there @inpsydekrystian

Thanks for your reply. It turns out it was a theme issue with the checkboxes being displayed, now I can see them fine.

I have enabled “Require final confirmation on checkout on the settings page. Although I’m curious to know, how does Shipping and Billing addresses get populated without this setting? I.e It would be great to know why the shipping error is happening in the first place.

Many thanks.

Hi there,

Thanks for getting back to me.

I looked for the “Require final confirmation on checkout ” setting in the Standard Payments section and it looks like the field is broken. On your screenshot it’s a checkbox. But on my installation it looks to be a broken select, screenshot attached.

Just so I can debug further, are there any other settings that may be causing this issue?

Thanks.

https://ibb.co/jWxyXSM

• This reply was modified 7 months, 3 weeks ago by Ainsley Clark.

Hi there,

Still no luck unfortunately. No log output or error message whatsoever, its like it just hard exits

Hi @inpsydekrystian would you mind providing me with other relevant tickets that have reported similar problems? I would like to see if there are any other resolutions if at all possible as it’s affecting our prod traffic.

I have also noticed some other errors in debug.log

PHP Fatal error: Uncaught TypeError: WooCommerce\PayPalCommerce\ApiClient\Entity\PaymentSource::name(): Return value must be of type string, null returned in /var/www/decspets.ie/wp-content/plugins/woocommerce-paypal-payments/modules/ppcp-api-client/src/Entity/PaymentSource.php:50

/wp-content/plugins/woocommerce-paypal-payments/modules/ppcp-button/src/Helper/ContextTrait.php(182): WooCommerce\PayPalCommerce\ApiClient\Entity\PaymentSource->name()

• This reply was modified 1 year, 2 months ago by Ainsley Clark.

Hi @inpsydekrystian

Thanks for getting back to me.

I have tried using the rc2 version of this plugin to no avail. I think the rc2 fixes the variable product (I believe) but it’s broken with any product specifically on the checkout.

Looking forward to hearing from you,

Ainsley.

Hi,

Thanks for your reply.

I have proceeded with the following steps:

• Created a new server on Digital Ocean
• Created a new Database
• Updated users and passwords.

Yet it’s still happening. I’m not sure what else to do now. I’m surprised Wordfence isn’t picking this up with a premium subscription.

Thanks.

Hi there, just wondering if you have seen above?
Many thanks.

Hi @niklasinpsyde

Thanks for your reply.

I have disablecd all plugins and I’m still only seeing the “Sandbox – Done”

I have attached a screenshot here: https://ibb.co/XYV1j86

Many thanks.

Hi @pressport

Thank you for your question.

May I ask what operating system your hosting is running? Installing avifenc can be a bit challenging but it really depends what distro of linux you are running.

With regards to checking if the browser accepts avif or webp, it’s a great idea. Although the browser can detect if it can serve an avif image by using the <picture> element.

I will need to inspect the headers and check if the browser has the correct headers and change the output of squidge_image accordingly.
Can you create a new issue on https://github.com/ainsleyclark/squidge as feature request? I will put this in the next version.

All the best.

• This reply was modified 3 years, 1 month ago by Ainsley Clark.

I’m presuming that Woocommerce is stripping due to security reasons. Is there anything I can do to sanitize the result?

Hi @vrandom

Thanks for your reply, sorry about the long delay. Thank you for being so patient.

I have deduced that it was down to me being clumsy and not changing my category on this line.

where foe_342fj29x2_term_taxonomy.taxonomy = 'foebar' and foe_342fj29x2_terms.slug = '$post_slug'

Its working ??

The only issue I have is with it returning an extra page. As In, I click the ‘next page’ on the last one and it displays no posts.

Would there be a way to fix this?

Many many thanks.

Gist of what I’m using at the moment too:

https://gist.github.com/ainsleyclark/aa8ea43f7f79de64ef5a9fa6dcf0ff50

Hi @vrandom

SQL dump looks like this:

string(2908) "select count(foe_342fj29x2_posts.id), foe_342fj29x2_posts.post_type,post_type_0.grouped_id, post_type_1.grouped_id, post_type_2.grouped_id from foe_342fj29x2_posts left join 			 
		(select GROUP_CONCAT(id  order by post_date desc, id desc) as grouped_id, post_type from (
			  SELECT id, post_type, post_date
			  FROM foe_342fj29x2_posts 
				inner join foe_342fj29x2_term_relationships on foe_342fj29x2_term_relationships.object_id = id
				inner join foe_342fj29x2_term_taxonomy on foe_342fj29x2_term_relationships.term_taxonomy_id = foe_342fj29x2_term_taxonomy.term_taxonomy_id
				inner join foe_342fj29x2_terms on foe_342fj29x2_term_taxonomy.term_id = foe_342fj29x2_terms.term_id
				where foe_342fj29x2_term_taxonomy.taxonomy = 'category' and foe_342fj29x2_terms.slug = 'marketing-masters'
			   and post_type in ('news')
			   and post_status = 'publish'
			   order by post_date desc, id desc                       
			  ) d0
			 GROUP BY d0.post_type) post_type_0		 
			 ON foe_342fj29x2_posts.post_type = post_type_0.post_type
left join 			 
		(select GROUP_CONCAT(id  order by post_date desc, id desc) as grouped_id, post_type from (
			  SELECT id, post_type, post_date
			  FROM foe_342fj29x2_posts 
				inner join foe_342fj29x2_term_relationships on foe_342fj29x2_term_relationships.object_id = id
				inner join foe_342fj29x2_term_taxonomy on foe_342fj29x2_term_relationships.term_taxonomy_id = foe_342fj29x2_term_taxonomy.term_taxonomy_id
				inner join foe_342fj29x2_terms on foe_342fj29x2_term_taxonomy.term_id = foe_342fj29x2_terms.term_id
				where foe_342fj29x2_term_taxonomy.taxonomy = 'category' and foe_342fj29x2_terms.slug = 'marketing-masters'
			   and post_type in ('exhibitors')
			   and post_status = 'publish'
			   order by post_date desc, id desc                       
			  ) d1
			 GROUP BY d1.post_type) post_type_1		 
			 ON foe_342fj29x2_posts.post_type = post_type_1.post_type
left join 			 
		(select GROUP_CONCAT(id  order by post_date desc, id desc) as grouped_id, post_type from (
			  SELECT id, post_type, post_date
			  FROM foe_342fj29x2_posts 
				inner join foe_342fj29x2_term_relationships on foe_342fj29x2_term_relationships.object_id = id
				inner join foe_342fj29x2_term_taxonomy on foe_342fj29x2_term_relationships.term_taxonomy_id = foe_342fj29x2_term_taxonomy.term_taxonomy_id
				inner join foe_342fj29x2_terms on foe_342fj29x2_term_taxonomy.term_id = foe_342fj29x2_terms.term_id
				where foe_342fj29x2_term_taxonomy.taxonomy = 'category' and foe_342fj29x2_terms.slug = 'marketing-masters'
			   and post_type in ('speakers')
			   and post_status = 'publish'
			   order by post_date desc, id desc                       
			  ) d2
			 GROUP BY d2.post_type) post_type_2		 
			 ON foe_342fj29x2_posts.post_type = post_type_2.post_type where foe_342fj29x2_posts.post_type in ('news', 'exhibitors', 'speakers') group by foe_342fj29x2_posts.post_type"

Hi @vrandom

Not sure about line 320 because thats way down in the loop.

Here:

// base template for sql query
$sql_template = "select count(foe_342fj29x2_posts.id), foe_342fj29x2_posts.post_type#sql_col# from foe_342fj29x2_posts #join_templates# where foe_342fj29x2_posts.post_type in ('".implode("', '", $post_types)."') group by foe_342fj29x2_posts.post_type";

// Assemble Query

// adds a comma separated list of the post ids that are found in each join statement to the results
//$found_post_query_select_addon = "CASE " . implode(' ', $selectFoundPostQueryAddon). " ELSE null END as post_ids";

$found_post_query_select_addon = "post_type_0.grouped_id, post_type_1.grouped_id, post_type_2.grouped_id";
$sql_template = str_replace("#sql_col#", ','.$found_post_query_select_addon, $sql_template);

// adds generated joins to query
$sql_template = str_replace("#join_templates#", implode("\n", $joinTemplate), $sql_template);

// execute posts build query
global $wpdb;
$page_count_per_post_type = $wpdb->get_results($sql_template, ARRAY_N);

// First place to check if we have results
echo "<pre>";
var_dump($page_count_per_post_type);
echo "</pre>"

;

Hi @vrandom

Its the same:

array(3) {
  [0]=>
  array(3) {
    [0]=>
    string(3) "102"
    [1]=>
    string(10) "exhibitors"
    [2]=>
    NULL
  }
  [1]=>
  array(3) {
    [0]=>
    string(2) "32"
    [1]=>
    string(4) "news"
    [2]=>
    NULL
  }
  [2]=>
  array(3) {
    [0]=>
    string(2) "31"
    [1]=>
    string(8) "speakers"
    [2]=>
    NULL
  }
}

Using this:

$found_post_query_select_addon = "post_type_0.grouped_id, post_type_1.grouped_id, post_type_2.grouped_id";