I have a problem with Advanced Search on multi-value fields in PHPMaker v2023.7.
As soon as several entries are saved in a field, the search no longer works.
I noticed that in the phpfn.php file on line 1986 the parameters for the SQL function find_in_set are swapped (found with Debugger).
After I corrected that, the search worked again.
Original: $filter = $fldOpr . "(" . $fldExpression . ", '" . AdjustSql($fldVal, $dbid) . "')";
Correct: $filter = $fldOpr . "('" . AdjustSql($fldVal, $dbid) . "'," . $fldExpression . ")";
Incorrect search for multiple values
-
- User
- Posts: 15