Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-8168

Memberlist sorting case sensitive

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 3.0.4
    • 3.1.0-b1
    • None
    • PHP Environment: 5.2.8
      Database: MySQL 5.0.45

    Description

      The sorting of the fields in the memberlist is case sensitive on some of the fields.

      Sorting on Username is done correctly because that sort is based on the db field 'username_clean' where case differences have been removed.

      Sorting on Location (or Website) on the other hand is case sensitive making 'Oldenburg' appear before 'bristol'.

      I have made a (temporary) fix by changing ...

      $order_by .= $sort_key_sql[$sort_key] . ' ' . (($sort_dir == 'a') ? 'ASC' : 'DESC');

      ... into ...

      $order_by .= 'LOWER(' . $sort_key_sql[$sort_key] . ') ' . (($sort_dir == 'a') ? 'ASC' : 'DESC');

      Attachments

        Issue Links

          Activity

            People

              nickvergessen Joas Schilling
              Michanek Michanek [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: