roniewebstudio17

Just wanted to follow up with the problems we are facing. Any chance there is some documentation I can read through to fix this?

Re-attached screenshots below.

Screenshot 1:
https://drive.google.com/file/d/1OC1DBTtr2ahAlj9BusQi6myHxDnyWUCy/view?usp=sharing

Screenshot 2:
https://drive.google.com/file/d/1GvX9pwxzn17bRCv9cU7SsI8EMbt9iAna/view?usp=sharing

Screenshot 3:
https://drive.google.com/file/d/1Quqom1OcIuZDO7kW7IKIV88cN1Hzueux/view?usp=sharing

Also, VAT is at 20% in this case.

Thank you.

Hi Dmytro,

Thanks for the reply. I was able to get the following query using Query Monitory plugin below:

SELECT COUNT( DISTINCT wp_1d01165959_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term_count_id
FROM wp_1d01165959_posts
INNER JOIN wp_1d01165959_postmeta AS mt1
ON ( wp_1d01165959_posts.ID = mt1.post_id )
INNER JOIN wp_1d01165959_term_relationships AS term_relationships
ON wp_1d01165959_posts.ID = term_relationships.object_id
WHERE wp_1d01165959_posts.post_type IN ( ‘product’ )
AND wp_1d01165959_posts.post_status = ‘publish’
AND ( wp_1d01165959_posts.ID NOT IN (
SELECT object_id
FROM wp_1d01165959_term_relationships
WHERE term_taxonomy_id IN (23) ) )
AND ( ( wp_1d01165959_postmeta.meta_key = ‘user_role_visibility’
AND wp_1d01165959_postmeta.meta_value LIKE ‘%Customer%’ )
AND ( mt1.meta_key = ‘user_role_visibility’
AND mt1.meta_value LIKE ‘%Customer%’ ) )
AND term_relationships.term_taxonomy_id IN (244,242,264,266,245,243,247,246,265)
GROUP BY term_relationships.term_taxonomy_id

There is an error:

Unknown column ‘wp_1d01165959_postmeta.meta_key’ in ‘where clause’

There is a duplicate condition where one condition is using an alias (mt1) and another condition is accessing the column directly wp_1d01165959_postmeta.meta_key.

Do you know how can this be rectified? Thanks!

Hi!

Just wanted to inform here that it looks like the missing tax calculation in the checkout page is caused by a plugin.

Thanks!

BTW, I also tried changing the country code to * but the issue still persist.

Hi,

Thanks for the reply. Which part of the plugin settings can this be found? I only have the following under usage restriction.

Thanks!