WordPress - Post Author Authenticated SQLi

Medium

Synopsis

Two REST handlers build SQL queries by concatenating client-supplied request parameters straight into the query string. There is no $wpdb->prepare(), no esc_like(), and no whitelisting. The only processing applied is sanitize_text_field(), which trims whitespace and strips tags and control characters. It does not escape quotes and offers no protection against SQL injection.

// includes/api-request/free/multi-authors/class-multiauthors.php — awpa_list_guest_authors()
$orderby     = sanitize_text_field($request['order_by']);   // not an SQL defense
$order       = sanitize_text_field($request['order']);
$search_term = sanitize_text_field($request['search']);
...
$query = "SELECT * FROM $table_name
   WHERE 1=1 AND (user_email LIKE '%$search_term%' OR
   display_name LIKE '%$search_term%' OR ...)
   ORDER BY $orderby $order LIMIT $offset, $authors_per_page;";
$posts = $wpdb->get_results($query, OBJECT);                // no prepare()

Every parameter is an injection point. search breaks out of the LIKE '%...%' string literal order_by and order inject into the identifier/keyword context after ORDER BY.per_page and page inject into the numeric LIMIT clause. The membership-listing handler in class-registered-users.php repeats the same pattern against a different table.

This was reproduced end-to-end against WP Post Author 3.10.0. A boolean oracle and a time-based oracle both fire, and the administrator account's password hash was extracted blind through the endpoint.

Solution

Upgrade to the WordPress Plugin WP Post Author version 4.1.0 or later.

Disclosure Timeline

July 27 2026 - Security Contact Request
August 03 2026 - Second Attempt
August 04 2026 - Vendor acknowledge
August 28 2026 - Ask if the fix has been released
September 9 2026 - Without response, the TRA will be published on September 16
September 10 2026 - The vendor confirms that they have fixed the issue and that it will be deployed soon.
October 05 2026 - Tenable asking for an ETA
October 05 2026 - The vendor has released version 4.0.0 and is requesting a retest.
October 05 2026 - Tenable indicated that the patch is incomplete and does not fix the report.
October 06 2026 - The vendor has released version 4.0.1 and is requesting a retest.
October 06 2026 - Tenable indicated that the patch is incomplete and does not fix the report.
October 08 2026 - The vendor has released version 4.1.0 and is requesting a retest.
October 08 2026 - Tenable confirm the fix
October 09 2026 - The vendor has released version 4.1.1 and is requesting a retest.
October 09 2026 - Tenable confirm that the fix is ​​still okay

All information within TRA advisories is provided “as is”, without warranty of any kind, including the implied warranties of merchantability and fitness for a particular purpose, and with no guarantee of completeness, accuracy, or timeliness. Individuals and organizations are responsible for assessing the impact of any actual or potential security vulnerability.

Tenable takes product security very seriously. If you believe you have found a vulnerability in one of our products, we ask that you please work with us to quickly resolve it in order to protect customers. Tenable believes in responding quickly to such reports, maintaining communication with researchers, and providing a solution in short order.

For more details on submitting vulnerability information, please see our Vulnerability Reporting Guidelines page.

If you have questions or corrections about this advisory, please email [email protected]