Bug #19422
delete field alway inserted for "select " in Full Search
| Status: | Resolved | Start date: | 2008-10-06 | |
|---|---|---|---|---|
| Priority: | Should have | Due date: | ||
| Assignee: | Christian Kuhn | % Done: | 0% |
|
| Category: | - | |||
| Target version: | - | |||
| TYPO3 Version: | 4.1 | Complexity: | ||
| PHP Version: | 5.0 | |||
| Votes: | 0 |
Description
In the "DB Check" => "Full Search" when you check "Show even deleted entries (with undelete buttons)" (eg: for table witch haven't this field declared) the "deleted" statement is still present in the query :
Select ui,pid,deleted FROM table WHERE (....) LIMIT 100.
With this correction it disapear and the query work.
in class.t3lib_querygenerator.php at line 1485 (in version 4.1.7) :
$fieldlist = $this->extFieldLists['queryFields'].',pid,deleted';
replaced by :
$fieldlist = $this->extFieldLists['queryFields'].',pid';
Add line at line 1488 in if mod_setting show_deleted:
$fieldlist.= ',deleted';
(issue imported from #M9495)
History
Updated by Dmitry Dulepov over 4 years ago
Why is it marked as crash? Nothing is crashing here. Changine severity to minor.
Updated by Andy Grunwald about 4 years ago
This Ticket could be closed.
The lines which are described in the bug description looks at revision 5364 like the following lines:
$fieldlist = $this->extFieldLists['queryFields'] .
',pid' .
($GLOBALS['TCA'][$this->table]['ctrl']['delete'] ? ',' . $GLOBALS['TCA'][$this->table]['ctrl']['delete'] : '');
if (!$GLOBALS['SOBE']->MOD_SETTINGS['show_deleted']) {
$qString .= t3lib_BEfunc::deleteClause($this->table);
}
In my opinion this ticket is solved.
Updated by Christian Kuhn over 3 years ago
Resolved, no change required.