SMS Alert subscriber sorting permits administrator-level SQL injection
SMS Alert through 3.9.7 reads the orderby request parameter on its manage_options All Subscriber page in All_Subscriber_List::getAllSubscriber(). It applies only text sanitization and appends the value directly to the SQL ORDER BY clause before $wpdb->get_results(), enabling an Administrator to perform time-based SQL injection and extract database information. Version 3.9.8 restricts the sort column and direction to allow-lists and parameterizes pagination values.
- Component
- SMS Alert – SMS & OTP for WooCommerce, Order Notifications & Abandoned Cart Recovery
- Plugin slug
sms-alert- Affected
- <= 3.9.7
- Safe version
3.9.8- Published
- Jul 28, 2026
This CVE was published Jul 28, 2026 and is one of 15 known issues for this plugin.
Update, patch or deactivate.
Update SMS Alert to 3.9.8 or later. Review Administrator activity and requests to the All Subscriber page for unusual orderby or order values.
A safe version is available, so updating to that version or later is the preferred remediation. If an immediate update is not practical, consider a targeted application patch or temporarily restricting the affected functionality.
Deactivate only when warranted by your risk profile, or when advised by your hosting provider in the limited circumstances where the vulnerability cannot otherwise be mitigated. If you’re unsure which action is appropriate, contact Fused or your hosting provider for guidance.
Technical description
The SMS Alert – SMS & OTP for WooCommerce, Order Notifications & Abandoned Cart Recovery plugin for WordPress is vulnerable to time-based SQL Injection via the 'orderby' parameter in all versions up to, and including, 3.9.7 due to insufficient escaping on the user supplied parameter and lack of sufficient preparation on the existing SQL query. This makes it possible for authenticated attackers, with administrator-level access and above, to append additional SQL queries into already existing queries that can be used to extract sensitive information from the database.
CVE / CNA vector: CVSS:3.1/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:N/A:N