Project

General

Profile

Actions

Bug #45887

closed

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

Added by Peter Kraume about 11 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
Start date:
2013-02-27
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
6.0
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

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


Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Bug #43626: Extension Manager not loadingClosed

Actions
Has duplicate TYPO3 Core - Bug #47425: type in field descripion in tbl_be.php (t3lib/stddb)Rejected2013-04-22

Actions
Actions #1

Updated by Christian Kuhn about 11 years ago

confirmed

Actions #2

Updated by Gerrit Code Review about 11 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

Actions #3

Updated by Gerrit Code Review about 11 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

Actions #4

Updated by Christian Kuhn about 11 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #5

Updated by Riccardo De Contardi over 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF