WordPress.DB.PreparedSQL.InterpolatedNotPrepared

Interpolated SQL is not prepared

Variables are interpolated into a SQL string before the query is prepared.

critical weight

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.

Affected Plugins

RankPluginScoreErrorsWarningsInstallsAddedUpdatedTop Issue
#901Simple Ajax Chat – Add a Fast, Secure Chat Box321082662k+Output is not escaped
#902Spoki – Chat Buttons and WooCommerce Notifications321,074260700Unsafe printing function
#903Stock Locations for WooCommerce325493601k+Output is not escaped
#904Stock Sync for WooCommerce323622321k+Text Domain Mismatch
#905System Dashboard32912051k+Request data is not unslashed
#906Thrive Automator32848410k+SQL query is not prepared
#907Tumult Hype Animations32561171k+Output is not escaped
#908Ultimate Store Kit – Addon For WooCommerce, EDD and Elementor32572934k+Post Not In exclude
#909WebwinkelKeur: Webshop keurmerk & reviews for WordPress32200474k+Short PHP open tag found
#910Management App for WooCommerce – Order notifications, Order management, Lead management, Uptime Monitoring32196160900Text Domain Mismatch
#911BEAR – Bulk Editor and Products Manager Professional for WooCommerce by Pluginus.Net32593340k+Non-prefixed global variable
#912WP Bannerize Pro32281216800Text Domain Mismatch
#913wp-jalali322196610k+Text Domain Mismatch
#914SEOPress – AI SEO Plugin & On-site SEO32138429300k+Non-prefixed global variable
#915WP-Stats322371262k+Output is not escaped
#916WPCasa – Real Estate for WordPress32854291k+Non-prefixed global variable
#917wpDirAuth32250135500wp function not compatible with requires wp
#918Privacy Policy Generator – WPLP Legal Pages322640910k+Non-prefixed global variable
#919Advanced Forms for ACF331692783k+Non-prefixed hook name
#920Auto Listings – Car Listings & Car Dealership Plugin for WordPress33803212k+Non-prefixed global variable
#921Addi – Cuotas que se adaptan a ti331062092k+Direct Query
#922Chartify – WordPress Chart Plugin33764113k+Non-prefixed global variable
#923ChatHelp – Click to Chat Button, WooCommerce Chat to Order & Floating Chat Form33572041k+Non-prefixed global variable
#924Companion Auto Update3315929840k+Direct Query
#925Companion Sitemap Generator – Simple, Smart, and SEO-Ready33118577k+Missing Translators Comment
#926Contact List – Online Staff Directory & Address Book331183421k+Nonce verification recommended
#927Chatbot with IBM watsonx Assistant3332483400Non Singular String Literal Domain
#928Easy Upload Files During Checkout33218199500Unsafe printing function
#929EchBay Phonering Alo3374471k+Output is not escaped
#930GetResponse Forms by Optin Cat33681381k+Missing direct file access protection
#931GSheetConnector for Forminator Forms331282011k+Non-prefixed global variable
#932HurryTimer – An Scarcity and Urgency Countdown Timer for WordPress & WooCommerce3337713920k+Unsafe printing function
#933Flipbox – Awesomes Flip Boxes Image Overlay334007,27910k+Input is not validated
#934ImageLinks – Interactive Image Builder with Hotspots33517901k+Text Domain Mismatch
#935Inactive User Deleter33453170800Output is not escaped
#936InPost Gallery33105245700Non-prefixed global variable
#937ITRO Popup Plugin335911356k+Output is not escaped
#938Logo Showcase Ultimate – Logo Carousel, Logo Slider & Logo Grid332741063k+Text Domain Mismatch
#939Forms for Mailchimp by Optin Cat – Grow Your MailChimp List33711332k+Missing direct file access protection
#940MWB HubSpot for WooCommerce – CRM, Abandoned Cart, Email Marketing, Marketing Automation & Analytics33262797k+Non-prefixed global variable
#941MAS Companies For WP Job Manager33623081k+Non-prefixed hook name
#942MaxiBlocks Builder | 17,000+ Design Assets, Patterns, Icons & Starter Sites332503700Non-prefixed function
#943Membership For WooCommerce3340659900Non-prefixed global variable
#944Molongui Post Contributors: Multi-Role Contributor Attribution33240162400Output is not escaped
#945News Announcement Scroll332372592k+Non-prefixed global variable
#946Nomad World Map33424191700Text Domain Mismatch
#947Notification Master – Real-Time WordPress Notifications With Email, SMS, Webhooks & More332932151k+Text Domain Mismatch
#948PW WooCommerce Gift Cards3323818620k+Output is not escaped
#949Frisbii Pay33912921k+Non-prefixed global variable
#950Review Slider for WooCommerce33160422400Non-prefixed global variable