Incorrect search for multiple values

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
pumuckl-online
User
Posts: 15

Incorrect search for multiple values

Post by pumuckl-online »

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 . ")";


Webmaster
User
Posts: 9427

Post by Webmaster »

Please update to the latest template (Tools -> Update Template) and try again.


pumuckl-online
User
Posts: 15

Post by pumuckl-online »

Thanks, it works


Post Reply