Issue Bug Closed

#45887details_nr instead of detail_nr in t3lib/stddb/tbl_be.php

Peter Kraume 02/27/13, 15:04 updated 10/23/17, 22:16

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

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.