[BUGFIX] Task remove expired entries fails to execute

Executing the task to remove expired entries without setting excludePages fails due to wrong where-statement in class tx_tablecleaner_tasks_Expired ind Classes/Tasks/Expired.php.

Thanks to Andreas Beyl

Fixes: #54697

git-svn-id: https://svn.typo3.org/TYPO3v4/Extensions/tablecleaner/trunk@83804 735d13b6-9817-0410-8766-e36946ffe9aa
[BUGFIX] Missing tables in task remove expired entries

There are tables (i.e. sys_log) missing in the tables-selectbox for the task to remove expired entries due to missing brackets in function getTables() of class tx_tablecleaner_tasks_ExpiredAdditionalFieldProvider in Classes/Tasks/ExpiredAdditionalFieldProvider.php.

Thanks to Andreas Beyl

Fixes: #54698

git-svn-id: https://svn.typo3.org/TYPO3v4/Extensions/tablecleaner/trunk@83806 735d13b6-9817-0410-8766-e36946ffe9aa
[BUGFIX] Expired task does not preserve selected tables on edit

This is due to confusing between $this->getTables() and $task->getTables(), brrrr.

Thanks to Loek Hilgersom

Fixes: #55308

git-svn-id: https://svn.typo3.org/TYPO3v4/Extensions/tablecleaner/trunk@83808 735d13b6-9817-0410-8766-e36946ffe9aa
[TASK] Add OPTIMIZE TABLE option

InnoDB tables do not reclaim free space after deleting records. When many deletions have been done, the table gets a lot faster if you do reclaim this space by running OPTIMIZE TABLE tablename.

This patch add this as an optional feature to all tablecleaner tasks. If you set 'Mark records as deleted instead of removing them', then the OPTIMIZE query is not performed (because it makes no sense when no records have been deleted).

Beware that running the OPTIMIZE query can make the database unavailable while its busy (which can take some time for large tables), so make sure to schedule this task in the off-hours.

Thanks to Loek Hilgersom

Fixes: #55310

git-svn-id: https://svn.typo3.org/TYPO3v4/Extensions/tablecleaner/trunk@83810 735d13b6-9817-0410-8766-e36946ffe9aa
[TASK] Add some more tables to the list in Expired Task

Could not select some tables like tx_solr_statistics and <extname>_cache

Thanks to Loek Hilgersom

Fixes: #55311

git-svn-id: https://svn.typo3.org/TYPO3v4/Extensions/tablecleaner/trunk@83811 735d13b6-9817-0410-8766-e36946ffe9aa
[TASK] Code cleanup

git-svn-id: https://svn.typo3.org/TYPO3v4/Extensions/tablecleaner/trunk@83813 735d13b6-9817-0410-8766-e36946ffe9aa