Issue Bug Closed

#19422delete field alway inserted for "select " in Full Search

Christophe Monard 10/06/08, 15:36 updated 10/02/18, 12:29

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.