WordPress.DB.PreparedSQLPlaceholders.UnsupportedIdentifierPlaceholder

Unsupported Identifier Placeholder

A SQL query is built in a way that Plugin Check cannot verify as safely prepared.

critical weight

Why It Shows Up

The scan found missing, incorrect, quoted, unsupported, or mismatched SQL placeholders around `$wpdb->prepare()` usage.

Why It Matters

Broken preparation can leave dynamic SQL values unsafe or make queries behave differently than intended.

How to Fix

  • Keep placeholders in the SQL string and pass dynamic values as separate arguments.
  • Use the placeholder that matches the value type.
  • Do not quote placeholders manually, and use allowlists for identifiers or SQL fragments.

Affected Plugins

RankPluginScoreErrorsWarningsInstallsUpdatedTop Issue
#1Backup Migration219811,09380k+Non Prefixed Variable Found
#2GeoDirectory – WP Business Directory Plugin and Classified Listings Directory224,4623,97210k+Output Not Escaped
#3LearnPress – WordPress LMS Plugin for Create and Sell Online Courses222,3613,38470k+Non Prefixed Variable Found
#4WPFunnels – Funnel Builder for WooCommerce with Checkout & One Click Upsell225,9962,7905k+Text Domain Mismatch
#5Announcement & Notification Banner – Bulletin239301,5762k+Non Prefixed Variable Found
#6WPBot – AI ChatBot for Live Support, Lead Generation, AI Services232641,0185k+Non Prefixed Variable Found
#7Groundhogg — CRM, Newsletters, and Marketing Automation231529502k+Non Prefixed Variable Found
#8Backuply – Backup, Restore, Migrate and Clone24704551700k+Non Prefixed Variable Found
#9Bulk Edit Categories and Tags – Create Thousands Quickly on the Editor241,0259844k+Text Domain Mismatch
#10CF7 Apps – Honeypot, Database, Redirection, Webhook, and Addons for Contact Form 7241,0341,396300k+Non Prefixed Variable Found
#11Easy Form Builder by WhiteStudio — Drag & Drop Form Builder241933631k+Recommended
#12eCommerce Product Catalog Plugin for WordPress246213,1777k+Non Prefixed Function Found
#13Conversios: Google Analytics (GA4), Google Ads, Conversion and Analytics Tracking for Multi-Channels241071,46110k+Non Prefixed Variable Found
#14The Plus Addons for Elementor – Addons for Elementor, Page Templates, Widgets, Mega Menu, WooCommerce2412,053494100k+Text Domain Mismatch
#15WC Vendors – WooCommerce Multivendor, WooCommerce Marketplace, Product Vendors241685844k+Non Prefixed Class Found
#16Bulk Edit Products for WooCommerce – WP Sheet Editor2494193610k+Text Domain Mismatch
#17Bulk Edit Posts and Products in Spreadsheet249189129k+Text Domain Mismatch
#18WP Travel Engine – Tour Booking Plugin – Tour Operator Software242,0105,68820k+Non Prefixed Variable Found
#19All-in-one Sticky Floating Contact Form, Call, Click to Chat, and 50+ Social Icon Tabs – My Sticky Elements2535259740k+Non Prefixed Variable Found
#20Appointment Booking Calendar — Simply Schedule Appointments Booking Plugin2596073860k+Text Domain Mismatch
#21Floating Chat Widget: Contact Chat Icons, Telegram Chat, Line Messenger, WeChat, Email, SMS, Call Button – Chaty26113671400k+Non Prefixed Variable Found
#22Duplicate Post27447274300k+Unsafe Printing Function
#23My Sticky Bar – Floating Notification Bar & Sticky Header (formerly myStickymenu)28161400100k+Non Prefixed Variable Found
#24WPO365 | SEAMLESS WORDPRESS + MICROSOFT INTEGRATION (WPO365 | LOGIN)2820921710k+Exception Not Escaped
#25Optimole – Optimize Images | Convert WebP & AVIF | CDN & Lazy Load | Image Optimization2980162200k+Recommended
#26Companion Sitemap Generator – Simple, Smart, and SEO-Ready33118577k+Missing Translators Comment
#27Advanced Coupons for WooCommerce Coupons & Store Credit347421420k+Non Prefixed Variable Found
#28ShopMagic Abandoned Cart Recovery for WooCommerce3516232k+Non Prefixed Variable Found
#29ALD – Dropshipping and Fulfillment for AliExpress and WooCommerce355034310k+Missing Unslash
#30Microsoft Clarity3648163200k+Recommended
#31WPO365 | MICROSOFT 365 GRAPH MAILER371128310k+Text Domain Mismatch
#32WPEPP – Essential Security, Password Protect & Login Page Customizer3934293k+Unsupported Identifier Placeholder
#33Country State City Dropdown CF74035545k+Direct Query
#34Hostinger Reach – AI-Powered Email Marketing for WordPress409461m+Direct Query
#35hCaptcha for WP421151870k+Exception Not Escaped
#36WP Mail Log42422910k+Text Domain Mismatch
#37User Role Editor43117145700k+Output Not Escaped
#38Social Media Auto Poster – Schedule & Publish to Buffer58232128k+Dynamic Hookname Found
#39Kit (formerly ConvertKit) – Email Newsletter, Email Marketing, Membership, Subscribers and Landing Pages628110040k+missing direct file access protection
#40Interlinks Manager – Internal Links Optimizer8017138k+Unescaped DBParameter