Bug #45887

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

Added by Peter Kraume about 7 years ago. Updated over 2 years ago.

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

100%

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

Related to TYPO3 Core - Bug #43626: Extension Manager not loading Closed
Duplicated by TYPO3 Core - Bug #47425: type in field descripion in tbl_be.php (t3lib/stddb) Rejected 2013-04-22

Associated revisions

Revision 9be1dcb9 (diff)
Added by Christian Kuhn about 7 years ago

[BUGFIX] Typo in sys_log TCA

Wrong table field name in sys_log TCA "detail_nr" instead of
"details_nr" triggers SQL errors in DB check -> Full search module.

Change-Id: I02298019ef29f38def0b6c204236fd6987b92bce
Releases: 6.1, 6.0
Fixes: #45887
Reviewed-on: https://review.typo3.org/18811
Reviewed-by: Christian Kuhn
Tested-by: Christian Kuhn

Revision ad969582 (diff)
Added by Christian Kuhn about 7 years ago

[BUGFIX] Typo in sys_log TCA

Wrong table field name in sys_log TCA "detail_nr" instead of
"details_nr" triggers SQL errors in DB check -> Full search module.

Change-Id: I02298019ef29f38def0b6c204236fd6987b92bce
Releases: 6.1, 6.0
Fixes: #45887
Reviewed-on: https://review.typo3.org/18812
Reviewed-by: Christian Kuhn
Tested-by: Christian Kuhn

History

#1 Updated by Christian Kuhn about 7 years ago

confirmed

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

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

#4 Updated by Christian Kuhn about 7 years ago

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

#5 Updated by Riccardo De Contardi over 2 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF