Post new reply

Yes, it will be in the future LuxCal versions
Roel

I upgraded to 5.3.2M and I modified "pages/search.php" file too ; it works.

Please, is it possible to keep that feature into the next LuxCal version, by default or as an option to enable ?

Thanks again.

That's weird indeed.
If you want the search to be always case-insensitive, edit the file "pages/search.php" and . . .
change line 118 from:

$schString = str_replace('&', '%', "%{$schText}%");

to

$schString = strtoupper(str_replace('&', '%', "%{$schText}%"));

and change lines 124 - 128 from:

if (in_array(0, $eF) or in_array(1, $eF)) { $filter .= "e.`title` LIKE '{$schString}'"; } //Title
if (in_array(0, $eF) or in_array(2, $eF)) { $filter .= ((substr($filter, -1) == '(') ? '' : ' OR ')."e.`venue` LIKE '{$schString}'"; } //venue
if (in_array(0, $eF) or in_array(3, $eF)) { $filter .= ((substr($filter, -1) == '(') ? '' : ' OR ')."e.`text1` LIKE '{$schString}'"; } //text field 1
if (in_array(0, $eF) or in_array(4, $eF)) { $filter .= ((substr($filter, -1) == '(') ? '' : ' OR ')."e.`text2` LIKE '{$schString}'"; } //text field 2
if (in_array(0, $eF) or in_array(5, $eF)) { $filter .= ((substr($filter, -1) == '(') ? '' : ' OR ')."e.`text3` LIKE '{$schString}'"; } //text field 3

to

if (in_array(0, $eF) or in_array(1, $eF)) { $filter .= "UPPER(e.`title`) LIKE '{$schString}'"; } //Title
if (in_array(0, $eF) or in_array(2, $eF)) { $filter .= ((substr($filter, -1) == '(') ? '' : ' OR ')."UPPER(e.`venue`) LIKE '{$schString}'"; } //venue
if (in_array(0, $eF) or in_array(3, $eF)) { $filter .= ((substr($filter, -1) == '(') ? '' : ' OR ')."UPPER(e.`text1`) LIKE '{$schString}'"; } //text field 1
if (in_array(0, $eF) or in_array(4, $eF)) { $filter .= ((substr($filter, -1) == '(') ? '' : ' OR ')."UPPER(e.`text2`) LIKE '{$schString}'"; } //text field 2
if (in_array(0, $eF) or in_array(5, $eF)) { $filter .= ((substr($filter, -1) == '(') ? '' : ' OR ')."UPPER(e.`text3`) LIKE '{$schString}'"; } //text field 3

That's all.

Use cut and paste

Roel

That's weird... I always had case-insensitive search ; and it's very useful.

How to explain I have mixed results since 5.3.1M version ?
Some fields are case sensitive, and others not.

Also, please ; do you think there is a way to search into MySQL to force case-insensitive (the best / useful way) ?

I tried in our MySQL test calendars and for all fields the text search is case-sensitive.
I also looked in the PHP code and the searches in the different database fields are all done in the same way (with the MySQL "LIKE" operator).

Roel

You prefer english ?

Ok ; but, with MySQL version, why it seems to be case-sensitive for title, and case-insensitive for description ?

Thank you

Hi there,
This is not really a bug.
• For the SQLite version of the calendar the text search is always case-insensitive. That's the way the SQLite database works.
• For the MySQL version of the calendar it depends on the database. Some databases support case-sensitive text search and others don't.

Roel

Bonjour,

Merci, ce problème est résolu.

J'en ai trouvé un autre :
La recherche de mots (a-z) est désormais sensible à la casse, alors que ça ne l'était pas avant.

Exemple : si je mets le nom "DUPOND" en titre et description
En recherche, ça ne trouve qu'avec "DUPOND" mais pas "Dupond".

Par contre, si je cherche "dupond", ça trouve uniquement en description (pas en titre).

Merci d'avance.

Bonjour,
You found a bug!
This problem can be solved by editing the file "pages/search.php" and change line 204 from . . .

$click = ($evt['mayE'] ? 'editE' : 'showE')."({$evt['eid']},'{$date}')";

to

$click = ($evt['mayE'] ? 'editE' : 'showE')."({$evt['eid']},`{$date}`)";

It's hard to see, but the single quotes around {$date} at the end of the line have been replaced by backticks ( ` ).
(Back ticks can be found on a US/UK keyboard left upper corner next to the 1 key.)

Roel