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
Updated by Gerrit Code Review almost 12 years ago
- Status changed from New to Under Review
Patch set 1 for branch master has been pushed to the review server.
It is available at https://review.typo3.org/18811
Updated by Gerrit Code Review almost 12 years ago
Patch set 1 for branch TYPO3_6-0 has been pushed to the review server.
It is available at https://review.typo3.org/18812
Updated by Christian Kuhn almost 12 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset ad969582c5ea38fa6b41af2b96786c583ad1f269.
Updated by Riccardo De Contardi over 7 years ago
- Status changed from Resolved to Closed