No tables available
I testet the table cleaner on serveral TYPO3 Installations, but in the scheduler tasks are no tables available to select for the task. Is an additional configuration necessary? I dont find something to this point in the manual.
Updated by Frenck Lutke over 7 years ago
Niklas, is your server set up to use the mysqli PHP extension? (recommended over the deprecated mysql extension)
tablecleaner uses PHP's is_resource() call to test database results in:
is_resource() doesn't play nice with mysqli_result instances. A quick workaround would be to change those conditions to e.g.
is_resource($resource) || $resource instanceof mysqli_result
Updated by Niklas Lazinbee over 7 years ago
Okay, I changed the conditions, now it works - thanks!
But there is another problem, I planed to use tablecleaner to empty indexed search tables. Its not so comfortable to do this with a separate cronjob. The tables to be clean with "remove expired entries" are:
But these tables are not available?
Updated by STI UdeS over 6 years ago
Now that the old mysql interface is not even supported anymore in recent PHP versions, it would be nice to implement the workaround that you suggest above in the TER version of this extension so we could use out of the box without first having to fix it.
That would be much appreciated!