roniewebstudio17

Thanks, discovered that the cause was a recaptcha plugin for woocommerce. Disabled it and checkout page worked OK. Thanks!

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 @tibetanitech

Thanks for the input. That’s what I was thinking too, although I was hoping to have some other way to do it.

Thanks!

Best Regards,
Ronie

Hi!

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

Thanks!

Thanks for the reply. Will let you know once I have tried this one.

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

Hi!

Thanks for the reply. Here is the Tax settings I currently have on site:

Then I have the Goods and Services Tax:

and the Standard Tax:

As for the status report, not sure which sections I need to remove. Some sections I have removed, please check below:

### WordPress Environment ###
WC Version: 4.2.0
REST API Version: ? 1.0.8
WC Blocks Version: ? 2.5.16
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 1.2.3
Log Directory Writable: ?
WP Version: 5.4.1
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###
Server Info: Apache
PHP Version: 7.3.18-1+ubuntu18.04.1+deb.sury.org+1
PHP Post Max Size: 256 MB
PHP Time Limit: 3600
PHP Max Input Vars: 10000
cURL Version: 7.58.0
OpenSSL/1.1.1g

SUHOSIN Installed: –
MySQL Version: 5.7.29-32-log
Max Upload Size: 1 GB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Security ###
Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Settings ###

API Enabled: –
Force SSL: –
Currency: AUD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: course (course)
external (external)
grouped (grouped)
simple (simple)
variable (variable)

Hi,

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

Thanks!

Hi David,

Thanks for the reply. Upon browsing the link you have provided, I am seeing a distorted page. Please see link:

https://www.screencast.com/t/IKoJfktSX2k

Also, the support page for the plugin is not working as per screenshot below:

https://www.screencast.com/t/WnZPGFDy3GMJ

Thanks for the response!

Best Regards,
R