WordPress.DB.RestrictedFunctions.mysql_mysqli_free_result
mysql mysqli free result
The plugin uses a raw MySQL extension or class instead of WordPress database APIs.
Why It Shows Up
The scan found `mysql_*`, `mysqli_*`, PDO MySQL, or related database functions in plugin code.
Why It Matters
Bypassing `$wpdb` can ignore WordPress database configuration, escaping conventions, character sets, and compatibility layers.
How to Fix
- Replace raw MySQL calls with `$wpdb` methods or higher-level WordPress APIs.
- Use `$wpdb->prepare()` for dynamic values.
- If a third-party library requires a database connection, isolate it and document why WordPress APIs cannot be used.
References
Affected Plugins
| Rank | Plugin | Score | Errors | Warnings | Installs | Added | Updated | Top Issue |
|---|---|---|---|---|---|---|---|---|
| #1 | 404 Solution | 15 | 582 | 1,532 | 10k+ | Non-prefixed class | ||
| #2 | Matomo Analytics – Powerful, Privacy-First Insights for WordPress | 19 | 1,993 | 892 | 100k+ | Exception output is not escaped | ||
| #3 | Brizy – Page Builder | 20 | 585 | 726 | 60k+ | Output is not escaped | ||
| #4 | Duplicator – Backups & Migration Plugin – Cloud Backups, Scheduled Backups, & More | 20 | 2,879 | 1,979 | 1m+ | Non-prefixed global variable | ||
| #5 | wpDataTables – WordPress Data Table, Dynamic Tables & Table Charts Plugin | 21 | 1,829 | 1,534 | 60k+ | Output is not escaped | ||
| #6 | WP Umbrella: Security Backup Restore & Monitoring | 22 | 1,001 | 1,191 | 80k+ | Exception output is not escaped | ||
| #7 | WP BackItUp Community Edition | 23 | 257 | 989 | 6k+ | Non-prefixed global variable | ||
| #8 | WP STAGING – Backups & Restore, Migration & Clone Plugin – Cloud Backups, Scheduled Backups | 23 | 1,580 | 1,786 | 100k+ | Non-prefixed global variable | ||
| #9 | Free 1-Click WordPress Migration | 24 | 224 | 244 | 300 | Direct Query | ||
| #10 | Backuply – Backup, Restore, Migrate and Clone | 24 | 729 | 553 | 600k+ | Non-prefixed global variable | ||
| #11 | Softaculous | 24 | 115 | 50 | 10k+ | file system operations fread | ||
| #12 | MapSVG – Vector maps, Image maps, Google Maps | 26 | 92 | 56 | 1k+ | Missing direct file access protection | ||
| #13 | EZ SQL Reports Shortcode Widget and DB Backup | 27 | 165 | 158 | 500 | Output is not escaped | ||
| #14 | User Spam Remover | 31 | 115 | 14 | 1k+ | Output is not escaped | ||
| #15 | PW WooCommerce Bulk Edit | 34 | 219 | 149 | 20k+ | Unsafe printing function |
