SQL error: Unknown column when WooCommerce is active - table alias not used in comments filter

[Vr00mm]

WP Job Manager Applications - Bug Report

Describe the bug

When WooCommerce is installed alongside WP Job Manager Applications, SQL errors occur because the plugin uses $wpdb->posts.post_type in a WHERE clause, but WooCommerce aliases the posts table as wp_posts_to_exclude_reviews in its comment count queries. Once a table is aliased in SQL, the original table name is no longer valid in that query scope.

The error appears in includes/class-wp-job-manager-applications-dashboard.php:

$where .= " $wpdb->posts.post_type NOT IN ('job_application') ";

This produces SQL errors like:

Unknown column 'wp_posts.post_type' in 'WHERE' for query SELECT COUNT(*)
FROM wp_comments LEFT JOIN wp_posts AS wp_posts_to_exclude_reviews ON comment_post_ID = wp_posts_to_exclude_reviews.ID 
WHERE ... AND wp_posts_to_exclude_reviews.post_type NOT IN ('product') AND wp_posts.post_type NOT IN ('job_application')

To Reproduce

1. Install and activate WooCommerce
2. Install and activate WP Job Manager and WP Job Manager Applications
3. Go to wp-admin dashboard or any admin page
4. Check PHP error logs - SQL errors appear on every page load

Screenshots

N/A - error visible in server logs

Expected behavior

No SQL errors. The filter should use a method that works regardless of table aliasing, such as a subquery:

$where .= " AND comment_post_ID NOT IN (SELECT ID FROM $wpdb->posts WHERE post_type = 'job_application') ";

Isolating the problem (mark completed items with an [x]):

• I have deactivated other plugins and confirmed this bug occurs when only WP Job Manager plugin is active.
• This bug happens with a default WordPress theme active.
• I can reproduce this bug consistently using the steps above.

WordPress Environment

• WordPress Version: 6.x
• WP Job Manager Version: latest
• WP Job Manager Applications Version: latest
• WooCommerce Version: 9.x
• PHP Version: 8.x
• Other important details: The bug is a conflict between WP Job Manager Applications and WooCommerce's WC_Comments::wp_count_comments filter which aliases the posts table.

[donnchawp]

This was generated by AI during triage.

Thanks for the detailed report and SQL trace — the diagnosis is correct.

This bug lives in the WP Job Manager Applications add-on (class-wp-job-manager-applications-dashboard.php), not in core WP Job Manager, so this repo isn't the right tracker for the fix. The add-on team is already aware of it (a proposed patch using a unique table alias has been filed internally) and the issue has been reported previously in #2888.

Closing as a duplicate / out of scope for this repo.

Temporary workaround until the add-on fix ships — add to a custom plugin or functions.php (credit to @danjjohnson from #2888):

add_filter( 'comments_clauses', function( $clauses ) {
    global $wpdb;

    // If the add-on already injected the broken "wp_posts.post_type" condition,
    // swap it with the WooCommerce alias when WooCommerce added one.
    if ( strpos( $clauses['where'], "{$wpdb->posts}.post_type NOT IN ('job_application')" ) !== false ) {
        if ( strpos( $clauses['join'], 'wp_posts_to_exclude_reviews' ) !== false ) {
            $clauses['where'] = str_replace(
                "{$wpdb->posts}.post_type NOT IN ('job_application')",
                "wp_posts_to_exclude_reviews.post_type NOT IN ('job_application')",
                $clauses['where']
            );
        }
    }

    return $clauses;
}, 99 );

If you have a WP Job Manager Applications licence, please also file via the add-on support channel at wpjobmanager.com so you receive updates when the fix ships.