#19422delete field alway inserted for "select " in Full Search
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.