Error in DB Check -> Record Statistics
Given a TCA table without (or empty) table label
'ctrl' => array( 'label' => '', 'hideTable' => 1, ),
the module DB Check -> Record Statistics returns an error
Uncaught TYPO3 Exception substr() expects parameter 1 to be string, null given TypeError thrown in file D:\Version Control\Git\TYPO3\TYPO3.CMS\master\typo3\sysext\core\Classes\Database\Query\QueryBuilder.php in line 983.
[BUGFIX] DB Check causes PHP warnings and errors
In DatabaseIntegrityCheck the method selectNonEmptyRecordsWithFkeys
also needs to take the BLOB into account or else it will fail with
a PHP warning. Furthermore the returned tableColumns list may contain
quoted fields names if the field name can be interpreted as a keyword
for the used connection platform. This patch ensures the correct
column information is received before further processing is started.
Additionally the "Record Statics" module is fixed by checking for an
empty TCA table field which invokes an exception.
Reviewed-by: Christer V <email@example.com>
Tested-by: Christer V <firstname.lastname@example.org>
Tested-by: TYPO3com <email@example.com>
Reviewed-by: Claus Due <firstname.lastname@example.org>
Reviewed-by: Nicole Cordes <email@example.com>
Tested-by: Nicole Cordes <firstname.lastname@example.org>
Reviewed-by: Markus Klein <email@example.com>
Reviewed-by: Anders Kostending <firstname.lastname@example.org>
Reviewed-by: Christian Kuhn <email@example.com>
Tested-by: Christian Kuhn <firstname.lastname@example.org>