Optimize Database after Deleting Revisions

One-click database optimization with precise revision cleanup and flexible scheduling. Speeding up sites since 2011!

v5.3.0NerdPressUpdated Added 60k+ installs94% rating
36
Score
644
Errors
127
Warnings
+0
Change

Category Scores

Security0
Repo94
Performance100
Maintainability59

Issues to Review

Prioritized issue groups from the latest Plugin Check scan

771 findings

Security

580

10 issue groups

Maintainability

117

7 issue groups

I18n

73

4 issue groups

Repo Compliance

1

1 issue group

ERRORSecurityOutput Not EscapedAll output should be run through an escaping function (see the Security sections in the WordPress Developer Handbooks), found '"')) {\r\n'.217
Category
Security
Occurrences
217
Severity
error

Sample message

All output should be run through an escaping function (see the Security sections in the WordPress Developer Handbooks), found '"')) {\r\n'.

ERRORSecurityNot PreparedUse placeholders and $wpdb->prepare(); found $i199
Category
Security
Occurrences
199
Severity
error

Sample message

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

ERRORSecurityUnsafe Printing FunctionAll output should be run through an escaping function (like esc_html_e() or esc_attr_e()), found '_e'.86
Category
Security
Occurrences
86
Severity
error

Sample message

All output should be run through an escaping function (like esc_html_e() or esc_attr_e()), found '_e'.

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

Sample message

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

WARNINGMaintainabilityDirect QueryUse of a direct database call is discouraged.40
Category
Maintainability
Occurrences
40
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().40
Category
Maintainability
Occurrences
40
Severity
warning

Sample message

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

ERRORSecurityUnescaped DBParameterUnescaped parameter $odb_class->odb_utilities_obj used in $wpdb->get_results()\n$odb_class->odb_utilities_obj used without escaping.31
Category
Security
Occurrences
31
Severity
error

Sample message

Unescaped parameter $odb_class->odb_utilities_obj used in $wpdb->get_results()\n$odb_class->odb_utilities_obj used without escaping.

ERRORMaintainabilitywp function not compatible with requires wpFunction "get_post_types()" requires WordPress 2.9.0, but your plugin minimum supported version is WordPress 2.8.0.28
Category
Maintainability
Occurrences
28
Severity
error

Sample message

Function "get_post_types()" requires WordPress 2.9.0, but your plugin minimum supported version is WordPress 2.8.0.

WARNINGSecurityMissing Unslash$_GET['_wpnonce'] not unslashed before sanitization. Use wp_unslash() or similar26
Category
Security
Occurrences
26
Severity
warning

Sample message

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

ERRORI18nNon Singular String Literal TextThe $text parameter must be a single text string literal. Found: $msg8
Category
I18n
Occurrences
8
Severity
error

Sample message

The $text parameter must be a single text string literal. Found: $msg

Show 12 more
ERRORSecurityLike Wildcards In Query5
Category
Security
Occurrences
5
Severity
error

Sample message

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

WARNINGSecurityInput Not Sanitized5
Category
Security
Occurrences
5
Severity
warning

Sample message

Detected usage of a non-sanitized input variable: $_GET['_wpnonce']

WARNINGSecurityUnescaped DBParameter4
Category
Security
Occurrences
4
Severity
warning

Sample message

Unescaped parameter $this->sql used in $wpdb->get_results()\n$this->sql assigned unsafely at line 181.

ERRORMaintainabilitydate date4
Category
Maintainability
Occurrences
4
Severity
error

Sample message

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

WARNINGSecurityRecommended4
Category
Security
Occurrences
4
Severity
warning

Sample message

Processing form data without nonce verification.

WARNINGSecurityInterpolated Not Prepared3
Category
Security
Occurrences
3
Severity
warning

Sample message

Use placeholders and $wpdb->prepare(); found interpolated variable {$where1} at {$where1}\r\n

WARNINGMaintainabilityDiscouraged2
Category
Maintainability
Occurrences
2
Severity
warning

Sample message

The use of function set_time_limit() is discouraged

WARNINGI18nNo Html Wrapped Strings2
Category
I18n
Occurrences
2
Severity
warning

Sample message

Translatable string should not be wrapped in HTML. Found: '<span class="odb-optimized">TABLE OPTIMIZED</span>'

ERRORMaintainabilitymissing direct file access protection2
Category
Maintainability
Occurrences
2
Severity
error

Sample message

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

WARNINGMaintainabilitySchema Change1
Category
Maintainability
Occurrences
1
Severity
warning

Sample message

Attempting a database schema change is discouraged.

ERRORI18nLoad plugin textdomain Param2Found1
Category
I18n
Occurrences
1
Severity
error

Sample message

The parameter "// domain\r\n\t\t\t\tfalse" at position #2 of load_plugin_textdomain() has been deprecated since WordPress version 2.7.0. Use "" instead.

ERRORRepo Complianceplugin header no license1
Category
Repo Compliance
Occurrences
1
Severity
error

Sample message

Missing "License" in Plugin Header. Please update your Plugin Header with a valid GPLv2 (or later) compatible license.

Score History

First score snapshot

v5.3.0

36

Latest

Findings
771
Errors
644
Warnings
127
Check
2.0.0

Related Plugins

Change Table Prefix

1k+ active installs

99
Transient Cleaner

1k+ active installs

96
AAA Option Optimizer

9k+ active installs

91
Index WP Users For Speed

1k+ active installs

77
Search Regex

100k+ active installs

76