WordPress.DB.PreparedSQL.InterpolatedNotPrepared
Interpolated SQL is not prepared
Variables are interpolated into a SQL string before the query is prepared.
Why It Shows Up
The scan found dynamic values placed directly inside SQL, often through string interpolation, before `$wpdb->prepare()` can safely bind them.
Why It Matters
Preparing a query after unsafe interpolation does not reliably protect the dynamic value.
How to Fix
- Replace interpolated variables with placeholders.
- Pass each dynamic value as a separate `$wpdb->prepare()` argument.
- Use allowlists for SQL identifiers and directions that cannot be represented as normal values.
References
Affected Plugins
| Rank | Plugin | Score | Errors | Warnings | Installs | Added | Updated | Top Issue |
|---|---|---|---|---|---|---|---|---|
| #1401 | Smoove connector for Elementor forms | 41 | 22 | 60 | 600 | Nonce verification recommended | ||
| #1402 | Solid Post Likes | 41 | 25 | 63 | 500 | Direct Query | ||
| #1403 | Feedback Company | 41 | 63 | 36 | 800 | Output is not escaped | ||
| #1404 | Abandoned Cart Recovery for WooCommerce | 41 | 20 | 202 | 4k+ | Request data is not unslashed | ||
| #1405 | M-Pesa(Kenya) Checkout for Woocommerce | 41 | 46 | 38 | 1k+ | Text Domain Mismatch | ||
| #1406 | Agoda Affiliate Partners Text Link Generator | 42 | 4 | 40 | 500 | Interpolated SQL is not prepared | ||
| #1407 | BP Auto Group Join | 42 | 55 | 55 | 700 | Output is not escaped | ||
| #1408 | Comment Reply Email | 42 | 21 | 23 | 500 | Unsafe printing function | ||
| #1409 | Companion Revision Manager – Revision Control | 42 | 18 | 28 | 4k+ | Unsafe printing function | ||
| #1410 | Contador de Visitas | 42 | 37 | 25 | 500 | SQL query is not prepared | ||
| #1411 | Etsy Shop | 42 | 58 | 21 | 3k+ | Unsafe printing function | ||
| #1412 | File Media Renamer | 42 | 16 | 42 | 2k+ | Input is not sanitized | ||
| #1413 | Geo Blocker – Control Site Access by Region and IP | 42 | 10 | 64 | 1k+ | Direct Query | ||
| #1414 | Image Uploader for Welcart | 42 | 27 | 24 | 3k+ | Output is not escaped | ||
| #1415 | WP All Import – Import SEO Settings for Rank Math SEO | 42 | 18 | 44 | 7k+ | Nonce verification recommended | ||
| #1416 | iyzico for WooCommerce | 42 | 34 | 54 | 10k+ | Unsafe printing function | ||
| #1417 | LeadSnap | 42 | 14 | 84 | 1k+ | Input is not validated | ||
| #1418 | Post Types Order | 42 | 45 | 43 | 600k+ | wp function not compatible with requires wp | ||
| #1419 | WP Email Log – PostBox | 42 | 2 | 81 | 700 | Nonce verification recommended | ||
| #1420 | Product Price History for WooCommerce | 42 | 101 | 800 | Nonce verification recommended | |||
| #1421 | Reusable Blocks Extended | 42 | 38 | 15 | 20k+ | Output is not escaped | ||
| #1422 | Simple Googlebot Visit | 42 | 32 | 67 | 1k+ | Non Singular String Literal Domain | ||
| #1423 | StifLi Flex MCP – MCP Server with undo for ChatGPT, Claude & Gemini | 42 | 2 | 110 | 1k+ | Interpolated SQL is not prepared | ||
| #1424 | Transients Manager | 42 | 45 | 50 | 20k+ | Output is not escaped | ||
| #1425 | Ultimate Coming Soon Page, Maintenance Mode & Under Construction – Gutenberg Block Builder & Landing Page | 42 | 15 | 89 | 9k+ | Non-prefixed global variable | ||
| #1426 | WC Price History | 42 | 18 | 23 | 4k+ | Database parameter is not escaped | ||
| #1427 | WP Bulk Delete | 42 | 7 | 130 | 100k+ | Direct Query | ||
| #1428 | WP Fingerprint | 42 | 34 | 47 | 9k+ | Direct Query | ||
| #1429 | Advanced All in One Admin Search by WP Spotlight | 42 | 25 | 25 | 900 | Missing Version | ||
| #1430 | Auto Alt Text | 43 | 52 | 13 | 4k+ | Exception output is not escaped | ||
| #1431 | Pods Gravity Forms Add-On | 43 | 79 | 1k+ | Missing nonce verification | |||
| #1432 | Qodax Checkout Manager – Checkout Field Editor for WooCommerce | 43 | 17 | 27 | 400 | Interpolated SQL is not prepared | ||
| #1433 | WP Hotel Booking WPML Support | 43 | 10 | 52 | 400 | Direct Query | ||
| #1434 | WP Mail Log | 43 | 40 | 29 | 10k+ | Text Domain Mismatch | ||
| #1435 | Advanced Dynamic Pricing and Discount Rules for WooCommerce | 44 | 2 | 813 | 20k+ | Non-prefixed namespace | ||
| #1436 | Proxy & VPN Blocker | 44 | 74 | 1k+ | Nonce verification recommended | |||
| #1437 | Simple Full Screen Background Image | 44 | 23 | 13 | 10k+ | Output is not escaped | ||
| #1438 | Icons Font Loader – Load Web Fonts and Icon Libraries | 45 | 47 | 33 | 2k+ | Text Domain Mismatch | ||
| #1439 | JetHost Total Care – Security & Enhancements | 45 | 10 | 85 | 800 | Direct Query | ||
| #1440 | Popup Box – Easily Create WordPress Popups | 45 | 7 | 151 | 7k+ | Non-prefixed global variable | ||
| #1441 | Related Posts By PickPlugins | 45 | 4 | 84 | 3k+ | Non-prefixed global variable | ||
| #1442 | Super Blank | 45 | 131 | 56 | 9k+ | Missing direct file access protection | ||
| #1443 | Easy Subscribe | 46 | 132 | 800 | Direct Query | |||
| #1444 | GetAutoSEO AI Tool | 46 | 10 | 254 | 2k+ | Direct Query | ||
| #1445 | Live Copy Paste for Elementor – Cross Domain Copy Paste & Page Duplicator | 46 | 13 | 25 | 7k+ | Request data is not unslashed | ||
| #1446 | Podcast Player – Your Podcasting Companion | 46 | 14 | 133 | 10k+ | Non-prefixed global variable | ||
| #1447 | Repeater Fields for Gravity Forms | 46 | 134 | 41 | 1k+ | wp function not compatible with requires wp | ||
| #1448 | WP All Import – Import SEO Settings for Yoast SEO | 46 | 19 | 26 | 20k+ | Nonce verification recommended | ||
| #1449 | Auto Focus Keyword for SEO | 47 | 13 | 44 | 2k+ | Interpolated SQL is not prepared | ||
| #1450 | 404 Image Redirection (Replace Broken Images) | 47 | 118 | 85 | 600 | Text Domain Mismatch |
