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

Login can fail if username contains non-Latin characters

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Invalid
    • Affects Version/s: 3.1.9
    • Fix Version/s: None
    • Component/s: Update system
    • Labels:
      None

      Description

      I discovered upgrading a client from 3.0-RC3 to 3.1.9 that if the username contains certain non-Latin characters (the board is Danish) these users could not login. In addition, in the ACP the username could not be found. After much analysis I determined that the value for username_clean in the database was different in the upgraded database compared with running username through utf8_clean_string. See my solution here:

      https://www.phpbb.com/community/viewtopic.php?f=466&t=2376981&p=14463071#p14463071

      There is likely a general problem here. A utility can clean these up but perhaps the database_update.php program needs to recalculate these for all users, at least if a language that uses more than basic Latin characters is used.

        Attachments

          Activity

            People

            • Assignee:
              Elsensee Oliver Schramm
              Reporter:
              MarkDHamill MarkDHamill
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: