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

Logging in with Mobile Device triggers SQL error on *_login_attempts.

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.0.9-RC1
    • Fix Version/s: 3.0.9-RC2
    • Component/s: Login
    • Labels:
      None
    • Environment:
      PHP 5.3.4, MySQL(i) 5.1.53, LG Optimus 2X Default Browser.

      Description

      When logging in with a mobile device I receive an SQL error on the new table *_login_attempts. Data too long for column 'attempt_browser'.

      Default value is too small at 150 or value needs to be trimmed as in session.php for session_browser.

      The browser string is 164 chars,

      Mozilla/5.0 (Linux; U; Android 2.2.2; en-gb; LG-P990 Build/FRG83G) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1 MMS/LG-Android-MMS-V1.0/1.2

        Attachments

          Activity

            People

            • Assignee:
              naderman Nils Adermann
              Reporter:
              CoC CoC [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: