Filtering pages by their tags - it's case sensitive

Bug #788444 reported by Szilvia Toth
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Triaged
Low
Unassigned

Bug Description

Environment: 1.4

User can filter pages by their tags but it's case sensitive. It depends how user enters tag on the Edit Title and Description page (using lower or upper case).

Tags: tags
Changed in mahara:
importance: Undecided → Medium
status: New → Triaged
tags: added: tags
Changed in mahara:
assignee: nobody → Hugh Davenport (hugh-catalyst)
status: Triaged → In Progress
Revision history for this message
Hugh Davenport (hugh-davenport) wrote :
Revision history for this message
Hugh Davenport (hugh-davenport) wrote :
Changed in mahara:
status: In Progress → Opinion
Revision history for this message
François Marier (fmarier) wrote :

I think that we should probably fix it (a status of "opinion" means "wontfix"), but I'm not entirely sure how yet.

Perhaps a good first step would be to lowercase all new tags entered by users.

Changed in mahara:
status: Opinion → Triaged
importance: Medium → Low
assignee: Hugh Davenport (hugh-catalyst) → nobody
Revision history for this message
Richard Mansfield (richard-mansfield) wrote :

In postgres it wouldn't be a big problem to leave the contents of the db alone, we could just add an index on LOWER(tag) and lowercase the search terms. But for mysql the easiest way would be to do what Hugh did in that patch - basically destroy data by lowercasing everything in the tag column (removing dupes first to avoid the pk error). Anther option would be creating a new indexed column and putting the lowercased tags in there.

Revision history for this message
Robert Lyon (robertl-9) wrote :

The discussion here relates to this bug also: https://bugs.launchpad.net/mahara/+bug/1231920

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.