Optimize Database after Deleting Revisions

[10/26/2021] = * BUG FIX: set_time_limit fixed

[08/04/2021] = * BUG FIX: Syntax error corrected

[08/03/2021] = * BUG FIX: Some performance inprovements (2nd try)

[07/24/2021] = * BUG FIX: Changed back to v5.0.4

[07/23/2021] = * BUG FIX: Scheduler fixed

[07/20/2021] = * BUG FIX: Some performance inprovements

[02/26/2021] = * BUG FIX: Field names INFORMATION_SCHEMA corrected

[11/17/2020] = * BUG FIX: Creating log table if not exists

[11/06/2020] = * BUG FIX: Deletion of orphaned term relationships deactivated

[09/10/2020] = * BUG FIX: Deletion of Duplicated Postmeta entries deactivated

[08/14/2020] = * New: Deletion of Duplicated Postmeta entries

[05/17/2020] = * BUG FIX: Fixed a bug for deleting orphans

[04/10/2020] = * NEW: Deletion of orphaned term relationships

[12/02/2019] = * BUG FIX: Fixed an (innocent) warning (while cleaning)

[09/28/2019] = * BUG FIX: Bug fix for 'Delete revisions older than'

[09/22/2019] = * BUG FIX: Some bug fixes + other minor changes

[09/19/2019] = * BUG FIX: Logging bug fixed

[09/07/2019] = * CHANGE: Improved performance

[09/01/2019] = * BUG FIX: Scheduler bug fixed

[08/15/2019] = * CHANGE: Rewrote the deletion of (expired) transients

[07/15/2019] = * BUG FIX: Scheduler bug fixed

[05/26/2019] = * NEW: New analyze / optimize options (summary or detail)

[01/05/2019] = * CHANGE: 'set_time_limit' warning suppressed * CHANGE: Some lay-out fixes * NEW: Added a 'help'-button on the settings page

[12/12/2018] = * CHANGE: The deletion of transients has been fully rewritten and is many times faster now! * CHANGE: Increased the time_limit * CHANGE: German translations have been updated

[11/12/2018] = * BUG FIX: Fixed a MySQL query

[11/11/2018] = * BUG FIX: Fixed an 'undefined variable' notice

[08/23/2018] = * CHANGE: Removed the MyISAM engine for the log table (now it uses the default-storage-engine of the database)

[06/05/2018] = * BUG FIX: Fixed a javascript bug for the 'Clear Log' confirmation * NEW: PayPal donation button

[06/04/2018] = * BUG FIX: Fixed the WordPress Admin Menu dropdowns on 'View Log' page

[05/08/2018] = * NEW: Logging system has been totally rewritten (from now it will store the logs in the database) * NEW: Export the log to a CSV file

[03/21/2018] = * NEW: Clear oEmbed cache (optional) * BUG FIX: Translation corrected ('Next scheduled run: 0 days, 9 hours, 35 minutes and 27 seconds')

[01/29/2018] = * NEW: Added last run seconds * NEW: French translation added * BUG FIX: Fixed a typo ('DELETEED')

[01/08/2018] = * CHANGE: Revamped and improved the scheduler code

[01/06/2018] = * BUG FIX: Fixed some scheduler time issues

[12/14/2017] = * NEW: Skip standard posttype 'oembed_cache' * BUG FIX: Hide the settings link (plugin page) for multi site sites (except for the main network site)

[11/06/2017] = * BUG FIX: Bug in counting excluded tables fixed

[08/22/2017] = * NEW: New options to delete revisions of posts, pages and / or specific custom post types

[08/12/2017] = * CHANGE: fixed some (innocent) PHP warnings

[08/10/2017] = * NEW: New option for deleting ALL transients (not the expired ones only)

[07/24/2017] = * NEW: New setting added: Delete revisions of (POSTS and PAGES, POSTS only or PAGES only) * CHANGE: Some code clean-up and minor changes

[07/05/2017] = * CHANGE: Extra save button added to the settings page

[04/06/2017] = * NEW: Indonesian (id_ID) translation added

[09/23/2016] = * CHANGE: fixed some (innocent) warnings

[09/16/2016] = * NEW: Added a 'monthly' schedule to the scheduler

[07/15/2016] = * BUG FIX: Bug fix for 4.1.9

[07/15/2016] = * CHANGE: 'Running indicator' added

[06/24/2016] = * CHANGE: Reverted back to 4.1.6 due to some problems. Sorry!

[06/23/2016] = * CHANGE: Orphaned media items will be deleted too now

[05/20/2016] = * NEW: Belarus (be_BY) translation added (thanks Natasha!)

[03/11/2016] = * NEW: Turkish (tr_TR) translation added (thanks Keremcan Buyuktaskin!)

[03/02/2016] = * NEW: Custom field 'keep_revisions', for excluding the deletion of revisions for specific posts/pages * NEW: Run the optimization from a Unix crontab (if possible)

[02/22/2016] = * BUG FIX: Saving settings didn't work well for multi-sites

[02/14/2016] = * NEW: Brasilian Portuguese (po_BR) translation added * NEW: Network: True added to the plugin header

[01/17/2016] = * CHANGE: Use can use the 'Delete revisions older than' AND 'Keep max number of revisions' options at the same time!

[01/14/2016] = * NEW: New option: delete revisions older than... * NEW: Persian translation (fa_IR) added * CHANGE: For muliti-site installations you only can use the plugin on the Main site, but all other sites will be cleaned too. * CHANGE: Some minor updates / changes

[12/17/2015] = * BUG FIX: Bug fix for Cron Schedules * BUG FIX: Un-installation generated an error * CHANGE: Some minor updates / changes

[11/28/2015] = * BUG FIX: Settings weren't saved correctly for MultiSites

[11/27/2015] = * NEW: New option: optimize InnoDB tables too * BUG FIX: Localization fixed for extra cron schedules * BUG FIX: De-activation issue on update fixed

[11/22/2015] = * NEW: Total rewrite of the code (OO code) * CHANGE: Many changes and bug fixes

[11/01/2015] = * BUG FIX: Views are skipped from the optimization

[10/24/2015] = * CHANGE: Stylesheet is only loaded on required admin pages

[10/23/2015] = * BUG FIX: Bug fixed for deleting unused tags

[09/14/2015] = * BUG FIX: Bug fixed for deleting transients

[08/30/2015] = * BUG FIX: Transients are now deleted using the delete_transient() / delete_site_transient() functions

[06/21/2015] = * NEW: Danish translation (da_DK) added

[06/07/2015] = * NEW: Russian translation (ru_RU) added

[06/03/2015] = * NEW: German translation (de_DE) added

[05/10/2015] = * BUG FIX: fixed a bug (options didn't get saved in old multisite installs) Many thanks to Pat who helped me fixing the issue!

[04/26/2015] = * BUG FIX: fixed a bug for the excluded tables (didn't work anymore)

[04/24/2015] = * NEW: Ukrainian translation (uk_UA) added * CHANGE: updates for Dutch and Italian translations * CHANGE: a new, fresh look! * CHANGE: a better way to show the EXCLUDED tables on the settings page

[04/08/2015] = * BUG FIX: fixed a bug with the scheduler (it didn't clean everything)

[03/27/2015] = * NEW: MULTISITE support added (second try ;-)) * CHANGE: various minor improvements * BUG FIX: sub-sites are accessible again (in the admin panel)

[03/18/2015] = * CHANGE: due to problems, I removed the MULTISITE support again for now... Sorry about that!

[03/18/2015] = * NEW: MULTISITE support added * CHANGE: various minor improvements

[03/01/2015] = * NEW: italian language support [it_IT] added (thanks Fabio Marzocca!) * NEW: optimization timer * CHANGE: from now on InnoDB tables are skipped from optimization * CHANGE: various minor improvements * BUG FIX: removed strtolower while fetching database properties

[02/21/2015] = * NEW: showing the icon in the admin menu is now configurable via the settings page

[02/20/2015] =

• BUG FIX: fixed the link to the settings page

[02/20/2015] = * NEW: added plugin banners and icons * NEW: added a new admin menu item with icon ('Optimize Database') * CHANGE: moved the language files to the '/language' directory * CHANGE: moved the styles to the '/css' directory * CHANGE: credit removed from the front-end pages

[01/29/2015] = * NEW: deletion of pingbacks and trackbacks (optional) * CHANGE: link to settings page in the main plugins page

[12/28/2014] = * BUG FIX: tags only used in scheduled posts won't be deleted anymore (thanks Michael!)

[10/22/2014] = * NEW: plugin has been fully localized * NEW: dutch language support [nl_NL] added * NEW: serbian language support [sr_RS] added

[09/10/2014] = * CHANGE: using the WP jQuery libs now (not from googleapis anymore) * BUG FIX: check_admin_referer() fixed (gave a debug warning)

[08/01/2014] = * BUG FIX: all problems with getting the table names should be fixed now!

[07/31/2014] = * CHANGE: changed the 'edit_themes' capability back to 'administrator'-role * BUG FIX: no table names beside checkboxes (rewrote it, so it should work for every site now)

[07/30/2014] = * CHANGE: 'administrator'-role changed to 'edit_themes'-capability * BUG FIX: no table names beside checkboxes

[05/02/2014] = * BUG FIX: some minor bug fixes (thanks Mike!)

[05/01/2014] = * CHANGE: replaced depreciated MySQL queries (from WP 3.9 / PHP 5.5)

[02/16/2014] = * BUG FIX: made jQuery also https compatible

[01/16/2014] = * BUG FIX: empty lines removed from output (gave problems with some RSS feeds)

[12/13/2013] = * CHANGE: two queries optimized for better performance

[12/11/2013] = * BUG FIX: added 'backticks' around the database name in a few queries

[12/09/2013] = * BUG FIX: deleted some CR/LF's from the end of the plugin sigh

[12/09/2013] = * BUG FIX: forgot to delete a debug item... oops! sorry!

[12/09/2013] = * BUG FIX: query and depreciated item (mysql_list_tables) fixed

[12/06/2013] = * NEW: deletion of expired transients (optional)

[07/22/2013] = * NEW: deletion of unused tags (optional)

[05/24/2013] = * BUG FIX: some short tags removed * CHANGE: schedule time is only relevant and therefore only shown for 'daily' and 'weekly' schedules * NEW: option to turn the '1-click' button in the admin bar on/off

[05/24/2013] = * NEW: you can set a time (hour) for the scheduler to run (thanks to frekel) * NEW: '1-click run button' in the admin bar (thanks to JB ORSI)

[05/24/2013] = * NEW: you can set a time (hour) for the scheduler to run (thanks to frekel) * NEW: '1-click run button' in the admin bar (thanks to JB ORSI)

[05/24/2013] = * NEW: you can set a time (hour) for the scheduler to run (thanks to frekel) * NEW: '1-click run button' in the admin bar (thanks to JB ORSI)

[05/03/2013] = * BUG FIX: fixed a problem with 'invalid header' (during installation)

[04/26/2013] = * BUG FIX: fixed the 'Stealing Cron Schedules' issue

[04/10/2013] = * BUG FIX: bug fix for the 'check all NON-WordPress tables' link

[03/19/2013] = * BUG FIX: bug fix for deleting Post Orphans

[03/18/2013] = * NEW: 'Orphan Post items' (like 'Auto Drafts') will be automatically deleted too now (thanks to: 0izys)

[03/05/2013] = * Text change: 'logging on' changed to 'keep a log' (thanks to: Neil Parks) * NEW: number of orphans deleted now also shown in the log file * NEW: 'Go To Optimizer' button on options page (thanks to: RonDsy)

[02/20/2013] = * Bug fix: fixed an (innocent) PHP warning (in error.log)

[02/12/2013] = * Bug fix: error corrected in readme.txt file

[08/02/2013] * Bug fix: fixed an (innocent) PHP warning (in error.log)

[01/20/2013] = * Bug fix: deleting of postmeta orphans didn't work correctly

[01/17/2013] = * Bug fix: fixed some debug warnings

[01/11/2013] = * NEW: 'Orphan Postmeta items' will be automatically deleted * NEW: the possibility to exclude tables from Optimization (for instance for 'heavy traffic' tables)

[01/04/2013] = * Bug fix: keeping a maximum number of revisions didn't work correctly

[12/18/2012] = * NEW: Logging of the Optimizations (optional) * NEW: Scheduling Optimizations for Automatic Execution (optional) * Many other (technical and cosmetical) changes and improvements

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.

No Upgrade Notice available.