Black Friday: 30% OFF on all plans, applied automatically at checkout View plans
Log in Cart

SigmaPlugin | Advanced Database Cleaner PRO Changelog

Every recorded version, newest first, with what changed in each one.

Latest 4.2.011 versionsSince Jan 2025

Undated · 1 version

  1. 4.2.0

    Latest
    2 new5 improvements4 fixes1 change
    New
    • 3 WooCommerce cleanup tools: Orphaned product variations, orphaned customer analytics, and expired customer sessions
    • Users can now assign items (belongs-to data) to themes/plugins that are not installed
    Improved
    • [Premium] New relations added to the Remote Scan database
    • Set "Keep last" to 30 days by default for completed actions in Action Scheduler to comply with the standard
    • Remember the "Items per page" value even after refreshing the page
    • The plugin menu is now called "DB Cleaner" instead of "WP DB Cleaner"
    • Refactored several parts of the codebase for better performance and maintainability
    Fixed
    • Prevent concurrency issues when creating "adbc_uploads_F..." folder by using a locking mechanism
    • 502 Bad Gateway error at the end of a scan triggered by unlink
    • REST permission errors returning HTTP 500 instead of 403 for unauthenticated requests
    • Don't display normal warnings when a critical warning exists
    Changes
    • Info: We created [WOptimize]

2026 · 3 versions

  1. 4.1.1

    1 improvement4 fixes1 security
    Improved
    • Refactored several parts of the codebase to improve performance and maintainability
    Fixed
    • Resolved an issue where the "No route was found matching the URL" error occurred when the default REST API URL was modified
    • Fixed ReflectionFunction::__construct error requiring a Closure or string as the first argument
    • Corrected "Invalid setting key" error when hiding the post types menu item
    • [Premium + Pro-Lifetime] Addressed undefined array key DOCUMENT_ROOT on sites running WP-Cron via system cron and WP-CLI in the Easy Digital Downloads (EDD) SDK package
    Security
    • [Premium + Pro-Lifetime] Patched a security vulnerability in the EDD SDK package
  2. 4.1.0

    5 new9 improvements7 fixes
    New
    • Added "Post Types" cleanup module
    • In the General Cleanup tab, added a toggle for each item: Auto Count or Manual Count
    • Added an action to convert table engines to InnoDB
    • Added quick actions per row (available on the right side) for faster processing
    • Added the ability to view table data, including rows content, column structure, indexes, and more
    Improved
    • Each table now displays the percentage of total database size it occupies, providing a clearer view of database distribution
    • Added an action to refresh table statistics and information
    • Prevent actions (such as delete) on WordPress core items by default (can be disabled in settings)
    • Add file path for cron jobs actions
    • Added direct links in notifications to help users quickly access logs or settings
    • Reduced (or eliminated) unnecessary frontend and backend requests/queries, executing them only when needed
    • Added a setting to bypass the confirmation modal for actions such as delete
    • In the settings page, invalid values are now handled locally with error messages, without sending REST requests
    • Refactored several parts of the codebase for better performance and maintainability
    Fixed
    • Resolved an issue where RecursiveIteratorIterator could trigger excessive server load in certain environments
    • Corrected the refresh icon behavior in the Addons Activity module to ensure consistent updates
    • Fixed an issue where multiple folders were unintentionally created when deleting plugin settings
    • Resolved a multisite issue where update notifications were displayed even when the latest version was already installed
    • Fixed a “_load_textdomain_just_in_time was called incorrectly” warning caused by premature calls to wp_get_schedules before the init hook
    • Prevented scan crash caused by natsort receiving a boolean instead of an array
    • Adjust display properties for img/svg in WP admin menu to prevent layout shifts
  3. 4.0.7

    2 new5 improvements4 fixes
    New
    • Added support for both SQL and native deletion methods in the Options, Transients, Postmeta, and Usermeta modules
    • [Pro-Lifetime] Implemented a scan credits system in the new Pro plugin version
    Improved
    • [Pro-Lifetime] Implement data migration between the new Pro version and the old Pro version
    • Added links to notification popups for easier navigation
    • Added Remote Scan balance to the top bar of the plugin interface
    • Added several known usermeta and postmeta entries to the internal dictionaries
    • General code improvements and CSS enhancements
    Fixed
    • Resolved conflict issues when different plugin versions are activated at the same time
    • General Cleanup data now refreshes correctly when clicking the eye icon after changing the "Keep last" value
    • Resolved "Invalid setting key" error when saving settings (Nginx edge case)
    • Fixed issue where the plugin menu could disappear in some cases when version conflicts occur

Undated · 4 versions

  1. 4.0.6

    4 improvements6 fixes
    Improved
    • In Trashed Posts, only WordPress core post types are now displayed to prevent accidental deletion of unexpected data.
    • Allow selecting items by groups under the "General Cleanup" tab.
    • Increase the maximum number of selectable items per page from 200 to 1000.
    • General improvements to code quality and styling.
    Fixed
    • Some SQL queries did not run when database tables had different collations in Multisite setups.
    • The "Show value" modal did not appear for expired transients.
    • Deleted items could reappear as "ghost" entries after switching tabs and coming back.
    • Some UI elements were incorrectly hidden on frontend pages.
    • Extra characters in some translations within the UK '.po' file.
    • [Premium] After a scan completed, correct counts were shown but disappeared when switching tabs and returning.
  2. 4.0.5

    9 improvements4 fixes
    Improved
    • Improved the General Cleanup page to reduce the number of REST requests for better performance.
    • Take into account the site_status_autoloaded_options_size_limit filter when displaying the autoload size warning.
    • Added bulk actions to the bottom of tables as well.
    • Added the ability to select multiple items using the Shift key.
    • Optimized loading of scan results from files for improved performance.
    • Optimized the calculation of non-scanned items for better performance.
    • Added plugin settings to the System Info page.
    • Unified the structure of installed add-ons data sent during Remote Scan.
    • Various improvements to code quality, security, and styling.
    Fixed
    • The plugin left menu was unstable in some environments.
    • Some filters did not correctly reflect the displayed data.
    • Certain strings were not translated in Multisite REST responses.
    • Some special usermeta entries in Multisite and custom table prefix setups were not correctly assigned to WordPress core.
  3. 4.0.4

    5 improvements2 fixes
    Improved
    • Refactored code to improve loading performance by caching data.
    • Added translatable strings and corrected some date-format inconsistencies.
    • Improved UI consistency across all tables.
    • Increased Database Rows Batch limit to 50,000 by default for better performance on large sites.
    • Added a refresh icon to the highlighted orange sections for easier counts refresh.
    Fixed
    • Resolved style conflicts with other plugins.
    • Corrected an issue where sorting usermeta by meta key returned empty results when the "duplicated" filter was applied.
  4. 4.0.3

    5 improvements1 fix
    Improved
    • Optimized the loading of the Post Meta module for large websites.
    • Highlighted preset filter section counters are now fetched via separate endpoints for better performance.
    • Optimized the duplicated meta module to improve performance.
    • Optimized the General Cleanup module for faster loading.
    • Overall performance improvements and internal code optimizations.
    Fixed
    • Improved compatibility with PHP 7.

2025 · 2 versions

  1. 4.0.2

    4 new6 improvements4 fixes
    New
    • [Free] new setting allowing to control the number of items retrieved from the database per request for better performance.
    • Choose between native WordPress functions or direct SQL queries for deleting items (new setting added).
    • Items in the General Cleanup page are now loaded individually, so content appears immediately without waiting for all items.
    • Items can now be deleted one by one in General Cleanup without reloading the entire list after each action.
    Improved
    • Synchronize Axios timeout (React) with PHP max execution time to avoid early request timeouts.
    • In trashed comments, count only trashed comments and ignore comments belonging to trashed posts.
    • Use crc32 hashing to speed up detection of duplicate values.
    • General code cleanup and optimization.
    • [Premium] Added new WordPress-related items for improved identification.
    • Tested with WordPress 6.9.
    Fixed
    • Conflict with another plugin injecting links into our plugin settings.
    • Syntax error: unexpected '...' (T_ELLIPSIS), expecting ']'.
    • Deletion of transients and expired_transients in multisite within the sitemeta table when the transient's site_id is invalid.
    • Duplicate "squared" transients and expired transients being displayed.
  2. 4.0.1

    2 fixes
    Fixed
    • handling FS_METHOD ftpext in the file system class.
    • sub-sites in Multisites were not loaded correctly

Undated · 1 version

  1. 4.0.0

    19 new7 improvements14 changes
    New
    • Duplicated post meta cleanup type.
    • Duplicated user meta cleanup type.
    • Duplicated comment meta cleanup type.
    • Duplicated term meta cleanup type.
    • oEmbed caches cleanup type.
    • Estimated size to clean displayed for each cleanup type, plus a total freed-space summary before running a cleanup.
    • Sorting capability added to cleanup preview tables (e.g. by name, date, size, site ID).
    • Value viewer added to several cleanup types, displaying serialized or JSON data in raw or formatted views.
    • Dedicated Post Meta Management module to list, sort, inspect, and clean post meta, including detection of unused and duplicated metadata.
    • Dedicated User Meta Management module to list, sort, inspect, and clean user meta, including detection of unused and duplicated metadata.
    • Dedicated Transients Management module to inspect, sort, and clean transients, with expiration tracking, detection of large transients, and control over their autoload status.
    • Tables Management can now detect tables with invalid prefixes that do not belong to the current WordPress installation, with their visibility controlled from the Settings page.
    • Options Management now includes a formatted value viewer, detection of large options, and warnings for heavy autoloaded options to help reduce autoload size.
    • Cron Jobs Management now includes detection of cron jobs with no valid action/callback to help you clean them safely.
    • All six management modules now detect items owned by WordPress core and Advanced Database Cleaner, making it clearer where data comes from.
    • All six management modules now include an Attention Area that highlights priority issues, warns you about items requiring action, and helps you quickly identify and target them.
    • Introduced a built-in error and exception logging system, allowing logs to be copied or downloaded for support or user-side investigations.
    • Added tools to display the current database size, show or hide the plugin’s menu tabs, and access the WordPress debug log directly from the interface.
    • Modern, fully responsive interface rebuilt with React for a smoother, faster, and more intuitive user experience.
    Improved
    • Cleaning process in the General Cleanup module now uses WordPress native deletion functions for deeper, hook-aware cleanup, with direct SQL deletion kept only as a safe fallback when required.
    • Automation is now centralized into a unified module with a clearer creation/edit flow and consistent use of the local timezone for all schedules.
    • Options, Tables, and Cron Jobs modules now display richer information with additional columns and more detailed data for each item.
    • System Info is now far more detailed and can be copied or downloaded, making it easier to share environment details, diagnose issues, and assist users during support.
    • Overall multisite support now provides clearer separation between network and site data and safer network-wide cleanup and optimization.
    • Backend architecture migrated to a REST API–driven system for significantly faster interactions and navigation without page reloads.
    • Numerous bugs and edge cases were resolved across all modules, resulting in more stable behavior and more reliable, effective cleaning operations.
    Changes
    • Premium: New - Action Scheduler completed actions cleanup type.
    • Premium: New - Action Scheduler failed actions cleanup type.
    • Premium: New - Action Scheduler canceled actions cleanup type.
    • Premium: New - Action Scheduler completed logs cleanup type.
    • Premium: New - Action Scheduler failed logs cleanup type.
    • Premium: New - Action Scheduler canceled logs cleanup type.
    • Premium: New - Action Scheduler orphan logs cleanup type.
    • Premium: New - "Keep last X items" rule introduced, either per parent (e.g. keep 5 revisions per post) or globally (e.g. keep the last 10 pingbacks), in addition to the existing "keep last X days" rule.
    • Premium: New - Introduced Remote Scan system that combines the local scan with our cloud-based detection engine and continuously curated ownership database to deliver near-perfect accuracy when identifying the true owners of tables, options, post meta, user meta, transients, and cron jobs.
    • Premium: New - Added the ability to anonymously send your ownership corrections to improve our global detection database and refine ownership results for all users.
    • Premium: New - "Keep last X items" rule now configurable inside scheduled tasks, in addition to the existing "keep last X days", for more advanced and safer automated cleanups.
    • Premium: New - Introduced Database Analytics module with daily and monthly charts, raw data views, and per-table analytics (size evolution, rows evolution, daily change breakdown), including multi-table selection for comparative analysis.
    • Premium: New - Added multisite filters to the General Cleanup preview, allowing items to be filtered by site ID or site name so you can focus on a specific site in the network.
    • Premium: New - Introduced per-automation event logs showing what was cleaned, when each task ran, and how many items were processed.

Changelog published by the developer, in their original language.