WordPress.DB.DirectDatabaseQuery.SchemaChange

Schema Change

The plugin runs a direct database query instead of using a higher-level WordPress API or cache-aware pattern.

medium weight

Why It Shows Up

Plugin Check found `$wpdb` access that queries the database directly, changes schema, or bypasses normal caching expectations.

Why It Matters

Direct queries can be correct, but they are easier to make unsafe, slower at scale, and harder for WordPress to cache or filter.

How to Fix

  • Use WordPress APIs such as post, term, metadata, option, or user functions when they fit the task.
  • If direct SQL is necessary, prepare dynamic values and add a clear caching strategy for repeated reads.
  • Keep schema changes in activation or upgrade routines and make them idempotent.

Affected Plugins

RankPluginScoreErrorsWarningsInstallsAddedUpdatedTop Issue
#1151Internet Archive Wayback Machine Link Fixer772221k+Database parameter is not escaped
#1152Tagembed Social Feeds Widget772113710k+Non-prefixed function
#1153Taggbox – Free Social Media Widgets, Review Badges & Shoppable UGC77231131k+Direct Query
#1154X-Currency – The Ultimate WooCommerce currency switcher for a smoother shopping experience7717771k+Non-prefixed global variable
#1155Web3 Crypto Payments by DePay for WooCommerce7861011k+Direct Query
#1156Real Category Management: Content Management in Category Folders794732k+Non-prefixed constant
#1157Stream8158080k+Direct Query
#1158SurveyX Builder – Easy Feedback, Poll, Quiz & Survey81222k+Interpolated SQL is not prepared
#1159Popup builder with Gamification, Multi-Step Popups, Page-Level Targeting, and WooCommerce Triggers8327360k+Direct Query
#1160Notifima – WooCommerce Stock Manager, Inventory Management, Waitlist85130403k+Text Domain Mismatch
#1161Enable Abilities for MCP87481k+Direct Query
#1162Bulk Page Generator and Mass Page Builder – Page Generator8726874k+Non-prefixed global variable
#1163Statify89533100k+Direct Query
#1164Taxonomy Metadata89494k+Direct Query
#1165External files in Media Library901668400Direct Query
#1166Rapid URL Indexer for WP – Index Websites in Google906281k+error log error log
#1167LinkCentral – URL shortener, Custom Links & Affiliate Link Shortener with Link Tracking937225400Direct Query
#1168Serial Numbers – Ultimate License Manager for Selling, Licensing & Securely Delivering Digital Content with WooCommerce9341281k+Direct Query
#1169Email Log9555380k+Non-prefixed hook name
#1170Pixelavo – Server Side Tracking & Pixel + AI Ads Tools95122k+Direct Query
#1171Remote Website Management by Watchful974123k+Direct Query
#1172WP Database Reset981105k+Direct Query
#1173Record of Consent Extension for Complianz1002400Schema Change