Mail Mint <= 1.31.4 - Authenticated (Custom+) SQL Injection via 'filters' Parameter

Overview

The Mail Mint plugin for WordPress is vulnerable to SQL Injection via the 'filters' parameter of the /wp-json/mrm/v1/segments/contacts REST endpoint in versions up to, and including, 1.31.4 This is due to insufficient escaping on the user supplied filter 'value' before it is appended to a SQL query in SegmentFilterService::get_meta_join_query() at line 797, where the value is string-interpolated into the WHERE fragment in a numeric (unquoted) context and the surrounding $wpdb->prepare() calls do not cover the injected value. This makes it possible for authenticated attackers, with the custom 'mint_read_contacts' capability (granted to Administrators by default, and configurable to lower roles via the plugin's role manager), to append additional SQL queries into already existing queries that can be used to extract sensitive information from the database.

Affected

• mail_mint_email_marketing_automation_woocommerce_emails_with_ai_assistance <= 1.31.4

Remediation

Refer to the linked advisories for vendor-supplied fixes and affected version ranges.