Bug #19422
closed
delete field alway inserted for "select " in Full Search
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)
Updated by Dmitry Dulepov about 16 years ago
Why is it marked as crash? Nothing is crashing here. Changine severity to minor.
Updated by Andy Grunwald over 15 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 
Updated by