ppl homepage alphabetical list redundancies
Bug #723858 reported by
Brad Phillips
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
PPL |
Fix Released
|
Undecided
|
Brad Phillips |
Bug Description
Currently, the site is displaying more than 150 public profiles, so the widget display has switched from a combined view (widget 108) to an alphabetized one (widget 107).
A problem has been exposed where the entire list is being listed under the first category (which is listed as a period rather than an alphanumeric character). So I think the sql is somehow being tripped up by this isolation of a period as a first letter that it doesn't know how to sort or compare to other first letters.
To fix, the sql needs to avoid cases like this & the names of the profiles that don't begin with an alphanumeric character should be amended
To post a comment you must log in.
Ok, I added some contingencies in the sql to only select a category if the first letter of the full name is alphanumeric & that has fixed the issue.
Names beginning with non alphanumeric characters will no longer display on the public profile, so those still need to be changed, but the primary issue has been resolved.