Database Cleaner

User-friendly tool to clean and optimize databases. Efficiently manages large databases, simplifying repair and ensuring peak performance.

v1.3.7Jordy MeowUpdated Added 10k+ installs100% rating
29
Score
135
Errors
297
Warnings
+0
Change

Category Scores

Security0
Repo100
Performance100
Maintainability19

Issues to Review

Prioritized issue groups from the latest Plugin Check scan

432 findings

Maintainability

252

11 issue groups

Security

127

11 issue groups

I18n

32

3 issue groups

WARNINGMaintainabilityDirect QueryUse of a direct database call is discouraged.105
Category
Maintainability
Occurrences
105
Severity
warning

Sample message

Use of a direct database call is discouraged.

WARNINGMaintainabilityNo CachingDirect database call without caching detected. Consider using wp_cache_get() / wp_cache_set() or wp_cache_delete().104
Category
Maintainability
Occurrences
104
Severity
warning

Sample message

Direct database call without caching detected. Consider using wp_cache_get() / wp_cache_set() or wp_cache_delete().

ERRORSecurityException output is not escapedAll output should be run through an escaping function (see the Security sections in the WordPress Developer Handbooks), found '"Count query for $item not found."'.35
Category
Security
Occurrences
35
Severity
error

Sample message

All output should be run through an escaping function (see the Security sections in the WordPress Developer Handbooks), found '"Count query for $item not found."'.

WARNINGSecurityInterpolated SQL is not preparedUse placeholders and $wpdb->prepare(); found interpolated variable $limit_clause at \t\t\t$limit_clause\n29
Category
Security
Occurrences
29
Severity
warning

Sample message

Use placeholders and $wpdb->prepare(); found interpolated variable $limit_clause at \t\t\t$limit_clause\n

ERRORI18nNon Singular String Literal DomainThe $domain parameter must be a single text string literal. Found: $this->domain21
Category
I18n
Occurrences
21
Severity
error

Sample message

The $domain parameter must be a single text string literal. Found: $this->domain

ERRORSecurityDatabase parameter is not escapedUnescaped parameter $query used in $wpdb->get_results()\n$query assigned unsafely at line 228.12
Category
Security
Occurrences
12
Severity
error

Sample message

Unescaped parameter $query used in $wpdb->get_results()\n$query assigned unsafely at line 228.

WARNINGSecurityNonce verification recommendedProcessing form data without nonce verification.11
Category
Security
Occurrences
11
Severity
warning

Sample message

Processing form data without nonce verification.

ERRORSecuritySQL query is not preparedUse placeholders and $wpdb->prepare(); found $query10
Category
Security
Occurrences
10
Severity
error

Sample message

Use placeholders and $wpdb->prepare(); found $query

ERRORI18nText Domain MismatchMismatched text domain. Expected 'database-cleaner' but got 'media-cleaner'.8
Category
I18n
Occurrences
8
Severity
error

Sample message

Mismatched text domain. Expected 'database-cleaner' but got 'media-cleaner'.

WARNINGSecurityDatabase parameter is not escapedUnescaped parameter $table_name used in $wpdb->get_results()7
Category
Security
Occurrences
7
Severity
warning

Sample message

Unescaped parameter $table_name used in $wpdb->get_results()

Show 15 more
ERRORSecurityLike Wildcards In Query7
Category
Security
Occurrences
7
Severity
error

Sample message

SQL wildcards for a LIKE query should be passed in through a replacement parameter. Found: LIKE '_oembed_%'.

ERRORMaintainabilityMissing direct file access protection7
Category
Maintainability
Occurrences
7
Severity
error

Sample message

PHP file should prevent direct access. Add a check like: if ( ! defined( 'ABSPATH' ) ) exit;

WARNINGMaintainabilityNon-prefixed class6
Category
Maintainability
Occurrences
6
Severity
warning

Sample message

Classes declared by a theme/plugin should start with the theme/plugin prefix. Found: "MeowKit_DBCLNR_Admin".

WARNINGMaintainabilityerror log error log6
Category
Maintainability
Occurrences
6
Severity
warning

Sample message

error_log() found. Debug code should not normally be used in production.

WARNINGSecurityMissing nonce verification6
Category
Security
Occurrences
6
Severity
warning

Sample message

Processing form data without nonce verification.

ERRORMaintainabilitydate date5
Category
Maintainability
Occurrences
5
Severity
error

Sample message

date() is affected by runtime timezone changes which can cause date/time to be incorrectly displayed. Use gmdate() instead.

ERRORMaintainabilityrand mt rand5
Category
Maintainability
Occurrences
5
Severity
error

Sample message

mt_rand() is discouraged. Use the far less predictable wp_rand() instead.

WARNINGSecurityUnfinished Prepare4
Category
Security
Occurrences
4
Severity
warning

Sample message

Replacement variables found, but no valid placeholders found in the query.

ERRORMaintainabilityfile system operations fclose4
Category
Maintainability
Occurrences
4
Severity
error

Sample message

File operations should use WP_Filesystem methods instead of direct PHP filesystem calls. Found: fclose().

ERRORMaintainabilityfile system operations fwrite4
Category
Maintainability
Occurrences
4
Severity
error

Sample message

File operations should use WP_Filesystem methods instead of direct PHP filesystem calls. Found: fwrite().

WARNINGMaintainabilitySchema Change3
Category
Maintainability
Occurrences
3
Severity
warning

Sample message

Attempting a database schema change is discouraged.

ERRORSecurityOutput is not escaped3
Category
Security
Occurrences
3
Severity
error

Sample message

All output should be run through an escaping function (see the Security sections in the WordPress Developer Handbooks), found '$nonce'.

WARNINGSecurityRequest data is not unslashed3
Category
Security
Occurrences
3
Severity
warning

Sample message

$_GET['page'] not unslashed before sanitization. Use wp_unslash() or similar

ERRORMaintainabilityfile system operations fopen3
Category
Maintainability
Occurrences
3
Severity
error

Sample message

File operations should use WP_Filesystem methods instead of direct PHP filesystem calls. Found: fopen().

ERRORI18nMissing Translators Comment3
Category
I18n
Occurrences
3
Severity
error

Sample message

A function call to __() with texts containing placeholders was found, but was not accompanied by a "translators:" comment on the line above to clarify the meaning of the placeholders.

Score History

First score snapshot

v1.3.7

29

Latest

Findings
432
Errors
135
Warnings
297
Check
2.0.0

Related Plugins

wp_head() cleaner

2k+ active installs

100
Change Table Prefix

1k+ active installs

99
99
Material Admin Theme

1k+ active installs

98
Aruba HiSpeed Cache

100k+ active installs

97