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
#51Trace My IP – Visitor IP Tracker, Stats Analytics & Page Views Counter with Email Alerts208663381k+wp function not compatible with requires wp
#52Razorpay for WooCommerce20974855100k+Non-prefixed function
#53Premium Packages – Sell Digital Products Securely202,0322,2322k+Non-prefixed global variable
#54School Management System – WPSchoolPress203535,2751k+Non-prefixed global variable
#55Store Locator WordPress212,3721,57210k+Text Domain Mismatch
#56Backup Migration219811,09380k+Non-prefixed global variable
#57Forumax – AI Powered Advanced Community Forum Plugin214,9354,354600Text Domain Mismatch
#58bbPress219293,672100k+Non-prefixed function
#59CallTrackingMetrics219232863k+Unsafe printing function
#60Captcha Them All213003236k+Output is not escaped
#61CartFlows – Funnel Builder & Checkout Plugin for WooCommerce21462656200k+Text Domain Mismatch
#62Smart Grid-Layout Design for Contact Form 7211,12673410k+Output is not escaped
#63SMS Extension for Contact Form 7217201,387400Non-prefixed global variable
#64Daily Prayer Time219471,7801k+Non-prefixed global variable
#65DELUCKS SEO213621,171400Missing nonce verification
#66Free Downloads WooCommerce214303594k+Output is not escaped
#67Duplicator – Backups & Migration Plugin – Cloud Backups, Scheduled Backups, & More212,5721,2771m+Output is not escaped
#68Ebook Store216661,087700Non-prefixed global variable
#69eRoom – Webinar & Meeting Plugin for Zoom, Google Meet, Microsoft Teams211864379k+Non-prefixed global variable
#70EventPrime – Events Calendar, Bookings and Tickets218734,3087k+Non-prefixed global variable
#71Feeds for YouTube (YouTube video, channel, and gallery plugin)21558978100k+Output is not escaped
#72Campaign Monitor for WordPress213864612k+Non-prefixed global variable
#73Front End Users217192,759400Non-prefixed global variable
#74Frontend Dashboard21384945500Non-prefixed function
#75If-So Dynamic Content – Elementor & All Page Builders Personalization218897257k+Unsafe printing function
#76Imagify Image Optimization: Optimize Images | Compress & Convert to WebP/AVIF214268621m+Non-prefixed global variable
#77Leyka212573,4462k+Request data is not unslashed
#78MailChimp Subscribe Form, Optin Builder, PopUp Builder, Form Builder211,1333,0112k+Non-prefixed global variable
#79Mooberry Book Manager211,0403991k+Text Domain Mismatch
#80MotoPress Hotel Booking213,0671,03710k+Text Domain Mismatch
#81Points Management System For Gamification, Ranks, Badges, and Loyalty Rewards Program – myCred211,4783,33710k+Non-prefixed global variable
#82Landing Page Builder – Coming Soon page, Maintenance Mode, Lead Page, WordPress Landing Pages211,1202,9139k+Non-prefixed global variable
#83Paid Membership Subscriptions – Effortless Memberships, Recurring Payments & Content Restriction211,9345,24810k+Non-prefixed hook name
#84User Profile Builder – Beautiful User Registration Forms, User Profiles & User Role Editor217011,46550k+Missing Translators Comment
#85PublishPress Planner – Editorial Calendar, Marketing Content, Kanban Board216038906k+Output is not escaped
#86Quill Forms | Conversational Multi Step Forms, Surveys & quizzes214013693k+Text Domain Mismatch
#87Razorpay for Gravity Forms2141147600Exception output is not escaped
#88Five Star Restaurant Reservations – WordPress Booking Plugin211,0991,14710k+Output is not escaped
#89Royal Addons for Elementor – Addons and Templates Kit for Elementor2113,0112,530600k+Text Domain Mismatch
#90Seamless Donations is Sunset216005142k+Text Domain Mismatch
#91SeatReg213121,637400Missing nonce verification
#92Professional Social Sharing Buttons, Icons & Related Posts – Shareaholic2132718110k+Output is not escaped
#93ThirstyAffiliates – Affiliate Links, Link Branding, Link Tracking & Marketing Plugin2119066030k+Non-prefixed global variable
#94UPC/EAN/GTIN Barcode Generator/Importer21776311500Exception output is not escaped
#95URL Shortify – Simple and Easy URL Shortener211,5192,68710k+Non-prefixed global variable
#96Buckaroo Woocommerce Payments Plugin215843262k+Exception output is not escaped
#97BuddyPress WooCommerce My Account Integration. Create WooCommerce Member Pages216681,569800Non-prefixed global variable
#98WebP Express21160427300k+Non-prefixed global variable
#99Wise Chat214705065k+Output is not escaped
#100Pay For Post with WooCommerce219601,4741k+Non-prefixed global variable