Bug #45887
closeddetails_nr instead of detail_nr in t3lib/stddb/tbl_be.php
100%
Description
There is a nobrainer in t3lib/stddb/tbl_be.php:
It must be "details_nr" instead of "details_nr".
'detail_nr' => array( 'label' => 'detail_nr', 'config' => array( 'type' => 'input' ) ),
Otherwise you'll get an exception e.g. when using the DB Check module:
caller:
TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery
ERROR:
Unknown column 'sys_log.detail_nr' in 'where clause'
lastBuiltQuery:
SELECT COUNT FROM sys_log WHERE (sys_log.tstamp LIKE '%flatex%' OR sys_log.userid LIKE '%flatex%' OR sys_log.action LIKE '%flatex%' OR sys_log.recuid LIKE '%flatex%' OR sys_log.tablename LIKE '%flatex%' OR sys_log.recpid LIKE '%flatex%' OR sys_log.error LIKE '%flatex%' OR sys_log.details LIKE '%flatex%' OR sys_log.type LIKE '%flatex%' OR sys_log.detail_nr LIKE '%flatex%' OR sys_log.IP LIKE '%flatex%' OR sys_log.log_data LIKE '%flatex%' OR sys_log.event_pid LIKE '%flatex%' OR sys_log.workspace LIKE '%flatex%' OR sys_log.NEWid LIKE '%flatex%')
debug_backtrace:
require(sysext/lowlevel/dbint/index.php),mod.php#41 // TYPO3\CMS\Lowlevel\View\DatabaseIntegrityView->main#46 // TYPO3\CMS\Lowlevel\View\DatabaseIntegrityView->func_search#186 // TYPO3\CMS\Core\Database\QueryView->search#349 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTcountRows#510 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTquery#344 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#216
Tested with TYPO3 6.0.2