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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • 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: